hibernate提供了丰富的api对数据库进行操作。 其中session是对数据库进行操作一个非常重要的类,他提供了对数据库增删改查的基本操作。 下面看一些具体示例,实例中实现了对数据库增加,删除,更新,根据id查询,查询全部,分页查询,以及模糊查询 package d
hibernate提供了丰富的api对数据库进行操作。
其中session是对数据库进行操作一个非常重要的类,他提供了对数据库增删改查的基本操作。
下面看一些具体示例,实例中实现了对数据库增加,删除,更新,根据id查询,查询全部,分页查询,以及模糊查询
package dao;import java.util.list;import org.hibernate.hibernateexception;import org.hibernate.query;import org.hibernate.session;import org.hibernate.transaction;import sessionfactory.hibernatesessionfactory;import entity.login;public class basedao { // 保存用户 public void save(login login) { session session = hibernatesessionfactory.getsession(); transaction tran = null; try { tran = session.begintransaction(); session.save(login); tran.commit(); system.out.println(添加成功!); } catch (hibernateexception e) { tran.rollback(); system.out.println(插入失败!); } finally { hibernatesessionfactory.closesession(); } } // 删除用户 public void delete(login login) { session session = hibernatesessionfactory.getsession(); transaction tran = null; try { tran = session.begintransaction(); session.delete(login); system.out.println(删除成功); tran.commit(); } catch (exception e) { system.out.println(删除失败); tran.rollback(); } finally { hibernatesessionfactory.closesession(); } } // 更新用户信息 public void update(login login) { session session = hibernatesessionfactory.getsession(); transaction tran = null; try { tran = session.begintransaction(); session.update(login); tran.commit(); system.out.println(更新成功!); } catch (exception e) { tran.rollback(); system.out.println(更新失败!); } finally { hibernatesessionfactory.closesession(); } } // 根据用户id查询 public login querybyid(int id) { login login =null; session session = hibernatesessionfactory.getsession(); transaction tran = null; try { tran = session.begintransaction(); login = (login) session.get(login.class, id); tran.commit(); } catch (exception e) { tran.rollback(); system.out.println(未找到用户!); } finally { hibernatesessionfactory.closesession(); } return login; } // 查询全部 public list queryall() { session session = hibernatesessionfactory.getsession(); string hql = from login; list list = null; transaction tran = null; try { tran = session.begintransaction(); query query = session.createquery(hql); list = query.list(); tran.commit(); } catch (exception e) { tran.rollback(); } finally { hibernatesessionfactory.closesession(); } return list; } // 模糊查询 public list querylike(string name) { session session = hibernatesessionfactory.getsession(); string hql = from login as l where l.username like ?; query query = session.createquery(hql); query.setstring(0, % + name + %); list list = query.list(); return list; } // 分页查询 public queryresult queryall(int firstresult, int maxresult) { queryresult qr = null; session session = hibernatesessionfactory.getsession(); transaction tran = null; try { tran = session.begintransaction(); query query = session.createquery(from login); list list = query.list(); int totalcount = list.size(); int pagesize = (totalcount%maxresult==0)?(totalcount/maxresult):(totalcount/maxresult+1); query.setfirstresult(firstresult); query.setmaxresults(maxresult); list listsize = query.list(); qr = new queryresult(pagesize, listsize); tran.commit(); } catch (exception e) { tran.rollback(); } finally { hibernatesessionfactory.closesession(); } return qr; }}