mybatis sqlserver 分页查询报错：'@P0' 附近有语法错误

来源：互联网发布：奥鹏网络研修总结作业编辑：程序博客网时间：2024/05/17 09:41

错误的sql

 <select id="searchEcoInfoPaged" resultMap="cm">select TOP #{rows} * from eco_info where ID in (            SELECT top (#{rows}*#{page}) ID FROM eco_info WHERE  1=1        <foreach collection="fieldMap" index="key" item="item" open="" separator="  " close="">            <if test="item != null and item != ''">               AND  ${key} LIKE '%'+#{item}+'%'            </if>        </foreach>        order by ID DESC)order by ID ASC    </select>

正确的sql

 <select id="searchEcoInfoPaged" resultMap="cm">select TOP ${rows} * from eco_info where ID in (            SELECT top (#{rows}*#{page}) ID FROM eco_info WHERE  1=1        <foreach collection="fieldMap" index="key" item="item" open="" separator="  " close="">            <if test="item != null and item != ''">               AND  ${key} LIKE '%'+#{item}+'%'            </if>        </foreach>        order by ID DESC)order by ID ASC    </select>

将第一个# 改为 $，具体原因有待研究。

0 0