读书人

hibernate查询记要总数量

发布时间: 2012-10-27 10:42:26 作者: rapoo

hibernate查询记录总数量

String hql = "select count(*) from Presc p "        + "where p.operType = ? and (trunc(p.orderDate) between ? and ?)";Query query = getSession().createQuery(hql);query.setString(0, prescTypeCode);query.setDate(1, startDate);query.setDate(2, endDate);Integer count = (Integer) query.uniqueResult();

读书人网 >软件架构设计

热点推荐