ModSQL
Class Operator_Like

java.lang.Object
  |
  +--ModSQL.AbstractFunction
        |
        +--ModSQL.Operator
              |
              +--ModSQL.Operator_Like

All Implemented Interfaces:

Function

final class Operator_Like

extends Operator

SQL operator LIKE.

Author:

chris.studholme@utoronto.ca

Fields inherited from class ModSQL.AbstractFunction

all_constant, constant_non_null, evaluate_order, evaluate_order_array, out_of_order, parameter_constant, parameter_value, parameters, parameters_array

Fields inherited from interface ModSQL.Function

MATCH_BEGINS, MATCH_EQU, MATCH_GT, MATCH_GTE, MATCH_LT, MATCH_LTE, MATCH_NE

Constructor Summary

(package private)

Operator_Like()

Method Summary

Object	evaluate(boolean aggregate) Evaluate parameters and compare.
Object	evaluate(int match_op, Object match_value) Evaluate parameters and compare.
String	functionName() Returns "#LIKE".
int	getMaxResultSize() Returns -1 as this operator will never return a String object.
int	getSQLType() Returns Types.BIT.
void	optimize() Prepare the function for use.
static boolean	patternCompare(String str, String pattern) Recursive LIKE pattern matching.

Methods inherited from class ModSQL.Operator

addAllParameters, addAllParametersNegate, addAllParametersNot, removeDoubleNegation, removeDoubleNot

Methods inherited from class ModSQL.AbstractFunction

addParameter, convertToSQLType, evaluateConstantParameters, evaluateOrder, evaluateParameters, evaluateParameters, getCompatableType, getObjectSQLType, getParameter, getParameterCount, isAggregate, isConstant, postfixParameters, prefixParameters, registerWith, reset, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

Operator_Like

Operator_Like()

Method Detail

optimize

public void optimize()
              throws SQLException

Prepare the function for use.

Overrides:

optimize in class AbstractFunction

Throws:

SQLException - if the parameters are invalid

functionName

public String functionName()

Returns "#LIKE".

Overrides:

functionName in class AbstractFunction

Returns:

name of function

getSQLType

public int getSQLType()

Returns Types.BIT.

Returns:

SQL type of data to be returned

getMaxResultSize

public int getMaxResultSize()

Returns -1 as this operator will never return a String object.

Returns:

maximum size of String returned or -1 if unknown

evaluate

public Object evaluate(boolean aggregate)
                throws SQLException,
                       EndOfTable

Evaluate parameters and compare.

Parameters:

aggregate - passed to parameters

Returns:

result object

Throws:

SQLException - if a database-access error occurs

EndOfTable - if thrown by a parameter

evaluate

public Object evaluate(int match_op,
                       Object match_value)
                throws SQLException,
                       EndOfTable

Evaluate parameters and compare.

Overrides:

evaluate in class AbstractFunction

Parameters:

match_op - how the value should be matched

match_value - desired value

Returns:

result object

Throws:

SQLException - if a database-access error occurs

EndOfTable - if thrown by a parameter

patternCompare

public static boolean patternCompare(String str,
                                     String pattern)

Recursive LIKE pattern matching. % is multi-character string, _ is single character.

Parameters:

str - string to test

pattern - pattern to match

Returns:

true for match, false otherwise