select accessTime, COMJNAM, FIRSTNAM, SECDNAM, companyName, userName from cardjava_1_6.dbo.TRN_ACCESS_VIEW, cardjava_1_6.cardjava.TRN_NC, cardjava_1_6.dbo.MST_USER_VIEW where cardjava_1_6.dbo.TRN_ACCESS_VIEW.accessCardID = cardjava_1_6.cardjava.TRN_NC.MIDID and cardjava_1_6.dbo.TRN_ACCESS_VIEW.userID = cardjava_1_6.dbo.MST_USER_VIEW.userID
(语句有点长:-D)该语句在.sql文件正常执行,并且结果表格有四行,但在java类代码中,执行该语句返回的结果集为null,为什么会出现这种情况?怎么解决啊?
(语句有点长:-D)该语句在.sql文件正常执行,并且结果表格有四行,但在java类代码中,执行该语句返回的结果集为null,为什么会出现这种情况?怎么解决啊?
public List findAll() {
List list = null;
try {
DBConnect dbc = new DBConnect(sql);
ResultSet rs = dbc.executeQuery();
if(rs.next()){
LogManageBean bean = new LogManageBean();
bean.setAccessTime(rs.getDate(1));
bean.setCOMJNAM(rs.getString(2));
bean.setFIRSTNAM(rs.getString(3));
bean.setSECDNAM(rs.getString(4));
bean.setCompanyName(rs.getString(5));
System.out.print(rs.getDate(1));
System.out.print(rs.getString(2));
System.out.print(rs.getString(3));
System.out.print(rs.getString(4));
System.out.print(rs.getString(5));
list.add(bean);
}
dbc.close();
//return list;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
别类中有 类似函数,最基本的东西都是一样的,就这个没结果集。(DBConnect类各函数正确)
bean.setAccessTime(rs.getDate("accessTime"))即可