方式一
示例
mapper
List<ProductInfoVo> selectProductNumCountByGroupConfigModel(List<String> batteryTypeIds);
注意此时参数前不能使用@param否则会在下面的书写方式下会冲突报错
例如List selectProductNumCountByGroupConfigModel(@Param(“batteryTypeIds”)List batteryTypeIds);
不行。
xml
<select id="selectProductNumCountByGroupConfigModel" parameterType="string" resultType="com.zzz.project.busi.domain.vo.ProductInfoVo">
SELECT COUNT(config_model) AS usable_num, config_model AS product_name FROM device_info
<where>
battery_type_id IN
<foreach item="batteryTypeId" collection="list" open="(" separator="," close=" )">
#{batteryTypeId}
</foreach>
GROUP BY config_model
</where>
</select>