mybatis分页时报错, '@P0' 附近有语法错误

最新推荐文章于 2023-08-22 10:25:33 发布

蓝色的乌鸦

最新推荐文章于 2023-08-22 10:25:33 发布

阅读量4.2k

点赞数 2

分类专栏： Java开发文章标签： mybatis sql P0 附近有语法错误

本文链接：https://blog.csdn.net/wangkadm/article/details/12708005

版权

Java开发专栏收录该内容

6 篇文章 0 订阅

订阅专栏

### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: '@P0' 附近有语法错误。
### The error may exist in com/shboka/gos/mapper/BaseinfoMapper.xml
### The error may involve com.shboka.gos.mapper.BaseinfoMapper.getGoods-Inline
### The error occurred while setting parameters
### SQL: select top ? *   from base_goodsinfo   where (goodsid not in             (select top (?*?) goodsid            from base_goodsinfo            order by goodsid))   order by goodsid
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: '@P0' 附近有语法错误。
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: '@P0' 附近有语法错误。
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: '@P0' 附近有语法错误。
### The error may exist in com/shboka/gos/mapper/BaseinfoMapper.xml
### The error may involve com.shboka.gos.mapper.BaseinfoMapper.getGoods-Inline
### The error occurred while setting parameters
### SQL: select top ? *   from base_goodsinfo   where (goodsid not in             (select top (?*?) goodsid            from base_goodsinfo            order by goodsid))   order by goodsid
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: '@P0' 附近有语法错误。
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: '@P0' 附近有语法错误。
   at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

我的SQL语句

SELECT TOP #{pageSize} *
       FROM BASE_GOODSINFO
       WHERE (GOODSID NOT IN
                  (SELECT TOP (#{pageSize}*#{page}) GOODSID
                 FROM BASE_GOODSINFO
                 ORDER BY GOODSID))
       ORDER BY GOODSID

解决方法:select top ${pageSize}....

将#改成$就Ok了.