<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> <%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %> <%@ page import="java.io.*"%> <%@ page import="java.sql.*"%> <%@ page import="java.text.*"%> <%@ page import="com.oreilly.servlet.*"%> <%@ page import="com.oreilly.servlet.multipart.*"%> <% ResultSet Rs =null; String SearchString =""; if(request.getParameter("SearchString") !=null && !request.getParameter("SearchString").equals("")){ SearchString = request.getParameter("SearchString"); } String id =""; if (request.getParameter("id") != null && !request.getParameter("id").equals("")) { id = request.getParameter("id"); } String SQL=""; String action =""; if(request.getParameter("action") !=null && !request.getParameter("action").equals("")){ action = request.getParameter("action"); } Integer pageNum = 1; Integer maxPage = 1; if (request.getParameter("pg") != null && !request.getParameter("pg").equals("")) { pageNum = Integer.valueOf(request.getParameter("pg")); } if(action.equals("delete")){ SQL="Delete from companies where company_serial="+id+""; sessionBean.executeDBQuery(SQL); } String limitStr = "LIMIT 10 OFFSET " + String.valueOf((pageNum * 10) - 10); SQL="Select co.company_serial, co.company_name, co.employer_code, co.company_website, co.company_address, co.company_ceo, co.date_added From companies co "+limitStr+""; Rs =sessionBean.getDataResultSet(SQL); if(action.equals("search")){ limitStr = "LIMIT 10 OFFSET " + String.valueOf((pageNum * 10) - 10); SQL="Select co.company_serial, co.company_name, co.employer_code, co.company_website, co.company_address, co.company_ceo, co.date_added" +" From companies co" +" Where (co.company_name ILike '%"+ SearchString +"%') Or" +" (co.employer_code ILike '%"+ SearchString +"%') Or" +" (co.company_website ILike '%"+ SearchString +"%') Or" +" (co.company_address ILike '%"+ SearchString +"%') Or" +" (co.company_ceo ILike '%"+ SearchString +"%') "+limitStr+""; Rs =sessionBean.getDataResultSet(SQL); } %> <% Boolean colorRow = false; while(Rs.next()){ if(colorRow){ out.print(""); colorRow = false; }else{ out.print(""); colorRow = true; } %> <%}%>

Period Name

Starting Date

Ending Date

Is Closed

Date Added

Added By

Operations

', 'leaveDiv');"><%=Rs.getString("employer_code")%>

', 'leaveDiv');"><%=Rs.getString("company_name")%>

<%=Rs.getString("company_address")%>

<%=Rs.getString("company_website")%>

', 'leaveDiv');">