del.jsp

来自「【首语】 非常感谢你能够对季风流量统计系统感兴趣。不管你是JAVA的初学者、」· JSP 代码 · 共 72 行

<%@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:[e-mail]                             
     网站: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) {
            }

}

%>