/**
* <b>Function: </b> todo
*
* @program: mybatis传递集合
* @Package: com.kingbal.king.dmp
* @author: dingcho
* @date: 2024/09/27
* @version: 1.0
* @Copyright: 2024 www.kingbal.com Inc. All rights reserved.
*/
public interface YourMapper {
List<YourVO> queryYourVOByids(@Param("ids") List<Integer> ids);
}
<mapper namespace="your.package.YourMapper">
<select id="queryYourVOByids" resultType="Long">
SELECT id
FROM table a
WHERE a.id IN
<foreach item="id" index="index" collection="ids" open="(" separator="," close=")">
#{id}
</foreach>
</select>
</mapper>