public interface SQLFactory
A factory for generating SQL statements.
Modifier and Type | Interface and Description |
---|---|
static interface |
SQLFactory.Ident |
Modifier and Type | Method and Description |
---|---|
Schema |
getDefaultSchema()
Returns the
Default schema . |
java.lang.Integer |
getMaxColumnNameLength()
Returns the maximum length of a column name.
|
java.lang.Integer |
getMaxSchemaNameLength()
Returns the maximum length of a schema name.
|
java.lang.Integer |
getMaxTableNameLength()
Returns the maximum length of a table name.
|
ObjectFactory |
getObjectFactory()
Returns the object factory being used.
|
Schema |
getSchema(java.sql.Connection pConnection,
Schema.Name pName)
Reads the schema named
pName from the database. |
Schema |
getSchema(java.sql.Connection pConnection,
java.lang.String pName)
Reads the schema named
pName from the database. |
Schema |
getSchema(Schema.Name pName)
Returns the schema with the given name or null, if no such
schema exists.
|
Schema |
getSchema(java.lang.String pName)
Returns the schema with the given name or null, if no such
schema exists.
|
java.util.Iterator |
getSchemas()
Returns a list of all schemas.
|
Table |
getTable(java.sql.Connection pConnection,
Schema.Name pSchema,
Table.Name pTable)
Reads the table named
pTable from the schema
named pSchema in the database. |
Table |
getTable(java.sql.Connection pConnection,
java.lang.String pSchema,
java.lang.String pTable)
Reads the table named
pTable from the schema
named pSchema in the database. |
boolean |
isColumnNameCaseSensitive()
Returns whether column names are case sensitive or not.
|
boolean |
isSchemaNameCaseSensitive()
Returns whether schema names are case sensitive or not.
|
boolean |
isTableNameCaseSensitive()
Returns whether table names are case sensitive or not.
|
DeleteStatement |
newDeleteStatement()
Creates a new DELETE statement.
|
InsertStatement |
newInsertStatement()
Creates a new INSERT statement.
|
Schema |
newSchema(Schema.Name pName)
Creates a new
Schema with the given name. |
Schema |
newSchema(java.lang.String pName)
Creates a new
Schema with the given name. |
SelectStatement |
newSelectStatement()
Creates a new SELECT statement.
|
SQLGenerator |
newSQLGenerator()
Creates a new
SQLGenerator . |
UpdateStatement |
newUpdateStatement()
Creates a new UPDATE statement.
|
ObjectFactory getObjectFactory()
Returns the object factory being used.
java.lang.Integer getMaxTableNameLength()
Returns the maximum length of a table name.
boolean isTableNameCaseSensitive()
Returns whether table names are case sensitive or not. Defaults to false.
java.lang.Integer getMaxSchemaNameLength()
Returns the maximum length of a schema name.
boolean isSchemaNameCaseSensitive()
Returns whether schema names are case sensitive or not. Defaults to false.
java.lang.Integer getMaxColumnNameLength()
Returns the maximum length of a column name.
boolean isColumnNameCaseSensitive()
Returns whether column names are case sensitive or not. Defaults to false.
SelectStatement newSelectStatement()
Creates a new SELECT statement.
InsertStatement newInsertStatement()
Creates a new INSERT statement.
UpdateStatement newUpdateStatement()
Creates a new UPDATE statement.
DeleteStatement newDeleteStatement()
Creates a new DELETE statement.
Schema newSchema(Schema.Name pName)
Creates a new Schema
with the given name.
Schema getDefaultSchema()
Returns the Default schema
. The default
schema has the name null.
Schema getSchema(Schema.Name pName)
Returns the schema with the given name or null, if no such schema exists.
Schema getSchema(java.lang.String pName)
Returns the schema with the given name or null, if no such schema exists.
java.util.Iterator getSchemas()
Returns a list of all schemas. The list includes the default
schema, if getDefaultSchema()
was called at any time.
SQLGenerator newSQLGenerator()
Creates a new SQLGenerator
.
Schema getSchema(java.sql.Connection pConnection, Schema.Name pName) throws java.sql.SQLException
Reads the schema named pName
from the database.
java.sql.SQLException
Schema getSchema(java.sql.Connection pConnection, java.lang.String pName) throws java.sql.SQLException
Reads the schema named pName
from the database.
java.sql.SQLException
Table getTable(java.sql.Connection pConnection, Schema.Name pSchema, Table.Name pTable) throws java.sql.SQLException
Reads the table named pTable
from the schema
named pSchema
in the database.
java.sql.SQLException
Table getTable(java.sql.Connection pConnection, java.lang.String pSchema, java.lang.String pTable) throws java.sql.SQLException
Reads the table named pTable
from the schema
named pSchema
in the database.
java.sql.SQLException