师哥师姐帮忙,实在是找不出原因
public CheckRe getCheckReByProConIDAndKind(String proCon_ID, String kind) {
StringBuffer buffer = new StringBuffer();
buffer.append("select * from "+SQL_TABLE+" where proCon_ID='"+proCon_ID+"'");
if(!kind.equals("")||kind!=null)
buffer.append("and checkReKind='"+kind+"'");
DBManager manager = new DBManager(buffer.toString(),true);
ResultSet rs = null;
CheckRe row = null;
//��ѯ��¼
try {
manager.setString(1,proCon_ID);
rs = manager.executeQuery();
if (rs.next()) {
CheckReRowExtractor extractor = new CheckReRowExtractor();
row = (CheckRe)extractor.extract(rs);
}
} catch (SQLException sqle) {
log.warn("��ѯ��Ŀ��Ϣ����"+sqle.getMessage(),sqle);
}
//�ͷ�l��
manager.close();
DBUtil.close(rs);
manager = null;
return row;
}
调用次方法得不到记录,同样的sql语句在数据库里面却能取到数据,想了很久,实在不明白上什么原因,请帮忙分析下,谢谢了!