foreach collection 读取类中list

XML:

select * from goods_info
where delete_flag = 0

and code = #{query.code}


and name = #{query.name}


and kks_code = #{query.kksCode}


and id not in

#{item}


order by create_date desc

MAPPER:

Page goodsPage(Page page, @Param("query") ListGoodsDTO listGoodsDTO);

SERVICEIMPL:

@Override
public Page selectGoodsList(ListGoodsDTO listGoodsDTO) {
Page page = new Page<>(listGoodsDTO.getCurrent(), listGoodsDTO.getLimit());
Page goodsPage = countManageMapper.goodsPage(page, listGoodsDTO);
return goodsPage;
}