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

最新推荐文章于 2020-12-22 01:27:20 发布

秦晓宇

最新推荐文章于 2020-12-22 01:27:20 发布

阅读量1.6k

点赞数

文章标签： hibernate

本文链接：https://blog.csdn.net/u012812482/article/details/53948624

版权

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

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; 
    }