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;
为什么while(rs.next())会直接跳到最后一行的记录去?
- 写回答
- 好问题 0 提建议
- 关注问题
- 邀请回答
-
