下面来点更复杂的:
添加订单详细表:
CREATE TABLE detail(
id INT PRIMARY KEY AUTO_INCREMENT,
goodsId INT,
num INT,
orderId INT
)DEFAULT CHARSET=utf8;
插入几条数据:
注意orderId 要对应 Order表的已经存在的id
insert into detail values(0,1,3,1);
1、创建 detail对象:
public class Detail {
private int id;
private int orderId;
private int num;
private int goodsId;
。。。 。。。
2 、 在order对象中添加 订单详情集合。
public class Orders {
private int id;
private int detailId;
private Date create;
private int userId;
private User user;
private List<Detail> details;//新增加的集合用于保存订单详情。
3、在第六章的基础上编写 OrderDao.xml Mapper 映射文件。
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zll.mybatis.dao.OrderDao">
<!-- 对应于每条纪律的数据 -->
<!-- Orders 属性 -->
<resultMap type="com.zll.mybatis.bean.Orders" id="OrderResultMap">
<!-- column 字段名称,如果使用别名就对应别名,如果没有就填写对象属性 ,property对应 Orders 对象属性名称 -->
<id column="id" property="id" /><!--map 的 key -->
<result column="detailId" property="detailId" />
<result column="create" property="create" />
<result column="userId" property="userId" />
<!-- User 属性 -->
<association property="user" javaType="com.zll.mybatis.bean.User">
<id column="userId" property="id" /><!-- 主外键关联 -->
<!-- 这里 column 字段名称 sql中使用了别名 -->
<result column="userName" property="name" />
<result column="userBirthday" property="birthday" />
</association>
</resultMap>
<!-- 继承 OrderResultMap 映射 加入 List<Detail> details 映射-->
<resultMap type="com.zll.mybatis.bean.Orders" id="OrderDetailResultMap" extends="OrderResultMap">
<!-- List<Detail> details 属性 -->
<!-- 注意由于 Orders 对象内 details 是一个List集合,所以这里要使用 collection标签-->
<collection property="details" ofType="com.zll.mybatis.bean.Detail">
<id column="detail_id" property="id" /><!-- 主外键关联 -->
<result column="orderId" property="orderId" />
<result column="num" property="num" />
<result column="goodsId" property="goodsId" />
</collection>
</resultMap>
<select id="findOrderDetailMapById" resultMap="OrderDetailResultMap">
select orders.*,user.name
username,user.birthday userBirthday,
detail.id detail_id,detail.num,detail.goodsId
from orders,user,detail
where orders.userId = user.id and detail.id = orders.id;
</select>
</mapper>
3、测试代码:
public void findOrderDetailMapById() throws Exception {
SqlSession openSession = sqlSessionFactory.openSession();
OrderDao mapper = openSession.getMapper(OrderDao.class);
List<Orders> findOrderMapById = mapper.findOrderDetailMapById();
for(int i=0; i<findOrderMapById.size(); i++){
System.out.println(findOrderMapById.get(i));
}
openSession.close();
}