MyBatis一对多保存多对多关系.docxVIP

一、 一对多保存 1) 1) 提出需求 保存班级以及学生信息。 2) 2) 创建表和数据 CREATE TABLE `dept` CREATE TABLE `dept` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `deptName` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `emp` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `empName` varchar(50) NOT NULL, `deptId` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `fk_emp_dept_id` (`deptId`), CONSTRAINT `fk_emp_dept_id` FOREIGN KEY (`deptId`) REFERENCES `dept` (`id`) ) INSERT INTO `emp` VALUES (2, emp01, 1); 3) 3) 定义实体 public public class Emp { private int id; private String empName; private Dept dept; } public class Dept { private int id;private String deptName; private ListEmp emps; private int id; private String deptName; private ListEmp emps; } 4 4) 定义 sql 映射文件 ?xml version=1.0 encoding=UTF-8 ?xml version=1.0 encoding=UTF-8 ? !DOCTYPE mapper PUBLIC -////DTD Mapper 3.0//EN /dtd/mybatis-3-mapper.dtd mapper namespace=com.tocean.domain.empMapper insert id=insert parameterType=com.tocean.domain.Emp insert into emp(empName,deptId) values(#{empName},#{dept.id}) /insert /mapper 5) 5) 测试代码 @Test @Test public void testInsert(){ SqlSession session = MyBatisUtil.getFactory().openSession(); Emp emp = new Emp(1,emp01,new Dept(1,dept1)); int insetCnt = session.insert(com.tocean.domain.empMapper.insert,emp); mit(); assertEquals(1, insetCnt); } 二、 多对多关联关系(实现方式 1) 1) 1) 提出需求 保存订单 根据订单ID 查询订单（订单对象包含产品信息） 2) 2) 创建表和数据 CREATE TABLE `product` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `prodName` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `order_infor` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `orderNum` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `prod_order` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `prodId` int(11) unsigned NOT NULL, `orderId` int(11) unsigned NOT NULL, `num` int(3) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), KEY `fk_prod_order_oid` (`orderId`), KEY `fk_prod_order_pid` (`prodId`), CONSTRAINT `fk_prod_order_pid` FOREIGN KEY (`pr