原因:
@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});")
注意看,真心有一点不一样。(提示:引号。。。)