📄 queryuser_manager.jsp
字号:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="err.jsp"%>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<%!String Stop_Id,Delete_Id,Is_User,User_Name,sql;%>
<%
Connection con=yy.getConn();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
Stop_Id=request.getParameter("stopid");
Delete_Id=request.getParameter("deleteid");
Is_User=request.getParameter("isuser");
User_Name=request.getParameter("username");
User_Name=yy.ex_chinese(User_Name);
if (Delete_Id!=null)
{
sql="delete from 用户表 where 用户id="+Delete_Id;
stmt.executeUpdate(sql);
sql="delete from 贴子 where 贴子作者='"+User_Name+"'";
stmt.executeUpdate(sql);
out.println("<html> <meta http-equiv='refresh' content='1;url=user_manager.jsp'> </html>");
return;
}
if ((Stop_Id!=null)&&(Is_User!=null))
{
if (Is_User.equals("0"))
sql="update 用户表 set 认证身份='0' where 用户id="+Stop_Id;
else
sql="update 用户表 set 认证身份='1' where 用户id="+Stop_Id;
stmt.executeUpdate(sql);
out.println("<html> <meta http-equiv='refresh' content='1;url=user_manager.jsp'> </html>");
}
%>
<jsp:include page="inc/online.jsp" flush="true"/>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -