Oracle+Mybatis查询select...in...按照in中的内容进行排序返回

按照in语句中内容进行返回

这里使用了Oracle中的函数DECODE,对应的数据库语句

DECODE函数的介绍

select * from
    tbl
where
      id in('A7519254DEA575ECE053EB68580A1371','A7519254DEA875ECE053EB68580A1371','A7519254DEA675ECE053EB68580A1371','A7519254DEA775ECE053EB68580A1371')
ORDER BY "DECODE"(id,'A7519254DEA575ECE053EB68580A1371',1,'A7519254DEA875ECE053EB68580A1371',2,'A7519254DEA675ECE053EB68580A1371',3,'A7519254DEA775ECE053EB68580A1371',4);

这里使用了数字进行顺序标记;

对接Mybatis中的mapper.xml

<select id="xxx">
select * from
    tbl
where
id in <foreach item="id" index="index" collection="ids"
               open="(" separator="," close=")">
        #{id,jdbcType=OTHER}
      </foreach>
ORDER BY "DECODE"(id,
    <foreach item="dataId" index="index" collection="dataIds"
             open="" separator="," close="">
      #{id,jdbcType=OTHER},#{index}
    </foreach>)
</select>