mybatis中@SELECT 语句报错：Parameter index out of range (1 > number of parameters, which is 0) 报错及解决方案

最新推荐文章于 2022-02-05 21:31:08 发布

原创最新推荐文章于 2022-02-05 21:31:08 发布 · 1.8k 阅读

0 ·

CC 4.0 BY-SA版权

java 同时被 2 个专栏收录

325 篇文章

订阅专栏

Java

299 篇文章

订阅专栏

本文详细解析了在使用MyBatis框架时遇到的SQL语法错误案例，具体表现为在动态SQL语句中连接字符串参数时出现的问题。通过对比错误与正确SQL语句，强调了在SQL字符串中正确使用参数占位符的重要性。

原因：

@SELECT中的sql写错了，如下

错误的sql：

@Select("SELECT id, clientKey AS clientkey, unknow_num AS unknowNum, online_num AS onlineNum, offline_num AS offlineNum, record_date AS recordDate, record_hour AS recordHour, create_time AS createTime FROM device_total WHERE `record_date` = '#{rd}'  AND `clientKey` IN (${ck});")

正确的sql：

@Select("SELECT id, clientKey AS clientkey, unknow_num AS unknowNum, online_num AS onlineNum, offline_num AS offlineNum, record_date AS recordDate, record_hour AS recordHour, create_time AS createTime FROM device_total WHERE `record_date` = #{rd}  AND `clientKey` IN (${ck});")

注意看，真心有一点不一样。（提示：引号。。。）