Mybatis遍历list元素内容为数组,任意字段排序

1.尝试使用#号报dao中方法没有item参数，后来发现$好用

    <select id="selectByOption" resultType="bw.zcfx.svc.module.main.entity.DatStatConsistencePO"> 
        select indicator_id1 indicatorId1,indicator_id2 indicatorId2,`offset`,trend,consistence,data_len dataLen from 
        dat_stat_consistence 
        <where> 
            <foreach collection="reqList" separator="or" item="item" index="index"> 
                indicator_id1 = ${item[0]} and indicator_id2 = ${item[1]} 
            </foreach> 
        </where> 
        <if test="orderField!=null and orderType!=null and orderField!='' and orderType!=''"> 
            order by ${orderField} ${orderType} 
        </if> 
        limit #{startIndex} ,#{pageSize} 
    </select> 

2.多字段排序

 <if test="orderMap.size>0"> 
        order by 
            <foreach item="value" index="key" collection="orderMap.entrySet()" separator=","> 
                ${key} ${value} 
            </foreach> 
        </if>