数据库疑难杂症java.sql.SQLSyntaxErrorException:YouhaveanerrorinyourSQLsyntax;checkthemanualtha_YouhaveanerrorinyourSQLsyntax

.sql

44 浏览量更新于2023-03-03 评论 2 收藏 46KB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

数据库疑难杂症数据库疑难杂症 java.sql.SQLSyntaxErrorException: You have an error in

your SQL syntax; check the manual tha

数据库疑难杂症数据库疑难杂症 java.sql.SQLSyntaxErrorException: 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 ‘order’ at line 1

数据库报错如下数据库报错如下：

Error querying database. Cause: java.sql.SQLSyntaxErrorException: 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 ‘order’ at line 1

The error may exist in com/biyesheji/order/mapper/OrderMapper.java (best guess)

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: SELECT id,sale_money,cost_money,create_time,update_time,customer_id,contract_id FROM order

Cause: java.sql.SQLSyntaxErrorException: 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 ‘order’ at line 1

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 ‘order’ at line 1] with root cause

然后我复制控制台显示的自动生成的然后我复制控制台显示的自动生成的sql语句到数据库中运行，果不其然，也报同样的错语句到数据库中运行，果不其然，也报同样的错

SQL语句：SELECT id,sale_money,cost_money,create_time,update_time,customer_id,contract_id FROM order

下图为数据库报的错误

然后我检查SQL语句，发现生成的表名是order而并不是’order’，少了’’符号

正确的SQL语句应该是SELECT id,sale_money,cost_money,create_time,update_time,customer_id,contract_id FROM ‘order’