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

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


@WebServlet("/Login")
public class Login extends HttpServlet {
	private static final long serialVersionUID = 1L;
    public Login() {
    }

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//System.out.println("ser");
		String id=request.getParameter("id");
		String pin=request.getParameter("pin");

		int id1=Integer.parseInt(id);
		int pin1=Integer.parseInt(pin);

		PrintWriter pw=response.getWriter();
		//pw.println("WelCome in website");

		try{
			Class.forName("com.mysql.jdbc.Driver");
			Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3366/dac20","root","");
			Statement stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery("select * from user where id="+(5000-id1)+" and pin="+(6000-pin1));
			while(rs.next())  {
				if(rs.getInt("id")==(5000-id1) && (6000-pin1)==rs.getInt("pin")){
					pw.println("WelCome in website");
					pw.println("<br>");
					pw.println("<h5>your id="+id1+"</h5>");
				}
				else{
					pw.println("Id or pin wrong");
				}


			}

			con.close();
		}
		catch (Exception e) {
			e.printStackTrace();
		}
	}

}