MyBatis排序时使用order by 动态参数时需要注意，用$而不是# 用$传参时，直接将参数的值放在sql语句中，如：

<select id="getOpenSourceApkList" resultType="OpenSourceApkInfo" parameterType="Map" >

                 <![CDATA[

                 SELECT * FROM

                      (SELECT A.*, ROWNUM RN FROM

                            (SELECT * FROM t_OPENSOURCEAPKINFO where RECOMMEND =1 and VISIBILITY=2 ORDER BY ${orderKey} desc,ID)

                       A WHERE ROWNUM <= #{endNo})

                 WHERE RN >= #{beginNo}

           ]]>

 </select>

Sql语句打印:SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM t_OPENSOURCEAPKINFO where RECOMMEND =1 and VISIBILITY=2 ORDER BY averagegrade desc) A WHERE ROWNUM <= ?) WHERE RN >= ?

参数：24(Integer), 1(Integer)

 

用#传参时，不会将参数直接放在sql中，如：

<select id="getOpenSourceApkList" resultType="OpenSourceApkInfo" parameterType="Map" >

                 <![CDATA[

                 SELECT * FROM

                      (SELECT A.*, ROWNUM RN FROM

                            (SELECT * FROM t_OPENSOURCEAPKINFO where RECOMMEND =1 and VISIBILITY=2 ORDER BY #{orderKey} desc,ID)

                       A WHERE ROWNUM <= #{endNo})

                 WHERE RN >= #{beginNo}

           ]]>

      </select>

Sql语句打印:SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM t_OPENSOURCEAPKINFO where RECOMMEND =1 and VISIBILITY=2 ORDER BY ? desc) A WHERE ROWNUM <= ?) WHERE RN >= ?

参数：averagegrade(String), 24(Integer), 1(Integer)

最后执行的是order by  'averagegrade'