查看mysql表编码方式:
show create table 表名;
更改mysql安装目录下的my.ini中 default-character-set的值 改为gbk
jsp页面获取数据库值,写过滤器解决。
web.xml文件
<filter>
<filter-name>EncodingFilter</filter-name>
<filter-class>com.ctcc.www.filter.EncodingFilter</filter-class>
<init-param>
<param-name>encode</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>EncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
过滤器类文件EncodingFilter.java
public class EncodingFilter implements Filter
{
private String encode = null;
public void destroy()
{
}
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException
{
if(request.getCharacterEncoding() == null){
if(encode != null){
request.setCharacterEncoding(encode);
response.setCharacterEncoding(encode);
}
}
chain.doFilter(request, response);
}
public void init(FilterConfig config) throws ServletException
{
encode = config.getInitParameter("encode");
}