hibernate DAO类的删除读取操作方法！

最新推荐文章于 2020-05-27 07:08:05 发布

zangxiaowei

最新推荐文章于 2020-05-27 07:08:05 发布

阅读量598

点赞数

文章标签： hibernate dao session list query delete

本文链接：https://blog.csdn.net/zangxiaowei/article/details/2069476

版权

删除

public void deleteByObjid(int objid) {
  Session session=this.getSessionFactory().openSession();
  Transaction t=session.beginTransaction();
  t.begin();
  Query q=session.createQuery("delete from CharacterBuff where char_obj_id=?");
  q.setInteger(0, objid);
  q.executeUpdate();
  t.commit();
  session.close();
}

读取

public List findTop100() {
  log.debug("finding all Characters instances");
  try {
   Session session=this.getSessionFactory().openSession();
   String queryString = "from Characters order by Level desc";
   Transaction t= session.beginTransaction();
   t.begin();
   Query q=session.createQuery(queryString);
   q.setFirstResult(0);
   q.setMaxResults(100);
   t.commit();
   List list=q.list();
   session.close();
   return list;
  } catch (RuntimeException re) {
   log.error("find all failed", re);
   throw re;
  }
}