论坛 › Mybatis › Mybatis ResultMap Collection 复合主键

tiyan 发表于 2016-11-26 10:29:13

Mybatis ResultMap Collection 复合主键

【转:http://blog.163.com/wp_2002wp/blog/static/3147225220123521037196/ 】
<resultMap type="XX" id="XXMap">  
        <id property="id" column="colid"/>  
        <id property="name" column="colname"/>  
        <collection property="list" javaType="ArrayList" column="{id = colid,name=colname}" select="getSubXXX"/>
 </resultMap> 
前为别名后为主查询getXXX语句中字段
<select id="getXXX" parameterType="HashMap" resultMap="XXX">  
        SELECT colid,colname FROM table1
 </select> 
 <select id="getSubXXX" parameterType="HashMap" resultType="XXX">  
        SELECT * FROM table2 WHERE id = #{id} AND name = #{name}
  </select>

查看完整版本: Mybatis ResultMap Collection 复合主键