Filtering a Query Result Set

You can filter the results of a query by certain parameters or conditions. You can also allow users of the application to customize the data filter. In the sample application created in this guide, the procedure of filtering the query result consists of the following tasks:

  1. Determining what filtered set is required

    Users can specify the set of employee records that they want to view by entering a filter criterion in a query field, in this case, a part of the name that they want to search for. The employees.jsp page accepts this input through form controls, and processes it.

  2. Creating a method to return a query ResultSet

    The user input string is used to create the SQL query statement. This statement selects all employees whose names include the sequence of characters that the user enters. The query searches for this string in both the first and the last names.

  3. Displaying the results of the query

    This is done by adding code to the employees.jsp page to use the method that runs the filtered query.

This section describes filtering query data in the following sections: