CheckPayRollHub.jsp
<%--Displays the data for the chosen employee--%> <html> <head> <title> CheckPayRollHub </title> </head> <body bgcolor = AAB6EC> <%@ page import= "java.sql.*" %> <%@ page import= "com.ConnectionPool2"%> <%@ page import= "com.PrintToFile"%> <%@ page import= "java.io.*" %> <%@ page import= "java.util.*" %> <% System.out.println("fgfgfdgfdrrrrrrr~~~t"); String NIC = request.getParameter("NIC"); Connection connect9 = ConnectionPool2.getConnection(); Statement statement; ResultSet resultSet; String query = "Select PerseWeekly.periodNum, Perse3.Surname, Perse3.MonthWeek, PerseWeekly.NIC, Perse3.PAYEcode, PerseWeekly.GrossPay, PerseWeekly.FinalPay, PerseWeekly.TaxDeducted FROM Perse3 INNER JOIN PerseWeekly ON Perse3.NIC like PerseWeekly.NIC WHERE Perse3.NIC LIKE '"+NIC+"' ORDER BY PerseWeekly.periodNum DESC"; statement = connect9.createStatement(); resultSet = statement.executeQuery( query ); %> <TABLE BORDER="1" WIDTH="100%"> <th><font size="2">Period Number </th> <th><font size="2">Surname Name </th> <th><font size="2">Month Week </th> <th><font size="2">NIC Number</th> <th><font size="2">PAYE code </th> <th><font size="2">Gross Pay </th> <th><font size="2">Final Pay</th> <th><font size="2">Tax Deducted</th> <% while(resultSet.next()) { %> <TR> <%System.out.println("dddddu yyyrtret"); %> <TD><%=resultSet.getDouble(1)%></TD> <TD><%=resultSet.getString(2)%></TD> <TD><%=resultSet.getString(3)%></TD> <TD><%=resultSet.getString(4)%></TD> <TD><%=resultSet.getString(5)%></TD> <TD><%=resultSet.getDouble(6)%></TD> <TD><%=resultSet.getDouble(7)%></TD> <TD><%=resultSet.getDouble(8)%></TD> </TR><% } %> </TABLE> <form action="MainMenu.jsp" method="post"> <input type="submit" value = "Return to Main Menu"> </form> </body> </html>