checkPayRoll.jsp

<%--Client enters the employee whos data they wish to check--%>
<html>
<head>
<title>
checkPayRoll
</title>
</head>
<body bgcolor = AAB6EC>
<%@ page import= "java.util.*" %>
<%@ page import= "com.EmployeeObject4"%>
<%@ page import= "java.sql.*"%>
<%@ page import= "com.PrintToFile"%>
<%@ page import= "java.io.*"%>
<%@ page import= "com.ConnectionPool2"%>
<h2>Check Past Payroll Data</h2>
<%--If the user enter this page with out first logging
on  they are sent to the login page --%>
<%@ include file="checkCompany.jsp" %>
<%
String permission = (String)session.getAttribute("Permission");
if(permission.equals("1"))
    {
    %><jsp:forward page="PermissionNotGiven.jsp"/><%
    }
Connection connect9 = ConnectionPool2.getConnection();
System.out.println("checkPayRoll top3" + company);
String query = "select FirstName, NIC from Perse3 WHERE CompanyName like '"+company+"'";
Statement statement = connect9.createStatement();
System.out.println("checkPayRoll top4");
ResultSet resultSet;
ArrayList arrayList = new ArrayList();
try{
    System.out.println("checkPayRoll top4.5");
    resultSet = statement.executeQuery( query );
    System.out.println("checkPayRoll top4.6");
    System.out.println("checkPayRoll top4.8");
//First the data is removed from the result set and placed into an employee object.
    %>
    <form action="CheckPayRollHub.jsp" method="post">
    <TABLE BORDER="1" WIDTH="60%">
    <%
    while( resultSet.next())
        {
        String A = resultSet.getString(1);
        String B = resultSet.getString(2);
        %>
        <TR>
        <TD><input type="radio" name = "id" value = <%= B%>></TD>
        <TD><%= A%><input type="hidden" name = "name" value = <%= A%>> </TD>
        <TD><%= B %> <input type="hidden" name = "NIC" value = <%= B%>></TD>
        </TR>
        <%}%>
    </TABLE>
    <input type="submit">
    </form><%
    }
catch(Exception e)
    {
    System.out.println("Company blank");
    }
%>
</body>