基于jsp+servlet+ajax的web聊天室

package com.prj.servlet; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.sql.Timestamp; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class SendContentGroup extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String browerId = request.getParameter("browerId"); String userId = request.getParameter("userId"); String saycontent=""; if(Integer.parseInt(browerId)==1){ request.setCharacterEncoding("gbk"); saycontent = request.getParameter("say"); //response.setContentType("text/xml;charset=UTF-8"); saycontent = new String(saycontent.getBytes("iso-8859-1"),"utf-8"); }else if(Integer.parseInt(browerId)==2){ request.setCharacterEncoding("utf-8"); saycontent = request.getParameter("say"); //response.setContentType("text/xml;charset=UTF-8"); saycontent = new String(saycontent.getBytes("iso-8859-1"),"gbk"); } PrintWriter out = response.getWriter(); Connection conn=null; PreparedStatement pst = null; try{ Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/webtalk?useUnicode=true&characterEncoding=utf-8"; conn=DriverManager.getConnection(url,"root","root"); String sql = "INSERT INTO grouptalk(content,sendtime,userid) values(?,?,?)"; pst=conn.prepareStatement(sql); pst.setString(1,saycontent); java.util.Date date=new java.util.Date(); Timestamp tt=new Timestamp(date.getTime()); pst.setTimestamp(2,tt); pst.setInt(3,Integer.parseInt(userId)); pst.executeUpdate(); // // out.print(sendTime+"��"); // out.print(content); out.flush(); }catch(Exception e){ e.printStackTrace(); out.print("���쳣"); } } public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException ,IOException { doGet(request,response); } }