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是有元素的。