modify2.jsp

【功能】 1：多用户统计系统

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
/*
     季风流量统计系统1.0版(JSP)                   
                                                        
                                                         
     程序作者：季风                                     
                                                        
     QQ:9183838                                         
     E-Mail:[e-mail]                             
     网站:http://www.hxwa.net       
*/	
String id=request.getParameter("id");
  if (session.getValue("UserName")==null){
    response.sendRedirect("login.jsp");  
}
else {
	
    if (session.getValue("admin")==null){
       if (session.getValue("UserName").equals(id))
       {
      
       }else
        response.sendRedirect("err.jsp?id=6");
	   }
    }
	%>
<jsp:useBean id="feng" scope="page" class="feng.jdbc" />
<%
String Rereg1=request.getParameter("B1");

Connection con = feng.getConn();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//String id=request.getParameter("id") ;
String url=request.getParameter("url");
String txtemail=request.getParameter("txtemail");
String  sql="";
  // String  sql="select admin from InfoList where url='"+url+"'";
//   ResultSet rs = stmt.executeQuery(sql) ;
 //  rs.last();
//   if (rs.getRow()>0)  {
//      out.println("<script language=jscript>alert('该网址已登记');history.back();</script>");
//   }
//   else {
   stmt=con.createStatement();//ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
   String  webname=request.getParameter("webname");
   String  pws=request.getParameter("pws");
   String  intro=request.getParameter("intro");
   String  keys=request.getParameter("keys");
   String  clas=request.getParameter("class");
    id=feng.ex_chinese(id);
	url=feng.ex_chinese(url);
	txtemail=feng.ex_chinese(txtemail);
	webname=feng.ex_chinese(webname);
	pws=feng.ex_chinese(pws);
	intro=feng.ex_chinese(intro);
    keys=feng.ex_chinese(keys);
    clas=feng.ex_chinese(clas);    
	sql="update  InfoList set email='"+txtemail+"',password='"+pws+"',name='"+webname+"',url='"+url+"',typename='"
	+clas+"',note2='"+intro+"',keys='"+keys+"' where admin='"+id+"'";  

    stmt.executeUpdate(sql) ;
    
	sql="update admin set password='"+pws+"' where username='"+id+"'";
    stmt.executeUpdate(sql) ;
    String admin=id;
	if (Rereg1==null){
        String Sql="delete from InfoList where admin='"+admin+"'";
        stmt.executeUpdate(Sql) ;
	    Sql="insert into InfoList(admin,email,password,name,url,typename,note2,keys)   values('"+id+"','"+txtemail+"','"+pws+"','"+webname+"','"+url+"','"+clas+"','"+intro+"','"+keys+"')";
        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) ;
	    }
    //  }
          
            try {
           //   rs.close();
              stmt.close();
              con.close();
            }
            catch (Exception ex) {
            }
 out.println("<font size=2 color=blue>谢谢您的使用，正在处理您的用户信息，请稍后...</font><meta http-equiv='refresh' content=2;url='Modify.jsp?id="+id+"'>");
   //  response.sendRedirect("Modify.jsp?id="+id);   
%>