<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'