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

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.jasper.tagplugins.jstl.core.Out;

/**
 * Servlet implementation class register
 */
@WebServlet("/register")
public class register extends HttpServlet {
	private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public register() {
        super();
        // TODO Auto-generated constructor stub
    }




	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

		String fname = request.getParameter("fname");
		String lname = request.getParameter("lname");
		String email = request.getParameter("email");
		String pass = request.getParameter("pass");

		try{
			Class.forName("com.mysql.jdbc.Driver");

			 //creating connection with the database
		        Connection con=DriverManager.getConnection
		                       ("jdbc:mysql://localhost:3306/register","root","");
		        PreparedStatement ps =con.prepareStatement
                        ("insert into registration values (?,?,?,?)");
		        ps.setString(1, fname);
		        ps.setString(2, lname);
		        ps.setString(3, email);
		        ps.setString(4, pass);

		        ResultSet rs = ps.executeQuery();
		        System.out.print("register");
		        ps.close();
		        con.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}


	}

}