mybatis查询条件为数组时，按数组的顺序返回数据

最新推荐文章于 2024-04-30 17:28:01 发布

小小小果子

最新推荐文章于 2024-04-30 17:28:01 发布

阅读量508

点赞数

文章标签： mybatis java mysql

本文链接：https://blog.csdn.net/weixin_46244732/article/details/127810561

版权

mapper.java

List<User> selectUserByIds(Long[] userIds);

mapper.xml

   <select id="selectUserByIds" parameterType="Long" resultMap="UserVoResult">
        select u.user_id, u.user_name,u.office_city
        from user u
        <where>
            u.status = '0'
            and u.user_id in
            <foreach collection="array" item="item" open="(" separator="," close=")">
                #{item}
            </foreach>
        </where>
        <foreach collection="array" item="item" open="order by field(u.user_id," separator="," close=")">
            #{item}
        </foreach>
    </select>