笔者在写springboot+微信小程序时,在进行增加数据操作时,遇到了报500错误。
分别可能是两种原因导致的
第一个是sql语句中没有加反引号。
第二个是错误的把反引号用成了单引号,这个出现错误后如果不仔细的话非常难以检查出来
利用postman发送json也会报错(500)
idea报错:
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''name', 'grade', 'sex', 'phone') VALUES ('小月',null, '女', '123456')' at line 1
### The error may exist in com/webmaster/demo/mapper/UserMapper.java (best guess)
### The error may involve com.webmaster.demo.mapper.UserMapper.save-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO user ('name', 'grade', 'sex', 'phone') VALUES (?,?, ?, ?);
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''name', 'grade', 'sex', 'phone') VALUES ('小月',null, '女', '123456')' 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 MariaDB server version for the right syntax to use near ''name', 'grade', 'sex', 'phone') VALUES ('小月',null, '女', '123456')' at line 1] with root cause
sql报错:
You have an error in your SQL syntax
解决方案是使用反引号(tab键上面的),替代单引号