mybatits的一些常用问题

1、mybatits的in字段查询的时候出现从小到大默认排序的情况，实现根据in字段里面的id进行排序

<select id="getList" resultType="cn.domain.Do_check">
   SELECT * from controller_auto_check where auto_check_id in
      <foreach item="item" index="index" collection="api_id_list" open="(" separator="," close=")">
         #{item}
      </foreach>
      ORDER BY FIELD
      <foreach item="item" collection="api_id_list"  open="(auto_check_id," separator="," close=")">
         #{item}
      </foreach>
</select>

2、持续更新