package Register;


import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class RegisterServlet extends HttpServlet {

    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();

        String login = request.getParameter("login");
        String password = request.getParameter("password");
        String query = "insert into user values ("+login+","+password+")";
        try{

        //loading drivers for mysql
        Class.forName("com.mysql.jdbc.Driver");

    //creating connection with the database
          Connection  con=DriverManager.getConnection
                     ("jdbc:mysql://localhost:3306/shout","root","admin");

        //Statement stmt = null;
        //stmt = con.createStatement();
        //ResultSet rs = stmt.executeQuery(query);
        PreparedStatement ps=con.prepareStatement
                  (query);

        ps.setString(1, login);
        ps.setString(2, password);
        int i=ps.executeUpdate();

          if(i>0)
          {
            out.println("You are sucessfully registered");
          }
        }
        catch(ClassNotFoundException | SQLException se)
        {
        }

      }
  }