实体类与数据库字段不匹配问题,java.sql.SQLSyntaxErrorException: Unknown column 'xxx' in 'field list'
![复制代码](http://common.cnblogs.com/images/copycode.gif)
控制台报错Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'user_name' in 'field list'
The error may exist in panfeng/mapper/StudentMapper.java (best guess)
The error may involve panfeng.mapper.StudentMapper.selectByPrimaryKey-Inline
The error occurred while setting parameters
SQL: SELECT id,user_name,password,email FROM student WHERE id = ?
Cause: java.sql.SQLSyntaxErrorException: Unknown column 'user_name' in 'field list'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'user_name' in 'field list'] with root cause
java.sql.SQLSyntaxErrorException: Unknown column 'user_name' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.16.jar:8.0.16]
![复制代码](http://common.cnblogs.com/images/copycode.gif)
![复制代码](http://common.cnblogs.com/images/copycode.gif)
浏览器报错Whitelabel Error Page
This application has no explicit mapping for /error, so you are seeing this as a fallback.Tue Aug 06 13:10:39 CST 2019
There was an unexpected error (type=Internal Server Error, status=500).Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'user_name' in 'field list' ### The error may exist in panfeng/mapper/StudentMapper.java (best guess) ### The error may involve panfeng.mapper.StudentMapper.selectByPrimaryKey-Inline ### The error occurred while setting parameters ### SQL: SELECT id,user_name,password,email FROM student WHERE id = ? ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'user_name' in 'field list' ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'user_name' in 'field list'
![复制代码](http://common.cnblogs.com/images/copycode.gif)
出错的时候
修改之后,修改之后重启,就可以正常访问了!!!
https://www.cnblogs.com/taopanfeng/p/11308316.html 标签:Mapper,实体类,java,SQLSyntaxErrorException,column,Unknown,list,field From: https://www.cnblogs.com/sunny3158/p/16629029.html