JavaWeb使用SQL Server驱动的JDBC(4)

通过结果集接口ResultSet查询数据

一、简介
ResultSet接口是用来暂时存放数据库查询操作获得的结果。

二、代码介绍
1.首先是数据库的连接部分

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=UserInfo",         "sa", "Aa123789");

2.执行SQL语句

PreparedStatement pState = conn.prepareStatement("Select * from UserInfo");

3.获得结果集

ResultSet rs = pState.executeQuery();

4.获得结果集纪录中的第一列参数的值，并打印输出

out.print(rs.getString(1));

三、完整JSP代码：

<%    try{                    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");    Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=UserInfo",            "sa", "Aa123789");    PreparedStatement pState = conn.prepareStatement("Select * from UserInfo");    ResultSet rs = pState.executeQuery();    out.print("<table border=1>");    out.print("<tr><td>用户名</td><td>密码</td></tr>");    while(rs.next())    {        out.print("<tr><td>");        out.print(rs.getString(1));        out.print("</td><td>");        out.print(rs.getString(2));        out.print("</td></tr>");    }    out.print("</table>");}catch(SQLException se){    out.print(se);}    %>