mybatis映射文件配置-1对多

 1 <?xml version="1.0" encoding="UTF-8" ?>
 2 <!DOCTYPE mapper
 3         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 4         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 5 <mapper namespace="com.echo.digital.beans.TbTypeMapper">
 6 
 7     <resultMap id="TbTypeResultMap" type="com.echo.digital.beans.TbType">
 8         <id column="type_id" property="typeId" javaType="java.lang.Integer"></id>
 9         <result column="type_name" property="typeName" javaType="java.lang.String"></result>
10         <result  column="type_img" property="typeImg" javaType="java.lang.String"></result>
11         <collection property="brands" ofType="com.echo.digital.beans.TbBrand">
12             <id column="brand_id" property="brandId" javaType="java.lang.Integer"></id>
13             <result column="brand_name" property="brandName" javaType="java.lang.String"></result>
14         </collection>
15     </resultMap>
16 
17     <select id="findType" resultMap="TbTypeResultMap">
18         select type_name,type_img,brand_name from tb_type
19     </select>
20 
21     <select id="findBrand" resultMap="TbTypeResultMap">
22         select brand_name from tb_type t join tb_brand b on t.type_id=b.brand_type_id
23         and t.type_name=#{typeName}
24     </select>
25 
26 </mapper>

多对一：用association标签

历经苦难而不厌，此乃阿修罗之道。