批量查询保证顺序
<select id="selectByActionIdList" resultMap="BaseResultMap">
select *
from f_m_operation_action
where comp_id = #{compId}
and action_id in
<foreach collection="actionIdList" item="actionId" index="index" open="(" close=")" separator=",">
#{actionId}
</foreach>
order by field (action_id,
<foreach collection="actionIdList" item="actionId" separator=",">
#{actionId}
</foreach>
)
</select>