2021-02-25 22:23:42.107 ERROR 916 --- [nio-8400-exec-5] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException:
### Error updating database. Cause: java.sql.SQLException: Incorrect string value: '\xE5\x93\x88\xE5\x93\x88' for column 'name' at row 1
### The error may exist in com/wang/mall/product/dao/BrandDao.java (best guess)
### The error may involve com.wang.mall.product.dao.BrandDao.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO pms_brand ( name, logo, descript, show_status, first_letter, sort ) VALUES ( ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: Incorrect string value: '\xE5\x93\x88\xE5\x93\x88' for column 'name' at row 1
; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE5\x93\x88\xE5\x93\x88' for column 'name' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE5\x93\x88\xE5\x93\x88' for column 'name' at row 1] with root cause
java.sql.SQLException: Incorrect string value: '\xE5\x93\x88\xE5\x93\x88' for column 'name' at row 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.18.jar:8.0.18]
//省略一大堆......
前端往后端传入中文字符报错,我的解决方案在下面,已经解决......
数据库字符集的问题
之前显示的是latin1,改为utf8就好了,真是哭笑不得,查了一天