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

public class qno1 extends HttpServlet {
	public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
		respond(request, response);
	}
	public void doGet (HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
		respond(request, response);
	}
	
	public void respond (HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
		PrintWriter out = response.getWriter();
		Connection conn=null;
		response.setStatus (HttpServletResponse.SC_OK);
		response.setContentType ("text/html");
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch (Exception se) {
			out.println ("Catch 1");
			System.out.println(se);
		}
		out.println ("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">");
		out.println ("<html><head><title>Response Page</title></head><body>");
		int BasicPay=0;
		ResultSet rset;
		String cat;
		try {
			conn = DriverManager.getConnection("jdbc:odbc:emp");
			out.println ("<p>Connection Created</p>");
		catch (Exception se) {
			out.println ("<p>Conn not created</p>");
			out.println (se);
			return;
		}
		try {
			Statement stmt = conn.createStatement();
			out.println ("<p>Statement Created</p>");
}
		catch (Exception se) {
			out.println ("<p>stmt not created</p>");
			out.println (se);
			return;
		}
		try {
			String query = "select EmpCat, BasicPay from Employee where EmpID="+request.getParameter("empid");
			rset = stmt.executeQuery (query);
			out.println ("<p>Query executed</p>");
		catch (Exception se) {
			out.println ("<p>Query not executed</p>");
			out.println (se);
			return;
		}
		try {
			rset.next();
			cat = rset.getString(1);
			out.println ("<p>cat got </p>");
			BasicPay = Integer.parseInt(rset.getString (2));
			out.println ("<p>pay got</p>");
			out.println ("Employee Category: "+cat+"<br/>");
			query = "select * from booga where Category="+cat;
			rset = stmt.executeQuery (query);
			out.println ("<p>Query 2 executed</p>");
		}
		catch (Exception se) {
			out.println ("Catch 2");
			out.println (se);
			return;
		}
		int salary = BasicPay;
		try {
			rset.next();
			salary += Integer.parseInt(rset.getString(1))*BasicPay/100;
			salary += Integer.parseInt(rset.getString(2))*BasicPay/100;
			salary += Integer.parseInt(rset.getString(3))*BasicPay/100;
			if (cat.equals("1") || cat.equals("2"))
				salary += Integer.parseInt(rset.getString(4));
			else
				salary += Integer.parseInt(rset.getString(4))*BasicPay/100;
			salary += Integer.parseInt(rset.getString(5));
		}
		catch (Exception se) {
			out.println ("Catch 3");
			out.println (se);
		}
		out.println ("<strong>Total Salary: &nbsp;&nbsp;&nbsp;&nbsp;"+salary+"</strong>");
	}	
}