2

package project;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.SQLException;

public class Registration extends HttpServlet {

	  private static String host="localhost:3307";
	  private static String database="ia188";
	  private static String username="ia188";
	  private static String password="iw5fah3A";

	  public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
		  PrintWriter out = res.getWriter();
		  String Username = req.getParameter("Username");
		  String Password = req.getParameter("Password");
		  System.out.println("1");

		  try{
			  Class.forName("com.mysql.jdbc.Driver");
			  String conn_string="jdbc:mysql://"+host+"/"+database;
		      Connection connect = DriverManager.getConnection(conn_string,username,password);
		      String query = "insert into Member values(?,?)";
			  System.out.println("2");


		      PreparedStatement pstmt = connect.prepareStatement(query); //this will generate a sql query

		      String MD5Hash = MD5HashGenerator.getMD5Hash(Password);

		      pstmt.setString(1, Username);
		      pstmt.setString(2, MD5Hash);
		      pstmt.executeUpdate();
			  System.out.println("3");
		      pstmt.close();
		      connect.close();
		  }catch (ClassNotFoundException | SQLException e){

		      e.printStackTrace();
		  }
		  RequestDispatcher reqD = req.getRequestDispatcher("LoginPage.html");
		  reqD.forward(req, res);
	  }

}