如题,代码如下:
try {
if( null==whereCondition ) {
sql = "select " + selectROws + " from tb_user";
} else {
sql = "select " + selectROws + " from tb_user where 1=1 and " + whereCondition;
}
if( null!=others ) {
sql += others;
}
rs = stmt.executeQuery(sql);
boolean m = rs.next();
while (rs.next()) {
User u = new User();
u.setUid(rs.getString("userId"));
u.setUserName(rs.getString("userName"));
u.setSex(rs.getString("sex"));
u.setAge(rs.getInt("age"));
u.setAddress(rs.getString("address"));
u.setTelphone(rs.getString("telphone"));
list.add(u);
}
} catch (SQLException e) {
e.printStackTrace();
}
终点是红字部分,断点调试sql是对的,放到数据库里正常执行,为什么(resultSet)rs.next()总是为false呢?
try {
if( null==whereCondition ) {
sql = "select " + selectROws + " from tb_user";
} else {
sql = "select " + selectROws + " from tb_user where 1=1 and " + whereCondition;
}
if( null!=others ) {
sql += others;
}
rs = stmt.executeQuery(sql);
boolean m = rs.next();
while (rs.next()) {
User u = new User();
u.setUid(rs.getString("userId"));
u.setUserName(rs.getString("userName"));
u.setSex(rs.getString("sex"));
u.setAge(rs.getInt("age"));
u.setAddress(rs.getString("address"));
u.setTelphone(rs.getString("telphone"));
list.add(u);
}
} catch (SQLException e) {
e.printStackTrace();
}
终点是红字部分,断点调试sql是对的,放到数据库里正常执行,为什么(resultSet)rs.next()总是为false呢?
解决方案 »
- quartz是否有在执行完一次任务后,再定时执行下一次的功能?
- 各位大哥大姐,做视频聊天程序,哪些工具搭配比较合适啊?
- java 哪里可以查到ImageIO.write的源码,谢谢
- 两个接口有同样的方法,类实现接口的方法重写怎么写?
- 巨白痴问题,如何让jtextfield中的内容实时变化
- 重复key排序,请问用什么样的容器
- 还是“JAVA字符串等于”方面的疑惑
- 大家好 谁有Java Developers ALMANAC 这本书感觉如何 顺便送分
- 怎样限制JTextArea的输入长度?
- 为什么Timer一能工作?
- java一道题目,求大牛指导try的return和finally
- java项目路径及打包的问题
boolean m = rs.next();
while (rs.next()) {