Testing the Query Filter Method

You can use the JavaClient.java class created in Testing the Connection and the Query Methods to test the getEmployeesByName method. You must add the getEmployeesByName method to display the query results as described in the following steps:

  1. Open the JavaClient.java class in the Java Source Editor.
  2. After the result set displaying the results from the getAllEmployees query, define a result set for the conditional query as follows: 
    rset = datahandler.getEmployeesByName("King");
 
System.out.println("\nResults from query: ");
 
while (rset.next()) {
  System.out.println(rset.getInt(1) + " " + 
  rset.getString(2) + " " + 
  rset.getString(3) + " " + 
  rset.getString(4));
}
  3. To test your application at this stage, you can temporarily adjust the values of the jdbcUrl, userid and password variables in the DataHandler class to provide the values required for the HR schema. Save the file, and compile it to check for syntax errors.

    Note:

    Make sure you change the values of userid, password, and jdbcUrl back to null after testing. For more information, refer to Declaring Connection-Related Variables.

  4. To test-run the code, right-click in the Java Source Editor and select Run from the shortcut menu. In the Log window, you will first see the results of the getAllEmployees method, then the results from the getEmployeesByName("xxx") query. Here, xxx is set to "King" to test the filtering functionality. In actual operation, this parameter will be set to the value provided by the user of the application to filter the search.