Question

JAVA hibernate hql 查询不到数据

String hql = "from ProcessTrainingRecord p where isValid='1' and isFinished='1' and processName=:processName ";
if(!Common.isEmpty(userCode))
hql += ("and userCode=:userCode ");
if(startTime != null)
hql += "and startTime>=:startTime ";
if(endTime != null)
hql += "and startTime<=:endTime ";
Query query = this.getSession().createQuery(hql);
query.setString("processName", processName);
if(!Common.isEmpty(userCode))
query.setString("userCode", userCode);
if(startTime != null)
query.setDate("startTime", new java.sql.Date(startTime.getTime()));
if(endTime != null)
query.setDate("endTime", new java.sql.Date(endTime.getTime()));
@SuppressWarnings("unchecked")
List<ProcessTrainingRecord> list = query.list();
return list;

list size 是0 为什么? 数据库用SELECT * FROM MCS_PROCESS_TRAINING_RECORD WHERE IS_FINISHED='1' AND IS_VALID='1' AND PROCESS_NAME='AAA' AND USER_CODE='dba' AND START_TIME>='2013-12-29 00:00:00' AND START_TIME<='2013-12-29 23:59:59' 查出来明明是有数据的呀

Answer 1

试试用QBC来查询吧
Criteria criteria=session.createCriteria(ProcessTrainingRecord.class);
然后用criteria.add(Restrictions.eq("ProcessTrainingRecord","1"));添加条件
lt方法为<
gt为>
le为<=
ge为>=
条件添加完之后，用
criteria.list()即可

Answer 2

把hibernate的show_sql属性配成true，再看一下控制台输出的SQL是不是跟你预计的一样

Answer 3

看看执行的sql语句不就知道是哪的问题了。