savedata.jsp

用JSP实现的聊天室功能.满好的 初学者可以参考参考

<%@page contentType = "text/html;charset=GB2312"
        import = "java.sql.*"
%>
<%
 String name = new String(request.getParameter("name").getBytes("ISO-8859-1"));
 if(name.equals(""))     //判断是否输入昵称
  response.sendRedirect("enter.jsp?error=1");
 else                   //打开数据库
 {
  String sex = request.getParameter("sex");
  String change = request.getParameter("change");
  String color = request.getParameter("color");
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con = DriverManager.getConnection("jdbc:odbc:chat");
  Statement smt =  con.createStatement();
  String sql;
  sql="select * from online where  昵称='"+name+"'";
  ResultSet rs = smt.executeQuery(sql);
  if(!rs.next())         //检查是否已有相同昵称的上线者
  {
   session.putValue("name",name);
   session.putValue("sex",sex);
   session.putValue("change",change);
   session.putValue("color",color);
  sql="insert into online(昵称,性别) values ('"+name+"','"+sex+"')";
   smt.execute(sql);
   con.close();
   response.sendRedirect("chatroom.jsp"); 
  }
  else
   response.sendRedirect("enter.jsp?error=2");
  con.close();
 }
%>