mapper.java:
Page<UserPoJo> findUserListByIds(@Param("Ids") List<Integer> Ids);mapper.xml:
-
<!--根据id列表批量查询职位-->
-
<select id="findUserListByIds" resultType="com.glory.api.job.pojo.UserPoJo">
-
SELECT * from yy_users
-
WHERE id in
-
< foreach collection = "Ids" item = "dramaId" open = "(" close = ")" separator = "," >
-
#{dramaId}
-
</foreach>
-
</select>
注意sql语句SELECT * FROM ny_jobs WHERE id IN () 这个会报错,所以最后判断一下 Ids是有元素的。