Hibernate单向1-1映射范例
其实 Many-to-one 和 one-to-one 非常相似,只需要在 的尖括号中添加 unique="true"即可
1.hibernate.cfg.xml
代码如下 |
复制代码 |
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
org.hibernate.dialect.MySQLDialect
com.mysql.jdbc.Driver
root
word">root
jdbc:mysql://localhost:3306/hibernate
20
1
5000
true
true
true
100
3000
2
true
update
|
2.(一)持久化类 Member.java
代码如下 |
复制代码 |
package org.Rudiment.hibernate;
import java.io.Serializable;
public class Member{
private Integer id;
private Integer age;
private String name;
private Address address;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Address getAddress() {
return address;
}
public void setAddress(Address address) {
this.address = address;
}
}
|
3.Member类的映射规则文件 Member.cfg.xml
代码如下 |
复制代码 |
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
|
4.(一)持久化类 Address.java
代码如下 |
复制代码 |
package org.Rudiment.hibernate;
public class Address
{
private Integer address_id;
private String address_detail;
public Address()
{}
public Address(String detail)
{
this.address_detail = detail;
}
public Integer getAddress_id() {
return address_id;
}
public void setAddress_id(Integer address_id) {
this.address_id = address_id;
}
public String getAddress_detail() {
return address_detail;
}
public void setAddress_detail(String address_detail) {
this.address_detail = address_detail;
}
}
|
5.Address.java 的地址映射文件
代码如下 |
复制代码 |
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
|
6.对持久化类操纵的类: MemberHandler.java
代码如下 |
复制代码 |
package org.Rudiment.hibernate;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
public class MemberHandler
{
public static void insert(int i) {
Configuration conf = new Configuration();
conf.configure();
ServiceRegistry sr = new ServiceRegistryBuilder().applySettings(conf.getProperties()).buildServiceRegistry();
SessionFactory sf = conf.buildSessionFactory(sr);
Session session = sf.openSession();
session.beginTransaction();
Member m = new Member();
m.setAge(24 + i);
m.setName("IT客栈");
Address ad = new Address("广州" + i + "路");
m.setAddress(ad);
session.save(m);
session.getTransaction().commit();
session.close();
}
public static Member query(int id)
{
Configuration conf = new Configuration();
conf.configure();
ServiceRegistry sr = new ServiceRegistryBuilder().applySettings(conf.getProperties()).buildServiceRegistry();
SessionFactory sf = conf.buildSessionFactory(sr);
Session session = sf.openSession();
Member m = (Member)session.get(Member.class, 1);
session.close();
return m;
}
public static Member addMemberInSameAddress(Member m, int id)
{
Configuration conf = new Configuration();
conf.configure();
ServiceRegistry sr = new ServiceRegistryBuilder().applySettings(conf.getProperties()).buildServiceRegistry();
SessionFactory sf = conf.buildSessionFactory(sr);
Session session = sf.openSession();
Transaction tx = session.beginTransaction();
m.setAddress(query(id).getAddress());
session.save(m);
tx.commit();
session.close();
return m;
}
public static void main(String[] args) {
for(int i=0; i<2; i++)
{
insert(i);
}
}
}
|
注:
当运行MemberHandler的时候将发现,后台数据库多了一个 test_member 和 address 的数据表,表的内容如下:
代码如下 |
复制代码 |
mysql> show tables;
+---------------------+
| Tables_in_hibernate |
+---------------------+
| address |
| test_member |
+---------------------+
2 rows in set (0.00 sec)
mysql> select * from test_member;
+----+------+--------+---------+
| ID | AGE | NAME | address |
+----+------+--------+---------+
| 1 | 24 | IT客栈 | 1 |
| 2 | 25 | IT客栈 | 2 |
+----+------+--------+---------+
2 rows in set (0.00 sec)
mysql> select * from address;
+------------+----------------+
| ADDRESS_ID | ADDRESS_DETAIL |
+------------+----------------+
| 1 | 广州0路 |
| 2 | 广州1路 |
+------------+----------------+
2 rows in set (0.00 sec)
mysql> desc test_member;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| ID | int(11) | NO | PRI | NULL | auto_increment |
| AGE | int(11) | YES | | NULL | |
| NAME | varchar(255) | YES | | NULL | |
| address | int(11) | YES | UNI | NULL | |
+---------+--------------+------+-----+---------+----------------+
4 rows in set (0.02 sec)
mysql> desc address;
+----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+----------------+
| ADDRESS_ID | int(11) | NO | PRI | NULL | auto_increment |
| ADDRESS_DETAIL | varchar(255) | YES | | NULL | |
+----------------+--------------+------+-----+---------+----------------+
2 rows in set (0.03 sec)
|
当我们在hibernate中的1对1的模式下如果出现插入重复数据的时候,hibernate将出现下面的报错信息:
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not execute statement
单向1-1含中间连接表映射范例
其实 Many-to-one 和 one-to-one 非常相似,只需要在 的尖括号中添加 unique="true"即可
1.hibernate.cfg.xml
代码如下 |
复制代码 |
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
org.hibernate.dialect.MySQLDialect
com.mysql.jdbc.Driver
root
root
jdbc:mysql://localhost:3306/hibernate
20
1
5000
true
true
true
100
3000
2
true
update
|
2.(一)持久化类 Member.java
代码如下 |
复制代码 |
package org.Rudiment.hibernate;
import java.io.Serializable;
public class Member{
private Integer id;
private Integer age;
private String name;
private Address address;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Address getAddress() {
return address;
}
public void setAddress(Address address) {
this.address = address;
}
}
|
3.Member类的映射规则文件 Member.cfg.xml
代码如下 |
复制代码 |
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
|
4.(一)持久化类 Address.java
代码如下 |
复制代码 |
package org.Rudiment.hibernate;
public class Address
{
private Integer address_id;
private String address_detail;
public Address()
{}
public Address(String detail)
{
this.address_detail = detail;
}
public Integer getAddress_id() {
return address_id;
}
public void setAddress_id(Integer address_id) {
this.address_id = address_id;
}
public String getAddress_detail() {
return address_detail;
}
public void setAddress_detail(String address_detail) {
this.address_detail = address_detail;
}
}
|
5.Address.java 的地址映射文件 Address.cfg.xml
代码如下 |
复制代码 |
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
|
6.对持久化类操纵的类: MemberHandler.java
代码如下 |
复制代码 |
package org.Rudiment.hibernate;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
public class MemberHandler
{
public static void insert(int i) {
Configuration conf = new Configuration();
conf.configure();
ServiceRegistry sr = new ServiceRegistryBuilder().applySettings(conf.getProperties()).buildServiceRegistry();
SessionFactory sf = conf.buildSessionFactory(sr);
Session session = sf.openSession();
session.beginTransaction();
Member m = new Member();
m.setAge(24 + i);
m.setName("IT客栈");
Address ad = new Address("广州" + i + "路");
m.setAddress(ad);
session.save(m);
session.getTransaction().commit();
session.close();
}
public static Member query(int id)
{
Configuration conf = new Configuration();
conf.configure();
ServiceRegistry sr = new ServiceRegistryBuilder().applySettings(conf.getProperties()).buildServiceRegistry();
SessionFactory sf = conf.buildSessionFactory(sr);
Session session = sf.openSession();
Member m = (Member)session.get(Member.class, 1);
session.close();
return m;
}
public static Member addMemberInSameAddress(Member m, int id)
{
Configuration conf = new Configuration();
conf.configure();
ServiceRegistry sr = new ServiceRegistryBuilder().applySettings(conf.getProperties()).buildServiceRegistry();
SessionFactory sf = conf.buildSessionFactory(sr);
Session session = sf.openSession();
Transaction tx = session.beginTransaction();
m.setAddress(query(id).getAddress());
session.save(m);
tx.commit();
session.close();
return m;
}
public static void main(String[] args) {
for(int i=0; i<2; i++)
{
insert(i);
}
}
}
|
注:
当运行MemberHandler的时候将发现,后台数据库多了一个 test_member、member_address 和 address 的数据表,表的内容如下:
代码如下 |
复制代码 |
mysql> show tables;
+---------------------+
| Tables_in_hibernate |
+---------------------+
| address |
| member_address |
| test_member |
+---------------------+
3 rows in set (0.00 sec)
mysql> select * from test_member;
+----+------+--------+
| ID | AGE | NAME |
+----+------+--------+
| 1 | 24 | IT客栈 |
| 2 | 25 | IT客栈 |
+----+------+--------+
2 rows in set (0.00 sec)
mysql> select * from member_address;
+-----------+---------+
| person_id | address |
+-----------+---------+
| 1 | 1 |
| 2 | 2 |
+-----------+---------+
2 rows in set (0.00 sec)
mysql> select * from address;
+------------+----------------+
| ADDRESS_ID | ADDRESS_DETAIL |
+------------+----------------+
| 1 | 广州0路 |
| 2 | 广州1路 |
+------------+----------------+
2 rows in set (0.00 sec)
mysql> desc test_member;
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| ID | int(11) | NO | PRI | NULL | auto_increment |
| AGE | int(11) | YES | | NULL | |
| NAME | varchar(255) | YES | | NULL | |
+-------+--------------+------+-----+---------+----------------+
3 rows in set (0.02 sec)
mysql> desc member_address;
+-----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+-------+
| person_id | int(11) | NO | PRI | NULL | |
| address | int(11) | YES | UNI | NULL | |
+-----------+---------+------+-----+---------+-------+
2 rows in set (0.02 sec)
mysql> desc address;
+----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+----------------+
| ADDRESS_ID | int(11) | NO | PRI | NULL | auto_increment |
| ADDRESS_DETAIL | varchar(255) | YES | | NULL | |
+----------------+--------------+------+-----+---------+----------------+
2 rows in set (0.05 sec)
|
当我们在hibernate中的1对1的模式下如果出现插入重复数据的时候,hibernate将出现下面的报错信息:
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not execute statement