Hibernate主键生成
生成操控的对象
程序员自己控制:assigned
数据库控制: identity(标识列/自动增长) sequence
hibernate控制:increment uuid/uuid.hex
其它:native
代码演示
今天使用两张表
t_hibernate_student
id为int类型
t_hibernate_worker
id为varchar类型
Student
package com.tzx.two.entity;
public class Student {
private Integer sid;
private String sname;
public Integer getSid() {
return sid;
}
public void setSid(Integer sid) {
this.sid = sid;
}
public String getSname() {
return sname;
}
public void setSname(String sname) {
this.sname = sname;
}
public Student(Integer sid, String sname) {
super();
this.sid = sid;
this.sname = sname;
}
public Student() {
super();
}
@Override
public String toString() {
return "Student [sid=" + sid + ", sname=" + sname + "]";
}
}
worker
package com.tzx.two.entity;
public class Worker {
private String wid;
private String wname;
public String getWid() {
return wid;
}
public void setWid(String wid) {
this.wid = wid;
}
public String getWname() {
return wname;
}
public void setWname(String wname) {
this.wname = wname;
}
public Worker(String wid, String wname) {
super();
this.wid = wid;
this.wname = wname;
}
public Worker() {
super();
}
@Override
public String toString() {
return "Worker [wid=" + wid + ", wname=" + wname + "]";
}
}
Student.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.tzx.two.entity.Student" table="t_hibernate_student">
<id name="sid" type="java.lang.Integer" column="sid">
<generator class="assigned" />
<!-- <generator class="identity" /> -->
<!-- <generator class="increment" /> -->
<!-- <generator class="sequence" /> -->
<!-- <generator class="sequence" > <param name="sequence_name">aaa</param>
</generator> -->
<!-- <generator class="com.javaxl.two.id.Myts" /> -->
</id>
<property name="sname" type="java.lang.String" column="sname">
</property>
</class>
</hibernate-mapping>
Worker.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.tzx.two.entity.Worker" table="t_hibernate_worker">
<id name="wid" type="java.lang.String" column="wid">
<!-- <generator class="assigned" /> -->
<!-- <generator class="uuid" /> -->
<generator class="com.tzx.two.id.MyTsGeneraTor" />
<!-- <generator class="sequence" /> -->
<!-- <generator class="sequence" > <param name="sequence_name">aaa</param>
</generator> -->
<!-- <generator class="com.javaxl.two.id.Myts" /> -->
</id>
<property name="wname" type="java.lang.String" column="wname">
</property>
</class>
</hibernate-mapping>
hibernate.cfg.xml配置
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- 1. 数据库相关 -->
<property name="connection.username">root</property>
<property name="connection.password">123</property>
<property name="connection.url">jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8
</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- 配置本地事务(No CurrentSessionContext configured!) -->
<property name="hibernate.current_session_context_class">thread</property>
<!-- 2. 调试相关 -->
<property name="show_sql">true</property>
<property name="format_sql">true</property>
<!-- 3. 添加实体映射文件 -->
<mapping resource="com/tzx/one/entity/User.hbm.xml" />
<!-- 主键生成策略 -->
<mapping resource="com/tzx/two/entity/Student.hbm.xml" />
<mapping resource="com/tzx/two/entity/Worker.hbm.xml" />
</session-factory>
</hibernate-configuration>
主要
<!-- 主键生成策略 -->
<mapping resource="com/tzx/two/entity/Student.hbm.xml" />
<mapping resource="com/tzx/two/entity/Worker.hbm.xml" />
SessionFactoryUtils
package com.tzx.two.uitl;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
/**
* 仅在学习hibernate的工程中使用,当进入spring的学习后就没用了,后面会有ssh来替代
* 作用:
* 用来检测hibernate中的配置文件的准确性
* hiberbate.cfg.xml
* *.hbm.xml
* @author
*
*/
public class SessionFactoryUtils {
private static SessionFactory sessionFactory;
static {
Configuration cfg = new Configuration().configure("hibernate.cfg.xml");
sessionFactory = cfg.buildSessionFactory();
}
public static Session openSession() {
// 从本地的线程中获取session会话,第一次肯定是获取不到的,那么需要重新让sessionfactory创建
// 第二次就能够对第一次创建的session反复利用,节约性能
Session session = sessionFactory.getCurrentSession();
if(session == null) {
session = sessionFactory.openSession();
}
return session;
}
public static void closeSession() {
Session session = sessionFactory.getCurrentSession();
if(session != null && session.isOpen()) {
session.close();
}
}
public static void main(String[] args) {
Session session = SessionFactoryUtils.openSession();
session.beginTransaction();
System.out.println(session.isConnected());
SessionFactoryUtils.closeSession();
System.out.println(session.isConnected());
}
}
运行(assigned等策略应在xxx.hbm.xml中释放或注释)
当t_hibernate_student表设置id自增长时使用assigned
package com.tzx.two.dao;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.tzx.two.entity.Student;
import com.tzx.two.entity.Worker;
import com.tzx.two.uitl.SessionFactoryUtils;
/**
* hiberbate中的主键生成策略
* 1.人工控制
* 2.数据库控制
* 3.hibernate控制
* 4.自定义主键生成策略
* @author
*
*/
public class DemoDao {
/**
* 新增学生
* @param stu
*/
public void addStudent(Student stu) {
Session session = SessionFactoryUtils.openSession();
Transaction transaction = session.beginTransaction();
session.save(stu);
transaction.commit();
SessionFactoryUtils.closeSession();
}
/**
* 新增工人
* @param worker
*/
public void addWorker(Worker worker) {
Session session = SessionFactoryUtils.openSession();
Transaction transaction = session.beginTransaction();
session.save(worker);
transaction.commit();
SessionFactoryUtils.closeSession();
}
public static void main(String[] args) {
DemoDao dao=new DemoDao();
Student stu=new Student();
stu.setSname("大贤");
stu.setSid(70);
dao.addStudent(stu);
}
}
当t_hibernate_student表设置id自增长时使用identity
public static void main(String[] args) {
DemoDao dao=new DemoDao();
Student stu=new Student();
stu.setSname("大贤2");
stu.setSid(73);
dao.addStudent(stu);
}
当t_hibernate_student表id没有哦自增长时使用increment
注:使用这个策略数据库表id必须是int类型
public static void main(String[] args) {
DemoDao dao=new DemoDao();
Student stu=new Student();
stu.setSname("大贤3");
stu.setSid(73);
dao.addStudent(stu);
}
当t_hibernate_worker表使用uuid
public static void main(String[] args) {
DemoDao dao=new DemoDao();
Worker worker=new Worker();
worker.setWname("贤贤1");
dao.addWorker(worker);
}
自定义主键生成器
使用t_hibernate_worker表
1 *.hbm.xml指定主键生成器类
<generator class="com.tzx.two.id.MyTsGeneraTor" />
2 创建主键生成器类
实现org.hibernate.id.IdentifierGenerator接口即可,并还可以实现org.hibernate.id.Configurable接口来读取一些配置信息
MyTsGeneraTor
package com.tzx.two.id;
import java.io.Serializable;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.hibernate.HibernateException;
import org.hibernate.engine.spi.SharedSessionContractImplementor;
import org.hibernate.id.IdentifierGenerator;
public class MyTsGeneraTor implements IdentifierGenerator {
@Override
public Serializable generate(SharedSessionContractImplementor arg0, Object arg1) throws HibernateException {
// TODO Auto-generated method stub
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
return "tanzhixian_"+sdf.format(new Date());
}
}
// 测试工人
public static void main(String[] args) {
DemoDao dao=new DemoDao();
Worker worker=new Worker();
worker.setWname("贤贤2");
dao.addWorker(worker);
}