import java.io.*;
import javax.servlet.*;
import java.sql.*;
import javax.servlet.http.*;

public class LoginServlet extends HttpServlet
{
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
   {
       String id,Password;
	   response.setContentType("text/html");
	   PrintWriter out = response.getWriter();
       out.println("<h2>Hello Page</h2>");
	   id = request.getParameter("uname");
	   Password = request.getParameter("psw");

       out.println(id);
       out.println(Password);
	   try
	   {
		  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
					Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521","aakash","theaakash");
		   String qr = "select * from students where studid = ? and psw = ?";

		   PreparedStatement pst = con.prepareStatement(qr);
		   pst.setString(1,id);
		   pst.setString(2,Password);
		   ResultSet res = pst.executeQuery();
		   boolean more = res.next();
		   out.println(more);
		   if(more)
		   {
			   out.println("<h2>Welcome"+id+"</h2>");
			   qr = "select * from students where studid = ?";
			   pst = con.prepareStatement(qr);
			   pst.setString(1,id);
			   ResultSet rs = pst.executeQuery();
			   rs.next();
			   out.println("ITP:" +rs.getInt(3));
			   out.println("AP:" +rs.getInt(4));
			   out.println("Ecomm:" +rs.getInt(5));
			   out.println("ISVV:" +rs.getInt(6));
			   out.println("DCN:" +rs.getInt(7));
		   }

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