Question

jsp页面连接数据库只显示一条记录？

<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
.newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";
String user1 = "sa";
String password1 = "000";
java.sql.Connection conn = null;
Statement stmt = null;
String sql = "select * from subject";
conn = DriverManager.getConnection(url, user1, password1);
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);

if (rs.next()) {
out.print(rs.getInt("id") + ".");
out.println(rs.getString("subname"));
}
rs.close();
stmt.close();
conn.close();
%>
结果只显示数据库中的第一条记录

Answer 1

当然是只有1条，你用的是if(rs.next())使得你后面的语句只执行了一遍。把if改成while就可以了

Answer 2

请给rs读取做一个单步循环

Answer 3

试试while循环