mybatis根据批量id查询批量信息

mapper.java：

Page<UserPoJo> findUserListByIds(@Param("Ids") List<Integer> Ids);

mapper.xml:

1. <!--根据id列表批量查询职位-->
2. <select id="findUserListByIds" resultType="com.glory.api.job.pojo.UserPoJo">
3.     SELECT * from yy_users
4.         WHERE id in
5.         < foreach collection = "Ids" item = "dramaId" open = "(" close = ")" separator = "," >
6.              #{dramaId}
7.        </foreach>
8. </select>

注意sql语句SELECT * FROM ny_jobs WHERE id IN () 这个会报错，所以最后判断一下 Ids是有元素的。

1.