配置:
1、jsp页面配置 : <%@ page language="java" contentType="text/html;charset=UTF-8"%>
2、jsp页面配置: request.setCharacterEncoding("utf-8");
3、web.xml 文件中增加如下代码(使用spring后,spring提供的过滤器):
<filter>
<filter-name>Spring character encoding filter</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>
<filter-mapping>
<filter-name>Spring character encoding filter</filter-name>
<url-pattern>*.jsp</url-pattern>
</filter-mapping>
4、数据源配置处修改:dbconn.dmzy.url =jdbc:mysql://localhost:3306/dmzy?useUnicode=true&characterEncoding=utf8
5、 Mysql中编码配置:Mysql安装时选择utf8,然后创建的表和字段都要用utf8的编码:
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL,
`userpwd` varchar(100) NOT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
可能涉及到的字段如果没有修改也要修改: