org.apache.torque.sql.whereclausebuilder
Class LikeBuilder

java.lang.Object
  org.apache.torque.sql.whereclausebuilder.AbstractWhereClausePsPartBuilder
      org.apache.torque.sql.whereclausebuilder.LikeBuilder

All Implemented Interfaces:

WhereClausePsPartBuilder

public class LikeBuilder
extends AbstractWhereClausePsPartBuilder

Builds a PreparedStatementPart from a WhereClauseExpression containing a Like operator.

Version:

$Id: LikeBuilder.java 1377555 2012-08-27 02:52:28Z tfischer $

Constructor Summary

LikeBuilder()

Method Summary

PreparedStatementPart	buildPs(WhereClauseExpression whereClausePart, boolean ignoreCase, Adapter adapter) Builds the PS part for a WhereClauseExpression with a LIKE operator.
boolean	isApplicable(WhereClauseExpression whereClauseExpression, Adapter adapter) Returns whether this WhereClausePsPartBuilder is applicable for a given WhereClauseExpression.

Methods inherited from class org.apache.torque.sql.whereclausebuilder.AbstractWhereClausePsPartBuilder

getObjectOrColumnPsPartBuilder, setObjectOrColumnPsPartBuilder

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

LikeBuilder

public LikeBuilder()

Method Detail

buildPs

public PreparedStatementPart buildPs(WhereClauseExpression whereClausePart,
                                     boolean ignoreCase,
                                     Adapter adapter)
                              throws TorqueException

Builds the PS part for a WhereClauseExpression with a LIKE operator. Multicharacter wildcards % and * may be used as well as single character wildcards, _ and ?. These characters can be escaped with \. e.g. criteria = "fre%" -> columnName LIKE 'fre%' -> UPPER(columnName) LIKE UPPER('fre%') criteria = "50\%" -> columnName = '50%'

Parameters:

whereClausePart - the part of the where clause to build. Can be modified in this method.

ignoreCase - If true and columns represent Strings, the appropriate function defined for the database will be used to ignore differences in case.

adapter - The adapter for the database for which the SQL should be created, not null.

Returns:

the rendered SQL for the WhereClauseExpression

Throws:

TorqueException - when rendering fails.

isApplicable

public boolean isApplicable(WhereClauseExpression whereClauseExpression,
                            Adapter adapter)

Returns whether this WhereClausePsPartBuilder is applicable for a given WhereClauseExpression.

Parameters:

whereClauseExpression - the WhereClauseExpression in question.

adapter - The adapter for the database for which the SQL should be created, not null.

Returns:

true if applicable, false otherwise.