org.apache.empire.samples.db.advanced
Class SampleAdvDB

java.lang.Object
  extended by org.apache.empire.commons.ErrorObject
      extended by org.apache.empire.db.DBObject
          extended by org.apache.empire.db.DBDatabase
              extended by 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.
 


Nested Class Summary
static class SampleAdvDB.Departments
          This class represents the definition of the Departments table.
static class SampleAdvDB.EmployeeDepartmentHistory
          This class represents the definition of the Departments table.
static class SampleAdvDB.EmployeeDepSinceView
          This class represents the definition of the EmployeeDepSinceView table.
static class SampleAdvDB.EmployeeInfoView
          This class represents the definition of the EmployeeInfoView table.
static class SampleAdvDB.Employees
          This class represents the definition of the Employees table.
 
Nested classes/interfaces inherited from class org.apache.empire.db.DBDatabase
DBDatabase.DBSystemDate
 
Nested classes/interfaces inherited from class org.apache.empire.commons.ErrorObject
ErrorObject.ObjectErrorInfo
 
Field Summary
 SampleAdvDB.Departments T_DEPARTMENTS
           
 SampleAdvDB.EmployeeDepartmentHistory T_EMP_DEP_HIST
           
 SampleAdvDB.Employees T_EMPLOYEES
           
 SampleAdvDB.EmployeeDepSinceView V_EMP_DEP_SINCE_VIEW
           
 SampleAdvDB.EmployeeInfoView V_EMPLOYEE_INFO
           
 
Fields inherited from class org.apache.empire.db.DBDatabase
driver, EMPTY_STRING, linkName, relations, schema, SYSDATE, tables, views
 
Constructor Summary
SampleAdvDB()
          Constructor of the SampleDB data model description Put all foreigen key realtions here.
 
Method Summary
 
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.db.DBObject
error, error
 
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
 

Field Detail

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
Constructor Detail

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.