actreg.jsp

现今的社会是一个信息飞速发达的社会

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="reg" scope="page" class="numb1.com.db"/>
<jsp:useBean id="ht" scope="page" class="numb1.com.Dohtml"/>
<%
String test="";
request.setCharacterEncoding("gb2312");
String id=request.getParameter("id");if(id==null){test="wrong";}
String mm=request.getParameter("mm1");if(mm==null){test="wrong";}
String mail=request.getParameter("mail");if(mail==null){test="wrong";}

String question=request.getParameter("question");if(mail==null){test="wrong";}
String answer=request.getParameter("answer");if(mail==null){test="wrong";}
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String em=request.getParameter("em");
String qq=reg.gb2iso(request.getParameter("qq"));
String web=reg.gb2iso(request.getParameter("web"));
String tel=reg.gb2iso(request.getParameter("tel"));
String job=reg.gb2iso(request.getParameter("job"));
String love=reg.gb2iso(request.getParameter("love"));
String aboutme=reg.gb2iso(request.getParameter("aboutme"));
String refuse=request.getParameter("refuse"); if(refuse==null){refuse="n";}

String y=request.getParameter("year");
String m=request.getParameter("month");
String d=request.getParameter("day");
String date=reg.gb2iso(y+"-"+m+"-"+d);
String p=request.getParameter("fu_province");
String c=request.getParameter("fu_city");
String cfr=reg.gb2iso(p+"-"+c);

String ip=request.getRemoteAddr();
String sql;

sql="select*from numb1 where userid='"+id+"'";
ResultSet rs=reg.query(sql);rs.next();
if(rs.getRow()!=0){
out.print("<meta http-equiv=\"refresh\" content=\"3;URL=../reg.jsp?test=y\"><center><font color-#ff0000>对不起，您的ID已经有人使用。如果您还没有<a href=\"../reg.jsp?test=y\">注册</a>你可以<a href=\"../reg.jsp?test=y\">重新注册</a>，如果您已经注册，您可以<a href=\"../login.jsp\">登录</a>论坛。</font></center>");
}else{
if("wrong".equals(test)){
response.sendRedirect("reg.jsp");
}else{

sql="insert into numb1 values('"+id+"','"+mm+"','"+mail+"',now())";
reg.update(sql);
reg.close();

sql="insert into user values('"+id+"',1,'','"+question+"','"+answer+"','','"+reg.gb2iso(name)+"','"+sex+"','"+date+"','"+em+"','"+qq+"','"+web+"','"+tel+"','"+cfr+"','"+job+"','"+love+"','"+aboutme+"','"+refuse+"')";
reg.update(sql);
reg.close();

sql="insert into online values('"+id+"',1,0,0,0,0,0,0,'"+ip+"',now(),'','')";
reg.update(sql);
reg.close();

session.setAttribute("id",id);
session.setAttribute("root","1");
session.setAttribute("name",name);
out.print("<meta http-equiv=\"refresh\" content=\"3;URL=../first.jsp\"><center><h3>注册成功，感谢您成为南部湾论坛成员！3秒后自动跳转......</h3><br><br><a href=\"../index.jsp\">点击连接直接进入论坛</a></center>");
}
}
%>