1 package cqvie.yjq.Util; 2 3 import java.util.List; 4 5 import org.hibernate.Query; 6 import org.hibernate.Session; 7 import org.hibernate.SessionFactory; 8 import org.hibernate.Transaction; 9 import org.hibernate.cfg.AnnotationConfiguration; 10 11 final public class HibernataUtil { 12 13 private static SessionFactory sessionFactory = null; 14 //使用线程局部模式 15 private static ThreadLocal<Session> threadLocal = new ThreadLocal<Session>(); 16 private HibernataUtil() {}; 17 static { 18 sessionFactory = new AnnotationConfiguration().configure().buildSessionFactory(); 19 } 20 //获取全新的session 21 public static Session openSession() { 22 return sessionFactory.openSession(); 23 } 24 //获取和线程关联的session 25 public static Session getCurrentSession() { 26 Session session = threadLocal.get(); 27 //判断是否得到 28 if(session == null) { 29 session = sessionFactory.openSession(); 30 //把session对象设置到threadLocal,相当于已经和线程绑定 31 threadLocal.set(session); 32 } 33 return session; 34 } 35 36 //提供一个统一的修改和删除方法(批量) 37 public static void executeUpdate(String hql, String[] parameters) { 38 Session s = null; 39 Transaction ts = null; 40 try { 41 s = openSession(); 42 ts = s.beginTransaction(); 43 Query query = s.createQuery(hql); 44 //先判断是否有参数要绑定 45 if(parameters != null && parameters.length > 0) { 46 for(int i=0;i<parameters.length;i++) { 47 query.setString(i, parameters[i]); 48 } 49 } 50 query.executeUpdate(); 51 ts.commit(); 52 } catch(Exception e) { 53 e.printStackTrace(); 54 throw new RuntimeException(); 55 } finally { 56 if(s != null && s.isOpen()) { 57 s.close(); 58 } 59 } 60 } 61 62 //提供一个统一的添加方法 63 public static void sava(Object obj) { 64 Session s = null; 65 Transaction ts = null; 66 try { 67 s = openSession(); 68 ts = s.beginTransaction(); 69 s.save(obj); 70 ts.commit(); 71 } catch (Exception e) { 72 if(ts != null) { 73 ts.rollback(); 74 } 75 throw new RuntimeException(); 76 } finally { 77 if(s != null && s.isOpen()) { 78 s.close(); 79 } 80 } 81 } 82 83 //提供一个统一的查询方法(分页) 84 @SuppressWarnings("unchecked") 85 public static List executeQueryByPage(String hql, String[] parameters, int pageSize, int pageNow) { 86 Session s = null; 87 List list = null; 88 try { 89 s = openSession(); 90 Query query = s.createQuery(hql); 91 //先判断是否有参数要绑定 92 if(parameters != null && parameters.length > 0) { 93 for(int i=0;i<parameters.length;i++) { 94 query.setString(i, parameters[i]); 95 } 96 } 97 query.setFirstResult((pageNow-1)*pageSize).setMaxResults(pageSize); 98 list = query.list(); 99 } catch(Exception e) { 100 e.printStackTrace(); 101 throw new RuntimeException(); 102 } finally { 103 if(s != null && s.isOpen()) { 104 s.close(); 105 } 106 } 107 return list; 108 } 109 110 111 //提供一个统一的查询方法 hql 形式 from 类 where 条件=? 112 @SuppressWarnings("unchecked") 113 public List executeQuery(String hql, String[] parameters) { 114 Session s = null; 115 List list = null; 116 try { 117 s = openSession(); 118 Query query = s.createQuery(hql); 119 //先判断是否有参数要绑定 120 if(parameters != null && parameters.length > 0) { 121 for(int i=0;i<parameters.length;i++) { 122 query.setString(i, parameters[i]); 123 } 124 } 125 list = query.list(); 126 } catch(Exception e) { 127 e.printStackTrace(); 128 throw new RuntimeException(); 129 } finally { 130 if(s != null && s.isOpen()) { 131 s.close(); 132 } 133 } 134 return list; 135 } 136 }
1 package cqvie.yjq.domain; 2 3 import javax.persistence.Column; 4 import javax.persistence.Entity; 5 import javax.persistence.GeneratedValue; 6 import javax.persistence.Id; 7 import javax.persistence.Table; 8 9 import org.hibernate.annotations.GenericGenerator; 10 11 @Entity 12 @Table(name = "department_", catalog = "test") 13 public class Department implements java.io.Serializable { 14 15 private static final long serialVersionUID = 2076837731637660357L; 16 17 @Id 18 @GenericGenerator(name = "generator", strategy = "uuid") 19 @GeneratedValue(generator = "generator") 20 @Column(name = "depid", unique = true, nullable = false)//nullable = false表示该字段不为空 21 private String depid; 22 @Column(name = "name", nullable = false, length = 20) 23 private String name; 24 25 public String getDepid() { 26 return depid; 27 } 28 public void setDepid(String depid) { 29 this.depid = depid; 30 } 31 public String getName() { 32 return name; 33 } 34 public void setName(String name) { 35 this.name = name; 36 } 37 38 }
1 package cqvie.yjq.domain; 2 3 import javax.persistence.Column; 4 import javax.persistence.Entity; 5 import javax.persistence.GeneratedValue; 6 import javax.persistence.Id; 7 import javax.persistence.JoinColumn; 8 import javax.persistence.ManyToOne; 9 import javax.persistence.Table; 10 11 import org.hibernate.annotations.GenericGenerator; 12 13 14 @Entity 15 @Table(name = "student_", catalog = "test") 16 public class Student implements java.io.Serializable { 17 18 private static final long serialVersionUID = 8640757615294410421L; 19 20 @Id 21 @GenericGenerator(name = "generator", strategy = "uuid") 22 @GeneratedValue(generator = "generator") 23 @Column(name = "stuid", unique = true, nullable = false) 24 private String stuid; 25 @Column(name = "name", nullable = false, length = 20) 26 private String name; 27 @ManyToOne 28 @JoinColumn(name = "depid") 29 private Department dept; 30 31 public String getStuid() { 32 return stuid; 33 } 34 public void setStuid(String stuid) { 35 this.stuid = stuid; 36 } 37 public String getName() { 38 return name; 39 } 40 public void setName(String name) { 41 this.name = name; 42 } 43 public Department getDept() { 44 return dept; 45 } 46 public void setDept(Department dept) { 47 this.dept = dept; 48 } 49 50 51 }
1 package cqvie.yjq.View; 2 3 import org.hibernate.Session; 4 import org.hibernate.Transaction; 5 6 import cqvie.yjq.Util.HibernataUtil; 7 import cqvie.yjq.domain.Department; 8 import cqvie.yjq.domain.Student; 9 10 public class Test { 11 12 public static void main(String[] args) { 13 14 //通过获取session让hibernate框架运行(config --> 加载hibernate.cfg.xml) 15 Session session = null; 16 Transaction tx = null; 17 try { 18 session = HibernataUtil.getCurrentSession(); 19 tx = session.beginTransaction(); 20 21 Student stu = new Student(); 22 stu.setName("王敏"); 23 24 Department dep = new Department(); 25 dep.setName("财务部"); 26 Department dep1 = new Department(); 27 dep1.setName("人事部"); 28 29 stu.setDept(dep1); 30 31 session.save(stu); 32 session.save(dep); 33 session.save(dep1); 34 35 tx.commit(); 36 } catch (Exception e) { 37 if(tx != null) { 38 tx.rollback(); 39 } 40 } finally { 41 if(session != null && session.isOpen()) { 42 session.close(); 43 } 44 } 45 } 46 47 }
1 <?xml version='1.0' encoding='UTF-8'?> 2 <!DOCTYPE hibernate-configuration PUBLIC 3 "-//Hibernate/Hibernate Configuration DTD 3.0//EN" 4 "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> 5 6 <!-- Generated by MyEclipse Hibernate Tools. --> 7 <hibernate-configuration> 8 9 <session-factory> 10 <property name="dialect"> 11 org.hibernate.dialect.MySQLDialect 12 </property> 13 <property name="connection.url"> 14 jdbc:mysql://localhost:3306/student 15 </property> 16 <property name="connection.username">root</property> 17 <property name="connection.password">123</property> 18 <property name="connection.driver_class"> 19 com.mysql.jdbc.Driver 20 </property> 21 <property name="myeclipse.connection.profile">MySQL</property> 22 <property name="show_sql">true</property> 23 <!-- 格式化显示SQL --> 24 <property name="format_sql">true</property> 25 26 <property name="current_session_context_class">thread</property> 27 <!-- 让hibernate自动创建表 update:如果没有表则创建,有表则更新 --> 28 <property name="hbm2ddl.auto">create</property> 29 <mapping class="cqvie.yjq.domain.Department" /> 30 <mapping class="cqvie.yjq.domain.Student" /> 31 </session-factory> 32 33 </hibernate-configuration>