JSP中文有关问题
日期：2014-05-18 浏览次数：20686 次
JSP中文问题
怎么添加到数据库都是乱码
怎么解细
<%!
String name,price,spec,ku_count,remark;
ResultSet rs=null;
%>
<body>
<%
//wu_name=request.getParameter( "wu_name ").trim();
name=request.getParameter( "name ");
out.println(name);
price=request.getParameter( "price ");
out.println(price);
spec=request.getParameter( "spec ");
out.println(spec);
ku_count=request.getParameter( "ku_count ");
out.println(ku_count);
remark=request.getParameter( "remark ");
out.println(remark);
p_dbBean.executeUpdate( "insert into depot values( ' "+name+ " ', ' "+price+ " ', ' "+spec+ " ', ' "+ku_count+ " ', ' "+remark+ " ',getdate()) ");
------解决方案--------------------
（1）先看看取过来的参数是不是乱码
（2）数据库的字段属性是否设置有问题
（3）使用的是哪中数据库~~好象MYSQL有这个问题
以上谨供参考~
------解决方案--------------------
1.编码问题:
(1)首先确定JSP页面头部是否有: <%@ page contentType= "text/html; charset=GBK " %>
(2)类似这样的转码:
String param= new String(request.getParameter( "param ").getBytes( "ISO-8859-1 "), "GBK ");
(3)添加filter字符过滤器,具体做法:
先添加类:
import javax.servlet.Filter;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.FilterChain;
import java.io.IOException;
import org.apache.log4j.Logger;
import java.net.URLEncoder;
/** *//**
* 请求中中文字符串过滤类
*/
public class SetEncodingFilter
implements Filter ...{
private Logger logger=Logger.getLogger(this.getClass());
public void init(FilterConfig filterConfig) throws ServletException ...{
}
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException ...{
logger.info( "请求转码过滤器=================== ");
request.setCharacterEncoding( "gb2312 ");
chain.doFilter(request,response);
}
public void destroy() ...{
}
}
再注册类到XML里：
<filter>
<filter-name> Set Encoding </filter-name>
<filter-class> SetEncodingFilter </filter-class>
</filter>
<filter-mapping>
<filter-name> Set Encoding </filter-name>
<url-pattern> /* </url-pattern>
</filter-mapping>
(4)如果是通过 "a.jsp?param=中文 "传递参数,则需要:
a.在传参数之前先把参数进行转码:java.net.URLEncoder.encode(param);
取值用java.net.URLDncoder.dncode(param);再转回中文
b.在你的Tomcat目录--> conf目录--> server.xml里找出这段:
<Connector
port= "8080 " maxThreads= "150 " minSpareThreads= "25 " maxSpareThreads= "75
怎么添加到数据库都是乱码
怎么解细
<%!
String name,price,spec,ku_count,remark;
ResultSet rs=null;
%>
<body>
<%
//wu_name=request.getParameter( "wu_name ").trim();
name=request.getParameter( "name ");
out.println(name);
price=request.getParameter( "price ");
out.println(price);
spec=request.getParameter( "spec ");
out.println(spec);
ku_count=request.getParameter( "ku_count ");
out.println(ku_count);
remark=request.getParameter( "remark ");
out.println(remark);
p_dbBean.executeUpdate( "insert into depot values( ' "+name+ " ', ' "+price+ " ', ' "+spec+ " ', ' "+ku_count+ " ', ' "+remark+ " ',getdate()) ");
------解决方案--------------------
（1）先看看取过来的参数是不是乱码
（2）数据库的字段属性是否设置有问题
（3）使用的是哪中数据库~~好象MYSQL有这个问题
以上谨供参考~
------解决方案--------------------
1.编码问题:
(1)首先确定JSP页面头部是否有: <%@ page contentType= "text/html; charset=GBK " %>
(2)类似这样的转码:
String param= new String(request.getParameter( "param ").getBytes( "ISO-8859-1 "), "GBK ");
(3)添加filter字符过滤器,具体做法:
先添加类:
import javax.servlet.Filter;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.FilterChain;
import java.io.IOException;
import org.apache.log4j.Logger;
import java.net.URLEncoder;
/** *//**
* 请求中中文字符串过滤类
*/
public class SetEncodingFilter
implements Filter ...{
private Logger logger=Logger.getLogger(this.getClass());
public void init(FilterConfig filterConfig) throws ServletException ...{
}
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException ...{
logger.info( "请求转码过滤器=================== ");
request.setCharacterEncoding( "gb2312 ");
chain.doFilter(request,response);
}
public void destroy() ...{
}
}
再注册类到XML里：
<filter>
<filter-name> Set Encoding </filter-name>
<filter-class> SetEncodingFilter </filter-class>
</filter>
<filter-mapping>
<filter-name> Set Encoding </filter-name>
<url-pattern> /* </url-pattern>
</filter-mapping>
(4)如果是通过 "a.jsp?param=中文 "传递参数,则需要:
a.在传参数之前先把参数进行转码:java.net.URLEncoder.encode(param);
取值用java.net.URLDncoder.dncode(param);再转回中文
b.在你的Tomcat目录--> conf目录--> server.xml里找出这段:
<Connector
port= "8080 " maxThreads= "150 " minSpareThreads= "25 " maxSpareThreads= "75
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
