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

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

public class RegisterServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

//	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
//	{
//
//
//	}
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
	{

		PrintWriter out=response.getWriter();

		String driver="com.mysql.cj.jdbc.Driver";

		try
		{
			Class.forName(driver);

		}
		catch(ClassNotFoundException e)
		{
			System.out.println(e);
			//e.printStackTrace();
		}
		String url="jdbc:mysql://localhost:3306/java";
		String uname="root";
		String pass="";

		String n=request.getParameter("user");
		String p=request.getParameter("pass");
		String em=request.getParameter("email");
		String d=request.getParameter("desig");
	    String query="insert into product values(?,?,?,?)";
		try
		{
			Connection con=DriverManager.getConnection(url,uname,pass);
			PreparedStatement ps=con.prepareStatement(query);
		//	ps.setString(1, null);
			ps.setString(1, n);
			ps.setString(4, p);

			ps.setString(2, em);
			ps.setString(3, d);
			int i=ps.executeUpdate();
			//int count=ps.executeUpdate();
		//	System.out.println(count + "rows affected");
			if(i>0)
			{
				out.println("Record inserted");
				response.sendRedirect("Login.html");


			}
			else
			{
				out.println("please try again");
			}
		//	ps.close();
			//con.close();

		}
		catch(Exception e)
		{
			System.out.println(e);
		}

	}
}