<%
    request.setCharacterEncoding("UTF-8");
    String username = request.getParameter("username");

    String driver="com.mysql.jdbc.Driver";
    Class.forName(driver);
    String url="jdbc:mysql://localhost:3306/myusers";//addres of database
    Connection c=DriverManager.getConnection(url,"root","12345");//connection to the database

    Statement s=c.createStatement();

    String query="select username from myusers where "+
        "username='"+ username + "'";

    ResultSet rs=s.executeQuery(query);

    if(rs.next())
    {
        response.sendRedirect("ReRegistration.html");
    }
    else
    {
        String password=request.getParameter("password");
        String password2=request.getParameter("password2");

        if(!password.equals(password2))
        {
            response.sendRedirect("ReRegistrationCausePass.html");
        }
        else
        {
            String name=request.getParameter("name");
            int passport=Integer.parseInt(request.getParameter("passport"));
            String address=request.getParameter("address");
            String city=request.getParameter("city");
            int phone=Integer.parseInt(request.getParameter("phone"));
            int mobile=Integer.parseInt(request.getParameter("mobile"));
            int postCode=Integer.parseInt(request.getParameter("postcode"));
            String email=request.getParameter("email");
            int Bday=Integer.parseInt(request.getParameter("day"));
            int Bmonth=Integer.parseInt(request.getParameter("month"));
            int Byear=Integer.parseInt(request.getParameter("year"));
            String gender=request.getParameter("gender");
            StringBuilder queryB = new StringBuilder("insert into myusers values('");
            queryB.append(name);      queryB.append("', '");
            queryB.append(username);  queryB.append("', '");
            queryB.append(password);  queryB.append("', '");
            queryB.append(passport);  queryB.append("', '");
            queryB.append(address);  queryB.append("', '");
            queryB.append(city);  queryB.append("', '");
            queryB.append(postCode);  queryB.append("', '");
            queryB.append(phone);  queryB.append("', '");
            queryB.append(mobile);  queryB.append("', '");
            queryB.append(email);  queryB.append("', '");
            queryB.append(Bday);  queryB.append("', '");
            queryB.append(Bmonth);  queryB.append("', '");
            queryB.append(Byear);  queryB.append("', '");
            queryB.append(gender);

            queryB.append("');");
            out.println(queryB.toString());
            int res=s.executeUpdate(queryB.toString());

            if (res>0)
            {
                session.setAttribute("user", "ok");


                response.sendRedirect("mainPage.html");
            }
            else
            {
                out.println(queryB.toString());
            }
        }
    }

%>