mybaties根据list参数查询并排序

mybaties根据list参数查询并排序

测试代码

	List<Integer> merList=new ArrayList<Integer>();
    merList.add(37);
    merList.add(40);
    merList.add(38);
    merList.add(39);
    Map<String,Object> merParam=new HashMap<String,Object>();
    merParam.put("merList",merList);
    List list=session_front.selectList("com.di3fang.active.dao.getMerchant",merParam);
    logger.info("list:"+list);

mybaties查询

<select id="getMerchant" resultType="java.util.LinkedHashMap">
      select id
        from kpi_merchant
        where id in
        <foreach collection="merList" item="mer" separator="," open="(" close=")">
            #{mer}
        </foreach>
        order by field(
        id,
        <foreach collection="merList" item="mer" separator=",">
            #{mer}
        </foreach>
        )
    </select>

结果输出

	list:[{id=37}, {id=40}, {id=38}, {id=39}]