public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection Conn=new db().getConn();
try {
Statement stmt = Conn.createStatement();
String sql="Select * from student";
ResultSet rs = stmt.executeQuery(sql);
List<Student> liststu = new ArrayList<Student>();
while(rs.next()){
Student student = new Student();
student.setName(rs.getString("name"));
student.setSid(rs.getString("sid"));
student.setSex(rs.getString("sex"));
student.setProvince(rs.getString("province"));
student.setQq(rs.getString("qq"));
student.setTel(rs.getString("tel"));
liststu.add(student);
}
request.setAttribute("list", liststu);
rs.close();
stmt.close();
Conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// response.setCharacterEncoding("UTF-8"); // 先指定输出流的编码
// response.setContentType("text/html;charset=UTF-8");
// PrintWriter out = response.getWriter();
request.getRequestDispatcher("index.jsp").forward(request, response);
throws ServletException, IOException {
Connection Conn=new db().getConn();
try {
Statement stmt = Conn.createStatement();
String sql="Select * from student";
ResultSet rs = stmt.executeQuery(sql);
List<Student> liststu = new ArrayList<Student>();
while(rs.next()){
Student student = new Student();
student.setName(rs.getString("name"));
student.setSid(rs.getString("sid"));
student.setSex(rs.getString("sex"));
student.setProvince(rs.getString("province"));
student.setQq(rs.getString("qq"));
student.setTel(rs.getString("tel"));
liststu.add(student);
}
request.setAttribute("list", liststu);
rs.close();
stmt.close();
Conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// response.setCharacterEncoding("UTF-8"); // 先指定输出流的编码
// response.setContentType("text/html;charset=UTF-8");
// PrintWriter out = response.getWriter();
request.getRequestDispatcher("index.jsp").forward(request, response);
}
doget方法中如果有PrintWriter out = response.getWriter();就需要在此之前设置编码方式
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
不能够在PrintWriter out = response.getWriter();后面设置编码方式,否则就会中文乱码,因为在out对象初始化之后再设置就编码方式就没有任何意义了
如果doget方法中没有PrintWriter out = response.getWriter();可以不设置编码方式,这样也不会出现中文乱码的问题。