在mysql数据库中传入中文字符,并实现正常显示.docVIP

在mysql中输入中文应做的正确操作 1.在安装mysql后要将C:\Program Files\MySQL\MySQL Server 5.5中的my.ini文件中的两个 default-character-set的值设为default-character-set=gbk 2.在创建mysql数据库时要进行如下创建 GBK: create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci; UTF8: CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 数据库中的语名如下 CREATE DATABASE `zhuce` /*!40100 DEFAULT CHARACTER SET gbk */; CREATE TABLE `tb_user` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(45) CHARACTER SET gbk DEFAULT NULL COMMENT 用户名, `password` varchar(45) CHARACTER SET gbk DEFAULT NULL COMMENT 密码, `sex` varchar(45) CHARACTER SET gbk DEFAULT NULL COMMENT 性别, `question` varchar(45) CHARACTER SET gbk DEFAULT NULL COMMENT 密码问题, `answer` varchar(45) CHARACTER SET gbk DEFAULT NULL COMMENT 密码答案, `email` varchar(45) CHARACTER SET gbk DEFAULT NULL COMMENT 邮箱, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; 2.创建字符编码servlet CharacterEncodingFilter package admin.jichupeizhi.zifu; import java.io.IOException; import javax.servlet.Filter; import javax.servlet.FilterChain; import javax.servlet.FilterConfig; import javax.servlet.ServletException; import javax.servlet.ServletRequest; import javax.servlet.ServletResponse; /** * 字符编码过滤器 * @author Li Zhong Wei */ public class CharacterEncodingFilter implements Filter{ // 字符编码(初始化参数) protected String encoding = null; // FilterConfig对象 protected FilterConfig filterConfig = null; // 初始化方法 public void init(FilterConfig filterConfig) throws ServletException { // 对filterConfig赋值 this.filterConfig = filterConfig; // 对初始化参数赋值 this.encoding = filterConfig.getInitParameter(encoding); } // 过滤器处理方法 public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException { // 判断字符编码是否有效 if (encoding != null) { // 设置request字符编码 request.setCharacterEncoding(encoding); // 设置response字符编码