springmvc+mysql ：乱码

来源：互联网发布：excel统计空单元格数据编辑：程序博客网时间：2024/06/06 05:07

1、web.xml

     <filter>            <filter-name>CharacterEncodingFilter</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>            <init-param>                <param-name>forceEncoding</param-name>                <param-value>true</param-value>            </init-param>        </filter>        <filter-mapping>            <filter-name>CharacterEncodingFilter</filter-name>            <url-pattern>/*</url-pattern>        </filter-mapping>

2、springmvc.xml

<!--启动Spring MVC的注解功能,设置编码方式，防止乱码 -->    <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">        <property name="messageConverters">            <list>                <bean                    class="org.springframework.http.converter.StringHttpMessageConverter">                    <property name="supportedMediaTypes">                        <list>                            <value>text/html;charset=UTF-8</value>                        </list>                    </property>                </bean>                <!-- <ref bean="mappingJacksonHttpMessageConverter" /> -->            </list>        </property>    </bean>

3、jdbc.properties

jdbc.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8

4、数据库属性：utf8 -- UTF-8 Unicode

5、表属性：InnoDB

6、Tomcat的request、response编码设置

0 0