MyBatis之关联关系

一杯咖啡.

已于 2022-08-16 12:58:21 修改

阅读量368

点赞数

文章标签： hibernate java spring

于 2022-08-16 12:53:08 首次发布

本文链接：https://blog.csdn.net/m0_67094505/article/details/126363824

版权

本文详细介绍了在MyBatis中处理一对多关联关系的步骤，包括实体类的设计、Biz层的接口与实现、以及Mapper层的配置。通过Order和OrderItem为例，展示了如何在Java应用中实现一对多的关联查询，并提供了queryByBookId和queryByCid的实际运行效果。

摘要由CSDN通过智能技术生成

③OrderItemMapper.java

一、一对多关联关系

1、实体类

首先先用逆向生成工具生成t_hibernate_order、t_hibernate_order_item
这两张表对应的model与mapper

①Order

package com.chenchen.ssm.model;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

//t_hibernate_order
//相当于添加了set/get方法，同时添加tostring
//@NoArgsConstructor
//@AllArgsConstructor
@Data
public class Order {
    private Integer orderId;

    private String orderNo;

}

②OrderItem

package com.chenchen.ssm.model;

import lombok.Data;
import lombok.ToString;

@ToString
public class OrderItem {
    private Integer orderItemId;

    private Integer productId;

    private Integer quantity;

    private Integer oid;

    public OrderItem(Integer orderItemId, Integer productId, Integer quantity, Integer oid) {
        this.orderItemId = orderItemId;
        this.productId = productId;
        this.quantity = quantity;
        this.oid = oid;
    }

    public OrderItem() {
        super();
    }

    public Integer getOrderItemId() {
        return orderItemId;
    }

    public void setOrderItemId(Integer orderItemId) {
        this.orderItemId = orderItemId;
    }

    public Integer getProductId() {
        return productId;
    }

    public void setProductId(Integer productId) {
        this.productId = productId;
    }

    public Integer getQuantity() {
        return quantity;
    }

    public void setQuantity(Integer quantity) {
        this.quantity = quantity;
    }

    public Integer getOid() {
        return oid;
    }

    public void setOid(Integer oid) {
        this.oid = oid;
    }
}

2、Biz层

①OrderBiz

package com.chenchen.ssm.biz;

import com.chenchen.ssm.model.Book;
import com.chenchen.ssm.model.BookVo;
import com.chenchen.ssm.model.Order;
import com.chenchen.ssm.model.vo.OrderVo;
import com.chen.ssm.util.PageBean;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface OrderBiz {
    int deleteByPrimaryKey(Integer orderId);

    int insert(Order record);

    int insertSelective(Order record);

    Order selectByPrimaryKe

最低0.47元/天解锁文章