Mybatis自定义排序

需求：

根据接口传的用户id顺序返回用户信息

使用mysql的

order by field(id,1,2,3,4,5)

实例：

<select id="findUserListByIds" resultMap="SysUserResult" parameterType="java.lang.String">
   select u.id, u.dept_id, u.user_name, u.nick_name, u.email, u.avatar, u.phonenumber, u.password, u.sex, u.status, u.del_flag, u.login_ip, u.login_date, u.create_by, u.create_time, u.remark,
         u.id, u.userkey, u.nid, u.officePhone, u.post, u.zkem_card, u.style, u.internet, u.is_update_news, u.is_view_in_im, u.personal_email, u.pm_dutyId, u.qq, u.leader, u.leader_id, u.manager, u.manager_id, u.dep_leader, u.dep_leader_id,
         u.bid, u.order_number, u.postlevel, u.exetendField1, u.exetendField2, u.exetendField3, u.sub_leader, u.sub_leader_id, u.show_oa
   from sys_user u
   where u.id in
   <foreach collection="idList" item="userId" open="(" separator="," close=")">
      #{userId}
   </foreach>
   order by field
   <foreach collection="idList" item="userId" open="(u.id," separator="," close=")">
      #{userId}
   </foreach>

</select>