### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You

解决mybatis-plus插入的坑

### Error updating 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 'order (userEmail,productId,orderId,createTime,money,integral) values ('325359288' at line 1
### The error may exist in com/dpj/mapper/ShopMapper.xml
### The error may involve com.dpj.mapper.ShopMapper.insertProductOrder-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO order (userEmail,productId,orderId,createTime,money,integral) values (?,?,?,?,?,?)
### 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 'order (userEmail,productId,orderId,createTime,money,integral) values ('325359288' at line 1
; bad SQL grammar []; nested exception is 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 'order (userEmail,productId,orderId,createTime,money,integral) values ('3253598' at line 1] with root cause

原因插入语句出现了与mp的关键字了，这里sql语句没错，错在order这个表的关键词
改成ordertemp这个表

<insert id="insertProductOrder" parameterType="Order">
    INSERT INTO ordertemp (userEmail,productId,orderId,createTime,money,integral) values (#{usrEmail},#{productId},#{orderId},#{createTime},#{money},#{integral})
</insert>