hibernate框架双向一对多例子（十一）

一方Customer，多方Linkman

一、创建数据库

hibernate_second

创建两张表：

CREATE TABLE `cst_customer` (
  `cust_id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '客户编号(主键)',
  `cust_name` varchar(32) NOT NULL COMMENT '客户名称(公司名称)',
  `cust_user_id` bigint(32) DEFAULT NULL COMMENT '负责人id',
  `cust_create_id` bigint(32) DEFAULT NULL COMMENT '创建人id',
  `cust_source` varchar(32) DEFAULT NULL COMMENT '客户信息来源',
  `cust_industry` varchar(32) DEFAULT NULL COMMENT '客户所属行业',
  `cust_level` varchar(32) DEFAULT NULL COMMENT '客户级别',
  `cust_linkman` varchar(64) DEFAULT NULL COMMENT '联系人',
  `cust_phone` varchar(64) DEFAULT NULL COMMENT '固定电话',
  `cust_mobile` varchar(16) DEFAULT NULL COMMENT '移动电话',
  PRIMARY KEY (`cust_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `cst_linkman` (
  `lkm_id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '联系人编号(主键)',
  `lkm_name` varchar(16) DEFAULT NULL COMMENT '联系人姓名',
  `lkm_cust_id` bigint(32) NOT NULL COMMENT '客户id',
  `lkm_gender` char(1) DEFAULT NULL COMMENT '联系人性别',
  `lkm_phone` varchar(16) DEFAULT NULL COMMENT '联系人办公电话',
  `lkm_mobile` varchar(16) DEFAULT NULL COMMENT '联系人手机',
  `lkm_email` varchar(64) DEFAULT NULL COMMENT '联系人邮箱',
  `lkm_qq` varchar(16) DEFAULT NULL COMMENT '联系人qq',
  `lkm_position` varchar(16) DEFAULT NULL COMMENT '联系人职位',
  `lkm_memo` varchar(512) DEFAULT NULL COMMENT '联系人备注',
  PRIMARY KEY (`lkm_id`),
  KEY `FK_cst_linkman_lkm_cust_id` (`lkm_cust_id`),
  CONSTRAINT `FK_cst_linkman_lkm_cust_id` FOREIGN KEY (`lkm_cust_id`) REFERENCES `cst_customer` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

二、创建web项目

项目结构：

所需jar包：

三、在src目录下创建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标签，一个数据库对应一个SessionFactory -->
	<session-factory>
		<!-- 必须配置的4大参数 -->
		<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="hibernate.connection.url">jdbc:mysql:///hibernate_second?useUnicode=true&characterEncoding=UTF-8</property>
		<property name="hibernate.connection.username">root</property>
		<property name="hibernate.connection.password">123456</property>

		<!-- 数据库的方言（必须配置的） -->
		<!-- 方言的作用：底层用了什么数据库，告诉hibernate，hibernate会生成对应的sql语句 -->
		<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

		<!-- 可选的配置 -->
		<!-- 显示sql语句 -->
		<property name="hibernate.show_sql">true</property>
		<!-- 格式化sql语句 -->
		<property name="hibernate.format_sql">true</property>
		<!-- 生成数据库的表结构。hbm2ddl-hbm to ddl，意思是把映射文件去生成数据库定义的语言 -->
		<!-- 1.create，每次都创建一张新的表。开发中不会用的。 -->
		<!-- 2.create-drop，先创建，再删除。根本没什么用嘛！ -->
		<!-- 3.create-drop，先创建，再删除。根本没什么用嘛！ -->
		<!-- 4.update，如果没有表就创建。有新的字段，会添加到表中。但是javabean中少了属性，不会去删除表中的字段。对于字段，只能加，不能删 -->
		<!-- 5.validate，校验javabean属性和数据库表的字段是不是一致的。 -->
		<!-- 开发一般用update -->
		<property name="hibernate.hbm2ddl.auto">update</property>

		<!-- 开启绑定本地session -->
		<property name="hibernate.current_session_context_class">thread</property>

		<!-- 引入映射配置文件（一定要注意，要引入映射文件，框架需要加载映射文件） -->
		
	</session-factory>
</hibernate-configuration>

四、创建javabean

package com.hib.domain;

import java.util.HashSet;
import java.util.Set;

/**
 * 客户的JavaBean 一方
 * 
 * @author Administrator
 */
public class Customer {

	private Long cust_id;
	private String cust_name;
	private Long cust_user_id;
	private Long cust_create_id;
	private String cust_source;
	private String cust_industry;
	private String cust_level;
	private String cust_linkman;
	private String cust_phone;
	private String cust_mobile;

	// Hibernate框架默认的集合是set集合，集合必须要自己手动的初始化
	private Set<Linkman> linkmans = new HashSet<Linkman>();

	public Long getCust_id() {
		return cust_id;
	}

	public void setCust_id(Long cust_id) {
		this.cust_id = cust_id;
	}

	public String getCust_name() {
		return cust_name;
	}

	public void setCust_name(String cust_name) {
		this.cust_name = cust_name;
	}

	public Long getCust_user_id() {
		return cust_user_id;
	}

	public void setCust_user_id(Long cust_user_id) {
		this.cust_user_id = cust_user_id;
	}

	public Long getCust_create_id() {
		return cust_create_id;
	}

	public void setCust_create_id(Long cust_create_id) {
		this.cust_create_id = cust_create_id;
	}

	public String getCust_source() {
		return cust_source;
	}

	public void setCust_source(String cust_source) {
		this.cust_source = cust_source;
	}

	public String getCust_industry() {
		return cust_industry;
	}

	public void setCust_industry(String cust_industry) {
		this.cust_industry = cust_industry;
	}

	public String getCust_level() {
		return cust_level;
	}

	public void setCust_level(String cust_level) {
		this.cust_level = cust_level;
	}

	public String getCust_linkman() {
		return cust_linkman;
	}

	public void setCust_linkman(String cust_linkman) {
		this.cust_linkman = cust_linkman;
	}

	public String getCust_phone() {
		return cust_phone;
	}

	public void setCust_phone(String cust_phone) {
		this.cust_phone = cust_phone;
	}

	public String getCust_mobile() {
		return cust_mobile;
	}

	public void setCust_mobile(String cust_mobile) {
		this.cust_mobile = cust_mobile;
	}

	public Set<Linkman> getLinkmans() {
		return linkmans;
	}

	public void setLinkmans(Set<Linkman> linkmans) {
		this.linkmans = linkmans;
	}

}

package com.hib.domain;

/**
 * 客户的联系人 多方
 * 
 * @author Administrator
 */
public class Linkman {

	private Long lkm_id;
	private String lkm_name;
	private String lkm_gender;
	private String lkm_phone;
	private String lkm_mobile;
	private String lkm_email;
	private String lkm_qq;
	private String lkm_position;
	private String lkm_memo;

	// 编写一个对象，不要自己new
	private Customer customer;

	public Long getLkm_id() {
		return lkm_id;
	}

	public void setLkm_id(Long lkm_id) {
		this.lkm_id = lkm_id;
	}

	public String getLkm_name() {
		return lkm_name;
	}

	public void setLkm_name(String lkm_name) {
		this.lkm_name = lkm_name;
	}

	public String getLkm_gender() {
		return lkm_gender;
	}

	public void setLkm_gender(String lkm_gender) {
		this.lkm_gender = lkm_gender;
	}

	public String getLkm_phone() {
		return lkm_phone;
	}

	public void setLkm_phone(String lkm_phone) {
		this.lkm_phone = lkm_phone;
	}

	public String getLkm_mobile() {
		return lkm_mobile;
	}

	public void setLkm_mobile(String lkm_mobile) {
		this.lkm_mobile = lkm_mobile;
	}

	public String getLkm_email() {
		return lkm_email;
	}

	public void setLkm_email(String lkm_email) {
		this.lkm_email = lkm_email;
	}

	public String getLkm_qq() {
		return lkm_qq;
	}

	public void setLkm_qq(String lkm_qq) {
		this.lkm_qq = lkm_qq;
	}

	public String getLkm_position() {
		return lkm_position;
	}

	public void setLkm_position(String lkm_position) {
		this.lkm_position = lkm_position;
	}

	public String getLkm_memo() {
		return lkm_memo;
	}

	public void setLkm_memo(String lkm_memo) {
		this.lkm_memo = lkm_memo;
	}

	public Customer getCustomer() {
		return customer;
	}

	public void setCustomer(Customer customer) {
		this.customer = customer;
	}

}

五、创建映射配置文件

5.1 Customer.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.hib.domain.Customer" table="cst_customer">
		<id name="cust_id" column="cust_id">
			<generator class="native" />
		</id>

		<property name="cust_name" column="cust_name" />
		<property name="cust_user_id" column="cust_user_id" />
		<property name="cust_create_id" column="cust_create_id" />
		<property name="cust_source" column="cust_source" />
		<property name="cust_industry" column="cust_industry" />
		<property name="cust_level" column="cust_level" />
		<property name="cust_linkman" column="cust_linkman" />
		<property name="cust_phone" column="cust_phone" />
		<property name="cust_mobile" column="cust_mobile" />

		<!-- 配置一方 -->

		<!-- set标签name属性：表示集合的名称 -->
		<set name="linkmans">
			<key column="lkm_cust_id"></key>
			<!-- 
				为什么要one-to-many的class？
			 	private Set<Linkman> linkmans = new HashSet<Linkman>();
				 这里要用到Linkman，也要通过反射去创建 
			 -->
			<one-to-many class="com.hib.domain.Linkman" />
		</set>
	</class>
</hibernate-mapping>    

5.2 Linkman.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.hib.domain.Linkman" table="cst_linkman">
		<id name="lkm_id" column="lkm_id">
			<generator class="native"/>
		</id>
		
		<property name="lkm_name" column="lkm_name"/>
		<property name="lkm_gender" column="lkm_gender"/>
		<property name="lkm_phone" column="lkm_phone"/>
		<property name="lkm_mobile" column="lkm_mobile"/>
		<property name="lkm_email" column="lkm_email"/>
		<property name="lkm_qq" column="lkm_qq"/>
		<property name="lkm_position" column="lkm_position"/>
		<property name="lkm_memo" column="lkm_memo"/>
		
		<!-- 先配置多方 
			name	当前JavaBean中的属性
			class	属性的全路径。为什么需要这个全路径呢？在Linkman的private Customer customer，不要自己new。
					那么要用它就由hibernate框架通过反射的方式来封装。
			column	外键的字段
		-->
		<many-to-one name="customer" class="com.hib.domain.Customer" column="lkm_cust_id"></many-to-one>
	</class>
</hibernate-mapping>

六、在hibernate.cfg.xml中引入映射配置文件

		<!-- 引入映射配置文件（一定要注意，要引入映射文件，框架需要加载映射文件） -->
		<mapping resource="com/hib/domain/Customer.hbm.xml" />
		<mapping resource="com/hib/domain/Linkman.hbm.xml" />

七、创建测试类

package com.hib.test;

import org.hibernate.Session;
import org.hibernate.Transaction;
import org.junit.Test;

import com.hib.domain.Customer;
import com.hib.domain.Linkman;
import com.hib.utils.HibernateUtils;

/**
 * 测试一对多
 *
 */
public class Demo1 {

	/**
	 * 双向关联的方式，保存数据
	 */
	@Test
	public void run1() {
		Session session = HibernateUtils.getCurrentSession();
		Transaction tx = session.beginTransaction();

		// 保存客户和联系人的数据
		Customer c1 = new Customer();
		c1.setCust_name("美美");

		// 创建2个联系人
		Linkman l1 = new Linkman();
		l1.setLkm_name("熊大");
		Linkman l2 = new Linkman();
		l2.setLkm_name("熊二");

		// 演示双向关联
		c1.getLinkmans().add(l1);// linkmans集合new过了，可以直接装东西
		c1.getLinkmans().add(l2);

		l1.setCustomer(c1);
		l2.setCustomer(c1);

		// 保存数据
		session.save(c1);
		session.save(l1);
		session.save(l2);

		tx.commit();
	}
}

八、执行单元测试

注意：三个insert语句执行完了之后，还执行了两个update语句，用于维护linkman中的外键

源码下载