. Cause: java.sql.SQLException: Incorrect string value: '\xE6\xB5\x8B\xE8\xAF\x95' for column 'name

[2016-12-13 15:35:48,946] [main] (XmlBeanDefinitionReader.java:317) INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [system/applicationContext-mybatis.xml][2016-12-13 15:35:49,737] [main] (PropertiesLoaderSupport.java:172) INFO  org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Loading properties file from class path resource [system/jdbc.properties][2016-12-13 15:35:49,744] [main] (PropertiesLoaderSupport.java:172) INFO  org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Loading properties file from class path resource [system/druid.properties][2016-12-13 15:35:49,768] [main] (AutowiredAnnotationBeanPostProcessor.java:141) INFO  org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring[2016-12-13 15:35:50,884] [main] (DruidDataSource.java:669) INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited[2016-12-13 15:35:51,880] [main] (XmlBeanDefinitionReader.java:317) INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml][2016-12-13 15:35:51,934] [main] (SQLErrorCodesFactory.java:126) INFO  org.springframework.jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]org.springframework.jdbc.UncategorizedSQLException: ### Error updating database.  Cause: java.sql.SQLException: Incorrect string value: '\xE6\xB5\x8B\xE8\xAF\x95' for column 'name' at row 1### The error may involve com.linbingcheng.example.test.dao.TestMapper.insert-Inline### The error occurred while setting parameters### SQL: insert into test (id, name)     values (?, ?)### Cause: java.sql.SQLException: Incorrect string value: '\xE6\xB5\x8B\xE8\xAF\x95' for column 'name' at row 1; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE6\xB5\x8B\xE8\xAF\x95' for column 'name' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE6\xB5\x8B\xE8\xAF\x95' for column 'name' at row 1    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:399)    at com.sun.proxy.$Proxy13.insert(Unknown Source)    at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:253)    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:52)    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)    at com.sun.proxy.$Proxy14.insert(Unknown Source)    at com.linbingcheng.example.test.service.impl.TestSVImpl.insert(TestSVImpl.java:18)    at com.linbingcheng.util.SpringTest.testAddTest(SpringTest.java:33)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)    at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)    at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)    at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)    at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)    at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:71)    at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)    at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)    at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)    at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)    at org.junit.runner.JUnitCore.run(JUnitCore.java:121)    at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:74)    at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:211)    at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:67)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)    at com.intellij.rt.execution.application.AppMain.main(AppMain.java:134)Caused by: java.sql.SQLException: Incorrect string value: '\xE6\xB5\x8B\xE8\xAF\x95' for column 'name' at row 1    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199)    at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)    at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)    at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)    at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:118)    at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)    at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:45)    at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:73)    at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)    at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:115)    at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:170)    at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:157)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)    ... 30 moreProcess finished with exit code -1

此错误是因为数据库字符编码的问题。重新确认数据库和表的编码，改成UTF-8即可