超难问题，读取数据

Question

ResultSet rss=stmt1.executeQuery(sql1);
用stmt2试试

Answer 1

Statement stmt2 = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql1="select * from users";
ResultSet rss=stmt1.executeQuery(sql1);你都创建了stmt2，还用stmt1干嘛？

Answer 2

哦,刚抽口烟,按错键了.
可能是当执行里层的STMT2时,RS已经关闭了.所以只执行了一次

Answer 3

<%@page import="java.sql.*,java.io.*"%>
<%
Connection conn;
Statement stmt1;
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
conn=DriverManager.getConnection("jdbc:mysql://localhost**//这里省略");
stmt1 = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select * from lybook";
ResultSet rs=stmt1.executeQuery(sql);while(rs.next())
{
String tt=rs.getString(1);out.println(tt);
Statement stmt2 = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql1="select * from users";
ResultSet rss=stmt2.executeQuery(sql1);
while(rss.next()){
out.println(tt);
out.println(rss.getString("sex"));
}}
%>