Package | Description |
---|---|
org.apache.empire.db |
This package contains the core Empire-DB implementation classes.
|
org.apache.empire.db.expr.column |
This package contains SQL-generator classes for column expressions.
|
org.apache.empire.db.expr.compare |
This package contains SQL-generator classes for compare expressions used in the where and having clause.
|
org.apache.empire.db.expr.join |
This package contains SQL-generator classes for join expressions used in the from clause.
|
org.apache.empire.db.expr.order | |
org.apache.empire.db.expr.set |
This package contains SQL-generator classes for set expressions used in the set clause.
|
org.apache.empire.db.generic | |
org.apache.empire.dbms | |
org.apache.empire.dbms.h2 |
This package contains classes necessary to support the H2 database system.
|
org.apache.empire.dbms.hsql |
This package contains classes necessary to support the HSQLDB database system.
|
org.apache.empire.dbms.mysql |
This package contains classes necessary to support the MySQL database system.
|
org.apache.empire.dbms.oracle |
This package contains classes necessary to support the Oracle database system.
|
org.apache.empire.dbms.postgresql |
This package contains classes necessary to support the PostgreSQL database system.
|
org.apache.empire.dbms.sqlite | |
org.apache.empire.dbms.sqlserver |
This package contains classes necessary to support the Microsoft SQL-Server database system.
|
Modifier and Type | Class and Description |
---|---|
class |
DBCmdParam
This class defines a parameter for a prepared statement query.
|
class |
DBColumn
This is the base class for all database columns that have a physical representation.
|
class |
DBColumnExpr
This class is the base class for all expressions that represent a single value.
|
class |
DBCombinedCmd
This class is used for building up a partition of a SQL-Command.
|
class |
DBCommand
This abstract class handles the creation of the SQL-Commands.
|
class |
DBCommandExpr
This abstract class handles the creation of the SQL-Commands.
|
protected static class |
DBCommandExpr.DBCmdColumn
This class wraps a column of sql command in a special command column object.
|
protected static class |
DBCommandExpr.DBCmdQuery |
class |
DBQuery
This class can be used to wrap a query from a DBCommand and use it like a DBRowSet.
|
protected static class |
DBQuery.DBQueryExprColumn
DBQueryExprColumn
|
class |
DBQueryColumn |
class |
DBRowSet
This class is the base class for all the DBTable,
DBView and DBQuery classes this class contains all the columns of the
tables, views or queries
|
class |
DBTable
This class represent one table of the database.
|
class |
DBTableColumn
This class represent one column of a table.
|
class |
DBView
This class represents a database view.
|
static class |
DBView.DBViewColumn
DBViewColumn
|
Modifier and Type | Method and Description |
---|---|
DBExpr[] |
DBIndex.getExpressions()
Returns the columnExpressions belonging to this index.
|
DBExpr[] |
DBExpressionIndex.getExpressions()
Returns the columnExpressions belonging to this index.
|
Modifier and Type | Method and Description |
---|---|
DBCompareColExpr |
DBColumnExpr.in(DBExpr expr)
Creates and returns an expression for the SQL "not in" operator.
|
DBColumnExpr |
DBColumnExpr.indexOf(Object str,
DBExpr fromPos)
Creates and returns a sql-expression that returns the position of a string in the current column expression.
|
DBCompareColExpr |
DBColumnExpr.notIn(DBExpr expr)
Creates and returns an expression for the SQL "not in" operator.
|
DBColumnExpr |
DBColumnExpr.substring(DBExpr pos)
Creates and returns a sql-expression for the substring(...) function.
|
DBColumnExpr |
DBColumnExpr.substring(DBExpr pos,
DBExpr count)
Creates and returns a sql-expression for the substring(...) function.
|
DBColumnExpr |
DBColumnExpr.substring(DBExpr pos,
int count)
Overloaded.
|
DBColumnExpr |
DBColumnExpr.substring(int pos,
DBExpr count)
Overloaded.
|
Modifier and Type | Method and Description |
---|---|
protected void |
DBCommandExpr.addListExpr(DBSQLBuilder sql,
List<? extends DBExpr> list,
long context,
String separator)
Internally used to build a string from a list of database expressions
|
Constructor and Description |
---|
DBExpressionIndex(String name,
boolean unique,
DBExpr... columnExpressions)
Constructs a DBExpresionIndex
Overload for convenience
|
DBExpressionIndex(String name,
DBIndex.DBIndexType type,
DBExpr... columnExpressions)
Constructs a DBExpresionIndex
|
Modifier and Type | Class and Description |
---|---|
class |
DBAbstractFuncExpr
This implements some basic functionality for SQL functions based on a column expression
|
class |
DBAliasExpr
This class allows column renaming in SQL.
|
class |
DBCalcExpr
This class is used for performing calculations in SQL
It handles the mathematical operations ("+", "-", "*", "/") for the current column. |
class |
DBCaseExpr
This class represents a SQL case expression
like "case when ?
|
class |
DBCaseMapExpr
This class is used to create a SQL CASE constraint in the form of
case {expr} when {value1} then {result1}
when {value2} then {result2}
...
|
class |
DBCaseWhenExpr
This class is used to create a SQL CASE constraint in the form of
case when {cond1} then {result1}
when {cond2} then {result2}
...
|
class |
DBCmdResultExpr |
class |
DBCoalesceExpr |
class |
DBConcatExpr
This class is used for performing string concatenation in SQL
There is no need to explicitly create instances of this class. |
class |
DBConcatFuncExpr
DBConcatExpression
|
class |
DBConvertExpr
This class is used to convert a value to a different data type.
|
class |
DBCountExpr
This class is used to add the "count" statement to the SQL-Command.
|
class |
DBDecodeExpr
This class is used to decode a set of keys to the corresponding target values.
|
class |
DBFuncExpr
This class is used for performing various SQL functions on a column or column expression.
|
class |
DBParenthesisExpr
This class allows column renaming in SQL.
|
class |
DBScalarExpr
This class is used for declaring scalar functions in SQL (like e.g. random).
|
class |
DBValueExpr
This class is used for declaring constant values in SQL.
|
class |
DBVarArgsFuncExpr |
Modifier and Type | Class and Description |
---|---|
class |
DBCompareAndOrExpr
This class is used for combining two filter constraints by and / or operator
There is no need to explicitly create instances of this class. |
class |
DBCompareColExpr
This class is used for defining filter constraints based on a column expression in SQL
There is no need to explicitly create instances of this class. |
class |
DBCompareExpr
This class is a common base class for all SQL filter constraints classes
|
class |
DBCompareNotExpr
This class is used for defining filter constraints based on a column expression in SQL
There is no need to explicitly create instances of this class. |
class |
DBCompareParenthesisExpr
This class wraps an existing compare expression with parenthesis.
|
class |
DBExistsExpr
This class is used for building up the SQL-Command for the EXISTS syntax.
|
Modifier and Type | Class and Description |
---|---|
class |
DBColumnJoinExpr |
class |
DBCompareJoinExpr
This class is used for building a join expression of an SQL statement.
|
class |
DBCrossJoinExpr
This class is used for building a join expression of an SQL statement.
|
class |
DBJoinExpr
This class is used for building a join expression of an SQL statement.
|
Modifier and Type | Class and Description |
---|---|
class |
DBOrderByExpr |
Modifier and Type | Class and Description |
---|---|
class |
DBSetExpr
This class is used for building a set expression of a SQL update statement.
|
Modifier and Type | Class and Description |
---|---|
class |
TTable<DB extends TDatabase<DB>> |
class |
TView<DB extends TDatabase<DB>> |
Modifier and Type | Class and Description |
---|---|
static class |
DBMSHandlerBase.DBMSCommand
DBMSCommand
A Default DBCommand implementation with no additional features
|
static class |
DBMSHandlerBase.DBSeqTable
This class is used to emulate sequences by using a sequence table.
|
Modifier and Type | Class and Description |
---|---|
static class |
DBMSHandlerH2.DBCommandH2
Defines the H2 command type.
|
Modifier and Type | Class and Description |
---|---|
class |
DBCommandHSql
This class handles the special features of an HSqlDB database.
|
Modifier and Type | Class and Description |
---|---|
static class |
DBMSHandlerMySQL.DBCommandMySQL
Defines the MySQL command type.
|
Modifier and Type | Class and Description |
---|---|
class |
DBCommandOracle
This class handles the special features of an oracle database.
|
class |
OracleRowNumExpr
implements a column expression for the Oracle rownum function
|
static class |
OracleSYSDatabase.DBColComments |
static class |
OracleSYSDatabase.DBColInfo |
static class |
OracleSYSDatabase.DBConstraints |
static class |
OracleSYSDatabase.DBTabComments |
static class |
OracleSYSDatabase.DBUserConCol |
Modifier and Type | Method and Description |
---|---|
protected void |
OracleDDLGenerator.createComment(DBDatabase db,
String type,
DBExpr expr,
String comment,
DBSQLScript script) |
Modifier and Type | Class and Description |
---|---|
class |
DBCommandPostgres
Defines the PostgreSQL command type.
|
class |
PostgresAtAt
PostgresAtAt
create a Postgres @@ comparator
|
class |
PostgresBoolAndOrExpr |
class |
PostgresFuncExpr |
class |
PostgresIntervalExpr |
Modifier and Type | Class and Description |
---|---|
static class |
DBMSHandlerSQLite.DBCommandSQLite
Defines the SQLite command type.
|
Modifier and Type | Class and Description |
---|---|
static class |
DBMSHandlerMSSQL.DBCommandMSSQL
Provides a DBCommand implementation for Microsoft SQL-Server
|
Copyright © 2008–2023 Apache Software Foundation. All rights reserved.