hibernate 时间段查询

最新推荐文章于 2021-11-17 15:06:36 发布

琅琊山二当家

最新推荐文章于 2021-11-17 15:06:36 发布

阅读量2k

点赞数

分类专栏： hibernate

本文链接：https://blog.csdn.net/AlbertFly/article/details/51325359

版权

hibernate 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

hibernate 时间段查询

方法1

@Override
public int findIfLoginAlreadyLogin() {
Date now = new Date();
List<RevitLoginlog> result = getCurrentSession().createQuery("from RevitLoginlog where loginTime >=:beginTime and loginTime<=:endTime")
.setTimestamp("beginTime", DateUtils.getStartDate(now)).setTimestamp("endTime", DateUtils.getFinallyDate(now)).list();
return result != null && result.size() > 0 ? 1 : 0;
}

方法2

@SuppressWarnings("unchecked")
@Override
public List<Order> calcDeveloperMoney(Long year, Long month, Long reqId, Long staffId) {
String hql = "from Order t where t.revitAddInId = (select m.id from RevitAddIn m where m.reqId = :reqId) "+
"and t.status=1 and t.staffId=:staffId and t.createTime between :beginTime and :endTime ";
Date[] dates= getQueryTime(year, month);
List<Order> data = getCurrentSession().createQuery(hql).setLong("staffId", staffId).
setLong("reqId", reqId).setDate("beginTime",dates[0]).setDate("endTime",dates[1]).list();

return data;
}