<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="error.jsp" %> 
<jsp:useBean id="db" class="data.DBConnectionBean"/>
   <%
      request.setCharacterEncoding("gb2312");
      String id=(String)session.getAttribute("id");
      String password =(String)session.getAttribute("password");
      String name = (String)session.getAttribute("name");
      String question  = (String)session.getAttribute("question");
	  String answer  = (String)session.getAttribute("answer");
	  String zctime  = (String)session.getAttribute("zctime");
	  String year  = (String)session.getAttribute("year");
	  String month  = (String)session.getAttribute("month");
	  String day  = (String)session.getAttribute("day");
	  String ssex  = (String)session.getAttribute("ssex");
	  String myword  = (String)session.getAttribute("myword");
	  String pic = "01.jpg";
	  String money= "100";
      try{
      if(id.length()==0||password.length()==0||name.length()==0){
      %>
            <script language="JavaScript">
             alert("項(xiàng)目不能為空!");
           </script>
            <meta   HTTP-EQUIV=REFRESH   CONTENT="0;URL=/xunibuluo/regedit.jsp">
           <%
      }else{
     
      if (db.checkplayer(id))
      {
           %>
            <script language="JavaScript">
             alert("帳戶已存在!");
           </script>
            <meta   HTTP-EQUIV=REFRESH   CONTENT="0;URL=/xunibuluo/regedit.jsp">
           <%
      }else 
         {
         if(db.checkname(name)){
          %>
            <script language="JavaScript">
             alert("呢稱已存在!");
           </script>
            <meta   HTTP-EQUIV=REFRESH   CONTENT="0;URL=/xunibuluo/regedit.jsp">
           <%
         }else if(answer.length()==0 && question==null){%>
         <script language="JavaScript">
             alert("答案不能為空!");
           </script>
            <meta   HTTP-EQUIV=REFRESH   CONTENT="0;URL=/xunibuluo/regedit.jsp">
         <%} 
         else{
            db.insert(id,password,name,ssex,question,answer,pic,year,month,day,myword,money,zctime);
             %>
            <script language="JavaScript">
             alert("恭喜你:注冊(cè)成功!");
           </script>
            <meta   HTTP-EQUIV=REFRESH   CONTENT="2;URL=/xunibuluo/successs.jsp">
           <%
            }
           %>
           <%
          }}
      }catch(SQLException e){System.out.println(e.getMessage());}
     %>