目录
首先先用逆向生成工具生成t_hibernate_order、t_hibernate_order_item这两张表对应的model与mapper
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类
view object:视图对象
OrderVo.java
- package com.maomao.ssm.model.vo;
-
- import com.maomao.ssm.model.Order;
- import com.maomao.ssm.model.OrderItem;
-
- import java.util.List;
-
- /**
- * vo类不仅仅包含当前表的信息,还能够包含相关联表的信息
- *
- * 当前订单会有一个或者多个订单项,多个订单项必须用集合进行接收
- */
- public class OrderVo extends Order {
- //通过订单号查询本次订单的详细信息及对应的所哟普订单信息
- private List
orderItems; -
- public List
getOrderItems() { - return orderItems;
- }
-
- public void setOrderItems(List
orderItems) { - this.orderItems = orderItems;
- }
- }
OrderMapper.xml
- "1.0" encoding="UTF-8" ?>
- mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
- <mapper namespace="com.maomao.ssm.mapper.OrderMapper" >
- <resultMap id="BaseResultMap" type="com.maomao.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>
- <sql id="Base_Column_List" >
- order_id, order_no
- sql>
-
- <resultMap id="OrderVoMap" type="com.maomao.ssm.model.vo.OrderVo" >
- <result column="order_id" property="orderId">result>
- <result column="order_no" property="orderNo">result>
- <collection property="orderItems" ofType="com.maomao.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>
- collection>
- resultMap>
-
- <select id="quryOrderVoByOrderId" 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.maomao.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.maomao.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.maomao.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.maomao.ssm.model.Order" >
- update t_hibernate_order
- set order_no = #{orderNo,jdbcType=VARCHAR}
- where order_id = #{orderId,jdbcType=INTEGER}
- update>
- mapper>
OrderBiz.java
- package com.maomao.ssm.biz;
-
- import com.maomao.ssm.model.Order;
- import com.maomao.ssm.model.vo.OrderVo;
- import org.apache.ibatis.annotations.Param;
-
- public interface OrderBiz {
- int deleteByPrimaryKey(Integer orderId);
-
- int insert(Order record);
-
- int insertSelective(Order record);
-
- Order selectByPrimaryKey(Integer orderId);
-
- OrderVo quryOrderVoByOrderId(Integer orderId);
-
- int updateByPrimaryKeySelective(Order record);
-
- int updateByPrimaryKey(Order record);
- }
OrderBizImpl.java
- package com.maomao.ssm.biz;
-
- import com.maomao.ssm.mapper.OrderMapper;
- import com.maomao.ssm.model.Order;
- import com.maomao.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 quryOrderVoByOrderId(Integer orderId) {
- return orderMapper.quryOrderVoByOrderId(orderId);
- }
-
- @Override
- public int updateByPrimaryKeySelective(Order record) {
- return 0;
- }
-
- @Override
- public int updateByPrimaryKey(Order record) {
- return 0;
- }
- }
OrderBizImpl.java
- package com.maomao.ssm.biz.impl;
-
- import com.maomao.ssm.biz.OrderBiz;
- import com.maomao.ssm.model.Order;
- import com.maomao.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 quryOrderVoByOrderId() {
- OrderVo order = orderBiz.quryOrderVoByOrderId(9);
- System.out.println(order);
- order.getOrderItems().forEach(System.out::println);
- }
- }

OrderItemVo.java
- package com.maomao.ssm.model.vo;
-
- import com.maomao.ssm.model.Order;
- import com.maomao.ssm.model.OrderItem;
-
- /**
- * 某一个订单项一定属于某个订单的
- */
- public class OrderItemVo extends OrderItem {
-
- private Order order;
-
-
-
- public Order getOrder() {
- return order;
- }
-
- public void setOrder(Order order) {
- this.order = order;
- }
- }
OrderitemMapper.xml
- "1.0" encoding="UTF-8" ?>
- mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
- <mapper namespace="com.maomao.ssm.mapper.OrderItemMapper" >
- <resultMap id="BaseResultMap" type="com.maomao.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>
- <sql id="Base_Column_List" >
- order_item_id, product_id, quantity, oid
- sql>
-
- <resultMap id="OrderItemVoMap" type="com.maomao.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>
- <collection property="order" javaType="com.maomao.ssm.model.Order">
- <result column="order_id" property="orderId">result>
- <result column="order_no" property="orderNo">result>
- collection>
- resultMap>
-
- <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.maomao.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.maomao.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.maomao.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.maomao.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>
OrderitemBiz.java
- package com.maomao.ssm.biz;
-
- import com.maomao.ssm.mapper.OrderMapper;
- import com.maomao.ssm.model.Order;
- import com.maomao.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 quryOrderVoByOrderId(Integer orderId) {
- return orderMapper.quryOrderVoByOrderId(orderId);
- }
-
- @Override
- public int updateByPrimaryKeySelective(Order record) {
- return 0;
- }
-
- @Override
- public int updateByPrimaryKey(Order record) {
- return 0;
- }
- }
OrderitemBizImpl.java
- package com.maomao.ssm.biz.impl;
-
- import com.maomao.ssm.biz.OrderItemBiz;
- import com.maomao.ssm.mapper.OrderItemMapper;
- import com.maomao.ssm.model.OrderItem;
- import com.maomao.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;
- }
- }
OrderitemBizImplTest.java
- package com.maomao.ssm.biz.impl;
-
- import com.maomao.ssm.biz.OrderItemBiz;
- import com.maomao.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);
- }
- }

collection:一对多的一方,对应关联属性ofType
Association:一对多的多方,对应关联属性javaType
首先先用逆向生成工具生成t_hibernate_book、t_hibernate_book_category、t_hibernate_category,这两张表对应的model与mapper
HbookMapper.xml
- "1.0" encoding="UTF-8" ?>
- mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
- <mapper namespace="com.maomao.mapper.HbookMapper" >
- <resultMap id="BaseResultMap" type="com.maomao.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.maomao.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.maomao.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.maomao.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.maomao.model.Hbook" >
- update t_hibernate_book
- set book_name = #{bookName,jdbcType=VARCHAR},
- price = #{price,jdbcType=REAL}
- where book_id = #{bookId,jdbcType=INTEGER}
- update>
- mapper>
HbookCategoryBiz.java
- package com.maomao.biz;
-
- import com.maomao.model.HbookCategory;
- import com.maomao.model.vo.CategoryVo;
- import com.maomao.model.vo.HbookVo;
-
- 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);
-
- }
HbookCategoryBizImpl .java
- package com.maomao.biz.impl;
-
- import com.maomao.biz.HbookCategoryBiz;
- import com.maomao.mapper.HbookCategoryMapper;
- import com.maomao.model.HbookCategory;
- import com.maomao.model.vo.CategoryVo;
- import com.maomao.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 HbookVo queryByBookId(Integer bookId) {
- return hbookCategoryMapper.queryByBookId(bookId);
- }
-
- @Override
- public CategoryVo queryByCid(Integer cid) {
- return hbookCategoryMapper.queryByCid(cid);
- }
- }
HbookCategoryBizImplTest.java
- package com.maomao.biz.impl;
-
- import com.maomao.biz.HbookCategoryBiz;
- import com.maomao.model.vo.CategoryVo;
- import com.maomao.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);
-
- }
- }