Hibernate 1、获取一天中数据的总条数

来源：互联网发布：国乒集体退赛知乎编辑：程序博客网时间：2024/06/08 04:11

目前是随笔，内容多了会整理成文章

private static long getOrderIdForOneDay(String day)    {        long ret=0;        String start = day+" 00:00:00";          String end = day+" 23:59:59";          Session session = null;             int title = 0;        try         {                       session = HibernateUtil.currentSession();              session.beginTransaction();              String hql="select count(*) from MtRepair as p where p.date >='" +start+"' and p.date <='"+end+"'";               Query query=session.createQuery(hql);                      long d = (long)query.uniqueResult();               ret = d;                          }catch(Exception e)         {              e.printStackTrace();          }        finally        {                       HibernateUtil.closeSession();          }        return ret;     }

0 0