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

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