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

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

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