日期:2014-05-20 浏览次数:21057 次
try{
PrintWriter pw = res.getWriter();
//访问数据库进行读取数据
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String dbURL = "jdbc:sqlserver://127.0.0.1:1433;integratedSecurity=true;DatabaseName=zeng";
ct = DriverManager.getConnection(dbURL);
ps = ct.prepareStatement("select * from memberMag;");
rs = ps.executeQuery();
while(rs.next()){
pw.println("ID:" + rs.getInt(1));
pw.println("userName:" + rs.getString(2));
pw.println("password:" + rs.getString(3));
pw.println("mail:" + rs.getString(4));
pw.println("userLevel:" + rs.getString(5));
pw.println("<br>");
pw.println("<hr>");
}
}catch(Exception ee){
ee.printStackTrace();
}finally{
try{
rs.close();
ps.close();
ct.close();
}catch(Exception ee){
ee.printStackTrace();
}
}