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

在mysql中输入中文应做的正确操作1.在安装mysql后要将C:\Program Files\MySQL\MySQL Server 5.5中的my.ini文件中的两个default-character-set的值设为default-character-set=gbk2.在创建mysql数据库时要进行如下创建GBK: create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;UTF8: CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATEutf8_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.创建字符编码servletCharacterEncodingFilterpackage 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赋值t his.filterConfig = filterConfig;// 对初始化参数赋值this.encoding = filterConfig.getInitParameter("encoding");}// 过滤器处理方法public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException { // 判断字符编码是否有效i f (encoding != null) {// 设置request字符编码request.setCharacterEncoding(encoding);// 设置response字符编码response.setContentType("text/html; charset="+encoding);}// 传递给下一过滤器chain.doFilter(request, response);}// 销毁方法public void destroy() {// 释放资源this.encoding = null;this.filterConfig = null;}}3.在web.xm中调用<!-- 声明字符编码过滤器 --><filter><filter-name>CharacterEncodingFilter</filter-name><filter-class>admin.jichupeizhi.zifu.CharacterEncodingFilter</fil ter-class><!-- 设置初始化参数 --><init-param><param-name>encoding</param-name><param-value>UTF-8</param-value></init-param></filter><!-- 映射字符编码过滤器 --><filter-mapping><filter-name>CharacterEncodingFilter</filter-name><!-- 与所有请求关联 --><url-pattern>/*</url-pattern><!-- 设置过滤器对应的请求方式 --><dispatcher>REQUEST</dispatcher><dispatcher>FORWARD</dispatcher></filter-mapping>4.在数据库连接中的代码import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class RegServlet extends HttpServlet {private static final long serialVersionUID = 1789481329876401944L;// 数据库连接Connectionprivate Connection conn;// 初始化方法public void init() throws ServletException {super.init();try {// 加载驱动Class.forName("com.mysql.jdbc.Driver");// 数据库连接urlString url ="jdbc:mysql://localhost:3306/zhuce?useUnicode=true&characterEncoding= GBK";// 获取数据库连接conn = DriverManager.getConnection(url, "root", "111");} catch (Exception e) {e.printStackTrace();}}// doPost()方法处理注册请求public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {// 设置request与response的编码response.setContentType("text/html");request.setCharacterEncoding("GBK");response.setCharacterEncoding("GBK");// 获取表单中属性值String username = request.getParameter("username");String password = request.getParameter("password");String sex = request.getParameter("sex");String question = request.getParameter("question");String answer = request.getParameter("answer");String email = request.getParameter("email");String dianhua = request.getParameter("dianhua");String shouji = request.getParameter("shouji");String wangkadizhi = request.getParameter("wangkadizhi");String xueli = request.getParameter("xueli");// 判断数据库中否连接成功if (conn != null) {try {// 插入注册信息的SQL语句(使用?占位符)String sql = "insert intotb_user(username,password,sex,question,answer,email,dianhua,shouji,wa ngkadizhi,xueli) "+ "values(?,?,?,?,?,?,?,?,?,?)";// 创建PreparedStatement对象PreparedStatement ps = conn.prepareStatement(sql);// 对SQL语句中的参数动态赋值ps.setString(1, username);ps.setString(2, password);ps.setString(3, sex);ps.setString(4, question);ps.setString(5, answer);ps.setString(6, email);ps.setString(7, dianhua);ps.setString(8, shouji);ps.setString(9, wangkadizhi);ps.setString(10, xueli);// 执行更新操作ps.executeUpdate();// 获取PrintWriter对象PrintWriter out = response.getWriter();// 输出注册结果信息out.print("<h1 aling='center'>");out.print(username + "注册成功！");out.print("</h1>");out.flush();out.close();} catch (Exception e) {e.printStackTrace();}} else {// 发送数据库连接错误提示信息response.sendError(500, "数据库连接错误！");}}}5.在mysql-front软件中5中jsp文件中要写入<%@ page language="java" contentType="text/html" pageEncoding="GBK"%>。