- if (!searchField.equals("") && !searchText.equals("")) {
- queryField="";
-
- if (searchField.equals("title"))
- queryField = "title";
- else if (searchField.equals("creator"))
- queryField = "creator";
- else if (searchField.equals("description"))
- queryField = "description";
- else
- queryField = "";
-
- if (!queryField.equals("")) {
- if (!whereClause.equals(""))
- whereClause = whereClause + " and ";
-
- whereClause = whereClause + "lower(" + queryField + ") like '%" + JDBCStringRoutines.escapeStringLiteral(searchText.toLowerCase()) + "%'";
- }
+ if (searchText.length()>0) {
+ queryBuilder.appendAndCondition(
+ "lower("+ searchField + ") like " +
+ "'%" + JDBCStringRoutines.escapeStringLiteral(searchText.toLowerCase()) + "%'");