|
Oracle Application Server TopLink API Reference 10g Release 2 (10.1.2) B15903-01 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
oracle.toplink.expressions.Expression
Purpose: Define an object-level representation of a database query where clause.
Description: An expression is a tree-like structure that defines the selection criteria for a query against objects in the database. The expression has the advantage over SQL by being at the object-level, i.e. the object model attributes and relationships can be used to be query on instead of the database field names. Because it is an object, not a string the expression has the advantage that is can be easily manipulated through code to easily build complex selection criterias.
Responsibilities:
Constructor Summary | |
Expression() Base Expression Constructor. |
Method Summary | |
Expression |
addDate(java.lang.String datePart, int numberToAdd) PUBLIC: Function, return an expression that adds to a date based on the specified datePart. |
Expression |
addDate(java.lang.String datePart, java.lang.Object numberToAdd) PUBLIC: Function, return an expression that adds to a date based on the specified datePart. |
Expression |
addMonths(int months) PUBLIC: Function, to add months to a date. |
Expression |
addMonths(java.lang.Object months) PUBLIC: Function, to add months to a date. |
Expression |
and(Expression theExpression) PUBLIC: Return an expression that is the boolean logical combination of both expressions. |
Expression |
anyOf(java.lang.String attributeName) PUBLIC: Return an expression representing traversal of a 1:many or many:many relationship. |
Expression |
anyOfAllowingNone(java.lang.String attributeName) ADVANCED: Return an expression representing traversal of a 1:many or many:many relationship. |
Expression |
appendSQL(java.lang.String sqlString) Deprecated. since OracleAS TopLink 10g (9.0.4). See prefixSQL(java.lang.String) , postfixSQL(java.lang.String) . |
Expression |
ascending() PUBLIC: This can only be used within an ordering expression. |
Expression |
asciiValue() PUBLIC: Function, returns the single character strings ascii value. |
Expression |
average() PUBLIC: Function, This represents the aggregate function Average. |
Expression |
between(byte leftValue, byte rightValue) PUBLIC: Function, between two bytes |
Expression |
between(char leftChar, char rightChar) PUBLIC: Function, between two chars |
Expression |
between(double leftValue, double rightValue) PUBLIC: Function, between two doubles |
Expression |
between(Expression leftExpression, Expression rightExpression) |
Expression |
between(float leftValue, float rightValue) PUBLIC: Function, between two floats |
Expression |
between(int leftValue, int rightValue) PUBLIC: Function, between two ints |
Expression |
between(long leftValue, long rightValue) PUBLIC: Function, between two longs |
Expression |
between(java.lang.Object leftValue, java.lang.Object rightValue) PUBLIC: Return an expression that compares if the receivers value is between two other values. |
Expression |
between(short leftValue, short rightValue) PUBLIC: Function, between two shorts |
Expression |
caseStatement(java.util.Hashtable caseItems, java.lang.String defaultItem) PUBLIC: Function Convert values returned by the query to values given in the caseItems hashtable. |
Expression |
concat(java.lang.Object left) PUBLIC: Function, returns the concatenation of the two string values. |
Expression |
containsAllKeyWords(java.lang.String spaceSeperatedKeyWords) PUBLIC: Return an expression that performs a key word search. |
Expression |
containsAnyKeyWords(java.lang.String spaceSeperatedKeyWords) PUBLIC: Return an expression that performs a key word search. |
Expression |
containsSubstring(Expression expression) PUBLIC: Return an expression that compares if the receivers value contains the substring. |
Expression |
containsSubstring(java.lang.String theValue) PUBLIC: Return an expression that compares if the receivers value contains the substring. |
Expression |
containsSubstringIgnoringCase(Expression expression) PUBLIC: Return an expression that compares if the receivers value contains the substring, ignoring case. |
Expression |
containsSubstringIgnoringCase(java.lang.String theValue) PUBLIC: Return an expression that compares if the receivers value contains the substring, ignoring case. |
Expression |
count() PUBLIC: This represents the aggregate function Average. |
Expression |
currentDate() PUBLIC: This gives access to the current date on the database through expression. |
Expression |
dateDifference(java.lang.String datePart, java.util.Date date) PUBLIC: Function, Return the difference between the queried part of a date(i.e. years, days etc.) |
Expression |
dateDifference(java.lang.String datePart, Expression comparisonExpression) PUBLIC: Function, Return the difference between the queried part of a date(i.e. years, days etc.) |
Expression |
dateName(java.lang.String datePart) PUBLIC: return a string that represents the given part of a date. |
Expression |
datePart(java.lang.String datePart) PUBLIC: Function return an integer which represents the requested part of the date. |
Expression |
dateToString() PUBLIC: Function, returns the date converted to the string value in the default database format. |
Expression |
decode(java.util.Hashtable decodeableItems, java.lang.String defaultItem) PUBLIC: Function Convert values returned by the query to values given in the decodeableItems hashtable. |
Expression |
descending() PUBLIC: This can only be used within an ordering expression. |
Expression |
difference(java.lang.String expression) PUBLIC: Function return a value which indicates how much difference there is between two expressions. |
Expression |
distinct() PUBLIC: Function, This represents the distinct option inside an aggregate function. |
Expression |
equal(boolean theBoolean) |
Expression |
equal(byte theValue) |
Expression |
equal(char theChar) |
Expression |
equal(double theValue) |
Expression |
equal(Expression theValue) Returns an expression that compares if the receiver's value is equal to the other value. |
Expression |
equal(float theValue) |
Expression |
equal(int theValue) |
Expression |
equal(long theValue) |
Expression |
equal(java.lang.Object theValue) PUBLIC: Return an expression that compares if the receiver's value is equal to the other value. |
Expression |
equal(short theValue) |
Expression |
equalsIgnoreCase(Expression theValue) PUBLIC: Return an expression that compares if the receiver's value is equal to the other value, ignoring case. |
Expression |
equalsIgnoreCase(java.lang.String theValue) PUBLIC: Return an expression that compares if the receiver's value is equal to the other value, ignoring case. |
Expression |
exists(ReportQuery subQuery) PUBLIC: Return a sub query expression. |
Expression |
get(java.lang.String attributeName) PUBLIC: Return an expression that wraps the attribute or query key name. |
Expression |
getAllowingNull(java.lang.String attributeName) ADVANCED: Return an expression that wraps the attribute or query key name. |
Expression |
getField(oracle.toplink.internal.helper.DatabaseField field) ADVANCED: Return an expression representing a field in a data-level query. |
Expression |
getField(java.lang.String fieldName) ADVANCED: Return an expression representing a field in a data-level query. |
Expression |
getFunction(int selector) ADVANCED: This can be used for accessing user defined functions. |
Expression |
getFunction(int selector, java.util.Vector arguments) ADVANCED: This can be used for accessing user defined functions that have arguments. |
Expression |
getFunction(java.lang.String functionName) ADVANCED: Return a user defined function accepting the argument. |
Expression |
getFunction(java.lang.String functionName, java.lang.Object argument) ADVANCED: Return a user defined function accepting the argument. |
Expression |
getFunctionWithArguments(java.lang.String functionName, java.util.Vector arguments) ADVANCED: Return a user defined function accepting all of the arguments. |
Expression |
getParameter(oracle.toplink.internal.helper.DatabaseField field) ADVANCED: Return an expression representing a parameter with the given name. |
Expression |
getParameter(java.lang.String parameterName) ADVANCED: Return an expression representing a parameter with the given name. |
Expression |
getTable(oracle.toplink.internal.helper.DatabaseTable table) ADVANCED: Return an expression representing a table in a data-level query. |
Expression |
getTable(java.lang.String tableName) ADVANCED: Return an expression representing a table in a data-level query. |
Expression |
greaterThan(boolean theBoolean) PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
Expression |
greaterThan(byte theValue) PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
Expression |
greaterThan(char theChar) PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
Expression |
greaterThan(double theValue) PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
Expression |
greaterThan(Expression theValue) |
Expression |
greaterThan(float theValue) PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
Expression |
greaterThan(int theValue) PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
Expression |
greaterThan(long theValue) PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
Expression |
greaterThan(java.lang.Object theValue) PUBLIC: Return an expression that compares if the receiver's value is greater than the other value. |
Expression |
greaterThan(short theValue) PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
Expression |
greaterThanEqual(boolean theBoolean) PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
Expression |
greaterThanEqual(byte theValue) PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
Expression |
greaterThanEqual(char theChar) PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
Expression |
greaterThanEqual(double theValue) PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
Expression |
greaterThanEqual(Expression theValue) PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
Expression |
greaterThanEqual(float theValue) PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
Expression |
greaterThanEqual(int theValue) PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
Expression |
greaterThanEqual(long theValue) PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
Expression |
greaterThanEqual(java.lang.Object theValue) PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
Expression |
greaterThanEqual(short theValue) PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
Expression |
hexToRaw() PUBLIC: Function, returns binary array value for the hex string. |
Expression |
ifNull(java.lang.Object nullValue) PUBLIC: Function return the a specific value if item returned from the query is null. |
Expression |
in(boolean[] theBooleans) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
in(byte[] theBytes) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
in(char[] theChars) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
in(double[] theDoubles) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
in(Expression arguments) |
Expression |
in(float[] theFloats) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
in(int[] theInts) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
in(long[] theLongs) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
in(java.lang.Object[] theObjects) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
in(ReportQuery subQuery) |
Expression |
in(short[] theShorts) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
in(java.util.Vector theObjects) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
indexOf(java.lang.Object substring) PUBLIC: Function, returns the integer index of the substring within the source string. |
Expression |
isNull() PUBLIC: Compare to null. |
Expression |
lastDay() PUBLIC: Function, returns the date with the last date in the months of this source date. |
Expression |
leftPad(int size, java.lang.Object substring) PUBLIC: Function, returns the string padded with the substring to the size. |
Expression |
leftPad(java.lang.Object size, java.lang.Object substring) PUBLIC: Function, returns the string padded with the substring to the size. |
Expression |
leftTrim() PUBLIC: Function, returns the string left trimmed for white space. |
Expression |
length() PUBLIC: Function, returns the size of the string. |
Expression |
lessThan(boolean theBoolean) PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
Expression |
lessThan(byte theValue) PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
Expression |
lessThan(char theChar) PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
Expression |
lessThan(double theValue) PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
Expression |
lessThan(Expression theValue) |
Expression |
lessThan(float theValue) PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
Expression |
lessThan(int theValue) PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
Expression |
lessThan(long theValue) PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
Expression |
lessThan(java.lang.Object theValue) PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
Expression |
lessThan(short theValue) PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
Expression |
lessThanEqual(boolean theBoolean) PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
Expression |
lessThanEqual(byte theValue) PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
Expression |
lessThanEqual(char theChar) PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
Expression |
lessThanEqual(double theValue) PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
Expression |
lessThanEqual(Expression theValue) PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
Expression |
lessThanEqual(float theValue) PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
Expression |
lessThanEqual(int theValue) PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
Expression |
lessThanEqual(long theValue) PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
Expression |
lessThanEqual(java.lang.Object theValue) PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
Expression |
lessThanEqual(short theValue) PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
Expression |
like(Expression argument) PUBLIC: Return an expression that compares if the receivers value is like other value. |
Expression |
like(java.lang.String value) PUBLIC: Return an expression that compares if the receivers value is like other value. |
Expression |
like(java.lang.String value, java.lang.String escapeSequence) PUBLIC: Return an expression that compares if the receivers value is like other value. |
Expression |
likeIgnoreCase(Expression theValue) PUBLIC: Return an expression that compares if the receivers value is like the other value, ignoring case. |
Expression |
likeIgnoreCase(java.lang.String theValue) PUBLIC: Return an expression that compares if the receivers value is like the other value, ignoring case. |
Expression |
maximum() PUBLIC: This represents the aggregate function Maximum. |
Expression |
minimum() PUBLIC: This represents the aggregate function Minimum. |
Expression |
monthsBetween(java.lang.Object otherDate) PUBLIC: Function, returns the decimal number of months between the two dates. |
Expression |
newTime(java.lang.String timeZoneFrom, java.lang.String timeZoneTo) PUBLIC: funcation return a date converted to a new timezone. |
Expression |
nextDay(java.lang.Object dayName) PUBLIC: Function, returns the date with the next day from the source date as the day name given. |
Expression |
not() PUBLIC: Return an expression that is the boolean logical negation of the expression. |
Expression |
notBetween(byte leftValue, byte rightValue) PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
Expression |
notBetween(char leftChar, char rightChar) PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
Expression |
notBetween(double leftValue, double rightValue) PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
Expression |
notBetween(Expression leftExpression, Expression rightExpression) PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
Expression |
notBetween(float leftValue, float rightValue) PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
Expression |
notBetween(int leftValue, int rightValue) PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
Expression |
notBetween(long leftValue, long rightValue) PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
Expression |
notBetween(java.lang.Object leftValue, java.lang.Object rightValue) PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
Expression |
notBetween(short leftValue, short rightValue) PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
Expression |
notEqual(boolean theBoolean) PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
Expression |
notEqual(byte theValue) PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
Expression |
notEqual(char theChar) PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
Expression |
notEqual(double theValue) PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
Expression |
notEqual(Expression theValue) PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
Expression |
notEqual(float theValue) PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
Expression |
notEqual(int theValue) PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
Expression |
notEqual(long theValue) PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
Expression |
notEqual(java.lang.Object theValue) PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
Expression |
notEqual(short theValue) PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
Expression |
notExists(ReportQuery subQuery) PUBLIC: Return a sub query expression. |
Expression |
notIn(boolean[] theBooleans) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
notIn(byte[] theBytes) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
notIn(char[] theChars) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
notIn(double[] theDoubles) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
notIn(Expression arguments) |
Expression |
notIn(float[] theFloats) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
notIn(int[] theInts) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
notIn(long[] theLongs) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
notIn(java.lang.Object[] theObjects) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
notIn(short[] theShorts) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
notIn(java.util.Vector theObjects) PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
Expression |
notLike(Expression arguments) PUBLIC: Return an expression that compares if the receivers value is not like the other value. |
Expression |
notLike(java.lang.String aString) PUBLIC: Return an expression that compares if the receivers value is not like the other value. |
Expression |
notNull() PUBLIC: Return an expression representing a comparison to null Example: TopLink: employee.get("age").notNull() Java: employee.getAge() ! |
Expression |
or(Expression theExpression) PUBLIC: Return an expression that is the boolean logical combination of both expressions. |
Expression |
postfixSQL(java.lang.String sqlString) ADVANCED: Inserts the SQL as is directly into the expression. |
Expression |
prefixSQL(java.lang.String sqlString) ADVANCED: Insert the SQL as is directly into the expression. |
Expression |
ref() ADVANCED: For Object-relational support. |
Expression |
replace(java.lang.Object stringToReplace, java.lang.Object stringToReplaceWith) PUBLIC: Function, returns the string with occurances of the first substring replaced with the second substring. |
Expression |
replicate(int constant) PUBLIC: return the result of this query repeated a given number of times. |
Expression |
replicate(java.lang.Object theValue) PUBLIC: return the result of this query repeated a given number of times. |
Expression |
reverse() PUBLIC: Function return the reverse of the query result. |
Expression |
right(int characters) PUBLIC: Function return a given number of characters starting at the right of a string. |
Expression |
right(java.lang.Object characters) PUBLIC: Function return a given number of characters starting at the right of a string. |
Expression |
rightPad(int size, java.lang.Object substring) PUBLIC: Function, returns the string padded with the substring to the size. |
Expression |
rightPad(java.lang.Object size, java.lang.Object substring) PUBLIC: Function, returns the string padded with the substring to the size. |
Expression |
rightTrim() PUBLIC: Function, returns the string right trimmed for white space. |
Expression |
rightTrim(java.lang.Object substring) PUBLIC: Function, returns the string with the substring trimed from the right. |
Expression |
roundDate(java.lang.Object yearOrMonthOrDayRoundToken) PUBLIC: Function, returns the date rounded to the year, month or day. |
Expression |
standardDeviation() PUBLIC: This represents the aggregate function StandardDeviation. |
Expression |
subQuery(ReportQuery subQuery) PUBLIC: Return a sub query expression. |
Expression |
substring(int startPosition, int size) PUBLIC: Function, returns the substring from the souce string. |
Expression |
substring(java.lang.Object startPosition, java.lang.Object size) PUBLIC: Function, returns the substring from the souce string. |
Expression |
sum() PUBLIC: This represents the aggregate function Sum. |
Expression |
toCharacter() PUBLIC: Function, returns the single character string with the ascii or character set value. |
Expression |
toDate() PUBLIC: Function, returns date from the string using the default format. |
Expression |
toLowerCase() PUBLIC: Return an expression that represents the receiver value converted to lower case. |
Expression |
toNumber() PUBLIC: Function, returns the number converted from the string. |
java.lang.String |
toString() PUBLIC: Print a debug form of the expression tree. |
Expression |
toUpperCase() PUBLIC: Return an expression that represents the receiver value converted to upper case. |
Expression |
toUppercaseCasedWords() PUBLIC: Function, returns the string with the first letter of each word capitalized. |
Expression |
translate(java.lang.Object fromString, java.lang.Object toString) PUBLIC: Function, returns the string with each char from the from string converted to the char in the to string. |
Expression |
trim() PUBLIC: Function, returns the string trimmed for white space. |
Expression |
truncateDate(java.lang.String datePart) PUBLIC: return the date truncated to the indicated datePart. |
Expression |
value() PUBLIC: Function, this represents the value function, used in nestedtable |
Expression |
value(boolean constant) PUBLIC: Return an expression on the constant. |
Expression |
value(byte constant) PUBLIC: Return an expression on the constant. |
Expression |
value(char constant) PUBLIC: Return an expression on the constant. |
Expression |
value(double constant) PUBLIC: Return an expression on the constant. |
Expression |
value(float constant) PUBLIC: Return an expression on the constant. |
Expression |
value(int constant) PUBLIC: Return an expression on the constant. |
Expression |
value(long constant) PUBLIC: Return an expression on the constant. |
Expression |
value(java.lang.Object constant) PUBLIC: Return an expression on the constant. |
Expression |
value(short constant) PUBLIC: Return an expression on the constant. |
Expression |
variance() PUBLIC: Function, this represents the aggregate function Variance. |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Constructor Detail |
public Expression()
Method Detail |
public Expression addDate(java.lang.String datePart, int numberToAdd)
Example:
TopLink: employee.get("date").addDate("year", 2) Java: NA SQL: DATEADD(date, 2, year)
public Expression addDate(java.lang.String datePart, java.lang.Object numberToAdd)
Example:
TopLink: employee.get("date").addDate("year", 2) Java: NA SQL: DATEADD(date, 2, year)
public Expression addMonths(int months)
public Expression addMonths(java.lang.Object months)
public Expression and(Expression theExpression)
Example:
TopLink: employee.get("firstName").equal("Bob").and(employee.get("lastName").equal("Smith")) Java: (employee.getFirstName().equals("Bob")) && (employee.getLastName().equals("Smith")) SQL: F_NAME = 'Bob' AND L_NAME = 'Smith'
public Expression anyOf(java.lang.String attributeName)
Example:
Format | Equivalent |
---|---|
TopLink | ReadAllQuery query = new ReadAllQuery(Employee.class); |
Java | No direct equivalent |
SQL | SELECT DISTINCT ... WHERE (t2.MGR_ID (+) = t1.ID) AND (t2.F_NAME = 'Bob') |
public Expression anyOfAllowingNone(java.lang.String attributeName)
Example:
Format | Equivalent |
---|---|
TopLink | ReadAllQuery query = new ReadAllQuery(Employee.class); |
Java | No direct equivalent |
SQL | SELECT DISTINCT ... WHERE (t2.MGR_ID (+) = t1.ID) AND (t2.F_NAME = 'Bob') |
public Expression appendSQL(java.lang.String sqlString)
prefixSQL(java.lang.String)
, postfixSQL(java.lang.String)
.public Expression ascending()
readAllQuery.addOrderBy(expBuilder.get("address").get("city").ascending())
public Expression asciiValue()
public Expression average()
public Expression between(byte leftValue, byte rightValue)
public Expression between(char leftChar, char rightChar)
public Expression between(double leftValue, double rightValue)
public Expression between(float leftValue, float rightValue)
public Expression between(int leftValue, int rightValue)
public Expression between(long leftValue, long rightValue)
public Expression between(java.lang.Object leftValue, java.lang.Object rightValue)
Example:
TopLink: employee.get("age").between(19,50) Java: (employee.getAge() > 19) && (employee.getAge() < 50) SQL: AGE BETWEEN 19 AND 50
public Expression between(Expression leftExpression, Expression rightExpression)
public Expression between(short leftValue, short rightValue)
public Expression caseStatement(java.util.Hashtable caseItems, java.lang.String defaultItem)
Example:
Hashtable caseTable = new Hashtable(); caseTable.put("Robert", "Bob"); caseTable.put("Susan", "Sue"); TopLink: employee.get("name").caseStatement(caseTable, "No-Nickname") Java: NA SQL: CASE name WHEN "Robert" THEN "Bob" WHEN "Susan" THEN "Sue" ELSE "No-Nickname"
caseItems
- java.util.Hashtable a hashtable containing the items to be processed. Keys represent the items to match coming from the query. Values represent what a key will be changed to.defaultItem
- java.lang.String the default value that will be used if none of the keys in the hashtable matchpublic Expression concat(java.lang.Object left)
public Expression containsAllKeyWords(java.lang.String spaceSeperatedKeyWords)
Example:
TopLink: project.get("description").containsAllKeyWords("TopLink rdbms java")
public Expression containsAnyKeyWords(java.lang.String spaceSeperatedKeyWords)
Example:
TopLink: project.get("description").containsAllKeyWords("TopLink rdbms java")
public Expression containsSubstring(java.lang.String theValue)
Example:
TopLink: employee.get("firstName").containsSubstring("Bob") Java: employee.getFirstName().indexOf("Bob") != -1 SQL: F_NAME LIKE '%BOB%'
public Expression containsSubstring(Expression expression)
Example:
TopLink: employee.get("firstName").containsSubstring("Bob") Java: employee.getFirstName().indexOf("Bob") != -1 SQL: F_NAME LIKE '%BOB%'
public Expression containsSubstringIgnoringCase(java.lang.String theValue)
Example:
TopLink: employee.get("firstName").containsSubstringIgnoringCase("Bob") Java: employee.getFirstName().toUpperCase().indexOf("BOB") != -1 SQL: F_NAME LIKE '%BOB%'
public Expression containsSubstringIgnoringCase(Expression expression)
Example:
TopLink: employee.get("firstName").containsSubstringIgnoringCase("Bob") Java: employee.getFirstName().toUpperCase().indexOf("BOB") != -1 SQL: F_NAME LIKE '%BOB%'
public Expression count()
public Expression currentDate()
public Expression dateDifference(java.lang.String datePart, java.util.Date date)
Example:
TopLink: employee.get("date").dateDifference("year", new Date(System.currentTimeMillis())) Java: NA SQL: DATEADD(date, 2, GETDATE)
*
public Expression dateDifference(java.lang.String datePart, Expression comparisonExpression)
Example:
TopLink: employee.get("date").dateDifference("year", new Date(System.currentTimeMillis())) Java: NA SQL: DATEADD(date, 2, GETDATE)
*
public Expression dateName(java.lang.String datePart)
Example:
TopLink: employee.get("date").dateName("year") Java: new String(date.getYear()) SQL: DATENAME(date, year)
*
public Expression datePart(java.lang.String datePart)
Example:
TopLink: employee.get("date").datePart("year") Java: date.getYear() SQL: DATEPART(date, year)
*
public Expression dateToString()
public Expression decode(java.util.Hashtable decodeableItems, java.lang.String defaultItem)
Example:
Hashtable decodeTable = new Hashtable(); decodeTable.put("Robert", "Bob"); decodeTable.put("Susan", "Sue"); TopLink: employee.get("name").Decode(decodeTable, "No-Nickname") Java: NA SQL: DECODE(name, "Robert", "Bob", "Susan", "Sue", "No-Nickname")
decodeableItems
- java.util.Hashtable a hashtable containing the items to be decoded. Keys represent the items to match coming from the query. Values represent what a key will be changed to.defaultItem
- the default value that will be used if none of the keys in the hashtable matchpublic Expression descending()
Example:
readAllQuery.addOrderBy(expBuilder.get("address").get("city").descending())
public Expression difference(java.lang.String expression)
Example:
TopLink: employee.get("name").difference("Frank") SQL: DIFFERENCE(name, 'Frank')
*
public Expression distinct()
public Expression equal(byte theValue)
public Expression equal(char theChar)
public Expression equal(double theValue)
public Expression equal(float theValue)
public Expression equal(int theValue)
public Expression equal(long theValue)
public Expression equal(java.lang.Object theValue)
Example:
TopLink: employee.get("firstName").equal("Bob") Java: employee.getFirstName().equals("Bob") SQL: F_NAME = 'Bob'
public Expression equal(Expression theValue)
Since OracleAS TopLink 10g (9.0.4) if this
is an ExpressionBuilder
and theValue
is not used elsewhere, both will be translated to the same table. This can generate SQL with one less join for most exists subqueries.
Example:
TopLink: employee.get("manager").equal(employee) Java: employee.getManager().equals(employee) SQL (optimized): EMP_ID = MANAGER_ID SQL (unoptimized): t0.MANAGER_ID = t1.EMP_ID AND t0.EMP_ID = t1.EMP_ID
equal(Object)
public Expression equal(short theValue)
public Expression equal(boolean theBoolean)
public Expression equalsIgnoreCase(java.lang.String theValue)
Example:
TopLink: employee.get("firstName").equalsIgnoreCase("Bob") Java: employee.getFirstName().equalsIgnoreCase("Bob") SQL: UPPER(F_NAME) = 'BOB'
public Expression equalsIgnoreCase(Expression theValue)
Example:
TopLink: employee.get("firstName").equalsIgnoreCase("Bob") Java: employee.getFirstName().equalsIgnoreCase("Bob") SQL: UPPER(F_NAME) = 'BOB'
public Expression exists(ReportQuery subQuery)
Example:
ExpressionBuilder builder = new ExpressionBuilder(); ReportQuery subQuery = new ReportQuery(Employee.class, new ExpressionBuilder()); subQuery.setSelectionCriteria(subQuery.getExpressionBuilder().get("name").equal(builder.get("name"))); builder.exists(subQuery);
public Expression get(java.lang.String attributeName)
Example:
builder.get("address").get("city").equal("Ottawa");
public Expression getAllowingNull(java.lang.String attributeName)
Example:
builder.getAllowingNull("address").get("city").equal("Ottawa");
public Expression getField(java.lang.String fieldName)
Example:
builder.getField("ADDR_ID").greaterThan(100); builder.getTable("PROJ_EMP").getField("TYPE").equal("S");
public Expression getField(oracle.toplink.internal.helper.DatabaseField field)
Example:
builder.getField(aField).greaterThan(100);
public Expression getFunction(int selector)
Example:
builder.get("name").getFunction(MyFunctions.FOO_BAR).greaterThan(100);
public Expression getFunction(int selector, java.util.Vector arguments)
Example:
Vector arguments = new Vector(); arguments.addElement("blee"); builder.get("name").getFunction(MyFunctions.FOO_BAR, arguments).greaterThan(100);
public Expression getFunction(java.lang.String functionName)
Example:
builder.get("firstName").getFunction("UPPER");
public Expression getFunction(java.lang.String functionName, java.lang.Object argument)
public Expression getFunctionWithArguments(java.lang.String functionName, java.util.Vector arguments)
public Expression getParameter(java.lang.String parameterName)
public Expression getParameter(oracle.toplink.internal.helper.DatabaseField field)
public Expression getTable(java.lang.String tableName)
Example:
builder.getTable("PROJ_EMP").getField("TYPE").equal("S");
public Expression getTable(oracle.toplink.internal.helper.DatabaseTable table)
Example:
builder.getTable(linkTable).getField("TYPE").equal("S");
public Expression greaterThan(byte theValue)
public Expression greaterThan(char theChar)
public Expression greaterThan(double theValue)
public Expression greaterThan(float theValue)
public Expression greaterThan(int theValue)
public Expression greaterThan(long theValue)
public Expression greaterThan(java.lang.Object theValue)
public Expression greaterThan(Expression theValue)
public Expression greaterThan(short theValue)
public Expression greaterThan(boolean theBoolean)
public Expression greaterThanEqual(byte theValue)
public Expression greaterThanEqual(char theChar)
public Expression greaterThanEqual(double theValue)
public Expression greaterThanEqual(float theValue)
public Expression greaterThanEqual(int theValue)
public Expression greaterThanEqual(long theValue)
public Expression greaterThanEqual(java.lang.Object theValue)
public Expression greaterThanEqual(Expression theValue)
public Expression greaterThanEqual(short theValue)
public Expression greaterThanEqual(boolean theBoolean)
public Expression hexToRaw()
public Expression ifNull(java.lang.Object nullValue)
Example:
TopLink: employee.get("name").ifNull("no-name") Java: NA SQL: NVL(name, 'no-name')
*
public Expression in(byte[] theBytes)
public Expression in(char[] theChars)
public Expression in(double[] theDoubles)
public Expression in(float[] theFloats)
public Expression in(int[] theInts)
public Expression in(long[] theLongs)
public Expression in(java.lang.Object[] theObjects)
public Expression in(short[] theShorts)
public Expression in(boolean[] theBooleans)
public Expression in(java.util.Vector theObjects)
Example:
TopLink: employee.get("age").in(agesVector) Java: agesVector.contains(employee.getAge()) SQL: AGE IN (55, 18, 30)
public Expression in(Expression arguments)
public Expression in(ReportQuery subQuery)
public Expression indexOf(java.lang.Object substring)
public Expression isNull()
public Expression lastDay()
public Expression leftPad(int size, java.lang.Object substring)
public Expression leftPad(java.lang.Object size, java.lang.Object substring)
public Expression leftTrim()
public Expression length()
public Expression lessThan(byte theValue)
public Expression lessThan(char theChar)
public Expression lessThan(double theValue)
public Expression lessThan(float theValue)
public Expression lessThan(int theValue)
public Expression lessThan(long theValue)
public Expression lessThan(java.lang.Object theValue)
public Expression lessThan(Expression theValue)
public Expression lessThan(short theValue)
public Expression lessThan(boolean theBoolean)
public Expression lessThanEqual(byte theValue)
public Expression lessThanEqual(char theChar)
public Expression lessThanEqual(double theValue)
public Expression lessThanEqual(float theValue)
public Expression lessThanEqual(int theValue)
public Expression lessThanEqual(long theValue)
public Expression lessThanEqual(java.lang.Object theValue)
public Expression lessThanEqual(Expression theValue)
public Expression lessThanEqual(short theValue)
public Expression lessThanEqual(boolean theBoolean)
public Expression like(java.lang.String value)
Example:
TopLink: employee.get("firstName").like("B%") Java: NA SQL: F_NAME LIKE 'B%'
public Expression like(java.lang.String value, java.lang.String escapeSequence)
Example:
TopLink: employee.get("firstName").like("B\_SMITH", "\") Java: NA SQL: F_NAME LIKE 'B\_SMITH ESCAPE '\''
public Expression like(Expression argument)
Example:
TopLink: employee.get("firstName").like("B%") Java: NA SQL: F_NAME LIKE 'B%'
public Expression likeIgnoreCase(java.lang.String theValue)
Example:
TopLink: employee.get("firstName").likeIgnoreCase("%Bob%") Java: none SQL: UPPER(F_NAME) LIKE '%BOB%'
public Expression likeIgnoreCase(Expression theValue)
public Expression maximum()
public Expression minimum()
public Expression monthsBetween(java.lang.Object otherDate)
public Expression newTime(java.lang.String timeZoneFrom, java.lang.String timeZoneTo)
Example:
TopLink: employee.get("date").newTime("EST", "PST") Java: NA SQL: NEW_TIME(date, 'EST', 'PST')
*
public Expression nextDay(java.lang.Object dayName)
public Expression not()
Example:
TopLink: employee.get("age").equal(24).not() Java: (! (employee.getAge() == 24)) SQL: NOT (AGE = 24)
public Expression notBetween(byte leftValue, byte rightValue)
between(Object, Object)
public Expression notBetween(char leftChar, char rightChar)
between(Object, Object)
public Expression notBetween(double leftValue, double rightValue)
between(Object, Object)
public Expression notBetween(float leftValue, float rightValue)
between(Object, Object)
public Expression notBetween(int leftValue, int rightValue)
between(Object, Object)
public Expression notBetween(long leftValue, long rightValue)
between(Object, Object)
public Expression notBetween(java.lang.Object leftValue, java.lang.Object rightValue)
between(Object, Object)
public Expression notBetween(Expression leftExpression, Expression rightExpression)
between(Object, Object)
public Expression notBetween(short leftValue, short rightValue)
between(Object, Object)
public Expression notEqual(byte theValue)
equal(Object)
public Expression notEqual(char theChar)
equal(Object)
public Expression notEqual(double theValue)
equal(Object)
public Expression notEqual(float theValue)
equal(Object)
public Expression notEqual(int theValue)
equal(Object)
public Expression notEqual(long theValue)
equal(Object)
public Expression notEqual(java.lang.Object theValue)
equal(Object)
public Expression notEqual(Expression theValue)
equal(Object)
public Expression notEqual(short theValue)
equal(Object)
public Expression notEqual(boolean theBoolean)
equal(Object)
public Expression notExists(ReportQuery subQuery)
Example:
ExpressionBuilder builder = new ExpressionBuilder(); ReportQuery subQuery = new ReportQuery(Employee.class, new ExpressionBuilder()); subQuery.setSelectionCriteria(subQuery.getExpressionBuilder().get("name").equal(builder.get("name"))); builder.notExists(subQuery);
public Expression notIn(byte[] theBytes)
public Expression notIn(char[] theChars)
public Expression notIn(double[] theDoubles)
public Expression notIn(float[] theFloats)
public Expression notIn(int[] theInts)
public Expression notIn(long[] theLongs)
public Expression notIn(java.lang.Object[] theObjects)
public Expression notIn(short[] theShorts)
public Expression notIn(boolean[] theBooleans)
public Expression notIn(java.util.Vector theObjects)
Example:
TopLink: employee.get("age").in(agesVector) Java: agesVector.contains(employee.getAge()) SQL: AGE IN (55, 18, 30)
public Expression notIn(Expression arguments)
public Expression notLike(java.lang.String aString)
like(String)
public Expression notLike(Expression arguments)
like(String)
public Expression notNull()
Example:
TopLink: employee.get("age").notNull() Java: employee.getAge() != null SQL: AGE IS NOT NULL
public Expression or(Expression theExpression)
Example:
TopLink: employee.get("firstName").equal("Bob").OR(employee.get("lastName").equal("Smith")) Java: (employee.getFirstName().equals("Bob")) || (employee.getLastName().equals("Smith")) SQL: F_NAME = 'Bob' OR L_NAME = 'Smith'
public Expression postfixSQL(java.lang.String sqlString)
public Expression prefixSQL(java.lang.String sqlString)
public Expression ref()
public Expression replace(java.lang.Object stringToReplace, java.lang.Object stringToReplaceWith)
public Expression replicate(int constant)
Example:
TopLink: employee.get("name").replicate(2) Java: NA SQL: REPLICATE(name, 2)
public Expression replicate(java.lang.Object theValue)
Example:
TopLink: employee.get("name").replicate(2) Java: NA SQL: REPLICATE(name, 2)
public Expression reverse()
Example:
TopLink: employee.get("name").reverse() Java: NA SQL: REVERSE(name)
public Expression right(int characters)
Example:
TopLink: employee.get("name").right(2) Java: NA SQL: RIGHT(name, 2)
public Expression right(java.lang.Object characters)
Example:
TopLink: employee.get("name").right(2) Java: NA SQL: RIGHT(name, 2)
public Expression rightPad(int size, java.lang.Object substring)
public Expression rightPad(java.lang.Object size, java.lang.Object substring)
public Expression rightTrim()
public Expression rightTrim(java.lang.Object substring)
public Expression roundDate(java.lang.Object yearOrMonthOrDayRoundToken)
public Expression standardDeviation()
public Expression subQuery(ReportQuery subQuery)
Example:
ExpressionBuilder builder = new ExpressionBuilder(); ReportQuery subQuery = new ReportQuery(Employee.class, new ExpressionBuilder()); subQuery.addMaximum("salary"); builder.get("salary").equal(builder.subQuery(subQuery));
public Expression substring(int startPosition, int size)
public Expression substring(java.lang.Object startPosition, java.lang.Object size)
public Expression sum()
public Expression toCharacter()
public Expression toDate()
public Expression toLowerCase()
Example:
TopLink: employee.get("firstName").toLowerCase().equal("bob") Java: employee.getFirstName().toLowerCase().equals("bob") SQL: LOWER(F_NAME) = 'bob'
public Expression toNumber()
public java.lang.String toString()
public Expression toUpperCase()
Example:
TopLink: employee.get("firstName").toUpperCase().equal("BOB") Java: employee.getFirstName().toUpperCase().equals("BOB") SQL: UPPER(F_NAME) = 'BOB'
public Expression toUppercaseCasedWords()
public Expression translate(java.lang.Object fromString, java.lang.Object toString)
public Expression trim()
public Expression truncateDate(java.lang.String datePart)
Example:
TopLink: employee.get("date").truncDate(year) Java: NA SQL: TRUNC(date, year)
public Expression value()
public Expression value(byte constant)
Example:
reportQuery.addItem("a constant", builder.value("a constant"));
public Expression value(char constant)
Example:
reportQuery.addItem("a constant", builder.value("a constant"));
public Expression value(double constant)
Example:
reportQuery.addItem("a constant", builder.value("a constant"));
public Expression value(float constant)
Example:
reportQuery.addItem("a constant", builder.value("a constant"));
public Expression value(int constant)
Example:
reportQuery.addItem("a constant", builder.value("a constant"));
public Expression value(long constant)
Example:
reportQuery.addItem("a constant", builder.value("a constant"));
public Expression value(java.lang.Object constant)
Example:
reportQuery.addItem("a constant", builder.value("a constant"));
public Expression value(short constant)
Example:
reportQuery.addItem("a constant", builder.value("a constant"));
public Expression value(boolean constant)
Example:
reportQuery.addItem("a constant", builder.value("a constant"));
public Expression variance()
|
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |