try {
con=base.getConn();
pstmt=con.prepareStatement(sql);
rs=pstmt.executeQuery();
if(rs.next()){
Users use=new Users();
use.setUserName(rs.getString(2));
use.setPassword(rs.getString(3));
// use.setStatus(rs.getInt(4));
list.add(use);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
base.closeAll(con, pstmt, rs);
}
当运行到rs.next()时,为什么不能跳进去,con,pstmt,rs都有值
con=base.getConn();
pstmt=con.prepareStatement(sql);
rs=pstmt.executeQuery();
if(rs.next()){
Users use=new Users();
use.setUserName(rs.getString(2));
use.setPassword(rs.getString(3));
// use.setStatus(rs.getInt(4));
list.add(use);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
base.closeAll(con, pstmt, rs);
}
当运行到rs.next()时,为什么不能跳进去,con,pstmt,rs都有值
while(rs.next()){
Users use=new Users();
use.setUserName(rs.getString(2));
use.setPassword(rs.getString(3));
// use.setStatus(rs.getInt(4));
list.add(use);
}
use.setUserName(rs.getString(2));//第二列
use.setPassword(rs.getString(3));//第三列不行把异常帖出来看下
没绑定参数吧
SQL语句咋写的
con=base.getConn();
pstmt=con.prepareStatement(sql);
PrepareStatement 貌似没有设置参数吧 ? 怎么可能查到数据呢?