queryuser_manager.jsp

来自「用jsp实现在线留言!采用MVC三层架构!」· JSP 代码 · 共 33 行

JSP
33
字号
<%@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 + =
减小字号Ctrl + -
显示快捷键?