JSP聊天室踢人

<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.util.*"%>
<%@page import="java.sql.*" %><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>用户升级</title>
</head>
<body>
<%
String kickname2=request.getParameter("kickname");
  byte[] b=kickname2.getBytes("ISO-8859-1");
  kickname2=new   String(b);
String kickname=request.getParameter("kickname");
//String kickname2=request.getParameter("kickname");
kickname = kickname.substring(0,kickname.indexOf("["));//字符串截取去掉[后面的字符
String Name=(String)session.getValue("username");
Name = Name.substring(0,Name.indexOf("["));
String sDBDriver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=text";//text表示数据库名称;
    Connection Con = null;
    Statement Stmt = null;
     try          /*加载驱动程序*/
    {
    Class.forName(sDBDriver).newInstance();
     }
    catch(java.lang.ClassNotFoundException e)
    {
   out.print("Connect to Database error: " + e.getMessage());
     }
   try          /*建立连接*/
    {
   Con = DriverManager.getConnection(sConnStr,"sa","");
     }
   catch(SQLException e)
   {
   out.print(e.toString());
    }
    Stmt = Con.createStatement();    /*创建JDBC声明*/
   ResultSet rs=null;
   String sqlstring = "select * from chatuser where USERNAME = '" + Name + "'";
   //out.println(sqlstring);
   rs = Stmt.executeQuery(sqlstring);  if(rs.next())
{
     int exp= Integer.parseInt(rs.getString("EXPERIENCE"));//varchar转换成int
     if (exp>1000)
  {
     exp=exp - 50;

   Stmt.executeUpdate("update chatuser set EXPERIENCE= "+exp+" where USERNAME = '"+ Name +"'");

//Stmt.executeUuery("sqlstring");

    Stmt.executeQuery(sqlstring);
synchronized (application) {
Vector UserName=null;
UserName= (Vector)application.getAttribute("UserName");
        //out.println(UserName);
UserName.remove(kickname2);// (kickname2);
//out.println(UserName);

}
     synchronized (application){
     Vector outMessage=null;
     outMessage= (Vector)application.getAttribute("Message");
if(outMessage==null)
outMessage= new Vector(30,10);
String outstr="系统公告：<font color=blue>"+kickname+"</font>被踢出了聊天室";
String str1="no";
String systemSpeak = "yes"; outMessage.addElement(str1);
outMessage.addElement(Name);
outMessage.addElement(str1);
outMessage.addElement(outstr);
outMessage.addElement(systemSpeak);
outMessage.addElement(str1);
application.setAttribute("Message", outMessage);
}

out.print("<script>alert(\"该用户已经被踢出!\");");
out.print("window.location=\"userlist.jsp\"</script>");
  }
    else
    {
      out.print("<script>alert(\"只有经验大于1000分的用户才能踢人!\");");
out.print("window.location=\"advanced.jsp\"</script>");
      }
  }
  else

  {
out.print("<script>alert(\"只有注册用户且经验大于1000才能踢人!\");");
out.print("window.location=\"advanced.jsp\"</script>");
} %>
</body>
</html>

调试易

JSP聊天室踢人

解决方案 »