在MySQL中用sql语句插入就可以正常插中文,在JSP中也可以显示中文,可是在JSP往MySQL里插数据的时候数据库中显示的就是???,我甚至尝试重新安装过MySQL,安装的时候选择的也是gb2312,数据库和表我也设置的是gb2312。我看了很多这方面的帖子,问题依然没有得到解决,请求CSDN的朋友帮助,谢谢大家。代码如下:
<%@page contentType="text/html; charset=gb2312" language="java"%>
<%@page pageEncoding="gb2312"%>
<%@page import="java.sql.*"%>
<html>
<jsp:useBean id="dbm" scope="session" class="web.dbm"/>
<jsp:setProperty name="dbm" property="*"/>
<jsp:useBean id="sqlm" scope="session" class="web.sqlm"/>
<jsp:setProperty name="sqlm" property="*"/>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<head>
<title>提交成功</title>
</head>
<body bgcolor="#ffffff">
<%!String gsmc;%>
<%!String lxr;%>
<%!String lxdh;%>
<%!String lxcz;%>
<%!String email;%>
<%!String lybt;%>
<%!String lynr;%>
<%
gsmc = new String(request.getParameter("gsmc").getBytes("ISO-8859-1"));
// String temp_p=request.getParameter("gsmc");
// byte[] temp_t=temp_p.getBytes("ISO-8859-1");
// String temp=new String(temp_t);
lxr = new String(request.getParameter("lxr").getBytes("ISO-8859-1"));
lxdh = new String(request.getParameter("lxdh").getBytes("ISO-8859-1"));
lxcz = new String(request.getParameter("lxcz").getBytes("ISO-8859-1"));
email = new String(request.getParameter("email").getBytes("ISO-8859-1"));
lybt = new String(request.getParameter("lybt").getBytes("ISO-8859-1"));
lynr = new String(request.getParameter("lynr").getBytes("ISO-8859-1"));
try {
dbm.getConnection();
out.print(gsmc);
out.print(lxr);
out.print(lxdh);
out.print(lxcz);
out.print(email);
out.print(lybt);
out.print(lynr);
sqlm.setSqlStr("insert into pic values('我')");
sqlm.executeUpdate();
sqlm.setSqlStr("insert into liuyan values('" + gsmc + "'" + ",'" + lxr + "','" + lxdh + "','" + lxcz + "','" + email + "','" + lybt + "'," + "'" + lynr + "'" + ")");
sqlm.executeUpdate();
out.println("<font size=3 color=blue>提交成功,稍后返回......</font><meta http-equiv='refresh' content='2;url=/car/lx.html'>");
}
catch (Exception e) {
out.print(e.toString());
}
%>
</body>
</html>
----------bean里的直连代码:
private String driverName = "com.mysql.jdbc.Driver";
private String url = "jdbc:mysql://127.0.0.1:3306/car??useUnicode=true&characterEncoding=gb2312";
private String user = "root";
private String password = "123";
<%@page contentType="text/html; charset=gb2312" language="java"%>
<%@page pageEncoding="gb2312"%>
<%@page import="java.sql.*"%>
<html>
<jsp:useBean id="dbm" scope="session" class="web.dbm"/>
<jsp:setProperty name="dbm" property="*"/>
<jsp:useBean id="sqlm" scope="session" class="web.sqlm"/>
<jsp:setProperty name="sqlm" property="*"/>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<head>
<title>提交成功</title>
</head>
<body bgcolor="#ffffff">
<%!String gsmc;%>
<%!String lxr;%>
<%!String lxdh;%>
<%!String lxcz;%>
<%!String email;%>
<%!String lybt;%>
<%!String lynr;%>
<%
gsmc = new String(request.getParameter("gsmc").getBytes("ISO-8859-1"));
// String temp_p=request.getParameter("gsmc");
// byte[] temp_t=temp_p.getBytes("ISO-8859-1");
// String temp=new String(temp_t);
lxr = new String(request.getParameter("lxr").getBytes("ISO-8859-1"));
lxdh = new String(request.getParameter("lxdh").getBytes("ISO-8859-1"));
lxcz = new String(request.getParameter("lxcz").getBytes("ISO-8859-1"));
email = new String(request.getParameter("email").getBytes("ISO-8859-1"));
lybt = new String(request.getParameter("lybt").getBytes("ISO-8859-1"));
lynr = new String(request.getParameter("lynr").getBytes("ISO-8859-1"));
try {
dbm.getConnection();
out.print(gsmc);
out.print(lxr);
out.print(lxdh);
out.print(lxcz);
out.print(email);
out.print(lybt);
out.print(lynr);
sqlm.setSqlStr("insert into pic values('我')");
sqlm.executeUpdate();
sqlm.setSqlStr("insert into liuyan values('" + gsmc + "'" + ",'" + lxr + "','" + lxdh + "','" + lxcz + "','" + email + "','" + lybt + "'," + "'" + lynr + "'" + ")");
sqlm.executeUpdate();
out.println("<font size=3 color=blue>提交成功,稍后返回......</font><meta http-equiv='refresh' content='2;url=/car/lx.html'>");
}
catch (Exception e) {
out.print(e.toString());
}
%>
</body>
</html>
----------bean里的直连代码:
private String driverName = "com.mysql.jdbc.Driver";
private String url = "jdbc:mysql://127.0.0.1:3306/car??useUnicode=true&characterEncoding=gb2312";
private String user = "root";
private String password = "123";
解决方案 »
- 用java如何控制弹出窗口在闲置若干秒后自动关闭?
- js正则表达式 1-200 怎么写
- 写 webservice,和调用问题
- 使用showmodeldialog显示一个模式对话框时,标题中总是有个"-- 网页对话框"字样,有什么方法可以去除掉?
- review页面返回后,没有刷新??急~~~
- webShpere4.0 + struts1.1 如何配置初学STRUTS请高手帮忙?
- 用ajax写一个同名校验,和三大框架一起用
- 读数据库时怎样显示一个"请稍后"的窗口??
- xmvigour、beyond_xiruo 2位板主,以解决的问题怎么有很多连接打不开呀?
- 请教:关于英文,简体中文,繁体中文在JSP/JAVA中的整体解决方案!!!
- 这个取网页中图片的正则表达式为什么会报错?
- forward页面转发
WindowsXP中文
Eclipse3.2.1+Myeclipse5.1.0GA
Tomcat5.5
JDK1.5.0
Hibernate3.1
Mysql5.0+ mysql-connector-java-5.0.4-bin.jar方案:
1.集成开发环境Eclipse中设置文本文件存储编码为UTF-8。
//我想是因为….如果所做工程项目最终要在别的版本操作系统的服务器上跑,这里需要设置(未经证实)
2.数据库mysql,默认编码使用utf8;
并且创建数据库时在语句后面追加DEFAULT CHARSET=utf8;set names utf8;
//如果数据库默认编码是utf8,那这个也不是必需的吧(未经证实)
3.跟数据库连接的URL:Hibernate URL:
jdbc:mysql://127.0.0.1:3306/addressbook?useUnicode=true&characterEncoding=utf8
//如果数据库默认编码是utf8,那这个也不是必需的吧(未经证实)
4.使用过滤器,过滤器文件代码见后面附1。
<filter>
<filter-name>Set Character Encoding</filter-name>
<filter-class>org.biti.filters.SetCharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>Set Character Encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
//过滤的是post还是get还没弄明白,据说只过滤器中一个,另一个见5。
5.修改Tomcat配置文件server.xml中Connector部分
<Connector port="80"
maxHttpHeaderSize="8192"
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" />
加入URIEncoding="UTF-8"一项。
//我现在这个没乱码的就没有设置….附1:SetCharacterEncodingFilter.java(可在Tomcat示例源码中找到)
package org.biti.filters;
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;public class SetCharacterEncodingFilter implements Filter {
protected String encoding = null;
protected FilterConfig filterConfig = null;
protected boolean ignore = true;
public void destroy() {
this.encoding = null;
this.filterConfig = null;
}
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException {
if (ignore || (request.getCharacterEncoding() == null)) {
String encoding = selectEncoding(request);
if (encoding != null)
request.setCharacterEncoding(encoding);
}
chain.doFilter(request, response);
}
public void init(FilterConfig filterConfig) throws ServletException {
this.filterConfig = filterConfig;
this.encoding = filterConfig.getInitParameter("encoding");
String value = filterConfig.getInitParameter("ignore");
if (value == null)
this.ignore = true;
else if (value.equalsIgnoreCase("true"))
this.ignore = true;
else if (value.equalsIgnoreCase("yes"))
this.ignore = true;
else
this.ignore = false;
}
protected String selectEncoding(ServletRequest request) {
return (this.encoding);
}
}
有问题多问google