|
|||||||||
| Home >> All >> org >> jdbf >> engine >> [ sql overview ] | PREV NEXT | ||||||||
A
- AND - Static variable in class org.jdbf.engine.sql.SqlInterface
- ASC - Static variable in class org.jdbf.engine.sql.SqlInterface
- ASSIGNMENT - Static variable in class org.jdbf.engine.sql.SqlInterface
- addSqlInterface(String) - Static method in class org.jdbf.engine.sql.SqlInterfaceFactory
- Adds a
SqlInterfaceto the list of instantiated interfaces.
B
- BETWEEN - Static variable in class org.jdbf.engine.sql.SqlInterface
- buildStatement(RepositoryView, String[]) - Method in class org.jdbf.engine.sql.DeleteStatement
- Builds the delete statement with the informations passed by repository.
- buildStatement(RepositoryView, String[]) - Method in class org.jdbf.engine.sql.InsertStatement
- Builds the insert statement with the informations passed by repository.
- buildStatement(RepositoryView, String[]) - Method in class org.jdbf.engine.sql.SQLStatement
- buildStatement(RepositoryView, String[]) - Method in class org.jdbf.engine.sql.SelectStatement
- Builds the select statement with the informations passed by repository.
- buildStatement(RepositoryView, String[]) - Method in class org.jdbf.engine.sql.UpdateStatement
- Builds the update statement with the informations passed by repository.
- buildStatementForCriteria(RepositoryView, String[]) - Method in class org.jdbf.engine.sql.DeleteStatement
- Builds the delete statement with criteria.
- buildStatementForCriteria(RepositoryView, String[]) - Method in class org.jdbf.engine.sql.InsertStatement
- Not implemented
- buildStatementForCriteria(RepositoryView, String[]) - Method in class org.jdbf.engine.sql.SQLStatement
- buildStatementForCriteria(RepositoryView, String[]) - Method in class org.jdbf.engine.sql.SelectStatement
- buildStatementForCriteria(RepositoryView, String[]) - Method in class org.jdbf.engine.sql.UpdateStatement
- Builds the delete statement with criteria.
C
- CLOSE_BRACE - Static variable in class org.jdbf.engine.sql.SQLStatement
- identifies )
- CREATE - Static variable in class org.jdbf.engine.sql.SqlInterface
- Cursor - class org.jdbf.engine.sql.Cursor.
- This subclass of QueryResults provides rows of an sql query form cache.
- Cursor(List, Object) - Constructor for class org.jdbf.engine.sql.Cursor
- Creates the Cursor object
- className - Variable in class org.jdbf.engine.sql.QueryResults
- Class name
- className - Variable in class org.jdbf.engine.sql.SQLStatement
- class name
- create() - Method in interface org.jdbf.engine.sql.SqlInterfaceFactory.SqlInterfaceMaker
- criteria - Variable in class org.jdbf.engine.sql.SQLStatement
- Cirteria object
D
- DELETE - Static variable in class org.jdbf.engine.sql.DeleteStatement
- DELETE statement
- DELETE - Static variable in class org.jdbf.engine.sql.SqlInterface
- DESC - Static variable in class org.jdbf.engine.sql.SqlInterface
- DISTINCT - Static variable in class org.jdbf.engine.sql.SqlInterface
- DROP - Static variable in class org.jdbf.engine.sql.SqlInterface
- DeleteStatement - class org.jdbf.engine.sql.DeleteStatement.
DeleteStatementis that class that represents the delete sql statement.- DeleteStatement(RepositoryView) - Constructor for class org.jdbf.engine.sql.DeleteStatement
- Create the object and build the delete statement.
- DeleteStatement(RepositoryView, Criteria) - Constructor for class org.jdbf.engine.sql.DeleteStatement
- Create the object and build the delete statement.
- DeleteStatement() - Constructor for class org.jdbf.engine.sql.DeleteStatement
- Creates the empty object
- delete(ObjectMapped, RepositoryView, Connection) - Method in class org.jdbf.engine.sql.DeleteStatement
- Executes the delete statement and delete in database the ObjectMapped object specified in obj.
- delete(Connection) - Method in class org.jdbf.engine.sql.DeleteStatement
- Executes the delete statement and delete in database with the specific criteria.
E
- EQUAL - Static variable in class org.jdbf.engine.sql.SqlInterface
F
- FROM - Static variable in class org.jdbf.engine.sql.SelectStatement
- FROM statement
- FROM - Static variable in class org.jdbf.engine.sql.SqlInterface
- fields - Variable in class org.jdbf.engine.sql.Cursor
- Array of results
- first() - Method in class org.jdbf.engine.sql.Cursor
- Retrieves first object in Cursor.
G
- GREATER_OR_EQUAL - Static variable in class org.jdbf.engine.sql.SqlInterface
- GREATER_THAN - Static variable in class org.jdbf.engine.sql.SqlInterface
- GROUP_BY - Static variable in class org.jdbf.engine.sql.SqlInterface
- getClauseStringCurrentTimeStamp() - Method in class org.jdbf.engine.sql.HsqlInterface
- Return the current timestamp
- getClauseStringCurrentTimeStamp() - Method in class org.jdbf.engine.sql.OracleInterface
- Return the cluase of current timeStamp
- getClauseStringCurrentTimeStamp() - Method in class org.jdbf.engine.sql.SqlInterface
- Return the cluase of current timeStamp
- getClauseStringCurrentTimeStamp() - Method in class org.jdbf.engine.sql.SqlServerInterface
- Return the cluase of current timeStamp
- getClauseStringForUpdate() - Method in class org.jdbf.engine.sql.InformixInterface
- Return the relative cluase for "FOR UPDATE" statement
- getClauseStringForUpdate() - Method in class org.jdbf.engine.sql.OracleInterface
- Return the relative cluase for "FOR UPDATE" statement
- getClauseStringLower() - Method in class org.jdbf.engine.sql.InterbaseInterface
- Return the lower function.
- getColumnDefinition(String, String, boolean) - Method in class org.jdbf.engine.sql.SqlInterface
- returns the definition of column given name, given type,given isNullable
- getCountStatement(String) - Method in class org.jdbf.engine.sql.SqlInterface
- Forms an sql statement which counts records in the given table which statisfy the given search condition.
- getCountStatement(String, String) - Method in class org.jdbf.engine.sql.SqlInterface
- Forms an sql statement which counts records in the given table which statisfy the given search condition.
- getCreateTableStatement(String, String) - Method in class org.jdbf.engine.sql.SqlInterface
- Forms an sql statement the create the table given tableName,column
- getCurrentTimeStampStatement() - Method in class org.jdbf.engine.sql.HsqlInterface
- Return the current timeStamp statement
- getCurrentTimeStampStatement() - Method in class org.jdbf.engine.sql.InterbaseInterface
- Return the current timeStamp statement
- getCurrentTimeStampStatement() - Method in class org.jdbf.engine.sql.OracleInterface
- Return the current timeStamp statement
- getCurrentTimeStampStatement() - Method in class org.jdbf.engine.sql.SqlInterface
- Forms an sql statement the return a current timestamp
- getCurrentTimeStampStatement() - Method in class org.jdbf.engine.sql.SqlServerInterface
- Return the current timeStamp statement
- getDropTableStatement(String) - Method in class org.jdbf.engine.sql.MySQLInterface
- Forms an sql statement the drop the table given tableName
- getDropTableStatement(String) - Method in class org.jdbf.engine.sql.OracleInterface
- Forms an sql statement the drop the table given tableName
- getDropTableStatement(String) - Method in class org.jdbf.engine.sql.SqlInterface
- Forms an sql statement the drop the table given tableName
- getInsertStatement(String, String, String) - Method in class org.jdbf.engine.sql.SqlInterface
- Forms an sql insert statement for a given table, given columns, and given values.
- getObject() - Method in class org.jdbf.engine.sql.Cursor
- Retrieves an object from an sql row.
- getObject() - Method in class org.jdbf.engine.sql.QueryResults
- getSQLType(String) - Static method in class org.jdbf.engine.sql.Types
- Return the sql type for type of property specified in type.
- getSelectCountAll() - Method in class org.jdbf.engine.sql.SqlInterface
- Return the COUNT(*) statement
- getSelectInsertIdStatement() - Method in class org.jdbf.engine.sql.MySQLInterface
- Forms an sql insert id statement
- getSelectInsertIdStatement() - Method in class org.jdbf.engine.sql.SqlInterface
- Forms an sql insert id statement This method throws an MappingExcpetion because for a generic sql interface the inset id feature is not supported.
- getSelectInsertIdStatement() - Method in class org.jdbf.engine.sql.SqlServerInterface
- Forms an sql insert id statement NEWID() returns a 16-byte binary value (GUID) for example: 6F9619FF-8B86-D011-D42D-00C04FC964FF
- getSelectInsertIdStatement() - Method in class org.jdbf.engine.sql.SybaseInterface
- Forms an sql insert id statement
- getSelectSequenceStatement(String) - Method in class org.jdbf.engine.sql.InterbaseInterface
- Forms an sql sequence statement given name This method throws an MappingExcpetion because for a generic sql interface the sequence feature is not supported.
- getSelectSequenceStatement(String) - Method in class org.jdbf.engine.sql.OracleInterface
- Forms an sql sequence statement given name This method throws an MappingExcpetion because for a generic sql interface the sequence feature is not supported.
- getSelectSequenceStatement(String) - Method in class org.jdbf.engine.sql.PostgreSQLInterface
- Forms an sql sequence statement given name This method throws an MappingExcpetion because for a generic sql interface the sequence feature is not supported.
- getSelectSequenceStatement(String) - Method in class org.jdbf.engine.sql.SqlInterface
- Forms an sql sequence statement given name This method throws an MappingExcpetion because for a generic sql interface the sequence feature is not supported.
- getSelectStatement(String, String, String) - Method in class org.jdbf.engine.sql.SqlInterface
- Forms an sql select statement for a given table, given fields, and given criteria.
- getSelectStatement(String, String) - Method in class org.jdbf.engine.sql.SqlInterface
- Forms an sql select statement for a given table,given fileds
- getSqlInterface(String) - Static method in class org.jdbf.engine.sql.SqlInterfaceFactory
- Return the SqlInterface specified in name
- getSqlInterfaceIntern(String) - Static method in class org.jdbf.engine.sql.SqlInterfaceFactory
- Return an
SqlInterfacefor the given class name. - getUpdateStatement(String, String, String) - Method in class org.jdbf.engine.sql.SqlInterface
- Forms an sql update statement for a given table, given columns, and given values.
- getValuesFromResultSet(RepositoryView, ResultSet) - Method in class org.jdbf.engine.sql.SelectStatement
- Get results of select statement from ResultSet.
H
- HAVING - Static variable in class org.jdbf.engine.sql.SqlInterface
- HsqlInterface - class org.jdbf.engine.sql.HsqlInterface.
- It's overrides SqlInterface's methods for constructing sql statements where this implementation differs from ANSI or is not specified by ANSI.
- HsqlInterface() - Constructor for class org.jdbf.engine.sql.HsqlInterface
I
- INSERT - Static variable in class org.jdbf.engine.sql.InsertStatement
- INSERT statement
- INSERT - Static variable in class org.jdbf.engine.sql.SqlInterface
- InformixInterface - class org.jdbf.engine.sql.InformixInterface.
- It's overrides SqlInterface's methods for constructing sql statements where this implementation differs from ANSI or is not specified by ANSI.
- InformixInterface() - Constructor for class org.jdbf.engine.sql.InformixInterface
- InsertStatement - class org.jdbf.engine.sql.InsertStatement.
InsertStatementis that class that represents the insert sql statement.- InsertStatement(RepositoryView) - Constructor for class org.jdbf.engine.sql.InsertStatement
- Create the object and build the insert statement.
- InsertStatement() - Constructor for class org.jdbf.engine.sql.InsertStatement
- Creates the empty object
- InterbaseInterface - class org.jdbf.engine.sql.InterbaseInterface.
- It's overrides SqlInterface's methods for constructing sql statements where Interbase's implementaion differs from ANSI or is not specified by ANSI.
- InterbaseInterface() - Constructor for class org.jdbf.engine.sql.InterbaseInterface
- index - Variable in class org.jdbf.engine.sql.Cursor
- Current index
- insert(ObjectMapped, RepositoryView, Connection) - Method in class org.jdbf.engine.sql.InsertStatement
- Executes the insert statement and store in database the ObjectMapped object specified in obj.
L
- LESS_OR_EQUAL - Static variable in class org.jdbf.engine.sql.SqlInterface
- LESS_THAN - Static variable in class org.jdbf.engine.sql.SqlInterface
- LIKE - Static variable in class org.jdbf.engine.sql.SqlInterface
- last() - Method in class org.jdbf.engine.sql.Cursor
- Retrieves last object in Cursor
- loadTypes() - Static method in class org.jdbf.engine.sql.Types
- Load the table that maps the type of property with SQL type.
M
- MAX - Static variable in class org.jdbf.engine.sql.SqlInterface
- MySQLInterface - class org.jdbf.engine.sql.MySQLInterface.
- It's overrides SqlInterface's methods for constructing sql statements where Interbase's implementaion differs from ANSI or is not specified by ANSI.
- MySQLInterface() - Constructor for class org.jdbf.engine.sql.MySQLInterface
N
- NEXTVAL - Static variable in class org.jdbf.engine.sql.SqlInterface
- NOT_EQUAL - Static variable in class org.jdbf.engine.sql.SqlInterface
- NOT_EXISTS - Static variable in class org.jdbf.engine.sql.SqlInterface
- NULL - Static variable in class org.jdbf.engine.sql.SqlInterface
- name - Variable in class org.jdbf.engine.sql.SqlInterfaceFactory.SqlInterfaceEntry
- Logic name of SQLInterface
- next() - Method in class org.jdbf.engine.sql.Cursor
- The index into the results list is incremented, and true is returned if there is another result.
- next() - Method in class org.jdbf.engine.sql.QueryResults
O
- OPEN_BRACE - Static variable in class org.jdbf.engine.sql.SQLStatement
- identifies (
- OR - Static variable in class org.jdbf.engine.sql.SqlInterface
- ORDER_BY - Static variable in class org.jdbf.engine.sql.SqlInterface
- OracleInterface - class org.jdbf.engine.sql.OracleInterface.
- It's overrides SqlInterface's methods for constructing sql statements where Oracle's implementation differs from ANSI or is not specified by ANSI.
- OracleInterface() - Constructor for class org.jdbf.engine.sql.OracleInterface
- org.jdbf.engine.sql - package org.jdbf.engine.sql
P
- PARAMETER - Static variable in class org.jdbf.engine.sql.SqlInterface
- PostgreSQLInterface - class org.jdbf.engine.sql.PostgreSQLInterface.
- It's overrides SqlInterface's methods for constructing sql statements where Interbase's implementaion differs from ANSI or is not specified by ANSI.
- PostgreSQLInterface() - Constructor for class org.jdbf.engine.sql.PostgreSQLInterface
Q
- QueryResults - class org.jdbf.engine.sql.QueryResults.
- QueryResults is the class-mapped equivalent of
a JDBC
ResultsSet. - QueryResults(Object) - Constructor for class org.jdbf.engine.sql.QueryResults
- Creates a QueryResults object
R
S
- SELECT - Static variable in class org.jdbf.engine.sql.SelectStatement
- SELECT statement
- SELECT - Static variable in class org.jdbf.engine.sql.SqlInterface
- SELECT_ALL - Static variable in class org.jdbf.engine.sql.SqlInterface
- SET - Static variable in class org.jdbf.engine.sql.SqlInterface
- SET - Static variable in class org.jdbf.engine.sql.UpdateStatement
- SET statement
- SQLStatement - class org.jdbf.engine.sql.SQLStatement.
SQLStatementis an abstract class that represents the sql statement.- SQLStatement() - Constructor for class org.jdbf.engine.sql.SQLStatement
- SQLStatement(RepositoryView, String[], Criteria) - Constructor for class org.jdbf.engine.sql.SQLStatement
- SelectStatement - class org.jdbf.engine.sql.SelectStatement.
SelectStatementis that class that represents the select sql statement.- SelectStatement(RepositoryView, String[], Criteria) - Constructor for class org.jdbf.engine.sql.SelectStatement
- Creates the SelectStatement object and build the statement
- SelectStatement() - Constructor for class org.jdbf.engine.sql.SelectStatement
- Creates the empty object
- SqlInterface - class org.jdbf.engine.sql.SqlInterface.
- This class implements a part of RelationalDatabase It provides methods to build sql strings and statements and to convert data values into sql strings.
- SqlInterface() - Constructor for class org.jdbf.engine.sql.SqlInterface
- SqlInterfaceFactory - class org.jdbf.engine.sql.SqlInterfaceFactory.
- Associates a name with an instance of SqlInterface.
- SqlInterfaceFactory() - Constructor for class org.jdbf.engine.sql.SqlInterfaceFactory
- SqlInterfaceFactory.SqlInterfaceEntry - class org.jdbf.engine.sql.SqlInterfaceFactory.SqlInterfaceEntry.
- Single entry of SQLInterface
- SqlInterfaceFactory.SqlInterfaceEntry(String, SqlInterface) - Constructor for class org.jdbf.engine.sql.SqlInterfaceFactory.SqlInterfaceEntry
- Creates a SQLInterfaceEntry
- SqlInterfaceFactory.SqlInterfaceMaker - interface org.jdbf.engine.sql.SqlInterfaceFactory.SqlInterfaceMaker.
- Interface that creates the SQLInterface object
- SqlServerInterface - class org.jdbf.engine.sql.SqlServerInterface.
- It's overrides SqlInterface's methods for constructing sql statements where MS SQL Server implementation differs from ANSI or is not specified by ANSI.
- SqlServerInterface() - Constructor for class org.jdbf.engine.sql.SqlServerInterface
- SybaseInterface - class org.jdbf.engine.sql.SybaseInterface.
- It's overrides SqlInterface's methods for constructing sql statements where Sybase's implementaion differs from ANSI or is not specified by ANSI.
- SybaseInterface() - Constructor for class org.jdbf.engine.sql.SybaseInterface
- select(String, RepositoryView, Connection) - Method in class org.jdbf.engine.sql.SelectStatement
- Executes the select statement and retunathe ObjectMapped object specified in obj.
- setIdentifier(String, Object[]) - Method in class org.jdbf.engine.sql.Cursor
- Creates the identifier into cache.Append the name with hashcode of values array
- sqlIfaces - Static variable in class org.jdbf.engine.sql.SqlInterfaceFactory
- List of
SqlInterfaceEntryholding the instantiated interfaces - sqlInterface - Variable in class org.jdbf.engine.sql.SqlInterfaceFactory.SqlInterfaceEntry
- SQLInterface object
- sqlInterfaces - Static variable in class org.jdbf.engine.sql.SqlInterfaceFactory
- the list of sql interfaces
- statement - Variable in class org.jdbf.engine.sql.SQLStatement
- sql statement
T
- TABLE - Static variable in class org.jdbf.engine.sql.SqlInterface
- TYPES - Static variable in class org.jdbf.engine.sql.Types
- Map type of property - sql type
- Types - class org.jdbf.engine.sql.Types.
Typesis the class that maps the type of the property with SQLType (e.g.- Types() - Constructor for class org.jdbf.engine.sql.Types
- toString() - Method in class org.jdbf.engine.sql.SQLStatement
U
- UNION - Static variable in class org.jdbf.engine.sql.SqlInterface
- UNIQUE - Static variable in class org.jdbf.engine.sql.SqlInterface
- UPDATE - Static variable in class org.jdbf.engine.sql.SqlInterface
- UPDATE - Static variable in class org.jdbf.engine.sql.UpdateStatement
- UPDATE statement
- UpdateStatement - class org.jdbf.engine.sql.UpdateStatement.
UpdateStatementis that class that represents the update sql statement.- UpdateStatement(RepositoryView, String[], Criteria) - Constructor for class org.jdbf.engine.sql.UpdateStatement
- Creates the UpdateStatement object and build the statement
- UpdateStatement() - Constructor for class org.jdbf.engine.sql.UpdateStatement
- Creates the empty object
- update(ObjectMapped, RepositoryView, Connection, String[]) - Method in class org.jdbf.engine.sql.UpdateStatement
- Executes the update statement and updates in database the ObjectMapped object specified in obj.
- updateForCriteria(RepositoryView, Connection, String[], Object[]) - Method in class org.jdbf.engine.sql.UpdateStatement
- Executes the update statement and updates in database with sql criteria.
V
- VALUES - Static variable in class org.jdbf.engine.sql.InsertStatement
- VALUES statement
- VALUES - Static variable in class org.jdbf.engine.sql.SqlInterface
- VALUES - Static variable in class org.jdbf.engine.sql.UpdateStatement
- VALUES KEYWORD
W
- WHERE - Static variable in class org.jdbf.engine.sql.SQLStatement
- identifies WHERE clause
- WHERE - Static variable in class org.jdbf.engine.sql.SqlInterface
A B C D E F G H I L M N O P Q R S T U V W
|
|||||||||
| Home >> All >> org >> jdbf >> engine >> [ sql overview ] | PREV NEXT | ||||||||