目录
1、首先先用逆向生成工具生成t_hibernate_order、t_hibernate_order_item
2、 编写一对多一方面OrderMapper.xml配置文件
7、编写一对多多方面OrderItemMapper.xml配置文件
一、一对多关联关系
1、首先先用逆向生成工具生成t_hibernate_order、t_hibernate_order_item
这两张表对应的model与mapper
<table schema="" tableName="t_hibernate_order" domainObjectName="Order"
enableCountByExample="false" enableDeleteByExample="false"
enableSelectByExample="false" enableUpdateByExample="false">
</table>
<table schema="" tableName="t_hibernate_order_item" domainObjectName="OrderItem"
enableCountByExample="false" enableDeleteByExample="false"
enableSelectByExample="false" enableUpdateByExample="false">
</table>
逆向生成
2、 编写一对多一方面OrderMapper.xml配置文件
<?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.zking.ssm.mapper.OrderMapper" >
<resultMap id="BaseResultMap" type="com.zking.ssm.model.Order" >
<constructor >
<arg column="order_id" jdbcType="VARCHAR" javaType="java.lang.String" />
<arg column="order_no" jdbcType="VARCHAR" javaType="java.lang.String" />
</constructor>
</resultMap>
<resultMap id="OrdervVoMap" type="com.zking.ssm.model.vo.OrdervVo" >
<result column="order_id" property="orderId"></result>
<result column="order_no" property="orderNo"></result>
<collection property="orderItems" ofType="com.zking.ssm.model.OrderItem">
<result column="order_item_id" property="orderItemId"></result>
<result column="product_id" property="productId"></result>
<result column="quantity" property="quantity"></result>
<result column="oid" property="oid"></result>
</collection>
</resultMap>
<select id="queryOrderVoByOrderId" resultMap="OrdervVoMap" parameterType="java.lang.Integer">
select * from t_hibernate_order o,t_hibernate_order_item oi
where o.order_id = oi.oid
and o.order_id = #{orderId}
</select>
<insert id="insert" parameterType="com.zking.ssm.model.Order" >
insert into t_hibernate_order (order_id, order_no)
values (#{orderId,jdbcType=VARCHAR}, #{orderNo,jdbcType=VARCHAR})
</insert>
<insert id="insertSelective" parameterType="com.zking.ssm.model.Order" >
insert into t_hibernate_order
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="orderId != null" >
order_id,
</if>
<if test="orderNo != null" >
order_no,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="orderId != null" >
#{orderId,jdbcType=VARCHAR},
</if>
<if test="orderNo != null" >
#{orderNo,jdbcType=VARCHAR},
</if>
</trim>
</insert>
</mapper>
3、创建vo类(包含关联表的信息)
package com.zking.ssm.model.vo;
import com.zking.ssm.model.Order;
import com.zking.ssm.model.OrderItem;
import java.util.List;
/**
* @author 白未
* @site 3185579318
* @company xxx公司
* @create 2022-08-16 9:21
*
* vo类不仅仅包含当前表的信息还能包含相关联表的信息
*
* 当前订单会有一个或者多个订单项,多个订单项必须要集合进行接收
*/
public class OrdervVo extends Order {
//通过订单号查询本次订单的详细信息及对应的所有订单项信息
private List<OrderItem> orderItems;
public List<OrderItem> getOrderItems() {
return orderItems;
}
public void setOrderItems(List<OrderItem> orderItems) {
this.orderItems = orderItems;
}
}
给实体类添加注解@Data(相当于添加了set/get方法,同时添加了tostring方法)
package com.zking.ssm.model;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
//t_hibernate_order
//相当于添加了set/get方法,同时添加了tostring方法
//@NoArgsConstructor
//@AllArgsConstructor
@Data
public class Order {
private String orderId;
private String orderNo;
}
4、在biz、impl里都添加方法
package com.zking.ssm.biz;
import com.zking.ssm.model.Order;
import com.zking.ssm.model.vo.OrdervVo;
import o