Mapper.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="org.liutao.wzry.mapper.ChampMapper">
<resultMap type="Champ" id="champResultMap">
<id property="id" column="id" />
<result property="name" column="name" />
<result property="coverImg" column="coverImg" />
<result property="detailImgs" column="detailimgs" />
<result property="detail" column="detail" />
</resultMap>


<resultMap type="Champ" id="champAndChampTypeResultMap"
extends="champResultMap">
<association property="type" column="typeId" javaType="ChampType"
resultMap="org.liutao.wzry.mapper.ChampTypeMapper.champTypeResultMap" ></association>
</resultMap>
    <resultMap id="OrderInfoAndDetilResultMap" type="org.boot.ssm.wxshop.domain.OrderInfo" extends="OrderInfoResultMap">
        <collection property="orderInfoDetails" column="id"  ofType="org.boot.ssm.wxshop.domain.OrderInfoDetail" select="selectDetailByOid"></collection>
    </resultMap>

<select id="selectAllChamp" resultMap="champAndChampTypeResultMap">
select
id,
name,
coverImg,
detailimgs,
detail,
typeid "typeId",
typeName
from CHAMP_VIEW 
</select>

<insert id="insertChamp" parameterType="Champ">
insert into champ
(name,typeid,coverImg,detailimgs,detail)
values
(#{name},#{type.id},#{coverImg},#{detailImgs},#{detail})
</insert>

<select id="selectOneChampById"  resultMap="champAndChampTypeResultMap">
select
c.id,
name,
coverImg,
detailimgs,
detail,
t.id "typeId",
typeName
from champ c left join
champ_type t on c.typeid = t.id
where c.id = #{champId}

</select>
</mapper>