最近公司有SSI(spring+spring mvc + mybtais)框架，取数据的时候需要取一对多
一个车系对应多个子配件
实体类：
车系类：里边添加配件的List
private List<CarAccessories> carAccessoriesList;
xml:
1 <resultMap id="allAccessiories" type="conm.xx.xx.model.CarSeries"> 2 <id column="pkid" property="pkid" jdbcType="VARCHAR" /> 3 <result column="series_name" property="seriesName" jdbcType="VARCHAR" /> 4 //collection 5 <collection property="carAccessoriesList" ofType="com.xx.xx.model.CarAccessories"> 6 <id column="pkid" property="pkid" jdbcType="VARCHAR" /> 7 <result column="parentId" property="parentid" jdbcType="VARCHAR" /> 8 <result column="accessoriesName" property="accessoriesname" 9 jdbcType="VARCHAR" /> 10 <result column="accessoriesImage" property="accessoriesimage" 11 jdbcType="VARCHAR" /> 12 </collection> 13 </resultMap>
sql：
<select id="listAccessories" resultMap="allAccessiories"> SELECT s.*,a.* FROM car_series s LEFT JOIN car_accessories a ON s.pkid = a.parentId </select>
dao:
public List<CarSeries> listAccessories();
原文：http://www.cnblogs.com/wangdongBlog/p/3593388.html