Hibernate常见问题

来源：互联网发布：淘宝怎么加主播旺信编辑：程序博客网时间：2024/05/17 04:04

问题1，hql条件查询报错

执行Query session.createQuery(hql) 报错误直接跳到finally

解决方案

加入

<prop key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop>

节点

加入之后再次报错

org.hibernate.HibernateException: could not instantiate QueryTranslatorFactory: org.hibernate.hql.classic.ClassicQueryTransactionFactory

解决方案

修改成以下

<property name="hibernate.query.factory_class">org.hibernate.hql.internal.classic.ClassicQueryTranslatorFactory</property>

参考链接

Hibernate 问题,在执行Query session.createQuery(hql) 报错误直接跳到finally - morning99的专栏 - 博客频道 - CSDN.NET

org.hibernate.HibernateException: could not instantiate QueryTranslatorFactory: org.hibernate.hql.classic.ClassicQueryTransactionFactory - Stack Overflow

hql条件查询

查询最后一条数据

public RunTimePO getLast(String sin)    {         Session session = sessionFactory.openSession();         //System.out.println("22222222222222");         String hql="from RunTimePO where SIN=? order by id desc";            //String hql="from RunTimePO where SIN=?";          Query query = session.createQuery(hql);           query.setString(0, sin);          query.setMaxResults(1);          //query.setInteger(0, 139);            //int id=(Integer) query.uniqueResult();         RunTimePO rp=(RunTimePO) query.uniqueResult();           if(rp!=null)         {         System.out.println("id==="+rp.getId());         }            session.close();            return rp;     }

时间段查询

public List<RunTimePO> getBetweenSeg(String sin,String startTime,String endTime)    {        Session session = sessionFactory.openSession();         String hql="from RunTimePO as u where SIN=? and u.date between ? and ?";          Query query = session.createQuery(hql);         query.setString(0, sin);         query.setString(1, startTime);         query.setString(2, endTime);         System.out.println(query.list().size());         List<RunTimePO> runTimeList=query.list();         return runTimeList;    }

完成

0 0