Question

hibernate取离当前时间最近的时间,怎么取啊！各位大虾...

Answer 1

个人提供一个笨办法 就是你用代码获取当前时间 然后sql语句
Date t=new Date();
t.getTime();
select *from table where date(数据库字段)<t.gettime() order by date desc;
如果没用hql 就select top 1 from table where date(数据库字段)<t.gettime() order by date desc;
如果hql 那你就用分页
public List getPageList(int thisNumber, int sumCount, String sql) {
Session session = sf.openSession();
try {
Query query = session.createQuery(sql);
int firstResultIndex = sumCount * (thisNumber - 1);
query.setFirstResult(firstResultIndex);
query.setMaxResults(sumCount);
return query.list();
} catch (Exception e) {
e.printStackTrace();
} finally {
session.close();
}
return null;
}
getPageList(1,1,sql);

追问

select
max(this_.START_DATE) as y0_
from
RPM_PAR_TAX this_
where
this_.TAX_ID=?
and this_.START_DATE<?
这种方式就行，找到了！就是hibernate的criteria查询方式实现额！