Failed to process, please exclude the tableName or statementId. Error SQL

错误信息：

nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, please exclude the tableName or statementId. Error SQL: SELECT id,plc_no,plc_name,link_equipment_id,equipment_type,device_type,remark,plc_type,ip_address,ip_port,plc_state,bill_process_id,create_id,create_user,create_time,update_id,update_user,update_time,del_flag FROM dcs_plc_config WHERE (link_equipment_id IN ()) ### The error may exist in com/biz/plc/mapper/PlcConfigMapper.java (best guess) ### The error may involve com.biz.plc.mapper.PlcConfigMapper.selectList ### The error occurred while executing a query ### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, please exclude the tableName or statementId. Error SQL: SELECT id,plc_no,plc_name,link_equipment_id,equipment_type,device_type,remark,plc_type,ip_address,ip_port,plc_state,bill_process_id,create_id,create_user,create_time,update_id,update_user,update_time,del_flag FROM dcs_plc_config WHERE (link_equipment_id IN ()) 

 

原因： 

WHERE (link_equipment_id IN ()) 这个地方错了，IN() 括号里什么都没有，就是没有设置任何查询条件，这种方式是不对的，属于sql错误， .

IN()括号里必须设置查询条件，哪怕是空字符串也行，如：WHERE (link_equipment_id IN (''))，而他的查询条件就是空字符串。

如果真的没有查询参数，就不要走此SQL语句，可在业务里做下判断。