5.Hibernate工具类的简易封装

Hibernate用于持久化的一个框架，但是在实际项目中进行查询有很多的地方是需要进行一些封装的，比如他的configure以及session不可能有一个操作数据库调用dao层就创建一个，而且在获取数据的时候有很多是相同的操作，那么这些都需要进行一些封装，以下为自个进行的一个简易封装，在前面笔记Hibernate入门笔记的基础上做的一个简易项目，创建HibernateUtils工具类，封装代码如下

package com.HibernateUtils;import java.util.List;import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Restrictions;import com.whong.cust_customer;public class HibernateUtils {private static Session session;private static SessionFactory sessionFactory;private static Transaction transaction;static {Configuration configuration = new Configuration().configure();sessionFactory = configuration.buildSessionFactory();}static {session = sessionFactory.openSession();}static {transaction = session.beginTransaction();}// 插入数据public void insertData(String name,String phone) {cust_customer cust_customer = new cust_customer();cust_customer.setCust_name(name);cust_customer.setCust_phone(phone);session.save(cust_customer);transaction.commit();session.close();}// 查询所有的数据public void getAllData() {Configuration configuration = new Configuration().configure();SessionFactory sessionFactory = configuration.buildSessionFactory();Session session = sessionFactory.openSession();Query query = session.createQuery("from cust_customer");Listlist = query.list();this.PrintListArray(list);}// 根据条件查询(通过序列号1 2 3 等数字来进行查询)public void getDatawithName(String name) {Query query = session.createQuery("from cust_customer where cust_name = ?");query.setString(0, name);Listlist = query.list();this.PrintListArray(list);}// 条件查询(根据设定属性名称来进行查询)public void getDataWithNameAndPhone(String cust_name,String cust_phone) {Query query = session.createQuery("from cust_customer where cust_name = :cust_name and cust_phone = :cust_phone");query.setString("cust_name", cust_name);query.setString("cust_phone", cust_phone);Listlist = query.list();this.PrintListArray(list);}// 分页查询public void getDataSeparater(Integer minipage,Integer maxpage	) {Query query = session.createQuery("from cust_customer");query.setFirstResult(minipage);query.setMaxResults(maxpage);Listlist = query.list();this.PrintListArray(list);}// criterita查询所有数据public void getDataCriterita() {Criteria criteria = session.createCriteria(cust_customer.class);Listlist = criteria.list();this.PrintListArray(list);}// criterita条件查询public void getDataCriteritaWithName(String cust_name) {Criteria criteria = session.createCriteria(cust_customer.class);criteria.add(Restrictions.eq("cust_name", cust_name));Listlist = criteria.list();this.PrintListArray(list);}// criterita条件查询public void getDataCriteritaWithNameAndMobile(String name,String mobile) {Criteria criteria = session.createCriteria(cust_customer.class);criteria.add(Restrictions.eq("cust_name", name));criteria.add(Restrictions.eq("cust_mobile", mobile));Listlist = criteria.list();this.PrintListArray(list);}// criterita分页查询public void getDataMinAndMax(Integer min,Integer max) {Criteria criteria = session.createCriteria(cust_customer.class);criteria.setFirstResult(min);criteria.setMaxResults(max);Listlist	= criteria.list();this.PrintListArray(list);}// 打印所有的查询结果public void PrintListArray(Listlist) {for (int i = 0; i < list.size(); i++) {cust_customer cust_customer = list.get(i);System.out.println(cust_customer.getCust_id()+cust_customer.getCust_name()+cust_customer.getCust_mobile());}}
}
复制代码

在main中调用代码如下

package com.testPackage;import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.mapping.List;import com.HibernateUtils.HibernateUtils;
import com.whong.cust_customer;public class testHibernate {public static void main(String[] args) {// TODO Auto-generated method stubHibernateUtils hibernateUtils = new HibernateUtils();
//		hibernateUtils.insertData("伟鸿", "185*******9");
//		hibernateUtils.getAllData();
//		hibernateUtils.getDatawithName("weihong");
//		hibernateUtils.getDataWithNameAndPhone("伟鸿", "185******69");
//		hibernateUtils.getDataSeparater(3, 10);
//		hibernateUtils.getDataCriterita();
//		hibernateUtils.getDataCriteritaWithName("weihong");
//		hibernateUtils.getDataCriteritaWithNameAndMobile("伟鸿", "18******69");hibernateUtils.getDataMinAndMax(3, 10);}
}
复制代码

WiHongNoteBook

转载于:https://juejin.im/post/5c273210518825403339a19b

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！