Overview  Package   Class  Use  Deprecated  Index
Home >> All >> org >> jdbf >> engine >> [ sql overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---

org.jdbf.engine.sql
Class SqlInterface  

java.lang.Object
  org.jdbf.engine.sql.SqlInterface

All Implemented Interfaces:

java.io.Serializable

Direct Known Subclasses:

HsqlInterface, InformixInterface, InterbaseInterface, MySQLInterface, OracleInterface, PostgreSQLInterface, SqlServerInterface

---

public class SqlInterface

extends java.lang.Object

implements java.io.Serializable

This class implements a part of RelationalDatabase It provides methods to build sql strings and statements and to convert data values into sql strings. It supports the ANSI standard SQL clauses. Subclasses will override the appropriate method to support extensions to ANSI SQL. Giovanni Martone

---

Field Summary
static java.lang.String	AND
static java.lang.String	ASC
static java.lang.String	ASSIGNMENT
static java.lang.String	BETWEEN
static java.lang.String	CREATE
static java.lang.String	DELETE
static java.lang.String	DESC
static java.lang.String	DISTINCT
static java.lang.String	DROP
static java.lang.String	EQUAL
static java.lang.String	FROM
static java.lang.String	GREATER_OR_EQUAL
static java.lang.String	GREATER_THAN
static java.lang.String	GROUP_BY
static java.lang.String	HAVING
static java.lang.String	INSERT
static java.lang.String	LESS_OR_EQUAL
static java.lang.String	LESS_THAN
static java.lang.String	LIKE
static java.lang.String	MAX
static java.lang.String	NEXTVAL
static java.lang.String	NOT_EQUAL
static java.lang.String	NOT_EXISTS
static java.lang.String	NULL
static java.lang.String	OR
static java.lang.String	ORDER_BY
static java.lang.String	PARAMETER
static java.lang.String	SELECT
static java.lang.String	SELECT_ALL
static java.lang.String	SET
static java.lang.String	TABLE
static java.lang.String	UNION
static java.lang.String	UNIQUE
static java.lang.String	UPDATE
static java.lang.String	VALUES
static java.lang.String	WHERE

 

Constructor Summary

SqlInterface()

 

Method Summary
java.lang.String	getClauseStringCurrentTimeStamp()           Return the cluase of current timeStamp
java.lang.String	getColumnDefinition(java.lang.String name, java.lang.String type, boolean isNullable)           returns the definition of column given name, given type,given isNullable
(package private)  java.lang.String	getCountStatement(java.lang.String tableName)           Forms an sql statement which counts records in the given table which statisfy the given search condition.
(package private)  java.lang.String	getCountStatement(java.lang.String tableName, java.lang.String condition)           Forms an sql statement which counts records in the given table which statisfy the given search condition.
java.lang.String	getCreateTableStatement(java.lang.String tableName, java.lang.String columns)           Forms an sql statement the create the table given tableName,column
java.lang.String	getCurrentTimeStampStatement()           Forms an sql statement the return a current timestamp
java.lang.String	getDropTableStatement(java.lang.String tableName)           Forms an sql statement the drop the table given tableName
java.lang.String	getInsertStatement(java.lang.String tableName, java.lang.String columns, java.lang.String values)           Forms an sql insert statement for a given table, given columns, and given values.
java.lang.String	getSelectCountAll()           Return the COUNT(*) statement
java.lang.String	getSelectInsertIdStatement()           Forms an sql insert id statement This method throws an MappingExcpetion because for a generic sql interface the inset id feature is not supported.
java.lang.String	getSelectSequenceStatement(java.lang.String name)           Forms an sql sequence statement given name This method throws an MappingExcpetion because for a generic sql interface the sequence feature is not supported.
java.lang.String	getSelectStatement(java.lang.String tableName, java.lang.String fields)           Forms an sql select statement for a given table,given fileds
java.lang.String	getSelectStatement(java.lang.String tableName, java.lang.String fields, java.lang.String condition)           Forms an sql select statement for a given table, given fields, and given criteria.
java.lang.String	getUpdateStatement(java.lang.String tableName, java.lang.String columnsEqual, java.lang.String condition)           Forms an sql update statement for a given table, given columns, and given values.

 

Methods inherited from class java.lang.Object

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

 

Field Detail

INSERT

public static java.lang.String INSERT

---

SELECT_ALL

public static java.lang.String SELECT_ALL

---

SELECT

public static java.lang.String SELECT

---

DELETE

public static java.lang.String DELETE

---

UPDATE

public static java.lang.String UPDATE

---

FROM

public static java.lang.String FROM

---

WHERE

public static java.lang.String WHERE

---

ORDER_BY

public static java.lang.String ORDER_BY

---

SET

public static java.lang.String SET

---

VALUES

public static java.lang.String VALUES

---

AND

public static java.lang.String AND

---

OR

public static java.lang.String OR

---

EQUAL

public static java.lang.String EQUAL

---

NOT_EQUAL

public static java.lang.String NOT_EQUAL

---

GREATER_THAN

public static java.lang.String GREATER_THAN

---

GREATER_OR_EQUAL

public static java.lang.String GREATER_OR_EQUAL

---

LESS_THAN

public static java.lang.String LESS_THAN

---

LESS_OR_EQUAL

public static java.lang.String LESS_OR_EQUAL

---

LIKE

public static java.lang.String LIKE

---

BETWEEN

public static java.lang.String BETWEEN

---

GROUP_BY

public static java.lang.String GROUP_BY

---

HAVING

public static java.lang.String HAVING

---

UNION

public static java.lang.String UNION

---

DISTINCT

public static java.lang.String DISTINCT

---

NOT_EXISTS

public static java.lang.String NOT_EXISTS

---

UNIQUE

public static java.lang.String UNIQUE

---

NULL

public static java.lang.String NULL

---

PARAMETER

public static java.lang.String PARAMETER

---

MAX

public static java.lang.String MAX

---

NEXTVAL

public static java.lang.String NEXTVAL

---

ASSIGNMENT

public static java.lang.String ASSIGNMENT

---

ASC

public static java.lang.String ASC

---

DESC

public static java.lang.String DESC

---

TABLE

public static java.lang.String TABLE

---

CREATE

public static java.lang.String CREATE

---

DROP

public static java.lang.String DROP

Constructor Detail

SqlInterface

public SqlInterface()

Method Detail

getClauseStringCurrentTimeStamp

public java.lang.String getClauseStringCurrentTimeStamp()
                                                 throws org.jdbf.engine.mapping.MappingException

Return the cluase of current timeStamp

---

getColumnDefinition

public java.lang.String getColumnDefinition(java.lang.String name,
                                            java.lang.String type,
                                            boolean isNullable)

returns the definition of column given name, given type,given isNullable

---

getCountStatement

java.lang.String getCountStatement(java.lang.String tableName)

Forms an sql statement which counts records in the given table which statisfy the given search condition.

---

getCountStatement

java.lang.String getCountStatement(java.lang.String tableName,
                                   java.lang.String condition)

Forms an sql statement which counts records in the given table which statisfy the given search condition.

---

getCurrentTimeStampStatement

public java.lang.String getCurrentTimeStampStatement()
                                              throws org.jdbf.engine.mapping.MappingException

Forms an sql statement the return a current timestamp

---

getCreateTableStatement

public java.lang.String getCreateTableStatement(java.lang.String tableName,
                                                java.lang.String columns)

Forms an sql statement the create the table given tableName,column

---

getDropTableStatement

public java.lang.String getDropTableStatement(java.lang.String tableName)

Forms an sql statement the drop the table given tableName

---

getInsertStatement

public java.lang.String getInsertStatement(java.lang.String tableName,
                                           java.lang.String columns,
                                           java.lang.String values)

Forms an sql insert statement for a given table, given columns, and given values.

---

getSelectCountAll

public java.lang.String getSelectCountAll()

Return the COUNT(*) statement

---

getSelectInsertIdStatement

public java.lang.String getSelectInsertIdStatement()
                                            throws org.jdbf.engine.mapping.MappingException

Forms an sql insert id statement This method throws an MappingExcpetion because for a generic sql interface the inset id feature is not supported.

---

getSelectStatement

public java.lang.String getSelectStatement(java.lang.String tableName,
                                           java.lang.String fields,
                                           java.lang.String condition)

Forms an sql select statement for a given table, given fields, and given criteria.

---

getSelectStatement

public java.lang.String getSelectStatement(java.lang.String tableName,
                                           java.lang.String fields)

Forms an sql select statement for a given table,given fileds

---

getSelectSequenceStatement

public java.lang.String getSelectSequenceStatement(java.lang.String name)
                                            throws org.jdbf.engine.mapping.MappingException

Forms an sql sequence statement given name This method throws an MappingExcpetion because for a generic sql interface the sequence feature is not supported.

---

getUpdateStatement

public java.lang.String getUpdateStatement(java.lang.String tableName,
                                           java.lang.String columnsEqual,
                                           java.lang.String condition)

Forms an sql update statement for a given table, given columns, and given values.

---

Overview  Package   Class  Use  Deprecated  Index
Home >> All >> org >> jdbf >> engine >> [ sql overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---