servlet存入mysql乱码_servlet 连接MySQL数据库乱码问题

importjavax.servlet.*;importjavax.servlet.http.*;importjava.io.*;importjava.sql.*;publicclassShowRsextendsHttpServlet{protectedvoiddoGet(HttpServletRequestrequest,HttpSer...

import javax.servlet.*;

import javax.servlet.http.*;

import java.io.*;

import java.sql.*;

public class ShowRs extends HttpServlet {

protected void doGet(HttpServletRequest request,

HttpServletResponse response) throws ServletException, IOException {

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

response.setContentType("text/html");

response.setCharacterEncoding("GBK");

PrintWriter out = response.getWriter();

out.println("

out.println("

Content:");

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://localhost/bbs?user=root&password=root");

stmt = conn.createStatement();

rs = stmt.executeQuery("select * from article");

while(rs.next()){

out.println("

");

out.println("

" + rs.getString("cont") + "");

out.println("

");

}

out.println("

");

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

} finally {

try {

if(rs != null) {

rs.close();

rs = null;

}

if(stmt != null) {

stmt.close();

stmt= null;

}

if(conn != null) {

conn.close();

conn = null;

}

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

1、Tomcat 配置信息 conf/server,xml

< Connector port="8080" protocol="HTTP/1.1"

connectionTimeout="20000"

redirectPort="8443" URIEncoding="GBK" />

2、MySQL 连接正常 ，内容见图片

3、输出结果：见图片

4、试用版本:apache-tomcat-6.0.24 ; mysql-5.0.89-win32 ; jdk1.6.0_10

展开