我写了一个学生管理系统,为什么在查询数据库的时候,汉字总是以乱码的形式出现???
程序是application,不是asp,请大虾们看清楚.
我的数据库是mysql,可能是驱动的问题,高手能不能帮忙解决一下,我把数据库里面的东西查询出来,放到表里面,可是汉字是乱码,字符倒是可以用.
我把数据库里面的字符集改成gbk,utf8,gb2321,然后程序里面也改成相应的字符集,也不行,高手帮忙,谢谢!!!!!!!!!!!!!
程序是application,不是asp,请大虾们看清楚.
我的数据库是mysql,可能是驱动的问题,高手能不能帮忙解决一下,我把数据库里面的东西查询出来,放到表里面,可是汉字是乱码,字符倒是可以用.
我把数据库里面的字符集改成gbk,utf8,gb2321,然后程序里面也改成相应的字符集,也不行,高手帮忙,谢谢!!!!!!!!!!!!!
url="jdbc:mysql://localhost:3306/ssh?useUnicode=true&characterEncoding=UTF-8"
在取得数据库内容的页面加上
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
试一试
下面继续............
jdbc:mysql://localhost:3306/yhcmusic?useUnicode=true&characterEncoding=UTF-83 application 的话，直接显示就可以了。4 换最新的MySQL驱动 到www.mysql.com 去找，或者使用这个地址 http://www.java2000.net/download.jsp
* Copyright (C) JavaWing Organization. All rights reserved. *
* ------------------------------------------------------------------------- *
* The software in this package is reserved by JavaWing Organization. *
* FrameServer is a MVC framework which implements multiform terminal *
* support , includes WEB,J2ME,BREW,WAP,SMS and etc. *
* FrameServer is based on Ioc container and Aop framework. *
* ------------------------------------------------------------------------- *
* @version 3.0 *
*****************************************************************************/package myfilter;import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.FilterChain;/**
* <p><strong>SetCharacterEncodingFilter</strong>,
* Filter that sets the character encoding to be used in parsing the
* incoming request, either unconditionally or only if the client did not
* specify a character encoding. Configuration of this filter is based on
* the following initialization parameters:</p>
* <ul>
* <li><strong>encoding</strong> - The character encoding to be configured
* for this request, either conditionally or unconditionally based on
* the <code>ignore</code> initialization parameter. This parameter
* is required, so there is no default.</li>
* <li><strong>ignore</strong> - If set to "true", any character encoding
* specified by the client is ignored, and the value returned by the
* <code>selectEncoding()</code> method is set. If set to "false,
* <code>selectEncoding()</code> is called <strong>only</strong> if the
* client has not already specified an encoding. By default, this
* parameter is set to "true".</li>
* </ul>
*
* <p>Although this filter can be used unchanged, it is also easy to
* subclass it and make the <code>selectEncoding()</code> method more
* intelligent about what encoding to choose, based on characteristics of
* the incoming request (such as the values of the <code>Accept-Language</code>
* and <code>User-Agent</code> headers, or a value stashed in the current
* user's session.</p>
*
* @see javax.servlet.Fileter
*
* @author Yellowicq
* @version $Id: SetCharacterEncodingFilter.java,v 2.0 2004/08/18 14.34.08 yellowicq Exp $
* @package org.javawing.mvcframe.filter
* @since 2.0
*/
public class SetCharacterEncodingFilter
implements Filter { // ----------------------------------------------------- Instance Variables
/**
* The default character encoding to set for requests that pass through
* this filter.
*/
protected String encoding = null; /**
* The filter configuration object we are associated with. If this value
* is null, this filter instance is not currently configured.
*/
protected FilterConfig filterConfig = null; /**
* Should a character encoding specified by the client be ignored?
*/
protected boolean ignore = true; // --------------------------------------------------------- Public Methods
/**
* Take this filter out of service.
*/
public void destroy() {
this.encoding = null;
this.filterConfig = null;
} /**
* Select and set (if specified) the character encoding to be used to
* interpret request parameters for this request.
*
* @param request The servlet request we are processing
* @param response The servlet response we are creating
* @param chain The filter chain we are processing
* @throws IOException if an input/output error occurs
* @throws ServletException if a servlet error occurs
*/
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException { /** Conditionally select and set the character encoding to be used */
if (ignore || (request.getCharacterEncoding() == null)) {
String encoding = selectEncoding(request);
if (encoding != null) {
request.setCharacterEncoding(encoding);
}
} /** Pass control on to the next filter */
chain.doFilter(request, response);
} /**
* Place this filter into service.
*
* @param filterConfig The filter configuration object
* @throws ServletException
*/
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 Methods
/**
* Select an appropriate character encoding to be used, based on the
* characteristics of the current request and/or filter initialization
* parameters. If no character encoding should be set, return
* <code>null</code>.
*
* <p> The default implementation unconditionally returns the value configured
* by the <strong>encoding</strong> initialization parameter for this filter.
*
* @param request The servlet request we are processing
* @return String
*/
protected String selectEncoding(ServletRequest request) {
return this.encoding;
}}
public class Resell {
public static String resell(String put){
String get="";
try {
get=new String(put.getBytes("ISO-8859-1"),"GBK");
} catch (Exception e) {
e.printStackTrace();
}
return get;
}
}