mybatis 的几种关联关系

package com.xinzhi.mybatistest.Controller;

import com.xinzhi.mybatistest.mapper.OrderItemMapper;
import com.xinzhi.mybatistest.service.OrderItemService;
import com.xinzhi.mybatistest.service.OrderService;
import com.xinzhi.mybatistest.vo.ItemVo;
import com.xinzhi.mybatistest.vo.OrderVo;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * @Author: zzd
 * @Data: 2021/11/29 15:35
 */

@RestController
public class OrderController {

    @Autowired
    private OrderService orderService;

    @Autowired
    private OrderItemService orderItemService;



//一对一接口

    @GetMapping("order")
    public OrderVo FindAll(int order){
        OrderVo orderVo = orderService.FindByOIdAll(order);
        return orderVo;
    }
//多对一接口

    @GetMapping("item")
    public ItemVo FindOneOrder(@Param("orderItemUd") int orderItemId){
        ItemVo itemVo = orderItemService.FindOneOrder(orderItemId);
        return itemVo;
    }
}

实体类：

//  Order 实体类：

@Data
public class Order {
    private  int orderId;
    private int orderNo;
}


// Item 实体类

@Data
public class OrderItem {
    private int id;  //订单详情表id
    private int productId;
    private int quantity;
    private int oid;


}

Service 层：

package com.xinzhi.mybatistest.service;

import com.xinzhi.mybatistest.vo.ItemVo;


/**
 * @Author: zzd
 * @Data: 2021/11/29 16:18
 */

//订单详情接口

//多对一，根据订单项去查找订单 ，只有一个
public interface OrderItemService {
    public ItemVo FindOneOrder(int orderItemId);
}




// 订单接口

package com.xinzhi.mybatistest.service;

import com.xinzhi.mybatistest.vo.OrderVo;

/**
 * @Author: zzd
 * @Data: 2021/11/29 15:30
 */


public interface OrderService {
    public OrderVo FindByOIdAll(int oid);
}

serviceImpl :

package com.xinzhi.mybatistest.service.ServiceImpl;

import com.xinzhi.mybatistest.mapper.OderMapper;
import com.xinzhi.mybatistest.service.OrderService;
import com.xinzhi.mybatistest.vo.OrderVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @Author: zzd
 * @Data: 2021/11/29 15:32
 */

@Service
public class OrderServiceImpl implements OrderService {

    @Autowired
    private OderMapper oderMapper;

    @Override
    public OrderVo FindByOIdAll(int oid) {
        OrderVo orderVo = oderMapper.SelectBiOid(oid);
        return orderVo;
    }
}





// 商品详情serviceImpl


package com.xinzhi.mybatistest.service.ServiceImpl;

import com.xinzhi.mybatistest.entity.OrderItem;
import com.xinzhi.mybatistest.mapper.OrderItemMapper;
import com.xinzhi.mybatistest.service.OrderItemService;
import com.xinzhi.mybatistest.vo.ItemVo;
import com.xinzhi.mybatistest.vo.OrderVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @Author: zzd
 * @Data: 2021/11/29 16:20
 */

@Service
public class OrderItemImpl implements OrderItemService {

    @Autowired
    private OrderItemMapper orderItemMapper;
    @Override
    public ItemVo FindOneOrder(int orderItemId) {
        ItemVo itemVo = orderItemMapper.FindOneODItem(orderItemId);
        return itemVo;
    }
}

mapper 接口（dao）:

package com.xinzhi.mybatistest.mapper;

import com.xinzhi.mybatistest.vo.OrderVo;
import org.apache.ibatis.annotations.Mapper;

/**
 * @Author: zzd
 * @Data: 2021/11/29 15:07
 */

@Mapper
public interface OderMapper {
    //根据一个订单编号，查询到多个订单项  一对多
    public OrderVo SelectBiOid(int oid);
}





package com.xinzhi.mybatistest.mapper;

import com.xinzhi.mybatistest.vo.ItemVo;
import org.apache.ibatis.annotations.Mapper;

/**
 * @Author: zzd
 * @Data: 2021/11/29 15:22
 */


//一个订单详情对应多个订单

@Mapper
public interface OrderItemMapper {
    public ItemVo FindOneODItem(int orderItemId);
}

Vo 视图实体类：

package com.xinzhi.mybatistest.vo;

import com.xinzhi.mybatistest.entity.Order;
import com.xinzhi.mybatistest.entity.OrderItem;


import java.util.List;

/**
 * @Author: zzd
 * @Data: 2021/11/29 15:12
 */

public class ItemVo extends OrderItem {
    private Order order;

    public Order getOrderList(){
        return order;
    }

    public void setOrderList(List<Order> orderList){
        this.order = order;
    }
}

// 商品订单视图类


package com.xinzhi.mybatistest.vo;

import com.xinzhi.mybatistest.entity.Order;
import com.xinzhi.mybatistest.entity.OrderItem;

import java.util.ArrayList;
import java.util.List;

/**
 * @Author: zzd
 * @Data: 2021/11/29 15:12
 */

public class OrderVo extends Order {
    private List<OrderItem> orderItems ;

    public List<OrderItem> getOrderItems(){
        return orderItems;
    }


    public void setOrderItems(List<OrderItem> orderItems) {
        this.orderItems = orderItems;
    }
}

mapper.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.xinzhi.mybatistest.mapper.OrderItemMapper">

    <resultMap id="findOne" type="com.xinzhi.mybatistest.vo.ItemVo">
        <result property="id" column="order_item_id"></result>
        <result property="productId" column="product_id"></result>
        <result property="quantity" column="quantity"></result>
        <association property="order" javaType="com.xinzhi.mybatistest.entity.Order">
            <result property="orderId" column="order_id"></result>
            <result property="orderNo" column="order_no"></result>
        </association>
    </resultMap>
    <select id="FindOneODItem" resultMap="findOne">
        select * from test_order o, test_order_item oi
        where o.order_id = oi.oid
        and oi.order_item_id = #{orderItemId};
    </select>
</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.xinzhi.mybatistest.mapper.OderMapper">
    
    <resultMap id="SelectByOid" type="com.xinzhi.mybatistest.vo.OrderVo">
        <result property="orderId" column="order_id"></result>
        <result property="orderNo" column="order_no"></result>

<!--        注释： 一对多： collection 被翻译为 一堆的，多的，集合的  这里的orderItems 没有定义 这里我们写的是我们的实体类的小写模式，在
            工厂启动时自动的去映射到这个类上，我们后边的oftype 制定了它的类型。
-->
        <collection property="orderItems" ofType="com.xinzhi.mybatistest.entity.OrderItem">
<!--            剩下的这里面的property 以及colum 就是我们实体类，与表的数据-->
            <result property="id" column="order_item_id"></result>
            <result property="productId" column="product_id"></result>
            <result property="quantity" column="quantity"></result>
<!--            <result property="oid" column="oid"></result>   如果我们的表与实体类的数据字段一致的话，我们则可以不用配置它，否则的话需要配置-->
        </collection>
    </resultMap>

<!--    这里的resultMap 我们绑定到了上边的result Map 上 ，让它去映射我们的一对多关系-->
    <select id="SelectBiOid" resultMap="SelectByOid">
        select * from test_order o, test_order_item oi
        where o.order_id = oi.oid
        and o.order_id = #{oid}
    </select>
</mapper>

yml 配置文件： spring boot 项目继承mybatis

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/jdtable?serverTimezone=UTC


mybatis:
  type-aliases-package: com.xinzhi.mybatistest.entity
  mapper-locations: classpath:/mapping/*.xml
server:
  port: 8081