问题解决:Error querying database. Cause: java.sql.SQLSyntaxErrorException:

报错信息:

### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'client_name' in 'field list' ### The error may exist in com/cctc/customer/mapper/MsgMapper.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id,parent_id,business_id,type,modular_type,content,state,task_id,role_id,accept_user_id,creator_code,create_time,projbigcode,projbigname,customer_code,client_name,customer_name,customer_phone,msg_address,price_fair,demand_fair,instance_id FROM msg WHERE instance_id = ? AND modular_type = ? AND accept_user_id = ? ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'client_name' in 'field list' ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'client_name' in 'field list'

经过分析可以看出:

### 查询数据库时出错。 原因：java.sql.SQLSyntaxErrorException: Unknown column 'client_name' in 'field list' ### 错误可能存在于 com/cctc/customer/mapper/MsgMapper.java（最佳猜测）### 错误可能涉及 defaultParameterMap # ## 设置参数时出错### SQL: SELECT id,parent_id,business_id,type,modular_type,content,state,task_id,role_id,accept_user_id,creator_code,create_time,projbigcode,projbigname,customer_code,client_name,customer_name,customer_phone, msg_address,price_fair,demand_fair,instance_id FROM msg WHERE instance_id = ? AND 模块化类型 = ? 和接受用户ID =？ ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'client_name' in 'field list' ; 糟糕的 SQL 语法 []; 嵌套异常是 java.sql.SQLSyntaxErrorException: Unknown column 'client_name' in 'field list'

解决方法:

client_name字段在数据库表里没有对应的字段,只需要加上这个字段,或者实体类中去掉这个字段, 查询的时候不要带出来这个字段, 将其忽略掉,就可以解决此问题.