Question

jsp页面中为什么只显示一条记录啊

while(rs.next()){
HelyBean vb = new HelyBean();
vb.setUserName(rs.getString("username"));
vb.setSum(rs.getString("sum"));
sql = "select t.sub from user_con t where t.username='"+vb.UserName()+"'";
rs = stat.executeQuery(sql);
if(rs.next()){
vb.setSub(rs.getString("sub"));
}
sql = "select t.mob from user_mob t where t.sum='"+vb.getSum()+"'";
rs = stat.executeQuery(sql);
if(rs.next()){
vb.setNumber(rs.getInt("mob"));
}
list.add(vb);
}
这是后台的一部分代码，麻烦帮忙看下什么问题吧

Answer 1

rs在循环里面被你改了，最外层的while循环就出问题了

Answer 2

HelyBean vb = new HelyBean();
vb.setUserName(rs.getString("username"));
vb.setSum(rs.getString("sum"));
sql = "select t.sub from user_con t where t.username='"+vb.UserName()+"'";
rs = stat.executeQuery(sql);
while(rs.next()){
vb.setSub(rs.getString("sub"));
}
sql = "select t.mob from user_mob t where t.sum='"+vb.getSum()+"'";
rs = stat.executeQuery(sql);
if(rs.next()){
vb.setNumber(rs.getInt("mob"));
}
list.add(vb);
}

Answer 3