payRollEntry.jsp
<%--Called from the Main menu. Displays a list of all the employees in the company so they can be selected for payroll --%> <html> <head> <title>payroll</title> </head> <body bgcolor = AAB6EC> <%@ page import= "java.sql.*" %> <%@ page import= "java.util.*" %> <%@ page import= "java.io.*" %> <%@ page import= "com.*" %> <%@ page import= "com.ConnectionPool2" %> <% Connection connection = ConnectionPool2.getConnection(); String company = (String)session.getAttribute("company"); String query = "select FirstName,Surname, NIC, MonthWeek from perse3 where CompanyName like '"+company+"'AND employed = 1"; Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery( query ); %> <h2>Tick the employees who are to be payrolled</h2> <form action="payRollHub.jsp" method="post"> <TABLE BORDER="1" WIDTH="80%"> <td width = "20%"><font size="3" ></td> <td width = "20%" bgcolor = "90ee90"><font size="3" >First Name </td> <td width = "20%"><font size="3" >Surname </td> <td width = "20%" bgcolor = "90ee90"><font size="3"> NIC number </td> <td width = "20%"><font size="3" >Monthly<br> or <br>weekly</td> <% while( resultSet.next()) { //Because data can only be removed from a resultSet one time only and the NIC varible //is used twice it placed in a String Varible. %> <TR > <TD ><%= resultSet.getString(1)%> </TD> <TD ><%= resultSet.getString(2)%> </TD> <%String NIC = resultSet.getString(3);%> <TD><%= NIC %> </TD> <TD><%= resultSet.getString(4) %></TD> <TD ><input type="checkbox" name ="tick" value = <%= NIC%> ></TD> </TR> <% } %> </TABLE> Enter The Period <input type="text" name = "periodFor" value ="0"> <input type=submit name = "option" value=" Enter "> </form> </body> </html>