WindJine 2015-02-18 02:28 采纳率: 0%
浏览 3844

为什么while(rs.next())会直接跳到最后一行的记录去?

List UserList=new ArrayList();
String sql = "select * from dbo.userinfo";
Connection conn =null;
ResultSet rsb =null;
Statement stb=null;
try {
conn= new DBhelper().getConn();
stb = conn.createStatement();
rsb=stb.executeQuery(sql);

while(rsb.next())
{
User user=new User();
System.out.print(rsb.getString("userid"));
System.out.print(rsb.getString("pwd"));
System.out.print(rsb.getString("pemission"));
user.setUserid(rsb.getString("userid").trim());
user.setPwd(rsb.getString("pwd").trim());
user.setPemission(rsb.getString("pemission").trim());
UserList.add(user);
}

rsb.close();
stb.close();
conn.close();
} catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
}
return UserList;

  • 写回答

6条回答 默认 最新

  • WindJine 2015-02-18 03:11
    关注

    有四条记录
    它是直接跳到后面的4了,不知道怎么办

    评论

报告相同问题?