错误信息:

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语句,可在业务里做下判断。

Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐