这两天写了不少HQL语句,总结起来都是四步,在这四步的基础上加上其它的处理逻辑就行了。
直接看代码吧:
public static List<Integer> getAbsOperationIDsByServiceID(int sid){
List<Integer> result=new ArrayList<Integer>();
Session session = HibernateSessionFactory.getSession();//1.获得session
Transaction 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;
}