|
Compoze Software, Inc. | ||||||||
| PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES | ||||||||
See:
Description
| Interface Summary | |
| IFunction | This interface defines an object that provides a function. |
| IKeyword | This interface defines an object that provides SQL keywords. |
| IOperator | This interface defines a object that provides a comparison operators. |
| IPredicate | This interface defines an object that provides a predicate. |
| IScope | This interface contains the values that are used to determine scope of a folder search. |
| ISqlFragment | This interface defines an object that is a SQL fragment. |
| Class Summary | |
| AbstractFunction | The class provides default implementations for SQL functions. |
| AbstractOperator | The class provides default implementations for SQL operators. |
| AbstractPredicate | The class provides default implementations for SQL predicates. |
| AbstractSqlFragment | The class provides default implementations for SQL fragments. |
| CastFunction | This class creates a function clause based on the SQL function CAST. |
| Condition | This class provides the implementation for creating a condition statement. |
| ContainsPredicate | This class creates a functionn filter rule using a CONTAINS predicate. |
| EqualsOperator | This class represents the 'equals' operator. |
| FromClause | This class represents the Structured Query Language (SQL) "FROM" Clause. |
| GreaterThanOperator | This class represents the 'less than' operator. |
| GroupByClause | This class represents the Structured Query Language (SQL) "GROUP BY" clause. |
| IsNullCondition | This class provides the implementation for creating a 'IS null' condition statement. |
| LessThanOperator | This class represents the 'less than' operator. |
| LikePredicate | This class creates a functionn filter rule using the LIKE predicate. |
| NotCondition | This class provides the implementation for creating a 'NOT' condition statement. |
| NotEqualsOperator | This class represents the 'not equals' operator. |
| OrderByClause | This class represents the Structured Query Language (SQL) "ORDER BY" clause. |
| SelectStatement | This class represents the Structured Query Language (SQL) "SELECT" statement. |
| WhereClause | This class represents the Structured Query Language (SQL) "FROM" Clause. |
This package provides classes to build Structured Query Language (SQL) components (clauses, functions, predicates, and statements) used to perfrom searches against the Exchange store.
The following example demonstrates the use of these classes.
SelectStatement stmt = new SelectStatement(
new String[]
{
"\"DAV:href\"",
"\"DAV:displayname\"",
"\"DAV:contentclass\"",
"\"urn:schemas:httpmail:subject\""
},
new FromClause(new String[]
{
"/exchange/skip.ogrudnick/Inbox/",
"/exchange/skip.ogrudnick/Inbox/sub1/",
"/exchange/skip.ogrudnick/Inbox/sub2/"
}, IScope.SHALLOW_TRAVERSAL),
new WhereClause(Condition.create(new GreaterThanOperator("urn:schemas:contacts:givenName", "Skip"), true)),
new GroupByClause(new String[]
{
"DAV:href",
"DAV:contentclass"
}),
OrderByClause.create("uurn:schemas:httpmail:datereceived", OrderByClause.DESCENDING));
System.out.println(stmt);
Calling the toString() or toSQL() will yield the follwing SQL statement:
SELECT "DAV:href", "DAV:displayname", "DAV:contentclass", "urn:schemas:httpmail:subject"
FROM SCOPE('shallow traversal of "/exchange/skip.ogrudnick/Inbox/"',
'shallow traversal of "/exchange/skip.ogrudnick/Inbox/sub1/"',
'shallow traversalof "/exchange/skip.ogrudnick/Inbox/sub2/"')
WHERE ("urn:schemas:contacts:givenName" > 'Skip')
GROUP BY "DAV:href", "DAV:contentclass"
ORDER BY "urn:schemas:httpmail:datereceived" DESC
Although it should not strictly be needed, sometimes you may wish to refer to the CDO, MAPI, Exchange Store,or Microsoft Exchange developer documentation. This is available from Microsoft at http://msdn.microsoft.com/exchange/.
|
Compoze Software, Inc. | ||||||||
| PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES | ||||||||