mybatis 下 mysql in查询按照参数顺序输出结果

使用Field函数：

<select id="findByIds"  resultType="com.bwhx.eruler.bean.CeliangBuwei">  
    SELECT * FROM project_celiangbuwei  where  clbwid in   
    <foreach collection="array" index="index" item="item" open="(" separator=","  close=")" >  
        #{item}    
      </foreach>   
      order by   
      field(  
      clbwid,  
      <foreach collection="array" index="index" item="item"   separator=","    >  
        #{item}    
      </foreach>   
      )  
</select>