⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 del.jsp

📁 【功能】 1:多用户统计系统
💻 JSP
字号:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*" errorPage="" %>
<jsp:useBean id="feng" scope="page" class="feng.jdbc" />
<%
/*
     季风流量统计系统1.0版(JSP)                   
                                                        
                                                         
     程序作者:季风                                     
                                                        
     QQ:9183838                                         
     E-Mail:feng0904@163.com                             
     网站:http://www.hxwa.net       
*/	
 if (session.getValue("UserName")==null)
  response.sendRedirect("login.jsp");
else
  if (session.getValue("admin")==null)
     response.sendRedirect("err.jsp?id=5");
  else{
    String admin=request.getParameter("id");

Connection con = feng.getConn();
Statement stmt=con.createStatement();
  String Sql="delete from InfoList where admin='"+admin+"'";
  stmt.executeUpdate(Sql) ;

		Sql="Delete * from FAddress where admin='"+admin+"'";
	    stmt.executeUpdate(Sql) ;
        Sql="Delete * from FArea where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from FIpone where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from FIptwo where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from FBrowser where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from FSystem where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from FScreen where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from FMozilla where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from FRefer where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from FWeburl where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from FVisit where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from StatDay where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from StatMonth where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from StatYear where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from StatWeek where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
		Sql="Delete * from Visitor where admin='"+admin+"'";
		stmt.executeUpdate(Sql) ;
 
   response.sendRedirect("admin.jsp");
		 try {
              stmt.close();
              con.close();
            }
            catch (Exception ex) {
            }

}

%>	

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -