reg2.jsp

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

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="feng" scope="page" class="feng.jdbc" />
<%
/*
     季风流量统计系统1.0版(JSP)                   
                                                        
                                                         
     程序作者：季风                                     
                                                        
     QQ:9183838                                         
     E-Mail:[e-mail]                             
     网站:http://www.hxwa.net       
*/	
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="select admin from InfoList where admin='"+id+"' or url='"+url+"'";
   ResultSet rs = stmt.executeQuery(sql) ;
   rs.last();
   if (rs.getRow()>0)  {
      out.println("<script language=jscript>alert('该用户名已存在或该网址已登记');history.back();</script>");
   }
   else {

   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="insert into InfoList(admin,email,password,name,url,typename,note2,keys) values('"+id+"','"+txtemail+"','"+pws+"','"+webname+"','"+url+"','"+clas+"','"+intro+"','"+keys+"')";//"','"+feng.gettime()+
  
    stmt.executeUpdate(sql) ;

	sql="insert into admin(username,password) values('"+id+"','"+pws+"')";
    stmt.executeUpdate(sql) ;
   // out.println("<font size=2 color=blue>谢谢您的注册，正在处理您的用户信息，请稍后...</font><meta http-equiv='refresh' content='2;url=reg3.jsp'>");
   %>
<form action=reg3.jsp method=post name=reg>
<input type=hidden name=id value="<%=id%>">
<input type=hidden name=oldid value="<%=id%>">
<input type=hidden name=keys value="<%=keys%>">
<input type=hidden name=cla value="<%=clas%>">
<input type=hidden name=oldintro value="<%=intro%>">
<input type=hidden name=webname value="<%=webname%>">
<input type=hidden name=url value="<%=url%>">
<input type=hidden name=mail value="<%=txtemail%>">
</form>
<script language=jscript>document.reg.submit()</script>
<%
  }
             
          
            try {
              rs.close();
              stmt.close();
              con.close();
            }
            catch (Exception ex) {
            }
          
%>