oracle.jbo.server.rules
Class JboSQLListValidator

java.lang.Object
  |
  +--oracle.jbo.server.rules.JboBaseValidator
        |
        +--oracle.jbo.server.rules.JboListValidator
              |
              +--oracle.jbo.server.rules.JboSQLListValidator

public class JboSQLListValidator

extends JboListValidator

A validator that tests for the presence of a literal value in a list of database values. The list of values is obtained by invoking the validator's SQL query, and then taking the values from the first column of the result.

Since:

Jdeveloper 3.0

Fields inherited from class oracle.jbo.server.rules.JboBaseValidator

mLValue

Constructor Summary

JboSQLListValidator()
Creates an uninitialized list validator.

JboSQLListValidator(boolean bInverse, java.lang.Object owner, java.lang.String str)
Creates a list validator.

Method Summary

java.util.Vector	getList() Gets this validator's list of values.
java.lang.String	getSQL() Gets this validator's SQL statement.
void	setSQL(java.lang.String str) Sets this validator's SQL statement.
java.lang.String	toString() Internal: For debugging purposes only.

Methods inherited from class oracle.jbo.server.rules.JboListValidator

convertToVector, setList, validateValue

Methods inherited from class oracle.jbo.server.rules.JboBaseValidator

getDescription, getInverse, setDescription, setInverse, setNewValue, setValidatingAttribute, setValidatingAttribute, vetoableChange

Methods inherited from class java.lang.Object

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

Constructor Detail

JboSQLListValidator

public JboSQLListValidator()

Creates an uninitialized list validator.

Invoke setSQL() to provide a list of comparison values.

JboSQLListValidator

public JboSQLListValidator(boolean bInverse,
                           java.lang.Object owner,
                           java.lang.String str)

Creates a list validator.

Parameters:

inverse - if true the logic of this validator's test is inverted.

str - an SQL statement.

Method Detail

setSQL

public void setSQL(java.lang.String str)

Sets this validator's SQL statement.

Parameters:

str - an SQL statement.

getSQL

public java.lang.String getSQL()

Gets this validator's SQL statement.

Returns:

an SQL statement.

getList

public java.util.Vector getList()

Gets this validator's list of values.

This method executes the validator's SQL statement and extracts and the first column of the result.

Overrides:

getList in class JboListValidator

Returns:

a vector containing the values from the first column of the result.

toString

public java.lang.String toString()

Internal: For debugging purposes only.

Overrides:

toString in class JboListValidator