原来的写法:
<collection property="surcharge" javaType="list"
ofType="com.kuagejing.supplier.entity.TransportSchemeSurcharge" >
<result column="sId" property="id"/>
<result column="surchargeId" property="schemeId"/>
<result column="item_price_fee" property="itemPriceFee"/>
<result column="additional_fee" property="additionalFee"/>
<result column="over_fee" property="overFee"/>
<result column="parser" property="parser"/>
<result column="user_type" property="userType"/>
</collection>
这个只能查询到一条数据,因为分页时会把多余的数据过滤了
可以把collection 映射一个子查询
还有的就是在代码里面查询匹配
List priceRan=…;
//根据SchemeId分组
Map<Long, List> prs = priceRanges.stream().collect(Collectors.groupingBy(PriceRange::getSchemeId));