新手上路大家扶一下.谢了.jsp+sql??
juror 2006-06-29 10:27:32 为什么把它放到class里可以显示记录.在jsp下显示出来的是空的呢
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;databasename=sumway";
String user="sa";
String password="a";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select * from xyzjd3_users");
while (rset.next())
System.out.println (rset.getInt(1));
rset.close();
stmt.close();
conn.close();