MySql存入数据乱码

方法 1:

在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>

        <init-param>

            <param-name>forceEncoding</param-name>

            <param-value>true</param-value>

        </init-param>

    </filter>

    <filter-mapping>

        <filter-name>encodingFilter</filter-name>

        <url-pattern>/*</url-pattern>

    </filter-mapping>

方法 2:

在config.properties文件中：

#db url

jdbc.url=jdbc:mysql://127.0.0.1:3306/ssm?&useUnicode=true&characterEncoding=utf-8

&mysqlEncoding=utf-8

方法 3:

打开E:\MySQL\MySQL Server 5.0

在my.ini文件中：

[mysql]

default-character-set=utf8

[mysqld]

# The default character set that will be used when a new schema or table is

# created and no character set is defined

default-character-set=utf8