<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
<generatorConfiguration>
    <!-- 引入配置文件 -->
    <properties resource="jdbc.properties"/>
    <!--指定數(shù)據(jù)庫(kù)jdbc驅(qū)動(dòng)jar包的位置-->
    <classPathEntry location="C:\\temp2\\mvn_repository\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
    <!-- 一個(gè)數(shù)據(jù)庫(kù)一個(gè)context -->
    <context id="infoGuardian">
        <!-- 注釋 -->
        <commentGenerator>
            <property name="suppressAllComments" value="true"/><!-- 是否取消注釋 -->
            <property name="suppressDate" value="true"/> <!-- 是否生成注釋代時(shí)間戳 -->
        </commentGenerator>
        <!-- jdbc連接 -->
        <jdbcConnection driverClass="${jdbc.driver}"
                        connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
        <!-- 類型轉(zhuǎn)換 -->
        <javaTypeResolver>
            <!-- 是否使用bigDecimal， false可自動(dòng)轉(zhuǎn)化以下類型（Long, Integer, Short, etc.） -->
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>
        <!-- 01 指定javaBean生成的位置 -->
        <!-- targetPackage：指定生成的model生成所在的包名 -->
        <!-- targetProject：指定在該項(xiàng)目下所在的路徑  -->
        <javaModelGenerator targetPackage="com.zking.model"
                            targetProject="src/main/java">
            <!-- 是否允許子包，即targetPackage.schemaName.tableName -->
            <property name="enableSubPackages" value="false"/>
            <!-- 是否對(duì)model添加構(gòu)造函數(shù) -->
            <property name="constructorBased" value="true"/>
            <!-- 是否針對(duì)string類型的字段在set的時(shí)候進(jìn)行trim調(diào)用 -->
            <property name="trimStrings" value="false"/>
            <!-- 建立的Model對(duì)象是否 不可改變  即生成的Model對(duì)象不會(huì)有 setter方法，只有構(gòu)造方法 -->
            <property name="immutable" value="false"/>
        </javaModelGenerator>
        <!-- 02 指定sql映射文件生成的位置 -->
        <sqlMapGenerator targetPackage="com.zking.mapper"
                         targetProject="src/main/java">
            <!-- 是否允許子包，即targetPackage.schemaName.tableName -->
            <property name="enableSubPackages" value="false"/>
        </sqlMapGenerator>
        <!-- 03 生成XxxMapper接口 -->
        <!-- type="ANNOTATEDMAPPER",生成Java Model 和基于注解的Mapper對(duì)象 -->
        <!-- type="MIXEDMAPPER",生成基于注解的Java Model 和相應(yīng)的Mapper對(duì)象 -->
        <!-- type="XMLMAPPER",生成SQLMap XML文件和獨(dú)立的Mapper接口 -->
        <javaClientGenerator targetPackage="com.zking.mapper"
                             targetProject="src/main/java" type="XMLMAPPER">
            <!-- 是否在當(dāng)前路徑下新加一層schema,false路徑com.oop.eksp.user.model， true:com.oop.eksp.user.model.[schemaName] -->
            <property name="enableSubPackages" value="false"/>
        </javaClientGenerator>
        <!-- 配置表信息 -->
        <!-- schema即為數(shù)據(jù)庫(kù)名 -->
        <!-- tableName為對(duì)應(yīng)的數(shù)據(jù)庫(kù)表 -->
        <!-- domainObjectName是要生成的實(shí)體類 -->
        <!-- enable*ByExample是否生成 example類 -->
        <!--<table schema="" tableName="t_book" domainObjectName="Book"-->
        <!--enableCountByExample="false" enableDeleteByExample="false"-->
        <!--enableSelectByExample="false" enableUpdateByExample="false">-->
        <!--&lt;!&ndash; 忽略列，不生成bean 字段 &ndash;&gt;-->
        <!--&lt;!&ndash; <ignoreColumn column="FRED" /> &ndash;&gt;-->
        <!--&lt;!&ndash; 指定列的java數(shù)據(jù)類型 &ndash;&gt;-->
        <!--&lt;!&ndash; <columnOverride column="LONG_VARCHAR_FIELD" jdbcType="VARCHAR" /> &ndash;&gt;-->
        <!--</table>-->
        <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="HCategory"
               enableCountByExample="false" enableDeleteByExample="false"
               enableSelectByExample="false" enableUpdateByExample="false">
        </table>
        <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>
    </context>
</generatorConfiguration>

package com.liao.vo;
import com.liao.model.Order;
import com.liao.model.OrderItem;
public class OrderItemVo extends OrderItem {
    private Order order;
    public Order getOrder() {
        return order;
    }
    public void setOrder(Order order) {
        this.order = order;
    }
}
 

<resultMap id="OrderItemMap" type="com.liao.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.liao.model.Order">
      <result column="order_id" property="orderId" ></result>
      <result column="order_no" property="orderNo" ></result>
    </association>
  </resultMap>
  <select id="selectByBiid" resultMap="OrderItemMap" 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 = #{oiid}
</select>

package com.liao.biz;
import com.liao.vo.OrderItemVo;
public interface OrderItemBiz {
    OrderItemVo selectByBiid(Integer oiid);
}

package com.liao.biz;
import com.liao.mapper.OrderItemMapper;
import com.liao.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 OrderItemVo selectByBiid(Integer oiid) {
        return orderItemMapper.selectByBiid(oiid);
    }
}

package com.liao.biz;
import com.liao.vo.OrderItemVo;
import org.junit.After;
import org.junit.Before;
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;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:spring-context.xml"})
public class Test01 {
? ? @Autowired
? ? private OrderItemBiz orderItemBiz;
? ? @Before
? ? public void setUp() throws Exception {
? ? }
? ? @After
? ? public void tearDown() throws Exception {
? ? }
? ? @Test
? ? public void selectByBiid() {
? ? ? ? OrderItemVo orderItemVo = orderItemBiz.selectByBiid(27);
? ? ? ? System.out.println(orderItemVo);
? ? ? ? System.out.println(orderItemVo.getOrder());
? ? }
}

package com.liao.vo;
import com.liao.model.Order;
import com.liao.model.OrderItem;
import java.util.ArrayList;
import java.util.List;
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;
? ? }
}

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

OrderVo selectByOid(@Param("oid") Integer oid);

package com.liao.biz;
import com.liao.vo.OrderVo;
public interface OrderBiz {
? ? OrderVo selectByOid(Integer oid);
}

package com.liao.biz;
import com.liao.mapper.OrderMapper;
import com.liao.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 OrderVo selectByOid(Integer oid) {
? ? ? ? return orderMapper.selectByOid(oid);
? ? }
}

 ? @Autowired
? ? private OrderBiz orderBiz;
? ? @Test
? ? public void selectByOid() {
? ? ? ? OrderVo orderVo = orderBiz.selectByOid(7);
? ? ? ? System.out.println(orderVo);
? ? ? ? orderVo.getOrderItems().forEach(System.out::println);

<resultMap id="HBookVoMap" type="com.liao.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.liao.model.Category">
      <result column="category_id" property="categoryId"></result>
      <result column="category_name" property="categoryName"></result>
    </collection>
  </resultMap>
  <select id="selectByBookId" 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>

HbookVo selectByBookId(@Param("bid") Integer bid);

package com.liao.biz;
import com.liao.vo.HbookVo;
import org.apache.ibatis.annotations.Param;
public interface HBookBiz {
? ? HbookVo selecByBookId(@Param("bid") Integer bid);
}

package com.liao.biz;
import com.liao.mapper.HBookMapper;
import com.liao.vo.HbookVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class HBookBizImpl implements HBookBiz {
? ? @Autowired
? ? private HBookMapper hBookMapper;
? ? @Override
? ? public HbookVo selecByBookId(Integer bid) {
? ? ? ? return hBookMapper.selectByBookId(bid);
? ? }
}

?@Autowired
? ? private HBookBiz hbookBiz;
? ? @Test
? ? public void selectByBookId() {
? ? ? ? HbookVo hBookVo = hbookBiz.selecByBookId(8);
? ? ? ? System.out.println(hBookVo);
? ? ? ? hBookVo.getCategories().forEach(System.out::println);