java mysql 中文乱码问题 求高手指教
做了一个登录界面以下是代码：
login.jsp
- HTML code
<%@ page contentType="text/html; charset=gb2312"%><%request.setCharacterEncoding("gb2312");%><!-- 该Login页面是一个简单的登录界面 --><!-- 该JSP程序是用来测试与MySQL数据库的连接， 需要一个数据库：LearnJSP，和其中一个表：userinfo 表中有两个字段分别为：UserName varchar (20) not null,UserPwd varchar (20) not null--><html> <head> <title>登录</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <meta http-equiv="Content-Language" content="ch-cn"> </head> <body bgcolor=cyan> <!-- Form 用来提取用户填入并提交的信息--> <form method="POST" name="frmLogin" action="LoginServlet"> <h1 align="center">用户登录</h1><br> <div align="center">用户名： <input type="text" name="txtUserName" value="" size="20" maxlength="20" onfocus="if(this.value=='Your name')this.value=";"><br>密码： <input type="password" name="txtPassword" value="" size="20" maxlength="20" onfocus="if(this.value=='Your password')this.value=";"><br> <input type="submit" name="Submit" value="提交" onClick="validateLogin();" > <input type="reset" name="Reset" value="重置"><br> </div> </form> <!-- javaScript 函数 validateLogin(),用来验证用户名和密码是否为空 --> <script language="javaScript"> function validateLogin() { var sUserName = document.frmLogin.txtUserName.value; var sPassword = document.frmLogin.txtPassword.value; if( sUserName=="" ) { alert("请输入用户名！"); return false; } if( sPassword=="" ) { alert("请输入密码！"); return false; } } </script> </body></html>LoginServlet.java
- Java code
/** * 该JSP程序是用来测试与MySQL数据库的连接， * 需要一个数据库：LearnJSP，和其中一个表：userinfo * 表中有两个字段分别为：UserName varchar (20) not null,UserPwd varchar (20) not null */package zieckey.login.servlet;import java.sql.Statement;import java.io.IOException;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import javax.servlet.Servlet;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class LoginServlet extends HttpServlet implements Servlet{ public LoginServlet () { // TODO Auto-generated constructor stub } /* * (non-Javadoc) * * @see javax.servlet.http.HttpServlet#doGet(javax.servlet.http.HttpServletRequest, * javax.servlet.http.HttpServletResponse) */ @Override protected void doGet ( HttpServletRequest arg0, HttpServletResponse arg1 ) throws ServletException, IOException { } /* * (non-Javadoc) * * @see javax.servlet.http.HttpServlet#doPost(javax.servlet.http.HttpServletRequest, * javax.servlet.http.HttpServletResponse) */ @Override protected void doPost ( HttpServletRequest request, HttpServletResponse response ) throws ServletException, IOException { response.setContentType ( "text/html;charset=GB2312" ); String result = ""; // 获取用户名 String sUserName = request.getParameter ( "txtUserName" ); if ( sUserName == "" || sUserName == null || sUserName.length ( ) > 20 ) { try { result = "请输入用户名（不超过20字符）！"; request.setAttribute ( "ErrorUserName", result ); response.sendRedirect ( "login.jsp" ); } catch ( Exception e ) { } } // 获取密码 String sPasswd = request.getParameter ( "txtPassword" ); if ( sPasswd == "" || sPasswd == null || sPasswd.length ( ) > 20 ) { try { result = "请输入密码（不超过20字符）！"; request.setAttribute ( "ErrorPassword", result ); response.sendRedirect ( "login.jsp" ); } catch ( Exception e ) { } } // 登记JDBC驱动程序 try { Class.forName ( "org.gjt.mm.mysql.Driver" ).newInstance ( ); } catch ( InstantiationException e ) { // TODO Auto-generated catch block e.printStackTrace ( ); System.out.println ("InstantiationException"); } catch ( IllegalAccessException e ) { // TODO Auto-generated catch block e.printStackTrace ( ); System.out.println ("IllegalAccessException"); } catch ( ClassNotFoundException e ) { // TODO Auto-generated catch block e.printStackTrace ( ); System.out.println ("ClassNotFoundException"); } // 连接参数与Access不同 String url = "jdbc:mysql://localhost:3306/LearnJSP"; // 建立连接 java.sql.Connection connection = null; Statement stmt = null; ResultSet rs = null; try { connection = DriverManager.getConnection ( url, "root", "root" ); stmt = connection.createStatement ( ); // SQL语句 String sql = "select * from userinfo where username='" + sUserName + "' and userpwd = '" + sPasswd + "'"; rs = stmt.executeQuery ( sql );// 返回查询结果 } catch ( SQLException e ) { // TODO Auto-generated catch block e.printStackTrace ( ); } try { if ( rs.next ( ) )// 如果记录集非空，表明有匹配的用户名和密码，登陆成功 { // 登录成功后将sUserName设置为session变量的UserName // 这样在后面就可以通过 session.getAttribute("UserName") 来获取用户名， // 同时这样还可以作为用户登录与否的判断依据 request.getSession ( ).setAttribute ( "UserName", sUserName ); response.sendRedirect ( "login_success.jsp" ); } else { // 否则登录失败 //response.sendRedirect ( "MyJsp.jsp" ); request.getSession ( ).setAttribute ( "UserName", sUserName ); response.sendRedirect ( "login_failure.jsp" ); } } catch ( SQLException e ) { // TODO Auto-generated catch block e.printStackTrace ( ); } try { if ( null!=rs ) { rs.close ( ); } if ( null!=stmt ) { stmt.close ( ); } if ( null!=connection ) { connection.close ( ); } } catch ( SQLException e ) { // TODO Auto-generated catch block e.printStackTrace ( ); } } /** * */ private static final long serialVersionUID = 1L;}
login_failure.jsp
- Java code
<%@ page language="java" contentType="text/html; charset=gb2312"pageEncoding="gb2312"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <title>My JSP 'login_failure.jsp' starting page</title> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body bgcolor=cyan> <% String userName = (String)session.getAttribute ( "UserName" ); %> <div align=center> <%=userName%> 对不起，登录失败！ </div> </body></html>
login_success.jsp
- Java code
<%@ page language="java" contentType="text/html; charset=gb2312"pageEncoding="gb2312"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <title>My JSP 'login_failure.jsp' starting page</title> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body bgcolor=cyan> <% String userName = (String)session.getAttribute ( "UserName" ); %> <div align=center> <%=userName%> 欢迎您，登录成功！ </div> </body></html>
然后这是数据库中的截图：
如果你在登录页面查英文的用户名，它会顺利显示成功页面，如下图：
？？？？？？？？？？？？？但问题是：如果你在登录界面输入中文用户名，他就会显示以下页面：
[解决办法]
试试：
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("gb2312");
......
response.setContentType("text/html;charset=gb2312");
response.sendRedirect ( "login_success.jsp" );
}
[解决办法]
页面默认是使用get方法发送的，如果是get方法的话，建议在tomcat的安装目录下conf文件夹中的server.xml中的 <Connector port="8081" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" URIEncoding="UTF-8" /> 后面加一个URIEnconding的编码，我这里设置的是"utf-8"，我建议以后使用utf-8因为它的使用范围比gbk更广
如果是post方法发送的话，就像楼上有过提到的直接设置request.setCharacterEncoding("gb2312");
就可以了，我前段时间久刚好也到了java mysql的问题，现在解决了，就是我上面说的方法，希望能能帮上忙，最后还是建议你去看一篇文章，这里详细讲解了各种编码的问题http://www.ibm.com/developerworks/cn/java/j-lo-chinesecoding/
[解决办法]
- Java code
public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {request.setCharacterEncoding("gb2312"); ...... response.setContentType("text/html;charset=gb2312"); response.sendRedirect ( "login_success.jsp" ); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); }
[解决办法]
- Java code
@Override protected void doGet ( HttpServletRequest arg0, HttpServletResponse arg1 ) throws ServletException, IOException { this.doPost(arg0,arg1 ); } /* * (non-Javadoc) * * @see javax.servlet.http.HttpServlet#doPost(javax.servlet.http.HttpServletRequest, * javax.servlet.http.HttpServletResponse) */ @Override protected void doPost ( HttpServletRequest request, HttpServletResponse response ) throws ServletException, IOException {//把这个写在该方法的最上 request.setCharacterEncoding("gb2312"); response.setCharacterEncoding("gb2312"); response.setContentType ( "text/html;charset=GB2312" ); //your code...end }