问题就在于sql语句也不是我自己写的,是封装好的,所以为什么会出现语法错误…
2020-05-23 00:03:19.908 ERROR 20152 --- [nio-8088-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : 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 (sum_money, userid, orderid) values (20.0, '123456', '4028dc81723d1fd00172' at line 1
找到问题了,是因为我建表的时候使用了order,order是mysql语句的保留字段,会产生冲突,改个表名就好了