import java.sql.*;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class Register extends HttpServlet {


    protected void doPost(HttpServletRequest req, HttpServletResponse res)
            throws ServletException, IOException {

            res.setContentType("text/html");
            PrintWriter out = res.getWriter();

             int n=Integer.parseInt(req.getParameter("id"));
             int p=Integer.parseInt(req.getParameter("age"));
             String e=req.getParameter("fname");
             String c=req.getParameter("lname");

             try{
                 Class.forName("com.mysql.jdbc.Driver");
                 Connection con=DriverManager.getConnection("jdbc:mysql://localhost/test","root","itm");
                 System.out.println("Ok");

                 PreparedStatement ps=con.prepareStatement("insert into Employees values(?,?,?,?)");
                 ps.setInt(1, n);
                 ps.setInt(2, p);
                 ps.setString(3, e);
                 ps.setString(4, c);
                 int i=ps.executeUpdate();
                 if(i>0)
                     out.print("You are succesfully registered...");
             }
                catch(Exception e2){
                System.out.println(e2);
                }
             out.close();
        }
    }