removeEmployee.jsp
<html> <head> <title> removeEmployee </title> </head> <body> <%@ page import= "javax.swing.*" %> <%@ page import= "java.sql.*" %> <%@ page import= "java.util.*" %> <%@ page import= "com.EmployeeObject4"%> <%@ page import= "com.*"%> <%@ page import= "java.io.*"%> <% String company = (String)session.getAttribute("company"); System.out.println("company "+ company); String query = "select FirstName, Surname, NIC from Perse3 where CompanyName like '"+company+"'AND Employed = 1"; Connection connection = ConnectionPool2.getConnection(); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery( query ); //forwards to the first record returns a boolean value positive if there is a record. boolean checkRecords = resultSet.next(); if(! checkRecords) { System.out.println("nothing here"); %> <jsp:forward page="NoDataError.jsp"/><% } %> <form action="removeEmployeeProccessing.jsp" method="post"> <TABLE BORDER="1" WIDTH="100%"> <% do { %> <TR> <td> <%=resultSet.getString(1)%> </td> <td> <%=resultSet.getString(2)%> </td> <% String NIC = resultSet.getString(3); %> <td> <%=NIC%> </td> <td><input type="checkbox" name="tic" value=<%=NIC%> ></td> </TR> <% }while(resultSet.next()); %> </TABLE> <input type="submit"> </form> </body> </html>