org.apache.empire.samples.db.advanced
Class SampleAdvDB
java.lang.Object
org.apache.empire.commons.ErrorObject
org.apache.empire.db.DBObject
org.apache.empire.db.DBDatabase
org.apache.empire.samples.db.advanced.SampleAdvDB
- All Implemented Interfaces:
- ErrorInfo
public class SampleAdvDB
- extends DBDatabase
This file contains the definition of the data model in Java.
The SampleDB data model consists of two tables and a foreign key relation.
The tables are defined as nested classes here, but you may put the in separate files if you want.
PLEASE NOTE THE NAMING CONVENTION:
Since all tables, views and columns are declared as "final" constants they are all in upper case.
We recommend using a prefix of T_ for tables and C_ for columns in order to keep them togehter
when listed in your IDE's code completition.
There is no need to stick to this convention but it makes life just another little bit easier.
You may declare other database tables or views in the same way.
Constructor Summary |
SampleAdvDB()
Constructor of the SampleDB data model description
Put all foreigen key realtions here. |
Methods inherited from class org.apache.empire.db.DBDatabase |
addRelation, addRelation, addRelation, addTable, addView, appendQualifiedName, checkOpen, close, closeResultSet, closeStatement, commit, createCommand, executeQuery, executeSQL, executeSQL, executeSQL, getCreateDDLScript, getDatabase, getDriver, getLinkName, getNextSequenceValue, getQualifiedName, getRelations, getSchema, getSchemaPrefix, getSystemDateExpr, getTable, getTables, getUpdateTimestamp, getValueExpr, getValueExpr, getValueExpr, getValueExpr, getValueExpr, getView, getViews, isOpen, open, queryObjectList, queryOptionList, querySimpleList, querySimpleList, querySingleDouble, querySingleDouble, querySingleInt, querySingleInt, querySingleLong, querySingleLong, querySingleString, querySingleString, querySingleValue, rollback, setLinkName, setSchema |
Methods inherited from class org.apache.empire.commons.ErrorObject |
clearError, clearErrorInfo, error, error, error, error, error, error, error, getErrorInfo, getErrorMessage, getErrorParams, getErrorSource, getErrorType, getMessage, hasError, internalSetError, isExceptionsEnabled, setExceptionsEnabled, success |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
T_DEPARTMENTS
public final SampleAdvDB.Departments T_DEPARTMENTS
T_EMPLOYEES
public final SampleAdvDB.Employees T_EMPLOYEES
T_EMP_DEP_HIST
public final SampleAdvDB.EmployeeDepartmentHistory T_EMP_DEP_HIST
V_EMP_DEP_SINCE_VIEW
public final SampleAdvDB.EmployeeDepSinceView V_EMP_DEP_SINCE_VIEW
V_EMPLOYEE_INFO
public final SampleAdvDB.EmployeeInfoView V_EMPLOYEE_INFO
SampleAdvDB
public SampleAdvDB()
- Constructor of the SampleDB data model description
Put all foreigen key realtions here.
Copyright © 2008-2009 Apache Software Foundation. All Rights Reserved.