📄 kick.jsp
字号:
<html>
<head>
<title>用户升级</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="OPDB" scope="page" class="database.OPDB" />
<%
String userName = request.getParameter("userName");
String userlevel = OPDB.AsciiToChineseString("巫师");
String password = request.getParameter("password");
String Name = OPDB.AsciiToChineseString((String) (session.getValue("Name")));
OPDB.connection();
Connection conn =OPDB.getConn();
String sql = "select userid from t_bbs_user where username = '" + Name + "' and userlevel = '" + userlevel + "' and password = '" + password + "'";
ResultSet rs =OPDB.select(conn,sql);
//out.print(sql);
if (!(rs.next())) {
out.print("<script>alert(\"你还不是巫师,不能踢人!\");");
out.print("window.location=\"advanced.jsp\"</script>");
}
else {
rs.close();
synchronized (application) {
Vector UserName=null;
UserName= (Vector)application.getAttribute("UserName");
UserName.remove(userName);
}
synchronized (application) {
Vector outMessage=null;
outMessage= (Vector)application.getAttribute("Message");
if(outMessage==null)
outMessage= new Vector(30,10);
String outstr="系统公告：<font color=blue>"+userName+"</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);
}
String sql2 = "";
int i = Name.indexOf(OPDB.AsciiToChineseString("[会员]"));
if (i != -1) {
Name = Name.substring(0,i);
sql2 = "update t_bbs_user set experience = experience - 50 where username = '" + Name + "' and usertype = 'Y'";
}
else {
sql2 = "update t_bbs_user set experience = experience - 50 where username = '" + Name + "' and usertype = 'N'";
}
OPDB.update(conn,sql2);
OPDB.Close();
out.print("<script>alert(\"该用户已经被踢出!\");");
out.print("window.location=\"advanced.jsp\"</script>");
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -