org.springframework.jdbc.BadSqlGrammarException:报SQL语句拼写错误

https://blog.csdn.net/qq_35459724/article/details/85218744
org.springframework.jdbc.BadSqlGrammarException:
Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘desc
from commodity
where id = 1’ at line 4
The error may exist in com/yc/commodity/dao/CommodityMapper.xml
The error may involve com.yc.commodity.dao.CommodityMapper.selectByPrimaryKey-Inline
The error occurred while setting parameters
SQL: select id, name, brand, type, price, num, desc from commodity where id = ?
大概的错误就是这样子。
从上面可以看到
sql语句是这样的： select id, name, brand, type, price, num, desc from commodity where id = ？
查了资料才发现 name 和 desc 是sql的关键字，会报错
需要换数据库字段。把字段换掉就行了。