hibernate 在order by后不执行where语句

问题描述

public List searchWorklogCount(){ return this.getHibernateTemplate().find("from worklog order by id desc where (logDate between '2011-04-21' and '2011-04-22')"); }取出的是所有数据，如果把order by id desc去掉，变成：public List searchWorklogCount(){ return this.getHibernateTemplate().find("from worklog where (logDate between '2011-04-21' and '2011-04-22')"); }则取出的是正确的数据。在mysql中输入以上两个语句，取出均为正确的。求教中......

解决方案

return this.getHibernateTemplate().find("from worklog where (logDate between '2011-04-21' and '2011-04-22')")order by id desc ; 就ok啦！
解决方案二：
order by 是放在语句最后的；把order by 和where的顺序改变下，看看是不是你要的结果