Mybatis之关联关系映射

最新推荐文章于 2023-06-27 15:49:23 发布
最新推荐文章于 2023-06-27 15:49:23 发布
阅读量75 收藏
点赞数
文章标签： mybatis java idea
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_44247968/article/details/126354173
版权

目录

一、一对多关联关系

         1、实体类

2、Biz层

3、Biz的实现层Impl

4、mapper层

5、测试类

二、多对多关联关系

1、实体类

2、biz层

3、biz的实现层impl

4、mapper

4、vo层

5、测试类

一、一对多关联关系

1、实体类

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

①Order

package com.liaoxin.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.liaoxin.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.liaoxin.ssm.biz;

import com.liaoxin.ssm.model.Book;
import com.liaoxin.ssm.model.BookVo;
import com.liaoxin.ssm.model.Order;
import com.liaoxin.ssm.model.vo.OrderVo;
import com.liaoxin.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 selectByPrimaryKey(Integer orderId);

    OrderVo queryOrderVoByOrderId(Integer orderId);

    int updateByPrimaryKeySelective(Order record);

    int updateByPrimaryKey(Order record);
}

②OrderItemBiz

package com.liaoxin.ssm.biz;

import com.liaoxin.ssm.model.OrderItem;
import com.liaoxin.ssm.model.vo.OrderItemVo;
import org.apache.ibatis.annotations.Param;

public interface OrderItemBiz {
    int deleteByPrimaryKey(Integer orderItemId);

    int insert(OrderItem record);

    int insertSelective(OrderItem record);

    OrderItem selectByPrimaryKey(Integer orderItemId);

    OrderItemVo queryOrderItemVoByOrderItemId(Integer orderItemId);

    int updateByPrimaryKeySelective(OrderItem record);

    int updateByPrimaryKey(OrderItem record);
}

3、Biz的实现层Impl

①OrderBizImpl

package com.liaoxin.ssm.biz.impl;

import com.liaoxin.ssm.biz.OrderBiz;
import com.liaoxin.ssm.mapper.OrderMapper;
import com.liaoxin.ssm.model.Order;
import com.liaoxin.ssm.model.vo.OrderVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class OrderBizImpl implements OrderBiz {
    @Autowired
    private OrderMapper orderMapper;
    @Override
    public int deleteByPrimaryKey(Integer orderId) {
        return 0;
    }

    @Override
    public int insert(Order record) {
        return 0;
    }

    @Override
    public int insertSelective(Order record) {
        return 0;
    }

    @Override
    public Order selectByPrimaryKey(Integer orderId) {
        return null;
    }

    @Override
    public OrderVo queryOrderVoByOrderId(Integer orderId) {
        return orderMapper.queryOrderVoByOrderId(orderId);
    }

    @Override
    public int updateByPrimaryKeySelective(Order record) {
        return 0;
    }

    @Override
    public int updateByPrimaryKey(Order record) {
        return 0;
    }
}

②OrderItemBizImpl

package com.liaoxin.ssm.biz.impl;

import com.liaoxin.ssm.biz.OrderItemBiz;
import com.liaoxin.ssm.mapper.OrderItemMapper;
import com.liaoxin.ssm.model.OrderItem;
import com.liaoxin.ssm.model.vo.OrderItemVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class OrderItemBizImpl implements OrderItemBiz {
    @Autowired
    private OrderItemMapper orderItemMapper;
    @Override
    public int deleteByPrimaryKey(Integer orderItemId) {
        return 0;
    }

    @Override
    public int insert(OrderItem record) {
        return 0;
    }

    @Override
    public int insertSelective(OrderItem record) {
        return 0;
    }

    @Override
    public OrderItem selectByPrimaryKey(Integer orderItemId) {
        return null;
    }

    @Override
    public OrderItemVo queryOrderItemVoByOrderItemId(Integer orderItemId) {
        return orderItemMapper.queryOrderItemVoByOrderItemId(orderItemId);
    }

    @Override
    public int updateByPrimaryKeySelective(OrderItem record) {
        return 0;
    }

    @Override
    public int updateByPrimaryKey(OrderItem record) {
        return 0;
    }
}

4、mapper层

①OrderMapper.java

package com.liaoxin.ssm.mapper;

import com.liaoxin.ssm.model.Order;
import com.liaoxin.ssm.model.vo.OrderVo;
import org.apache.ibatis.annotations.Param;

public interface OrderMapper {
    int deleteByPrimaryKey(Integer orderId);

    int insert(Order record);

    int insertSelective(Order record);

    Order selectByPrimaryKey(Integer orderId);

    OrderVo queryOrderVoByOrderId(@Param("orderId") Integer orderId);

    int updateByPrimaryKeySelective(Order record);

    int updateByPrimaryKey(Order record);
}

②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.liaoxin.ssm.mapper.OrderMapper" >
  <resultMap id="BaseResultMap" type="com.liaoxin.ssm.model.Order" >
    <constructor >
      <idArg column="order_id" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="order_no" jdbcType="VARCHAR" javaType="java.lang.String" />
    </constructor>
  </resultMap>

  <resultMap id="OrderVoMap" type="com.liaoxin.ssm.model.vo.OrderVo" >
    <result column="order_id" property="orderId"></result>
    <result column="order_no" property="orderNo"></result>
    <collection property="orderItems" ofType="com.liaoxin.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>

  <sql id="Base_Column_List" >
    order_id, order_no
  </sql>

  <select id="queryOrderVoByOrderId" 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=#{orderId}
  </select>

  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    from t_hibernate_order
    where order_id = #{orderId,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    delete from t_hibernate_order
    where order_id = #{orderId,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.liaoxin.ssm.model.Order" >
    insert into t_hibernate_order (order_id, order_no)
    values (#{orderId,jdbcType=INTEGER}, #{orderNo,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="com.liaoxin.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=INTEGER},
      </if>
      <if test="orderNo != null" >
        #{orderNo,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.liaoxin.ssm.model.Order" >
    update t_hibernate_order
    <set >
      <if test="orderNo != null" >
        order_no = #{orderNo,jdbcType=VARCHAR},
      </if>
    </set>
    where order_id = #{orderId,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.liaoxin.ssm.model.Order" >
    update t_hibernate_order
    set order_no = #{orderNo,jdbcType=VARCHAR}
    where order_id = #{orderId,jdbcType=INTEGER}
  </update>
</mapper>

③OrderItemMapper.java

package com.liaoxin.ssm.mapper;

import com.liaoxin.ssm.model.OrderItem;
import com.liaoxin.ssm.model.vo.OrderItemVo;
import org.apache.ibatis.annotations.Param;

public interface OrderItemMapper {
    int deleteByPrimaryKey(Integer orderItemId);

    int insert(OrderItem record);

    int insertSelective(OrderItem record);

    OrderItem selectByPrimaryKey(Integer orderItemId);

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

    int updateByPrimaryKeySelective(OrderItem record);

    int updateByPrimaryKey(OrderItem record);
}

④OrderItemMapper.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.liaoxin.ssm.mapper.OrderItemMapper" >
  <resultMap id="BaseResultMap" type="com.liaoxin.ssm.model.OrderItem" >
    <constructor >
      <idArg column="order_item_id" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="product_id" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="quantity" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="oid" jdbcType="INTEGER" javaType="java.lang.Integer" />
    </constructor>
  </resultMap>

  <resultMap id="OrderItemVoMap" type="com.liaoxin.ssm.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.liaoxin.ssm.model.Order">
      <result column="order_id" property="orderId"></result>
      <result column="order_no" property="orderNo"></result>
    </association>
  </resultMap>

  <sql id="Base_Column_List" >
    order_item_id, product_id,quantity,oid
  </sql>

  <select id="queryOrderItemVoByOrderItemId" resultMap="OrderItemVoMap" parameterType="java.lang.Integer" >
    select * from t_hibernate_order o,t_hibernate_order_item oi where
o.order_id=oi.oid and oi.order_item_id=#{orderItemId}
  </select>

  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    from t_hibernate_order_item
    where order_item_id = #{orderItemId,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    delete from t_hibernate_order_item
    where order_item_id = #{orderItemId,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.liaoxin.ssm.model.OrderItem" >
    insert into t_hibernate_order_item (order_item_id, product_id, quantity, 
      oid)
    values (#{orderItemId,jdbcType=INTEGER}, #{productId,jdbcType=INTEGER}, #{quantity,jdbcType=INTEGER}, 
      #{oid,jdbcType=INTEGER})
  </insert>
  <insert id="insertSelective" parameterType="com.liaoxin.ssm.model.OrderItem" >
    insert into t_hibernate_order_item
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="orderItemId != null" >
        order_item_id,
      </if>
      <if test="productId != null" >
        product_id,
      </if>
      <if test="quantity != null" >
        quantity,
      </if>
      <if test="oid != null" >
        oid,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="orderItemId != null" >
        #{orderItemId,jdbcType=INTEGER},
      </if>
      <if test="productId != null" >
        #{productId,jdbcType=INTEGER},
      </if>
      <if test="quantity != null" >
        #{quantity,jdbcType=INTEGER},
      </if>
      <if test="oid != null" >
        #{oid,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.liaoxin.ssm.model.OrderItem" >
    update t_hibernate_order_item
    <set >
      <if test="productId != null" >
        product_id = #{productId,jdbcType=INTEGER},
      </if>
      <if test="quantity != null" >
        quantity = #{quantity,jdbcType=INTEGER},
      </if>
      <if test="oid != null" >
        oid = #{oid,jdbcType=INTEGER},
      </if>
    </set>
    where order_item_id = #{orderItemId,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.liaoxin.ssm.model.OrderItem" >
    update t_hibernate_order_item
    set product_id = #{productId,jdbcType=INTEGER},
      quantity = #{quantity,jdbcType=INTEGER},
      oid = #{oid,jdbcType=INTEGER}
    where order_item_id = #{orderItemId,jdbcType=INTEGER}
  </update>
</mapper>

5、测试类

①OrderBizImplTest

package com.liaoxin.ssm.biz.impl;

import com.liaoxin.ssm.biz.OrderBiz;
import com.liaoxin.ssm.model.Order;
import com.liaoxin.ssm.model.vo.OrderVo;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import static org.junit.Assert.*;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:applicationContext-mybatis.xml"})
public class OrderBizImplTest {
    @Autowired
    private OrderBiz orderBiz;

    @Test
    public void queryOrderVoByOrderId() {
        OrderVo orderVo = orderBiz.queryOrderVoByOrderId(9);
        System.out.println(orderVo);
        orderVo.getOrderItems().forEach(System.out::println);
    }
}

无@Data注解运行效果：

 

有@Data注解运行效果：

 

②OrderItemBizImplTest

package com.liaoxin.ssm.biz.impl;

import com.liaoxin.ssm.biz.OrderItemBiz;
import com.liaoxin.ssm.model.vo.OrderItemVo;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import static org.junit.Assert.*;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:applicationContext-mybatis.xml"})
public class OrderItemBizImplTest {
    @Autowired
    private OrderItemBiz orderItemBiz;
    @Test
    public void queryOrderItemVoByOrderItemId() {
        OrderItemVo orderItemVo = orderItemBiz.queryOrderItemVoByOrderItemId(43);
        System.out.println(orderItemVo);
        System.out.println(orderItemVo.getOrder());
    }
}

运行效果：

 

二、多对多关联关系

1、实体类

①Hbook

package com.liaoxin.ssm.model;

import lombok.ToString;

@ToString
public class Hbook {
    private Integer bookId;

    private String bookName;

    private Float price;

    public Hbook(Integer bookId, String bookName, Float price) {
        this.bookId = bookId;
        this.bookName = bookName;
        this.price = price;
    }

    public Hbook() {
        super();
    }

    public Integer getBookId() {
        return bookId;
    }

    public void setBookId(Integer bookId) {
        this.bookId = bookId;
    }

    public String getBookName() {
        return bookName;
    }

    public void setBookName(String bookName) {
        this.bookName = bookName;
    }

    public Float getPrice() {
        return price;
    }

    public void setPrice(Float price) {
        this.price = price;
    }
}

②HbookCategory

package com.liaoxin.ssm.model;

public class HbookCategory {
    private Integer bcid;

    private Integer bid;

    private Integer cid;

    public HbookCategory(Integer bcid, Integer bid, Integer cid) {
        this.bcid = bcid;
        this.bid = bid;
        this.cid = cid;
    }

    public HbookCategory() {
        super();
    }

    public Integer getBcid() {
        return bcid;
    }

    public void setBcid(Integer bcid) {
        this.bcid = bcid;
    }

    public Integer getBid() {
        return bid;
    }

    public void setBid(Integer bid) {
        this.bid = bid;
    }

    public Integer getCid() {
        return cid;
    }

    public void setCid(Integer cid) {
        this.cid = cid;
    }
}

2、biz层

①HbookCategoryBiz

package com.liaoxin.ssm.biz;

import com.liaoxin.ssm.model.HbookCategory;
import com.liaoxin.ssm.model.vo.CategoryVo;
import com.liaoxin.ssm.model.vo.HbookVo;
import org.apache.ibatis.annotations.Param;

public interface HbookCategoryBiz {
    int deleteByPrimaryKey(Integer bcid);

    int insert(HbookCategory record);

    int insertSelective(HbookCategory record);

    HbookCategory selectByPrimaryKey(Integer bcid);

    int updateByPrimaryKeySelective(HbookCategory record);

    int updateByPrimaryKey(HbookCategory record);

    HbookVo queryByBookId(Integer bookId);

    CategoryVo queryByCid(Integer cid);

}

3、biz的实现层impl

①HbookCategoryBizImpl

package com.liaoxin.ssm.biz.impl;

import com.liaoxin.ssm.biz.HbookCategoryBiz;
import com.liaoxin.ssm.mapper.HbookCategoryMapper;
import com.liaoxin.ssm.model.HbookCategory;
import com.liaoxin.ssm.model.vo.CategoryVo;
import com.liaoxin.ssm.model.vo.HbookVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class HbookCategoryBizImpl implements HbookCategoryBiz {
    @Autowired
    private HbookCategoryMapper hbookCategoryMapper;
    @Override
    public int deleteByPrimaryKey(Integer bcid) {
        return 0;
    }

    @Override
    public int insert(HbookCategory record) {
        return 0;
    }

    @Override
    public int insertSelective(HbookCategory record) {
        return 0;
    }

    @Override
    public HbookCategory selectByPrimaryKey(Integer bcid) {
        return null;
    }

    @Override
    public int updateByPrimaryKeySelective(HbookCategory record) {
        return 0;
    }

    @Override
    public int updateByPrimaryKey(HbookCategory record) {
        return 0;
    }

    @Override
    public HbookVo queryByBookId(Integer bookId) {
        return hbookCategoryMapper.queryByBookId(bookId);
    }

    @Override
    public CategoryVo queryByCid(Integer cid) {
        return hbookCategoryMapper.queryByCid(cid);
    }
}

4、mapper

①HbookCategoryMapper.java

package com.liaoxin.ssm.mapper;

import com.liaoxin.ssm.model.HbookCategory;
import com.liaoxin.ssm.model.vo.CategoryVo;
import com.liaoxin.ssm.model.vo.HbookVo;
import org.apache.ibatis.annotations.Param;

public interface HbookCategoryMapper {
    int deleteByPrimaryKey(Integer bcid);

    int insert(HbookCategory record);

    int insertSelective(HbookCategory record);

    HbookCategory selectByPrimaryKey(Integer bcid);

    int updateByPrimaryKeySelective(HbookCategory record);

    int updateByPrimaryKey(HbookCategory record);

    HbookVo queryByBookId(@Param("bookId") Integer bookId);

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

}

②HbookCategoryMapper.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.liaoxin.ssm.mapper.HbookCategoryMapper" >
  <resultMap id="BaseResultMap" type="com.liaoxin.ssm.model.HbookCategory" >
    <constructor >
      <idArg column="bcid" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="bid" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="cid" jdbcType="INTEGER" javaType="java.lang.Integer" />
    </constructor>
  </resultMap>
  <resultMap id="HbookVoMap" type="com.liaoxin.ssm.model.vo.HbookVo">
    <result property="bookId" column="book_id"></result>
    <result property="bookName" column="book_name"></result>
    <collection property="categories" ofType="com.liaoxin.ssm.model.Category">
      <result property="categoryId" column="category_id"></result>
      <result property="categoryName" column="category_name"></result>
    </collection>
  </resultMap>

  <resultMap id="CategoryVoMap" type="com.liaoxin.ssm.model.vo.CategoryVo">
    <result property="categoryId" column="category_id"></result>
    <result property="categoryName" column="category_name"></result>
    <collection property="hbooks" ofType="com.liaoxin.ssm.model.Hbook">
      <result property="bookId" column="book_id"></result>
      <result property="bookName" column="book_name"></result>
    </collection>
  </resultMap>
  <sql id="Base_Column_List" >
    bcid, bid, cid
  </sql>


  <select id="queryByBookId" 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 = #{bookId}
 </select>
  <select id="queryByCid" 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>



  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    from t_hibernate_book_category
    where bcid = #{bcid,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    delete from t_hibernate_book_category
    where bcid = #{bcid,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.liaoxin.ssm.model.HbookCategory" >
    insert into t_hibernate_book_category (bcid, bid, cid
      )
    values (#{bcid,jdbcType=INTEGER}, #{bid,jdbcType=INTEGER}, #{cid,jdbcType=INTEGER}
      )
  </insert>
  <insert id="insertSelective" parameterType="com.liaoxin.ssm.model.HbookCategory" >
    insert into t_hibernate_book_category
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="bcid != null" >
        bcid,
      </if>
      <if test="bid != null" >
        bid,
      </if>
      <if test="cid != null" >
        cid,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="bcid != null" >
        #{bcid,jdbcType=INTEGER},
      </if>
      <if test="bid != null" >
        #{bid,jdbcType=INTEGER},
      </if>
      <if test="cid != null" >
        #{cid,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.liaoxin.ssm.model.HbookCategory" >
    update t_hibernate_book_category
    <set >
      <if test="bid != null" >
        bid = #{bid,jdbcType=INTEGER},
      </if>
      <if test="cid != null" >
        cid = #{cid,jdbcType=INTEGER},
      </if>
    </set>
    where bcid = #{bcid,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.liaoxin.ssm.model.HbookCategory" >
    update t_hibernate_book_category
    set bid = #{bid,jdbcType=INTEGER},
      cid = #{cid,jdbcType=INTEGER}
    where bcid = #{bcid,jdbcType=INTEGER}
  </update>
</mapper>

③HbookMapper.java

package com.liaoxin.ssm.mapper;

import com.liaoxin.ssm.model.Hbook;

public interface HbookMapper {
    int deleteByPrimaryKey(Integer bookId);

    int insert(Hbook record);

    int insertSelective(Hbook record);

    Hbook selectByPrimaryKey(Integer bookId);

    int updateByPrimaryKeySelective(Hbook record);

    int updateByPrimaryKey(Hbook record);
}

④HbookMapper.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.liaoxin.ssm.mapper.HbookMapper" >
  <resultMap id="BaseResultMap" type="com.liaoxin.ssm.model.Hbook" >
    <constructor >
      <idArg column="book_id" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="book_name" jdbcType="VARCHAR" javaType="java.lang.String" />
      <arg column="price" jdbcType="REAL" javaType="java.lang.Float" />
    </constructor>
  </resultMap>
  <sql id="Base_Column_List" >
    book_id, book_name, price
  </sql>



  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    from t_hibernate_book
    where book_id = #{bookId,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    delete from t_hibernate_book
    where book_id = #{bookId,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.liaoxin.ssm.model.Hbook" >
    insert into t_hibernate_book (book_id, book_name, price
      )
    values (#{bookId,jdbcType=INTEGER}, #{bookName,jdbcType=VARCHAR}, #{price,jdbcType=REAL}
      )
  </insert>
  <insert id="insertSelective" parameterType="com.liaoxin.ssm.model.Hbook" >
    insert into t_hibernate_book
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="bookId != null" >
        book_id,
      </if>
      <if test="bookName != null" >
        book_name,
      </if>
      <if test="price != null" >
        price,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="bookId != null" >
        #{bookId,jdbcType=INTEGER},
      </if>
      <if test="bookName != null" >
        #{bookName,jdbcType=VARCHAR},
      </if>
      <if test="price != null" >
        #{price,jdbcType=REAL},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.liaoxin.ssm.model.Hbook" >
    update t_hibernate_book
    <set >
      <if test="bookName != null" >
        book_name = #{bookName,jdbcType=VARCHAR},
      </if>
      <if test="price != null" >
        price = #{price,jdbcType=REAL},
      </if>
    </set>
    where book_id = #{bookId,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.liaoxin.ssm.model.Hbook" >
    update t_hibernate_book
    set book_name = #{bookName,jdbcType=VARCHAR},
      price = #{price,jdbcType=REAL}
    where book_id = #{bookId,jdbcType=INTEGER}
  </update>
</mapper>

4、vo层

①CategoryVo

package com.liaoxin.ssm.model.vo;

import com.liaoxin.ssm.model.Category;
import com.liaoxin.ssm.model.Hbook;

import java.util.List;

public class CategoryVo extends Category {
    public List<Hbook> getHbooks() {
        return hbooks;
    }

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

    private List<Hbook> hbooks;

}

②HbookVo

package com.liaoxin.ssm.model.vo;

import com.liaoxin.ssm.model.Category;
import com.liaoxin.ssm.model.Hbook;

import java.util.List;

public class HbookVo extends Hbook {
    public List<Category> getCategories() {
        return categories;
    }

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

    private List<Category> categories;

}

5、测试类

①HbookCategoryBizImplTest

package com.liaoxin.ssm.biz.impl;

import com.liaoxin.ssm.biz.HbookCategoryBiz;
import com.liaoxin.ssm.model.vo.CategoryVo;
import com.liaoxin.ssm.model.vo.HbookVo;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import static org.junit.Assert.*;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:applicationContext-mybatis.xml"})
public class HbookCategoryBizImplTest {
    @Autowired
    private HbookCategoryBiz hbookCategoryBiz;

    @Test
    public void queryByBookId() {
        HbookVo hbookVo = hbookCategoryBiz.queryByBookId(8);
        System.out.println(hbookVo);
        hbookVo.getCategories().forEach(System.out::println);
    }

    @Test
    public void queryByCid() {
        CategoryVo categoryVo=hbookCategoryBiz.queryByCid(8);
        System.out.println(categoryVo);
        categoryVo.getHbooks().forEach(System.out::println);
    }
}

queryByBookId运行效果：

queryByCid运行效果：

 

Lme1216
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Mybatis关联映射
11-07
Mybatis关联映射 Mybatis关联映射 Mybatis关联映射 Mybatis关联映射 Mybatis关联映射
Mybatis关系映射
qq_40148886的博客
02-04 109
一、一对一关系映射 使用resultType+包装类实现 　　1、假设问题背景是要求在某一个购物平台的后台程序中添加一个这样的功能：查询某个订单的信息和下该订单的用户信息。首先我们可以知道，一般这样的平台上面，某一笔订单只属于某一个用户，从这个角度来看，可以作为一对一的参考模型 　　①首先创建数据表user（用户表） CREATE TABLE `user` ( `uid...
MyBatis的关联映射
shi_zi_183的博客
08-17 1300
MyBatis的关联映射 实际开发中，对数据库的操作常常会设计多张表，这在面向对象中就设计了对象与对象之间的关联关系。针对多表之间的操作，MyBatis提供了关联映射，通过关联映射就可以很好地处理对象与对象之间的关联关系。 关联关系概述 在关系型数据库中，多表之间存在三种关系，分别是一对一、一对多、多对多 一对一：在任意一方引入对方主键作为外键。 一对多：在"多"的一方，添加"一"的一方的主键作为外键。 多对多：产生中间关系表，引入两张表的主键作为外键，两个主键成为联合主键或使用新的字段作为主键。 通过数据
Mybatis的关联查询映射
08-23 228
1. 介绍：关联查询字面意思上就是多表之间的查询，单表操作是最简单的，多表操作才是业务所需要的，那么查出来的字段怎么封装呢？ 2. mybatis在这方面提供了很大的便利，通过三个标签便可以完成，resultMap、collection和association便是今天的猪脚 　　先对这几个标签做一下介绍 　　2.1 resultMap ： 　　　　id —— 我们调用的标识 　...
Mybatis一对多关联关系映射实现过程解析
08-25
主要介绍了Mybatis一对多关联关系映射实现过程解析,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
MyBatis的关联映射实践报告
12-04
了解数据表之间以及对象之间的三种关联关系 2.熟悉关联关系中的嵌套查询和 嵌套结果 3.掌握一对一，一对多，和多对多关联映射作用
基于java的企业级应用开发：MyBatis的关联映射.ppt
06-21
* * * * * MyBatis的关联映射 为什么学习MyBatis关联关系？ 9.1 关联关系概述 实际的开发中，对数据库的操作常常会涉及到多张表，这在面向对象中就涉及到了对象与对象之间的关联关系。针对多表之间的操作，MyBatis...
MyBatis关联映射代码
06-20
MyBatis关联映射代码
MyBatis关联映射
m0_62498006的博客
05-18 814
先来简单的了解一下关联映射吧，关联映射关系有一对一、一对多、多对多的关系，在开发中都会使用到，一对多其实比较多用。这些关联查询mybatis又可以使用两种方式来实现，分别为嵌套查询、嵌套结果。嵌套查询：嵌套查询其实是查询SQL语句后再进行一个(子查询)，会执行多条SQL语句,SQL语句编写比较简单，查询效率低，要多查一轮。嵌套结果：嵌套结果是一个多表查询的SQL语句，只有一条复杂的SQL语句(多表连接),SQL语句编写较为复杂，但是效率高。
MyBatis 关联映射
m0_52861684的博客
11-17 2791
MyBatis 关联映射，实现数据的一对一、一对多、多对多查询，同时对嵌套查询和嵌套结果集两种配置方法分别进行了演示。
mybatis关联映射
weixin_44603464的博客
06-27 314
表中多条记录对应关联表中一条记录（相当于一对多的反过来），将一对多关联中的主表与关联表交换位置后，描述此时的关系即为多对一。在嵌套结果查询中，即使实体类属性名与字段名一致，也不会进行自动映射。Oracle数据库不支持主键自增,需要采用序列(队列)生成主键值。主表中的一条记录在关联表中有多条记录(一对多)；主表中的记录在关联表中有且只有一条记录与之对应。在插入操作时,返回自动递增的主键值。例如：一个班级对应多个学生。
MyBatis-映射关系
爱笑的boy的博客
07-09 609
MyBatis-映射关系
【MyBatis】关系映射
学习 - 总结 - 分享 - Francis
10-18 641
一对一映射映射关系：一个员工对应一张员工卡 说明： 根据id查询Employee信息，因为Employee中有一个关联对象Card，所以返回对象是resultMap； 通过column的card_id值作为参数执行CardMapper.selectCardById，查询到的数据封装到Card对象<mapper namespace="com.mapper.CardMapper"> <se
mybatis关系关联映射
最新发布
09-13
MyBatis是一种持久化框架，它可以通过配置文件或注解来进行关系关联映射。在MyBatis中，关系关联映射主要通过以下几种方式实现： 1. 一对一关联映射：通过在对象之间定义关联关系，可以使用嵌套查询或嵌套结果映射...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值