Uses of Class
org.apache.empire.db.DBRowSet
Packages that use DBRowSet
Package
Description
This package contains implmentations of Empire's data and metadata interfaces for JavaBeans of Data Tranfer Objects (DTO's).
This package contains the core Empire-DB implementation classes.
This package contains classes for exception handling of database related errors.
This package contains SQL-generator classes for column expressions.
This package contains SQL-generator classes for compare expressions used in the where and having clause.
This package contains SQL-generator classes for join expressions used in the from clause.
This package contains SQL-generator classes for set expressions used in the set clause.
This package contains classes necessary to support the HSQLDB database system.
This package contains classes necessary to support the MySQL database system.
This package contains classes necessary to support the Oracle database system.
This package contains classes necessary to support the PostgreSQL database system.
This package contains classes for exception handling of general errors.
-
Uses of DBRowSet in org.apache.empire.data.bean
Methods in org.apache.empire.data.bean with parameters of type DBRowSetModifier and TypeMethodDescriptionprotected voidBeanResult.autoSelectColumns(DBRowSet rowset) Selects all columns for a given rowsetConstructors in org.apache.empire.data.bean with parameters of type DBRowSetModifierConstructorDescriptionBeanResult(Class<T> beanType, DBRowSet rowset) Creates a bean result for a Table, View or Query from the supplied columns. -
Uses of DBRowSet in org.apache.empire.db
Subclasses of DBRowSet in org.apache.empire.dbModifier and TypeClassDescriptionprotected static classclassThis class can be used to wrap a query from a DBCommand and use it like a DBRowSet.
You may use this class for two purposes: In oder to define subqueries simply define a command object with the subquery and wrap it inside a DBQuery.classThis class represent one table of the database.classThis class represents a database view.Fields in org.apache.empire.db declared as DBRowSetModifier and TypeFieldDescriptionprotected final DBRowSetDBColumn.rowsetprotected final DBRowSetDBRecord.rowsetprotected DBRowSetDBRecordBean.rowsetFields in org.apache.empire.db with type parameters of type DBRowSetMethods in org.apache.empire.db with type parameters of type DBRowSetModifier and TypeMethodDescriptionprotected <T extends DBRowSet>
voidDBRowSet.initClonedFields(T clone) Clone columnsMethods in org.apache.empire.db that return DBRowSetModifier and TypeMethodDescriptionDBColumn.getRowSet()Returns DBTable, DBQuery or DBView object.abstract DBRowSetDBColumnExpr.getRowSet()Returns the underlying rowset containing this column For functions involving none or more than one physical column this function return the first oneFinds a DBRowSet object (DBTable or DBView) by name.DBRecord.getRowSet()Returns the DBRowSet object.abstract DBRowSetDBRecordBase.getRowSet()Returns the DBRowSet object.DBRecordBean.getRowSet()Returns the DBRowSet object.DBDatabase.getRowSetByAlias(String alias) Finds a RowSet object by the alias name.protected DBRowSetDBRecord.readRowSet(ObjectInputStream strm) Methods in org.apache.empire.db that return types with arguments of type DBRowSetModifier and TypeMethodDescriptionDBDatabase.getAllRowSets()Returns all DBRowSet instances currently created for this databaseDBCommand.getRowSetList()Gets a list of all tables referenced by the query.Methods in org.apache.empire.db with parameters of type DBRowSetModifier and TypeMethodDescriptionprotected voidDBCommand.addDeleteForTable(DBSQLBuilder sql, DBRowSet table) protected voidDBCommand.addDeleteWithJoins(DBSQLBuilder sql, DBRowSet table) voidDBCommand.addKeyConstraints(DBRowSet rowset, RecordData data) Adds key constraints the commandprotected voidDBDatabase.addRowsetToAliasMap(DBRowSet rowset) adds a DBRowSet to the alias mapprotected voidDBCommand.addUpdateForTable(DBSQLBuilder sql, DBRowSet table) protected voidDBCommand.addUpdateWithJoins(DBSQLBuilder sql, DBRowSet table) protected voidDBCommand.appendCompareColExprs(DBRowSet table, DBCompareExpr expr, List<DBCompareColExpr> list) Appends all nested DBCompareColExpr for a particular RowSet to a listprotected DBColumnDBCommandExpr.DBCmdQuery.cloneColumn(DBRowSet clone, DBColumn scourceColumn) throws ERR_NOTSUPPORTEDprotected DBColumnDBQuery.cloneColumn(DBRowSet clone, DBColumn scourceColumn) protected abstract DBColumnDBRowSet.cloneColumn(DBRowSet clone, DBColumn scourceColumn) Clones a RowSet columnprotected DBColumnDBTable.cloneColumn(DBRowSet clone, DBColumn sourceColumn) protected DBColumnDBView.cloneColumn(DBRowSet clone, DBColumn sourceColumn) protected DBIndexDBTable.clonePrimaryKey(DBRowSet clone) Creates a new recordCreates a new recordprotected <R extends DBRecordBase>
DBRecordListFactory<R>DBUtils.createDefaultRecordListFactory(Class<R> recordClass, DBRowSet rowset) Crates a default DBRecordListFactory for a DBRecord class The DBRecord class must provide the following constructor DBRecord(DBContext context, DBRowSet rowset)<T> DBBeanListFactory<T>DBUtils.getRowsetBeanListFactory(Class<T> beanType, DBRowSet rowset) gets or creates DBBeanListFactory for the given rowsetbooleanDBCommand.hasConstraintOn(DBRowSet rowset) Returns true if the command has a constraint on the given table or false otherwise.booleanReturns true if the command has a join on the given table or false otherwise.booleanCompares the rowset to another oneprotected booleanDBDatabase.isSameRowSet(DBRowSet first, DBRowSet second) Checks if two Rowsets with the same name are equal and just another instancefinal DBCommandAdds a cross join for two tables or views New in release 3.1: Use left.on(right)) insteadfinal DBCommandDBCommand.join(DBRowSet rowset, DBCompareExpr cmp) Adds an inner join based on a compare expression to the command.final DBCommandDBCommand.join(DBRowSet rowset, DBCompareExpr cmp, DBJoinType joinType) Adds a join based on a compare expression to the command.Creates a cross join expressionfinal <T> TQueries a single bean based on primary key valuesfinal <T> TDBUtils.queryBean(Class<T> beanType, DBRowSet rowset, DBCompareExpr whereConstraints) Queries a single bean based on a where constraint<T> List<T>DBUtils.queryBeanList(DBCommandExpr cmd, Class<T> beanType, DBRowSet rowset, Object parent) Queries a list of Java beans for a given commandDBUtils.queryRecordList(DBCommand cmd, DBRowSet rowset) Executes a query and returns a list of DBRecord itemsfinal <R extends DBRecordBase>
List<R>DBUtils.queryRecordList(DBCommand cmd, DBRowSet rowset, Class<R> recordType) Executes a query and returns a list of DBRecord itemsReads a record from the database This method can only be used for tables with a single primary keyReads a record from the databaseDBRecordBean.read(DBContext context, DBRowSet rowset, Object[] key, DBRowSet.PartialMode mode, DBColumn... columns) Reads a record partially i.e. not with all but just some selected fields There are two modes: 1.DBRecordBean.read(DBContext context, DBRowSet rowset, DBCompareExpr whereConstraints) Reads a record from the databasebooleanDBCommand.removeJoinsOn(DBRowSet rowset) removes all joins to a given table or viewprotected voidDBDatabase.removeRowsetFromAliasMap(DBRowSet rowset) removes a rowset from the alias mapvoidDBCommand.setParentTables(DBRowSet... rowSets) Set parent tables for subquery command generation.Constructors in org.apache.empire.db with parameters of type DBRowSetModifierConstructorDescriptionDBCmdColumn(DBRowSet query, DBColumnExpr expr) Constructs a new DBCmdColumn objectprotectedConstructs a DBColumn object and set the specified parameters to this object.Constructs a new DBRecord.protectedInternal constructor for DBRecord May be used by derived classes to provide special behaviourDBTriggerGeneratedValue(DBRowSet table, String triggerName, DBTableColumn[] sourceColumns) -
Uses of DBRowSet in org.apache.empire.db.exceptions
Methods in org.apache.empire.db.exceptions with parameters of type DBRowSetModifier and TypeMethodDescriptionprotected static StringRecordException.rowsetName(DBRowSet rowset) Constructors in org.apache.empire.db.exceptions with parameters of type DBRowSetModifierConstructorDescriptionInvalidKeyException(DBRowSet rowset, Object[] key) NoPrimaryKeyException(DBRowSet rowset) RecordDeleteFailedException(DBRowSet rowset, Object[] key) RecordNotFoundException(DBRowSet rowset, Object[] key) RecordUpdateAmbiguousException(DBRowSet rowset, Object[] key) RecordUpdateFailedException(DBRowSet rowset, Object[] key) -
Uses of DBRowSet in org.apache.empire.db.expr.column
Methods in org.apache.empire.db.expr.column that return DBRowSetModifier and TypeMethodDescriptionDBAbstractFuncExpr.getRowSet()Returns the underlying rowsetDBAliasExpr.getRowSet()Returns the underlying rowsetDBCalcExpr.getRowSet()Returns the underlying rowsetDBCaseExpr.getRowSet()DBCmdResultExpr.getRowSet()DBConcatExpr.getRowSet()Returns the underlying rowsetDBCountExpr.getRowSet()Returns the underlying rowsetDBParenthesisExpr.getRowSet()Returns the underlying rowsetDBScalarExpr.getRowSet()Returns null.DBValueExpr.getRowSet()Returns null.DBVarArgsFuncExpr.getRowSet()Returns the underlying rowsetConstructors in org.apache.empire.db.expr.column with parameters of type DBRowSet -
Uses of DBRowSet in org.apache.empire.db.expr.compare
Methods in org.apache.empire.db.expr.compare that return DBRowSetModifier and TypeMethodDescriptionDBCompareAndOrExpr.getRowSet()Returns the underlying rowset containing this columnDBCompareColExpr.getRowSet()Returns the underlying rowset containing this columnabstract DBRowSetDBCompareExpr.getRowSet()Returns the underlying rowset containing this column For functions involving none or more than one physical column this function return the first oneDBCompareNotExpr.getRowSet()Returns the underlying rowset containing this columnDBCompareParenthesisExpr.getRowSet()DBExistsExpr.getRowSet()Returns the underlying rowset containing this column -
Uses of DBRowSet in org.apache.empire.db.expr.join
Fields in org.apache.empire.db.expr.join declared as DBRowSetModifier and TypeFieldDescriptionprotected DBRowSetDBCrossJoinExpr.leftprotected DBRowSetDBCrossJoinExpr.rightMethods in org.apache.empire.db.expr.join that return DBRowSetModifier and TypeMethodDescriptionDBColumnJoinExpr.getLeftTable()DBCrossJoinExpr.getLeftTable()returns the RowSet on the left of the joinabstract DBRowSetDBJoinExpr.getLeftTable()returns the RowSet on the left of the joinDBColumnJoinExpr.getOuterTable()Returns the left table name if the data type= JOIN_LEFT and returns the right table if the data type= JOIN_RIGHT.DBCrossJoinExpr.getOuterTable()Returns the left table name if the data type= JOIN_LEFT and returns the right table if the data type= JOIN_RIGHT.abstract DBRowSetDBJoinExpr.getOuterTable()Returns the left table name if the data type= JOIN_LEFT and returns the right table if the data type= JOIN_RIGHT.DBColumnJoinExpr.getRightTable()returns the RowSet on the right of the joinDBCrossJoinExpr.getRightTable()returns the RowSet on the right of the joinabstract DBRowSetDBJoinExpr.getRightTable()returns the RowSet on the right of the joinMethods in org.apache.empire.db.expr.join with parameters of type DBRowSetModifier and TypeMethodDescriptionbooleanreturns true if this join is using the given table or view or false otherwisebooleanreturns true if this join is using the given table or view or false otherwiseabstract booleanreturns true if this join is using the given table or view or false otherwiseConstructors in org.apache.empire.db.expr.join with parameters of type DBRowSetModifierConstructorDescriptionDBCompareJoinExpr(DBRowSet rset, DBCompareExpr cmp, DBJoinType joinType) Constructs a new DBJoinExprExDBCrossJoinExpr(DBRowSet left, DBRowSet right) Constructs a new DBJoinExpr object initialize this object with the left and right column and the data type of the join expression. -
Uses of DBRowSet in org.apache.empire.db.expr.set
Methods in org.apache.empire.db.expr.set that return DBRowSet -
Uses of DBRowSet in org.apache.empire.db.generic
Classes in org.apache.empire.db.generic with type parameters of type DBRowSetSubclasses of DBRowSet in org.apache.empire.db.genericModifier and TypeClassDescriptionclassclassFields in org.apache.empire.db.generic declared as DBRowSet -
Uses of DBRowSet in org.apache.empire.db.list
Fields in org.apache.empire.db.list declared as DBRowSetConstructors in org.apache.empire.db.list with parameters of type DBRowSetModifierConstructorDescriptionDBRecordListFactoryImpl(Class<T> recordClass, Class<? extends DBContext> contextClass, DBRowSet rowset) Constructs a DBRecordListFactoryImpl based on an DBRecord classDBRecordListFactoryImpl(Constructor<T> constructor, DBRowSet rowset) Constructs a DBRecordListFactoryImpl based on an DBRecord constructor -
Uses of DBRowSet in org.apache.empire.db.validation
Fields in org.apache.empire.db.validation with type parameters of type DBRowSetMethods in org.apache.empire.db.validation that return DBRowSetMethods in org.apache.empire.db.validation that return types with arguments of type DBRowSetMethods in org.apache.empire.db.validation with parameters of type DBRowSet -
Uses of DBRowSet in org.apache.empire.dbms
Subclasses of DBRowSet in org.apache.empire.dbmsModifier and TypeClassDescriptionstatic classThis class is used to emulate sequences by using a sequence table. -
Uses of DBRowSet in org.apache.empire.dbms.hsql
Methods in org.apache.empire.dbms.hsql with parameters of type DBRowSetModifier and TypeMethodDescriptionprotected voidDBCommandHSql.addUpdateWithJoins(DBSQLBuilder sql, DBRowSet table) -
Uses of DBRowSet in org.apache.empire.dbms.mysql
Methods in org.apache.empire.dbms.mysql with parameters of type DBRowSetModifier and TypeMethodDescriptionprotected voidDBMSHandlerMySQL.DBCommandMySQL.addDeleteWithJoins(DBSQLBuilder sql, DBRowSet table) -
Uses of DBRowSet in org.apache.empire.dbms.oracle
Subclasses of DBRowSet in org.apache.empire.dbms.oracleModifier and TypeClassDescriptionstatic classstatic classstatic classstatic classstatic classMethods in org.apache.empire.dbms.oracle that return DBRowSetMethods in org.apache.empire.dbms.oracle with parameters of type DBRowSetModifier and TypeMethodDescriptionprotected voidDBCommandOracle.addDeleteForTable(DBSQLBuilder sql, DBRowSet table) protected voidDBCommandOracle.addDeleteWithJoins(DBSQLBuilder sql, DBRowSet table) protected voidDBCommandOracle.addUpdateForTable(DBSQLBuilder sql, DBRowSet table) protected voidDBCommandOracle.addUpdateWithJoins(DBSQLBuilder sql, DBRowSet table) -
Uses of DBRowSet in org.apache.empire.dbms.postgresql
Methods in org.apache.empire.dbms.postgresql that return DBRowSetModifier and TypeMethodDescriptionPostgresAtAt.getRowSet()PostgresBoolAndOrExpr.getRowSet()PostgresIntervalExpr.getRowSet()Methods in org.apache.empire.dbms.postgresql with parameters of type DBRowSetModifier and TypeMethodDescriptionprotected voidDBCommandPostgres.addUpdateWithJoins(DBSQLBuilder sql, DBRowSet table) -
Uses of DBRowSet in org.apache.empire.exceptions
Constructors in org.apache.empire.exceptions with parameters of type DBRowSet