web项目插入mysql乱码

检查以下几点
1.mysql 数据表的字符集方式：utf8
2.web.xml文件编码
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>
org.springframework.web.filter.CharacterEncodingFilter
</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
3.数据库连接mysql字符串
jdbc.connection.driver_class=com.mysql.jdbc.Driver
#jdbc.connection.url=jdbc\:mysql\://172.22.0.x\:3306/datebasename [color=red](这样是不行的)
jdbc.connection.url=jdbc\:mysql\://172.22.0.x\:3306/datebasename?useUnicode\=true&characterEncoding\=UTF-8&autoReconnect\=true[/color]
jdbc.connection.username=xxx
jdbc.connection.password=xxx

4.修改tomcat下的conf/server.xml文件，找到如下代码：

<Connector port="8080" protocol="HTTP/1.1"

connectionTimeout="20000"

redirectPort="8443" />

这段代码规定了Tomcat监听HTTP请求的端口号等信息。可以在这里添加一个属性：URIEncoding，将该属性值设置为UTF-8，即可让Tomcat（默认ISO-8859-1编码）以UTF-8的编码处理get请求。

<Connector port="8080" protocol="HTTP/1.1"

connectionTimeout="20000"

[color=red]URIEncoding="UTF-8"

[/color] redirectPort="8443" />