在“
Hibernate关联关系映射实例速查”一文中,通过myeclipse5.5,快速做出了Hibernate各种映射的示例。时隔快一年了,但是还是有博友向我索要工程源码,很遗憾的是已经找不到了。但找到一了一个测试代码:对双向关联和乐观锁的测试。其实映射类型很多,搞清楚一对多,基本上所有的映射就搞明白了,一对一也是一对多的特例而已,多对多也可以转换为一对多和多对一,并且实际中很少用到多对多。
还是老规矩,因为是测试,代码几乎全部是myeclipse生成的,我稍作了修改。并且应博友“阿飞”的留言,我做了详细的注释。
例子两部分:
1、一对多双向映射:模型是“班级-学生”模型。两个实体分别是Tclass和Student。
2、乐观锁的是使用,版本分别使用递增整数和时间戳。两个实体分别是Foo和Bar。
Tclass实体及其映射:
public
class Tclass
implements java.io.Serializable {
// Fields
private Long cid;
private String cname;
private Set students = new HashSet(0);
// Constructors
// Property accessors
.......
public String toString() {
return "Tclass{" +
"cid=" + cid +
", cname='" + cname + '\'' +
'}';
}
}
// Fields
private Long cid;
private String cname;
private Set students = new HashSet(0);
// Constructors
// Property accessors
.......
public String toString() {
return "Tclass{" +
"cid=" + cid +
", cname='" + cname + '\'' +
'}';
}
}
<
hibernate-mapping
>
< class name ="stu.one2many.pojo.Tclass" table ="tclass" >
< id name ="cid" type ="java.lang.Long" >
< column name ="cid" />
< generator class ="native" />
</ id >
< property name ="cname" type ="java.lang.String" >
< column name ="cname" length ="24" not-null ="true" />
</ property >
<!-- set元素属性说明:
name="students" 设置表示多个学生的变量名;
inverse="true" 关系控制反转,不掌握主控权,表示Tclass不控制与Student关联关系,而是将这种关联控制的权利转给Student。
cascade="all" 表示级联操作,操作班级的时候,对班级关联的学生也做同样的操作。
lazy="true" 查询班级的时候,延迟查询班级下的学生。
-->
< set name ="students" inverse ="true" cascade ="all" lazy ="true" >
< key >
<!--
name="fk_cid" 指定关联的外键列;
not-null="true" 说明这个外间列不能为空,多余的。
-->
< column name ="fk_cid" not-null ="true" />
</ key >
<!-- 指定所关联的类 -->
< one-to-many class ="stu.one2many.pojo.Student" />
</ set >
</ class >
</ hibernate-mapping >
< class name ="stu.one2many.pojo.Tclass" table ="tclass" >
< id name ="cid" type ="java.lang.Long" >
< column name ="cid" />
< generator class ="native" />
</ id >
< property name ="cname" type ="java.lang.String" >
< column name ="cname" length ="24" not-null ="true" />
</ property >
<!-- set元素属性说明:
name="students" 设置表示多个学生的变量名;
inverse="true" 关系控制反转,不掌握主控权,表示Tclass不控制与Student关联关系,而是将这种关联控制的权利转给Student。
cascade="all" 表示级联操作,操作班级的时候,对班级关联的学生也做同样的操作。
lazy="true" 查询班级的时候,延迟查询班级下的学生。
-->
< set name ="students" inverse ="true" cascade ="all" lazy ="true" >
< key >
<!--
name="fk_cid" 指定关联的外键列;
not-null="true" 说明这个外间列不能为空,多余的。
-->
< column name ="fk_cid" not-null ="true" />
</ key >
<!-- 指定所关联的类 -->
< one-to-many class ="stu.one2many.pojo.Student" />
</ set >
</ class >
</ hibernate-mapping >
Student实体及其映射
public
class Student
implements java.io.Serializable {
// Fields
private Long sid;
private Tclass tclass;
private String sname;
// Constructors
// Property accessors
.......
public String toString() {
return "Student{" +
"sid=" + sid +
", sname='" + sname + '\'' +
'}';
}
}
// Fields
private Long sid;
private Tclass tclass;
private String sname;
// Constructors
// Property accessors
.......
public String toString() {
return "Student{" +
"sid=" + sid +
", sname='" + sname + '\'' +
'}';
}
}
<
hibernate-mapping
>
< class name ="stu.one2many.pojo.Student" table ="student" >
< id name ="sid" type ="java.lang.Long" >
< column name ="sid" />
< generator class ="native" />
</ id >
<!-- 表示多个Student关联一个Tclass -->
<!--
name="tclass" 关联的成员变量名;
class="stu.one2many.pojo.Tclass" 表示所关联的类;
fetch="select" 查询策略,有两个选项select和join,
select表示通过外联接来进行查询,查询速度稍慢,但消耗资源少;
join表示通过内连接来查询,速度快,但消耗资源多.
-->
< many-to-one name ="tclass"
class ="stu.one2many.pojo.Tclass"
fetch ="select" >
<!-- 指定关联的外键列 -->
< column name ="fk_cid" not-null ="true" />
</ many-to-one >
< property name ="sname" type ="java.lang.String" >
< column name ="sname" length ="24" not-null ="true" />
</ property >
</ class >
</ hibernate-mapping >
< class name ="stu.one2many.pojo.Student" table ="student" >
< id name ="sid" type ="java.lang.Long" >
< column name ="sid" />
< generator class ="native" />
</ id >
<!-- 表示多个Student关联一个Tclass -->
<!--
name="tclass" 关联的成员变量名;
class="stu.one2many.pojo.Tclass" 表示所关联的类;
fetch="select" 查询策略,有两个选项select和join,
select表示通过外联接来进行查询,查询速度稍慢,但消耗资源少;
join表示通过内连接来查询,速度快,但消耗资源多.
-->
< many-to-one name ="tclass"
class ="stu.one2many.pojo.Tclass"
fetch ="select" >
<!-- 指定关联的外键列 -->
< column name ="fk_cid" not-null ="true" />
</ many-to-one >
< property name ="sname" type ="java.lang.String" >
< column name ="sname" length ="24" not-null ="true" />
</ property >
</ class >
</ hibernate-mapping >
测试班级学生模型:
public
class Test {
/**
* @param args
*/
public static void main(String[] args) {
testSave();
// testDeleteTclass();
}
public static void testSave() {
Tclass c = new Tclass();
c.setCname( "某班级");
Student s1 = new Student();
Student s2 = new Student();
s1.setSname( "张三");
s1.setTclass(c);
s2.setSname( "李四");
s2.setTclass(c);
c.getStudents().add(s1);
c.getStudents().add(s2);
Session session = HibernateSessionFactory.getSession();
Transaction tx = session.beginTransaction();
session.save(c);
tx.commit();
session.close();
}
public static void testUpdateClass() {
System.out.println( "----------------正在调用testUpdateClass()----------------");
Session session = HibernateSessionFactory.getSession();
Tclass c = (Tclass) session.load(Tclass. class, Long.valueOf(1L));
System.out.println(c);
c.setCname( "班级更名");
session.beginTransaction().commit();
}
public static void testUpdateStudent() {
System.out.println( "----------------正在调用testUpdateStudent()----------------");
Session session = HibernateSessionFactory.getSession();
Tclass c = (Tclass) session.load(Tclass. class, Long.valueOf(3L));
Student s = (Student) session.load(Student. class, Long.valueOf(2L));
s.setSname( "学生改名换姓-王八");
s.setTclass(c);
System.out.println(c);
System.out.println(s);
session.beginTransaction().commit();
System.out.println(s);
System.out.println(s.getTclass());
}
public static void testDeleteStudent() {
System.out.println( "----------------正在调用testDelete()----------------");
Session session = HibernateSessionFactory.getSession();
Student s = (Student) session.load(Student. class, Long.valueOf(5L));
System.out.println(s);
System.out.println(s.getTclass());
session.delete(s);
session.beginTransaction().commit();
}
public static void testDeleteTclass() {
System.out.println( "----------------正在调用testDelete()----------------");
Session session = HibernateSessionFactory.getSession();
Tclass c = (Tclass) session.load(Tclass. class, Long.valueOf(3L));
System.out.println(c);
session.delete(c);
session.beginTransaction().commit();
}
public static void testQueryClass() {
System.out.println( "----------------正在调用testQueryClass()----------------");
Session session = HibernateSessionFactory.getSession();
Tclass c = (Tclass) session.load(Tclass. class, new Long( "1"));
System.out.println(c);
System.out.println(c.getStudents());
}
public static void testQueryStudent() {
System.out.println( "----------------正在调用testQueryStudent()----------------");
Session session = HibernateSessionFactory.getSession();
Student s = (Student) session.load(Student. class, new Long( "1"));
System.out.println(s);
System.out.println(s.getTclass());
}
}
/**
* @param args
*/
public static void main(String[] args) {
testSave();
// testDeleteTclass();
}
public static void testSave() {
Tclass c = new Tclass();
c.setCname( "某班级");
Student s1 = new Student();
Student s2 = new Student();
s1.setSname( "张三");
s1.setTclass(c);
s2.setSname( "李四");
s2.setTclass(c);
c.getStudents().add(s1);
c.getStudents().add(s2);
Session session = HibernateSessionFactory.getSession();
Transaction tx = session.beginTransaction();
session.save(c);
tx.commit();
session.close();
}
public static void testUpdateClass() {
System.out.println( "----------------正在调用testUpdateClass()----------------");
Session session = HibernateSessionFactory.getSession();
Tclass c = (Tclass) session.load(Tclass. class, Long.valueOf(1L));
System.out.println(c);
c.setCname( "班级更名");
session.beginTransaction().commit();
}
public static void testUpdateStudent() {
System.out.println( "----------------正在调用testUpdateStudent()----------------");
Session session = HibernateSessionFactory.getSession();
Tclass c = (Tclass) session.load(Tclass. class, Long.valueOf(3L));
Student s = (Student) session.load(Student. class, Long.valueOf(2L));
s.setSname( "学生改名换姓-王八");
s.setTclass(c);
System.out.println(c);
System.out.println(s);
session.beginTransaction().commit();
System.out.println(s);
System.out.println(s.getTclass());
}
public static void testDeleteStudent() {
System.out.println( "----------------正在调用testDelete()----------------");
Session session = HibernateSessionFactory.getSession();
Student s = (Student) session.load(Student. class, Long.valueOf(5L));
System.out.println(s);
System.out.println(s.getTclass());
session.delete(s);
session.beginTransaction().commit();
}
public static void testDeleteTclass() {
System.out.println( "----------------正在调用testDelete()----------------");
Session session = HibernateSessionFactory.getSession();
Tclass c = (Tclass) session.load(Tclass. class, Long.valueOf(3L));
System.out.println(c);
session.delete(c);
session.beginTransaction().commit();
}
public static void testQueryClass() {
System.out.println( "----------------正在调用testQueryClass()----------------");
Session session = HibernateSessionFactory.getSession();
Tclass c = (Tclass) session.load(Tclass. class, new Long( "1"));
System.out.println(c);
System.out.println(c.getStudents());
}
public static void testQueryStudent() {
System.out.println( "----------------正在调用testQueryStudent()----------------");
Session session = HibernateSessionFactory.getSession();
Student s = (Student) session.load(Student. class, new Long( "1"));
System.out.println(s);
System.out.println(s.getTclass());
}
}
下面是乐观锁的使用:
1、基于整数的版本控制
Foo实体和映射文件
public
class Foo
implements java.io.Serializable {
// Fields
private Long pid;
private Integer version;
private String name;
// Constructors
// Property accessors
.......
public String toString() {
return "Foo{" +
"pid=" + pid +
", version=" + version +
", name='" + name + '\'' +
'}';
}
}
// Fields
private Long pid;
private Integer version;
private String name;
// Constructors
// Property accessors
.......
public String toString() {
return "Foo{" +
"pid=" + pid +
", version=" + version +
", name='" + name + '\'' +
'}';
}
}
<
hibernate-mapping
>
< class name ="stu.one2many.pojo.Foo" table ="foo"
optimistic-lock ="version" >
< id name ="pid" type ="java.lang.Long" >
< column name ="pid" />
< generator class ="native" />
</ id >
<!-- 版本控制字段必须在id后配置 -->
< version name ="version" type ="java.lang.Integer" >
< column name ="version" />
</ version >
< property name ="name" type ="java.lang.String" >
< column name ="name" length ="24" not-null ="true" />
</ property >
</ class >
</ hibernate-mapping >
< class name ="stu.one2many.pojo.Foo" table ="foo"
optimistic-lock ="version" >
< id name ="pid" type ="java.lang.Long" >
< column name ="pid" />
< generator class ="native" />
</ id >
<!-- 版本控制字段必须在id后配置 -->
< version name ="version" type ="java.lang.Integer" >
< column name ="version" />
</ version >
< property name ="name" type ="java.lang.String" >
< column name ="name" length ="24" not-null ="true" />
</ property >
</ class >
</ hibernate-mapping >
测试:
public
class TestFoo {
/**
* @param args
*/
public static void main(String[] args) {
testSave();
}
public static void testSave(){
Foo foo1 = new Foo( "foo1");
Session session = HibernateSessionFactory.getSession();
session.save(foo1);
session.beginTransaction().commit();
session.close();
}
}
/**
* @param args
*/
public static void main(String[] args) {
testSave();
}
public static void testSave(){
Foo foo1 = new Foo( "foo1");
Session session = HibernateSessionFactory.getSession();
session.save(foo1);
session.beginTransaction().commit();
session.close();
}
}
2、基于时间戳的版本控制
public
class Bar
implements java.io.Serializable, Comparable {
// Fields
private Long id;
private Date timestamp;
private String name;
// Constructors
// Property accessors
.......
public String toString() {
return "Bar{" +
"id=" + id +
", timestamp=" + timestamp +
", name='" + name + '\'' +
'}';
}
/**
* 排序接口方法实现,为了能对查询结果按照id的大小进行排序
* @param o 排序对象
* @return 比较值
*/
public int compareTo(Object o) {
Bar bar = (Bar) o;
Long res = this.id - bar.getId();
return res.intValue();
}
}
// Fields
private Long id;
private Date timestamp;
private String name;
// Constructors
// Property accessors
.......
public String toString() {
return "Bar{" +
"id=" + id +
", timestamp=" + timestamp +
", name='" + name + '\'' +
'}';
}
/**
* 排序接口方法实现,为了能对查询结果按照id的大小进行排序
* @param o 排序对象
* @return 比较值
*/
public int compareTo(Object o) {
Bar bar = (Bar) o;
Long res = this.id - bar.getId();
return res.intValue();
}
}
<
hibernate-mapping
>
< class name ="stu.one2many.pojo.Bar" table ="bar" optimistic-lock ="version" >
< id name ="id" type ="java.lang.Long" >
< column name ="id" />
< generator class ="native" />
</ id >
< version name ="timestamp" type ="java.util.Date" >
< column name ="timestamp" length ="0" not-null ="true" />
</ version >
< property name ="name" type ="java.lang.String" >
< column name ="name" length ="24" not-null ="true" />
</ property >
</ class >
</ hibernate-mapping >
< class name ="stu.one2many.pojo.Bar" table ="bar" optimistic-lock ="version" >
< id name ="id" type ="java.lang.Long" >
< column name ="id" />
< generator class ="native" />
</ id >
< version name ="timestamp" type ="java.util.Date" >
< column name ="timestamp" length ="0" not-null ="true" />
</ version >
< property name ="name" type ="java.lang.String" >
< column name ="name" length ="24" not-null ="true" />
</ property >
</ class >
</ hibernate-mapping >
public
class TestBar {
public static void main(String args[]) {
testUpdateBar();
testQueryBar();
}
public static void testSaveBar() {
Bar bar = new Bar( "bar");
Session session = HibernateSessionFactory.getSession();
session.save(bar);
session.beginTransaction().commit();
session.close();
}
public static void testQueryBar() {
Session session = HibernateSessionFactory.getSession();
String hql = "from Bar";
Query query = session.createQuery(hql);
List<Bar> barList = query.list();
Collections.sort(barList);
for (Bar bar : barList) {
System.out.println(bar.getId() + ":\t" + bar.getTimestamp().getTime());
}
session.close();
}
public static void testUpdateBar() {
Session session = HibernateSessionFactory.getSession();
String hql = "from Bar";
Query query = session.createQuery(hql);
List<Bar> barList = query.list();
for (Bar bar : barList) {
bar.setName( "newBar");
}
session.beginTransaction().commit();
session.close();
}
}
public static void main(String args[]) {
testUpdateBar();
testQueryBar();
}
public static void testSaveBar() {
Bar bar = new Bar( "bar");
Session session = HibernateSessionFactory.getSession();
session.save(bar);
session.beginTransaction().commit();
session.close();
}
public static void testQueryBar() {
Session session = HibernateSessionFactory.getSession();
String hql = "from Bar";
Query query = session.createQuery(hql);
List<Bar> barList = query.list();
Collections.sort(barList);
for (Bar bar : barList) {
System.out.println(bar.getId() + ":\t" + bar.getTimestamp().getTime());
}
session.close();
}
public static void testUpdateBar() {
Session session = HibernateSessionFactory.getSession();
String hql = "from Bar";
Query query = session.createQuery(hql);
List<Bar> barList = query.list();
for (Bar bar : barList) {
bar.setName( "newBar");
}
session.beginTransaction().commit();
session.close();
}
}
public
class TestStack {
public static void main(String args[]){
test();
}
public static void test(){
Stack stack = new Stack();
String s1= "1";
String s2= "2";
String s3= "3";
String s4= "4";
stack.push(s1);
stack.push(s2);
stack.push(s3);
stack.push(s4);
for(;!stack.isEmpty();){
System.out.println(stack.pop());
}
//for语句先判断是否符合条件,然后确定是否执行循环
for( int i=0;i>10;i--){
System.out.println( ">>> "+i);
}
}
}
public static void main(String args[]){
test();
}
public static void test(){
Stack stack = new Stack();
String s1= "1";
String s2= "2";
String s3= "3";
String s4= "4";
stack.push(s1);
stack.push(s2);
stack.push(s3);
stack.push(s4);
for(;!stack.isEmpty();){
System.out.println(stack.pop());
}
//for语句先判断是否符合条件,然后确定是否执行循环
for( int i=0;i>10;i--){
System.out.println( ">>> "+i);
}
}
}
下面是SessionFactory工具和hibernate配置文件:
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
/**
* Configures and provides access to Hibernate sessions, tied to the
* current thread of execution. Follows the Thread Local Session
* pattern, see {@link [url]http://hibernate.org/42.html[/url] }.
*/
public class HibernateSessionFactory {
/**
* Location of hibernate.cfg.xml file.
* Location should be on the classpath as Hibernate uses
* #resourceAsStream style lookup for its configuration file.
* The default classpath location of the hibernate config file is
* in the default package. Use #setConfigFile() to update
* the location of the configuration file for the current session.
*/
private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";
private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
private static Configuration configuration = new Configuration();
private static org.hibernate.SessionFactory sessionFactory;
private static String configFile = CONFIG_FILE_LOCATION;
static {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println( "%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
private HibernateSessionFactory() {
}
/**
* Returns the ThreadLocal Session instance. Lazy initialize
* the <code>SessionFactory</code> if needed.
*
* @return Session
* @throws HibernateException
*/
public static Session getSession() throws HibernateException {
Session session = (Session) threadLocal.get();
if (session == null || !session.isOpen()) {
if (sessionFactory == null) {
rebuildSessionFactory();
}
session = (sessionFactory != null) ? sessionFactory.openSession()
: null;
threadLocal.set(session);
}
return session;
}
/**
* Rebuild hibernate session factory
*
*/
public static void rebuildSessionFactory() {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println( "%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
/**
* Close the single hibernate session instance.
*
* @throws HibernateException
*/
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set( null);
if (session != null) {
session.close();
}
}
/**
* return session factory
*
*/
public static org.hibernate.SessionFactory getSessionFactory() {
return sessionFactory;
}
/**
* return session factory
*
* session factory will be rebuilded in the next call
*/
public static void setConfigFile(String configFile) {
HibernateSessionFactory.configFile = configFile;
sessionFactory = null;
}
/**
* return hibernate configuration
*
*/
public static Configuration getConfiguration() {
return configuration;
}
}
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
/**
* Configures and provides access to Hibernate sessions, tied to the
* current thread of execution. Follows the Thread Local Session
* pattern, see {@link [url]http://hibernate.org/42.html[/url] }.
*/
public class HibernateSessionFactory {
/**
* Location of hibernate.cfg.xml file.
* Location should be on the classpath as Hibernate uses
* #resourceAsStream style lookup for its configuration file.
* The default classpath location of the hibernate config file is
* in the default package. Use #setConfigFile() to update
* the location of the configuration file for the current session.
*/
private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";
private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
private static Configuration configuration = new Configuration();
private static org.hibernate.SessionFactory sessionFactory;
private static String configFile = CONFIG_FILE_LOCATION;
static {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println( "%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
private HibernateSessionFactory() {
}
/**
* Returns the ThreadLocal Session instance. Lazy initialize
* the <code>SessionFactory</code> if needed.
*
* @return Session
* @throws HibernateException
*/
public static Session getSession() throws HibernateException {
Session session = (Session) threadLocal.get();
if (session == null || !session.isOpen()) {
if (sessionFactory == null) {
rebuildSessionFactory();
}
session = (sessionFactory != null) ? sessionFactory.openSession()
: null;
threadLocal.set(session);
}
return session;
}
/**
* Rebuild hibernate session factory
*
*/
public static void rebuildSessionFactory() {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println( "%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
/**
* Close the single hibernate session instance.
*
* @throws HibernateException
*/
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set( null);
if (session != null) {
session.close();
}
}
/**
* return session factory
*
*/
public static org.hibernate.SessionFactory getSessionFactory() {
return sessionFactory;
}
/**
* return session factory
*
* session factory will be rebuilded in the next call
*/
public static void setConfigFile(String configFile) {
HibernateSessionFactory.configFile = configFile;
sessionFactory = null;
}
/**
* return hibernate configuration
*
*/
public static Configuration getConfiguration() {
return configuration;
}
}
<?
xml
version
='1.0'
encoding
='UTF-8'
?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools. -->
< hibernate-configuration >
< session-factory >
< property name ="connection.username" >root </ property >
< property name ="connection.url" >
jdbc:mysql://localhost:3306/testdb
</ property >
< property name ="dialect" >
org.hibernate.dialect.MySQLDialect
</ property >
< property name ="myeclipse.connection.profile" >
com.mysql.jdbc.Driver
</ property >
< property name ="connection.password" >leizhimin </ property >
< property name ="connection.driver_class" >
com.mysql.jdbc.Driver
</ property >
< property name ="show_sql" >true </ property >
<!-- <property name="format_sql">true</property>-->
< property name ="hbm2ddl.auto" >create </ property >
< mapping resource ="stu/one2many/pojo/Tclass.hbm.xml" />
< mapping resource ="stu/one2many/pojo/Student.hbm.xml" />
< mapping resource ="stu/one2many/pojo/Foo.hbm.xml" > </ mapping >
< mapping resource ="stu/one2many/pojo/Bar.hbm.xml" />
</ session-factory >
</ hibernate-configuration >
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools. -->
< hibernate-configuration >
< session-factory >
< property name ="connection.username" >root </ property >
< property name ="connection.url" >
jdbc:mysql://localhost:3306/testdb
</ property >
< property name ="dialect" >
org.hibernate.dialect.MySQLDialect
</ property >
< property name ="myeclipse.connection.profile" >
com.mysql.jdbc.Driver
</ property >
< property name ="connection.password" >leizhimin </ property >
< property name ="connection.driver_class" >
com.mysql.jdbc.Driver
</ property >
< property name ="show_sql" >true </ property >
<!-- <property name="format_sql">true</property>-->
< property name ="hbm2ddl.auto" >create </ property >
< mapping resource ="stu/one2many/pojo/Tclass.hbm.xml" />
< mapping resource ="stu/one2many/pojo/Student.hbm.xml" />
< mapping resource ="stu/one2many/pojo/Foo.hbm.xml" > </ mapping >
< mapping resource ="stu/one2many/pojo/Bar.hbm.xml" />
</ session-factory >
</ hibernate-configuration >
数据库用的是mysql5,sql脚本我导出了一份如下:
/*
SQLyog Enterprise - MySQL GUI v6.5
MySQL - 5.0.45-community-nt : Database - testdb
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
create database if not exists testdb;
USE testdb;
/*Table structure for table bar */
DROP TABLE IF EXISTS bar;
CREATE TABLE bar (
id bigint(20) NOT NULL auto_increment,
timestamp datetime NOT NULL,
name varchar(24) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
/*Table structure for table foo */
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
pid bigint(20) NOT NULL auto_increment,
version int(11) NOT NULL,
name varchar(24) NOT NULL,
PRIMARY KEY (pid)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
/*Table structure for table student */
DROP TABLE IF EXISTS student;
CREATE TABLE student (
sid bigint(20) NOT NULL auto_increment,
fk_cid bigint(20) NOT NULL,
sname varchar(24) NOT NULL,
PRIMARY KEY (sid),
KEY FK8FFE823B3AA29689 (fk_cid),
CONSTRAINT FK8FFE823B3AA29689 FOREIGN KEY (fk_cid) REFERENCES tclass (cid)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;
/*Table structure for table tclass */
DROP TABLE IF EXISTS tclass;
CREATE TABLE tclass (
cid bigint(20) NOT NULL auto_increment,
cname varchar(24) NOT NULL,
PRIMARY KEY (cid)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
SQLyog Enterprise - MySQL GUI v6.5
MySQL - 5.0.45-community-nt : Database - testdb
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
create database if not exists testdb;
USE testdb;
/*Table structure for table bar */
DROP TABLE IF EXISTS bar;
CREATE TABLE bar (
id bigint(20) NOT NULL auto_increment,
timestamp datetime NOT NULL,
name varchar(24) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
/*Table structure for table foo */
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
pid bigint(20) NOT NULL auto_increment,
version int(11) NOT NULL,
name varchar(24) NOT NULL,
PRIMARY KEY (pid)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
/*Table structure for table student */
DROP TABLE IF EXISTS student;
CREATE TABLE student (
sid bigint(20) NOT NULL auto_increment,
fk_cid bigint(20) NOT NULL,
sname varchar(24) NOT NULL,
PRIMARY KEY (sid),
KEY FK8FFE823B3AA29689 (fk_cid),
CONSTRAINT FK8FFE823B3AA29689 FOREIGN KEY (fk_cid) REFERENCES tclass (cid)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;
/*Table structure for table tclass */
DROP TABLE IF EXISTS tclass;
CREATE TABLE tclass (
cid bigint(20) NOT NULL auto_increment,
cname varchar(24) NOT NULL,
PRIMARY KEY (cid)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
具体测试运行的结果运行下即可看到。
源码压缩包太大4M多,我删除了所有引用的包。使用的是hibernate3.1
本文转自 leizhimin 51CTO博客,原文链接:http://blog.51cto.com/lavasoft/78916,如需转载请自行联系原作者