81,122
社区成员




List<ProjectEntity> list=new ArrayList<ProjectEntity>();
Connection conn = DBUtil.getConn();
PreparedStatement pstmt = null;
ResultSet resultSet = null;
StringBuffer sb=new StringBuffer(" select p.项目CODE as projectcode, p.项目名称 as projectname ");
sb.append(" from SM_PROJECT_PMP P left join SM_PROJECT_GROUP_PMP M on m.项目CODE = p.项目CODE ");
sb.append(" where p.项目状态 = '否' AND m.是否在项目 = '是' AND p.项目分类大类 != 'GM' AND m.人员CODE ='");
sb.append(user_mail);
sb.append("'");
try {
pstmt = conn.prepareStatement(sb.toString());
resultSet = pstmt.executeQuery(sb.toString());
if (resultSet.next()) {
resultSet.getRow();// 得到 1
ProjectEntity entity=new ProjectEntity();
entity.setProjectnameSub(resultSet.getString("projectname"));
entity.setProjectcodeSub(resultSet.getString("projectcode"));
list.add(entity);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.close(resultSet);
DBUtil.close(pstmt);
DBUtil.close(conn);
}
return list;
我蠢了,看错了,把if当成while了
while (resultSet.next()){
XXX
}
查询的结果是对的,你没有读取出来 while(resultSet.next){ resultSet.getRow();// 得到 1 ProjectEntity entity=new ProjectEntity(); entity.setProjectnameSub(resultSet.getString("projectname")); entity.setProjectcodeSub(resultSet.getString("projectcode")); list.add(entity); }