package JSPMultipleForms;

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

public class LoginAuthentication2 extends HttpServlet{

  private ServletConfig config;

  public void init(ServletConfig config)
    throws ServletException{
     this.config=config;
     }
  public void doPost(HttpServletRequest request, HttpServletResponse response)
              throws ServletException,IOException{

    PrintWriter out = response.getWriter();

    String connectionURL = "jdbc:mysql://mysql.cmi-hro.nl:3306/cmi0814147";
    Connection connection=null;
    ResultSet rs;
    String userName=new String("");
    String passwrd=new String("");
    response.setContentType("text/html");
    try {
       // Load the database driver
      Class.forName("com.mysql.jdbc.Driver");
      // Get a Connection to the database
      connection = DriverManager.getConnection(connectionURL, "cmi0814147", "..........");
      //Add the data into the database
      String sql = "select user,password from cmi0814147.user";
      Statement s = connection.createStatement();
      s.executeQuery (sql);
      rs = s.getResultSet();
      while (rs.next ()){
        userName=rs.getString("user");
        passwrd=rs.getString("password");
      }
      rs.close ();
      s.close ();
      }catch(Exception e){
      System.out.println("Exception is ;"+e);
      }
      if(userName.equals(request.getParameter("user"))
             && passwrd.equals(request.getParameter("pass"))){

      String nextJSP = "beheer.jsp";
      response.sendRedirect(nextJSP);

      }
      else{
      String nextHTML = "index.html";
      response.sendRedirect(nextHTML);

      }
  }
}