mybatis关联关系

mybatis一对多关联关系

下面就用几个例子来参照
首先我们
通过逆向生成工具生成t_hibernate_order、t_hibernate_order_item（关于怎么逆向生成工程我这里就不多说了，我在前面的博客有介绍(mybatis入门)）
这两张表对应的model与mapper对应的实体类
Hbook,HbookCategory,Category

在generatorConfig.xml

 <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>

接下来就是写Vo类了 V：视图 O：Object 视图对象
纯粹的实体类是直接与数据库相对应的列段，不包含其他列段，就是纯粹的来描述表的，
Vo类就是专门用来开发一个展示的视图，存放与数据库无关的字段，这样达到了解耦的效果，增加了可读性。

OrderVo 继承会把注解继承过来，但是如果不想要注解的话，直接把它有的东西copy过来

package com.tzp.model.vo;

import com.tzp.model.Order;
import com.tzp.model.OrderItem;

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

/**
 * @author 心如止水
 * @site www.xiaomage.com
 * @company
 * @create  2019-09-26 20:30
 *
 */
public class OrderVo extends Order {
    private List<OrderItem> orderItems = new ArrayList<>();

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

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

}

OrderItemVo

package com.tzp.model.vo;

import com.tzp.model.Order;
import com.tzp.model.OrderItem;

/**
 * @author 心如止水
 * @site www.xiaomage.com
 * @company
 * @create  2019-09-27 19:51
 */
public class OrderItemVo extends OrderItem {
    private Order order;

    public Order getOrder() {
        return order;
    }

    public void setOrder(Order order) {
        this.order = order;
    }

}

配置映射文件
OrederMapper.xml

  <resultMap id="OrderVoMap" type="com.tzp.model.vo.OrderVo" >
    <result property="orderId" column="order_id"></result>
    <result property="orderNo" column="order_no"></result>
    <!--描述关联属性(对应多个订单项)-->
    <collection property="orderItems" javaType="com.tzp.model.OrderItem">
      <result property="orderItemId" 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>

OrderItemMapper.xml配置

<resultMap id="OrderItemVoMap" type="com.tzp.model.vo.OrderItemVo" >
    <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>

    <association property="order" javaType="com.tzp.model.Order">
      <result column="order_id" property="orderId"></result>
      <result column="order_no" property="orderNo"></result>
    </association>

  </resultMap>

OrderMapper（接口）

//    通过订单的id查出订单的详情，以及该订单的订单项
    OrderVo selectByOid(@Param("bid") Integer oid);

直接选中方法名 alt+回车 选 Generate Mapper Select Statement 它会跳到下面那个xml文件配置
OrderMapper.xml配置
property指的是类属性，column指的是表字段，javaType表示关联属性类型。

  <!--resultMap  传出参数   parameterType 传入参数-->
  <select id="selectByOid" resultMap="OrderVoMap" 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 = #{oid}
  </select>

OrderItemMapper(接口)

OrderItemVo selectByOrderItemId(@Param("orderItemId") Integer orderItemId);

OrderItemMapper.xml配置

<select id="selectByOid" resultMap="OrderVoMap" 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 = #{oid}
  </select>

测试

@Service
public class OneTestImpl implements OneTest {
    @Autowired
    private OrderMapper orderMapper;
    @Autowired
    private OrderItemMapper orderItemMapper;


    @Override
    public OrderVo OrderByOid(Integer oid) {
        return orderMapper.OrderByOid(oid);
    }

    @Override
    public OrderItemVo OrderItemByoid(Integer oid) {
        return orderItemMapper.OrderItemByoid(oid);
    }
}

mybatis多对多关联关系

首先也是通过逆向生成工具生成Hbook,HbookCategory,Category

		<table schema="" tableName="t_hibernate_book" domainObjectName="Hbook"
               enableCountByExample="false" enableDeleteByExample="false"
               enableSelectByExample="false" enableUpdateByExample="false">

        </table>
        <table schema="" tableName="t_hibernate_book_category" domainObjectName="HbookCategory"
               enableCountByExample="false" enableDeleteByExample="false"
               enableSelectByExample="false" enableUpdateByExample="false">
     
        </table>
        <table schema="" tableName="t_hibernate_category" domainObjectName="Category"
               enableCountByExample="false" enableDeleteByExample="false"
               enableSelectByExample="false" enableUpdateByExample="false">

        </table>

Vo类
HbookVo

package com.tzp.model.vo;

import com.tzp.model.Category;
import com.tzp.model.Hbook;

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

/**
 * @author 心如止水
 * @site www.xiaomage.com
 * @company
 * @create 2019-09-27 10:40
 */
public class HbookVo extends Hbook {
    List<Category> categories = new ArrayList<>();

    public List<Category> getCategories() {
        return categories;
    }

    public void setCategories(List<Category> categories) {
        this.categories = categories;
    }
}

CategoryVo

package com.tzp.model.vo;

import com.tzp.model.Category;
import com.tzp.model.Hbook;

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

/**
 * @author 心如止水
 * @site www.xiaomage.com
 * @company
 * @create 2019-09-27 10:41
 */
public class CategoryVo extends Category {
    List<Hbook> hbooks = new ArrayList<>();

    public List<Hbook> getHbooks() {
        return hbooks;
    }

    public void setHbooks(List<Hbook> hbooks) {
        this.hbooks = hbooks;
    }
}

HbookCategory.xml配置

<resultMap id="HbookVoMap" type="com.tzp.model.vo.HbookVo">
    <result column="book_id" property="bookId" ></result>
    <result column="book_name" property="bookName" ></result>
    <result column="price" property="price" ></result>
    <collection property="categories" ofType="com.tzp.model.Category">
      <result column="category_id" property="categoryId"></result>
      <result column="category_name" property="categoryName"></result>
    </collection>
  </resultMap>

  <resultMap id="CategoryVoMap" type="com.tzp.model.vo.CategoryVo">
    <result column="category_id" property="categoryId"></result>
    <result column="category_name" property="categoryName"></result>
    <collection property="hbooks" ofType="com.tzp.model.Hbook">
      <result column="book_id" property="bookId" ></result>
      <result column="book_name" property="bookName" ></result>
      <result column="price" property="price" ></result>
    </collection>
  </resultMap>

接口

    HBookVo HbookBybid(@Param("bid") Integer bid);

    CategoryVo HbookBybid(@Param("cid") Integer cid);

HbookCategoryMapper.xml

  <select id="HbookBybid" resultMap="HbookVoMap" parameterType="java.lang.Integer">
    select * from t_hibernate_book b,t_hibernate_book_category bc,t_hibernate_category c
    where b.book_id = bc.bid and bc.cid = c.category_id and b.book_id = #{bid}
  </select>
  <select id="CategoryBycid" resultMap="CategoryVoMap" parameterType="java.lang.Integer">
    select * from t_hibernate_book b,t_hibernate_book_category bc,t_hibernate_category c
    where b.book_id = bc.bid and bc.cid = c.category_id and c.category_id = #{cid}

  </select>

测试接口：
ManyToManyService：

public interface ManyToManyService {

    HBookVo HbookBybid(Integer bid);

    CategoryVo CategoryBycid(Integer cid);
}

测试

public class ManyToManyServiceImplTest extends SpringBaseTest {
    @Autowired
    private ManyToManyService manyToManyService;

    @Test
    public void HbookBybid() {
        HBookVo hBooks = manyToManyService.HbookBybid(1);
        System.out.println(hBooks);
        List<Category> list = hBooks.getCategoryList();
        for (Category c : list) {
            System.out.println(c);
        }
    }

    @Test
    public void CategoryBycid() {
        CategoryVo categorys = manyToManyService.CategoryBycid(1);
        System.out.println(categorys);
        List<HBook> hBookList = categorys.getHBookList();
        for (HBook hBook : hBookList) {
            System.out.println(hBook);
        }
    }
}

over~~~