<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="../conn/conn.jsp"%>
<%@ include file="../conn/time.jsp"%>
<%
String username=request.getParameter("username");
String pass=request.getParameter("pass");
String question=request.getParameter("question");
String answer=request.getParameter("answer");
String bumen=request.getParameter("bumen");
String email=request.getParameter("email");
String sex=request.getParameter("sex");
%>
<%
stmt = con.createStatement() ;
rs=stmt.executeQuery("SELECT * from member where username='"+username+"'");
if(!rs.next()){
%>



<%
String sql="insert into member(username,password,question,answer,email,bumen,regtime,lastlogintime,sex) values('"+username+"','"+pass+"','"+question+"','"+answer+"','"+email+"','"+bumen+"','"+time+"','"+time+"','"+sex+"')";
stmt.executeUpdate(sql);
%>
<script language=JavaScript>{window.alert('注冊成功!請等待審核!');window.location.href='../index.jsp'}</script>

<%}else{%><script language=JavaScript>{window.alert('對不起！請帳號已被注冊,請重新選擇!');window.history.go(-1);}</script><%
}%>