mapper层
public interface SysUserMapper extends BaseMapper<SysUser>{
List<SysUser> findUsersByUserId(@Param("userIds")Long[] userIds);
}
xml文件
<mapper namespace="com.netech.system.mapper.SysUserMapper">
<select id="findUsersByUserId" resultType="com.netech.common.core.domain.entity.SysUser">
select nick_name from sys_user
<where>
del_flag=0
<if test="userIds != null and userIds.length > 0">
and user_id in
<foreach collection="userIds" item="userId" open="(" separator="," close=")">
#{userId}
</foreach>
</if>
</where>
</select>