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

原因：

@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});")

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