MyBatis一对多

最近公司有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();

 

posted @ 2014-03-11 10:44  wrong_ai  阅读(196)  评论(0)  编辑  收藏  举报