Hibernate中HQL话语的一般写法

Hibernate中HQL语句的一般写法

这两天写了不少HQL语句，总结起来都是四步，在这四步的基础上加上其它的处理逻辑就行了。

直接看代码吧：

public static List<Integer> getAbsOperationIDsByServiceID(int sid){List<Integer> result=new ArrayList<Integer>();Session session = HibernateSessionFactory.getSession();//1.获得sessionTransaction tx = null;//2.写hql语句String hql = "select abstractOperation.asid from AoperationServiceMapping where serviceinfo.sid = "+sid;try {tx = session.beginTransaction();Query query = session.createQuery(hql);//3.创建Query对象result = query.list();//4.执行查询tx.commit();} catch (Exception e) {if (tx != null) {tx.rollback();}} finally {HibernateSessionFactory.closeSession();}return result;}

?