1111

<%@page import="java.sql.*;"  %>
<html>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
    <head>
        <title>Регистрация</title>
        <link rel="stylesheet" href="Regcss.css" />
        <link rel="stylesheet" href="style.css" />

    </head>


    <body bgcolor="gray">
        <table width="100%" height="488" border="0">
  <tr>

    <th width="80%" scope="col">

        <form method="post" action="signup.jsp">
            <table width="40%" align="center" border="1">


                        <h2 align="center">Регистрация</h2>

         <tr><td width="10%"> Логин:</td><td> <input type="text" name="username">  </td></tr>

         <tr><td width="10%"> Имя:</td><td> <input type="text" name="fname">  </td></tr>

         <tr><td width="10%"> Фамилия:</td><td> <input type="text" name="lname">  </td></tr>

         <tr><td>Пол:</td><td><input type="radio" name="gender" value="male" checked>Мужской
         <input type="radio" name="gender" value="Female">Женский</td></tr>

         <tr><td width="10%">Пароль:</td><td>  <input type="password" name="password"></td></tr>

         <tr> <td width="10%">Подтверждение пароля:</td><td> <input type="password" name="p2"></td></tr>

         <tr> <td width="10%">Email: </td><td> <input type="text" name="email"></td></tr>

         <tr> <td width="10%">Адрес:</td><br/> <td> <textarea cols="50" rows="8" name="address"></textarea></td></tr>
              <tr><td>Город:</td><td><select name="city">

                                     <option >Минск</option>
                                       <option >Гродно</option>
                                         <option >Гомель</option>
                                         <option >Брест</option>
                     </select></td></tr>

         <tr> <td width="10%">Телефон: </td><td> <input type="text" name="mobile"></td></tr>

             <tr><td>Секретный вопрос:</td><td><select name="squestion">

                                     <option >Имя животного?</option>
                                       <option >Какой университет закончили?</option>
                                         <option >Имя друга?</option>
                                         <option >Родной город?</option>
                     </select></td></tr>
             <tr><td>Ответ:</td><td><input type='text' name="sanswer"></td></tr>
             <input type="text" value="user" name="designation" hidden />
            <tr><td></td><td width="10%"><input type="submit" value="Зарегистрироваться"></td></tr>

            </table>

            </form>


  <%


   Connection con;


    try{
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3307/dit","root","1111");


              String username =request.getParameter("username");
              String fname= request.getParameter("fname");
              String lname= request.getParameter("lname");
              String password = request.getParameter("password");
              double mobile = Double.parseDouble(request.getParameter("mobile"));
              String address = request.getParameter("address");
              String squestion= request.getParameter("squestion");
              String sanswer = request.getParameter("sanswer");
              String gender = request.getParameter("gender");
              String designation = "user";
              String email = request.getParameter("email");
              String city = request.getParameter("city");

                PreparedStatement ps= con.prepareStatement("insert into fosusers(username,password,firstname,lastname,email,mobile,address,securityq,answer,gender,designation,city) values(?,?,?,?,?,?,?,?,?,?,?,?)");
                ps.setString(1,username);
            ps.setString(2,password);
            ps.setString(3,fname);
           ps.setString(4,lname);
            ps.setString(5, email);
            ps.setDouble(6,mobile);
            ps.setString(7,address);
            ps.setString(8,squestion);
           ps.setString(9,sanswer);
            ps.setString(10, gender);
            ps.setString(11,designation);
           ps.setString(12, city);

            int r=ps.executeUpdate();

            RequestDispatcher rd = request.getRequestDispatcher("thankyou.jsp");

          rd.forward(request, response);
        }
          catch(Exception e)
        {
            System.out.println(e);
        }


      %>
      <style>
      .backb{
position: fixed;
top: 20px;
left: 4px;
width: 46px;
height: 46px;

}
      </style>
      <script> function goBack() {
    window.history.back()
}
   </script>
    <div><img src="icons/back.png" class="backb" onclick="goBack()" id="backb"/></div>
     <style>
      .backb{
position: fixed;
top: 20px;
left: 4px;
width: 46px;
height: 46px;

}
      </style>
      <script> function goBack() {
    window.history.back();
}
   </script>
    <div><img src="icons/back.png" class="backb" onclick="goBack()" id="backb"/></div>
</body>
</html>