mybatis注解一对多查询

官网例子 http://www.mybatis.cn/archives/424.html

@Results的基本用法。当数据库字段名与实体类对应的属性名不一致时，可以使用@Results映射来将其对应起来。column为数据库字段名，porperty为实体类属性名，jdbcType为数据库字段数据类型，id为是否为主键。

@Many 一对多 

@One 一对一

public interface TProductSpecMapper extends BaseMapper<TProductSpec> {

	@Select(value = { "select * from t_product_spec where id=#{proId}" })
	@Results({
		@Result(property = "FSpecID", column = "FSpecID",many = @Many(select = "com.oranth.p2p.mapper.TSpecMapper.selectById"))
	})
	public List<TProductSpec> selectByProId(int proId);
}

public interface TSpecMapper extends BaseMapper<TSpec> {

	@Select(value = "select * from t_spec where FID=#{id}")
	@Results({
		@Result(property="fid",column="FID",
				many = @Many(select="com.oranth.p2p.mapper.TSpecvlaMapper.selectBySpecID"))
	})
	List<TSpecvlaMapper> selectById(int id); 
}