Package | Description |
---|---|
de.esprit.appsuite.database.dbase |
Contains most of the database related classes.
|
de.esprit.appsuite.database.dbase.tools |
Contains general purpose database tools.
|
de.esprit.appsuite.database.dbgui.list |
Contains the DBList component for visualizing DBRecord instances in a list.
|
de.esprit.appsuite.database.dbgui.table |
Contains the DBTable component for visualizing DBRecord instances in a table.
|
de.esprit.appsuite.database.dbo |
Contains a set of standard DBObjects for testing purposes.
|
de.esprit.appsuite.database.xml |
Contains support tools for advanced XML reading/writing
|
de.esprit.netsuite.client.abo |
Contains the client's support classes for ABOs (Alive Business Objects)
|
de.esprit.netsuite.client.gui.db |
Contains the client's support classes for managing remote Records
|
de.esprit.netsuite.client.net |
Contains GUI gui components for network controlling and monitoring
|
de.esprit.netsuite.netdata.agent.database |
Contains database related network agents for reading/writing records from/to the database
|
de.esprit.netsuite.server.abo |
Contains server classes for working with Alive Business Objects (ABOs)
|
de.esprit.netsuite.server.batch |
Contains classes that implement and manage the available server processes
|
Modifier and Type | Method and Description |
---|---|
void |
SqlCondition.add(SqlCondition condition)
Same as
and(SqlCondition) |
void |
SqlCondition.and(SqlCondition condition)
Adds a nested condition that will be ANDed.
|
int |
DBObject.dbCountRecords(SqlCondition cond)
Counts the number of records in the table by issuing a
select count(*) from ...
|
int |
DBObject.dbDelete(SqlCondition condition)
Performs a conditional deletion of all DBObjects of the given type, that
match the given condition.
|
void |
DBRecordWrapper.dbLoad(DBLoadMonitor monitor,
SqlCondition condition) |
void |
DBPersistent.dbLoad(DBLoadMonitor monitor,
SqlCondition condition)
Reads a set of objects from from the database according to the given condition.
|
void |
DBObject.dbLoad(DBLoadMonitor monitor,
SqlCondition condition)
|
void |
ComposedRecord.dbLoad(DBLoadMonitor monitor,
SqlCondition condition) |
void |
DBRecordWrapper.dbLoad(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
void |
DBPersistent.dbLoad(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order)
Reads a set of objects from from the database according to the given condition and order.
|
void |
DBObject.dbLoad(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order)
Loads records according to the given condition and order.
|
void |
ComposedRecord.dbLoad(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order)
Performs a monitored load of records.
|
void |
LocalDatabase.dbLoadRecords(DBRecord master,
DBLoadMonitor monitor,
SqlCondition condition) |
void |
Database.dbLoadRecords(DBRecord master,
DBLoadMonitor monitor,
SqlCondition condition)
|
void |
LocalDatabase.dbLoadRecords(DBRecord master,
DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
void |
Database.dbLoadRecords(DBRecord master,
DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order)
Performs a database request to load records of the given type with the given condition and
order.
|
void |
DBRecordWrapper.dbSearch(DBLoadMonitor monitor,
SqlCondition condition) |
void |
DBPersistent.dbSearch(DBLoadMonitor monitor,
SqlCondition condition)
Reads a set of objects from from the database according to the given condition.
|
void |
DBObject.dbSearch(DBLoadMonitor monitor,
SqlCondition condition)
|
void |
ComposedRecord.dbSearch(DBLoadMonitor monitor,
SqlCondition condition) |
void |
DBRecordWrapper.dbSearch(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
void |
DBPersistent.dbSearch(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order)
Reads a set of objects from from the database according to the given condition and order.
|
void |
DBObject.dbSearch(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order)
|
void |
ComposedRecord.dbSearch(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
R[] |
DBRecordWrapper.dbSearch(SqlCondition condition) |
DBRecord[] |
DBObject.dbSearch(SqlCondition condition)
|
DBRecord[] |
ComposedRecord.dbSearch(SqlCondition condition) |
<R extends DBRecord> |
DBPersistent.dbSearch(SqlCondition condition)
Reads a set of objects from from the database according to the given condition.
|
R[] |
DBRecordWrapper.dbSearch(SqlCondition condition,
SqlOrder order) |
DBRecord[] |
DBObject.dbSearch(SqlCondition condition,
SqlOrder order)
|
DBRecord[] |
ComposedRecord.dbSearch(SqlCondition condition,
SqlOrder order) |
<R extends DBRecord> |
DBPersistent.dbSearch(SqlCondition condition,
SqlOrder order)
Reads a set of objects from from the database according to
the given condition and order.
|
DBRecord[] |
LocalDatabase.dbSearchRecords(DBRecord master,
SqlCondition condition,
SqlOrder order) |
DBRecord[] |
Database.dbSearchRecords(DBRecord master,
SqlCondition condition,
SqlOrder order)
Performs a database request to select
ComposedRecord instances by a
SqlCondition that may contain fields of different record parts (the composing
DBObjects). |
R[] |
DBRecordWrapper.dbSelect(SqlCondition condition) |
DBRecord[] |
DBObject.dbSelect(SqlCondition condition)
Reads all records that match the given condition,
ordered by primary key.
|
DBRecord[] |
ComposedRecord.dbSelect(SqlCondition condition) |
<R extends DBRecord> |
DBPersistent.dbSelect(SqlCondition condition)
Reads a set of objects from from the database according to the given condition.
|
R[] |
DBRecordWrapper.dbSelect(SqlCondition condition,
SqlOrder order) |
DBRecord[] |
DBObject.dbSelect(SqlCondition condition,
SqlOrder order)
Reads all records that match the given condition,
ordered by the given order clause.
|
DBRecord[] |
ComposedRecord.dbSelect(SqlCondition condition,
SqlOrder order)
Reads ComposedRecord instances from the database.
|
<R extends DBRecord> |
DBPersistent.dbSelect(SqlCondition condition,
SqlOrder order)
Reads a set of objects from from the database according to the given condition and order.
|
DBRecord[] |
LocalDatabase.dbSelectRecords(DBRecord master,
SqlCondition condition) |
DBRecord[] |
Database.dbSelectRecords(DBRecord master,
SqlCondition condition)
|
DBRecord[] |
LocalDatabase.dbSelectRecords(DBRecord master,
SqlCondition condition,
SqlOrder order) |
DBRecord[] |
Database.dbSelectRecords(DBRecord master,
SqlCondition condition,
SqlOrder order)
Performs a database request to read records of the given type with the given condition and
order.
|
int |
DBSupport.deleteRecords(java.lang.String tableName,
SqlCondition condition)
Deletes the records from the given table with the given condition
|
void |
SqlCondition.or(SqlCondition condition)
Adds a nested condition that will be ORed.
|
int |
DBSupport.readMaxValue(java.lang.String table,
java.lang.String column,
SqlCondition cond)
Reads the maximum value in the given table column.
|
int |
DBSupport.updateColumnValue(java.lang.String tableName,
java.lang.String columnName,
java.lang.String columnValue,
SqlCondition condition)
Update a table column with the given value in all records that match the given condition
|
Constructor and Description |
---|
DBLoadTask(C ctx,
DBRecord master,
SqlCondition condition) |
DBLoadTask(C ctx,
DBRecord master,
SqlCondition condition,
SqlOrder order) |
RecordIterator(DBObject master,
SqlCondition condition) |
RecordIterator(DBObject master,
SqlCondition condition,
SqlOrder order) |
SqlCondition(SqlCondition cond) |
Modifier and Type | Method and Description |
---|---|
SqlCondition |
UnlExportCLP.getSqlCondition() |
Modifier and Type | Method and Description |
---|---|
void |
DBRecordListModel.load(SqlCondition condition) |
void |
DBRecordList.load(SqlCondition condition) |
void |
DBRecordListModel.load(SqlCondition condition,
SqlOrder order) |
void |
DBRecordList.load(SqlCondition condition,
SqlOrder order) |
Modifier and Type | Method and Description |
---|---|
void |
DBRecordTableModel.load(SqlCondition condition)
Loads the table with all records
that match the given
SqlCondition . |
void |
DBRecordTable.load(SqlCondition condition)
Delegates to the DBTableModel.
|
void |
DBRecordTablePanel.load(SqlCondition condition,
SqlOrder order)
Delegates to the DBTable.
|
void |
DBRecordTableModel.load(SqlCondition condition,
SqlOrder order)
Loads the table the given
SqlCondition
and SqlOrder . |
void |
DBRecordTable.load(SqlCondition condition,
SqlOrder order)
Delegates to the DBTableModel.
|
void |
DBRecordTablePanel.search(SqlCondition condition,
SqlOrder order)
Delegates to the DBTable.
|
void |
DBRecordTableModel.search(SqlCondition condition,
SqlOrder order)
Loads the table content by performing a join on all involved tables
if the the managed DBRecord is a ComposedRecord.
|
void |
DBRecordTable.search(SqlCondition condition,
SqlOrder order)
Delegates to the DBTableModel.
|
void |
DBRecordTableFrame.searchRecords(SqlCondition condition,
SqlOrder order) |
void |
DBRecordTableDialog.searchRecords(SqlCondition condition,
SqlOrder order) |
Modifier and Type | Method and Description |
---|---|
static int |
DBO_tnt_tank.countRecords(SqlCondition cond) |
static int |
DBO_tnt_stdtype.countRecords(SqlCondition cond) |
static int |
DBO_tnt_route_vertex.countRecords(SqlCondition cond) |
static int |
DBO_tnt_route.countRecords(SqlCondition cond) |
static int |
DBO_tnt_pk_composed.countRecords(SqlCondition cond) |
static int |
DBO_tnt_pktype.countRecords(SqlCondition cond) |
static int |
DBO_tnt_persistent_type.countRecords(SqlCondition cond) |
static int |
DBO_tnt_nopk.countRecords(SqlCondition cond) |
static int |
DBO_tnt_logmsg.countRecords(SqlCondition cond) |
static int |
DBO_tnt_alltype.countRecords(SqlCondition cond) |
static int |
DBO_insert_def.countRecords(SqlCondition cond) |
static int |
DBO_esprit_userlist_view.countRecords(SqlCondition cond) |
static int |
DBO_esprit_user.countRecords(SqlCondition cond) |
static int |
DBO_esprit_group.countRecords(SqlCondition cond) |
static int |
DBO_tnt_tank.delete(SqlCondition condition) |
static int |
DBO_tnt_stdtype.delete(SqlCondition condition) |
static int |
DBO_tnt_route_vertex.delete(SqlCondition condition) |
static int |
DBO_tnt_route.delete(SqlCondition condition) |
static int |
DBO_tnt_pk_composed.delete(SqlCondition condition) |
static int |
DBO_tnt_pktype.delete(SqlCondition condition) |
static int |
DBO_tnt_persistent_type.delete(SqlCondition condition) |
static int |
DBO_tnt_nopk.delete(SqlCondition condition) |
static int |
DBO_tnt_logmsg.delete(SqlCondition condition) |
static int |
DBO_tnt_alltype.delete(SqlCondition condition) |
static int |
DBO_insert_def.delete(SqlCondition condition) |
static int |
DBO_esprit_userlist_view.delete(SqlCondition condition) |
static int |
DBO_esprit_user.delete(SqlCondition condition) |
static int |
DBO_esprit_group.delete(SqlCondition condition) |
static void |
DBO_tnt_tank.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_tnt_stdtype.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_tnt_route_vertex.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_tnt_route.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_tnt_pk_composed.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_tnt_pktype.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_tnt_persistent_type.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_tnt_nopk.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_tnt_logmsg.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_tnt_alltype.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_insert_def.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_esprit_userlist_view.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_esprit_user.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_esprit_group.load(DBLoadMonitor monitor,
SqlCondition condition) |
static void |
DBO_tnt_tank.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_tnt_stdtype.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_tnt_route_vertex.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_tnt_route.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_tnt_pk_composed.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_tnt_pktype.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_tnt_persistent_type.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_tnt_nopk.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_tnt_logmsg.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_tnt_alltype.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_insert_def.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_esprit_userlist_view.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_esprit_user.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static void |
DBO_esprit_group.load(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
static DBO_tnt_tank[] |
DBO_tnt_tank.select(SqlCondition condition) |
static DBO_tnt_stdtype[] |
DBO_tnt_stdtype.select(SqlCondition condition) |
static DBO_tnt_route_vertex[] |
DBO_tnt_route_vertex.select(SqlCondition condition) |
static DBO_tnt_route[] |
DBO_tnt_route.select(SqlCondition condition) |
static DBO_tnt_pk_composed[] |
DBO_tnt_pk_composed.select(SqlCondition condition) |
static DBO_tnt_pktype[] |
DBO_tnt_pktype.select(SqlCondition condition) |
static DBO_tnt_persistent_type[] |
DBO_tnt_persistent_type.select(SqlCondition condition) |
static DBO_tnt_nopk[] |
DBO_tnt_nopk.select(SqlCondition condition) |
static DBO_tnt_logmsg[] |
DBO_tnt_logmsg.select(SqlCondition condition) |
static DBO_tnt_alltype[] |
DBO_tnt_alltype.select(SqlCondition condition) |
static DBO_insert_def[] |
DBO_insert_def.select(SqlCondition condition) |
static DBO_esprit_userlist_view[] |
DBO_esprit_userlist_view.select(SqlCondition condition) |
static DBO_esprit_user[] |
DBO_esprit_user.select(SqlCondition condition) |
static DBO_esprit_group[] |
DBO_esprit_group.select(SqlCondition condition) |
static DBO_tnt_tank[] |
DBO_tnt_tank.select(SqlCondition condition,
SqlOrder order) |
static DBO_tnt_stdtype[] |
DBO_tnt_stdtype.select(SqlCondition condition,
SqlOrder order) |
static DBO_tnt_route_vertex[] |
DBO_tnt_route_vertex.select(SqlCondition condition,
SqlOrder order) |
static DBO_tnt_route[] |
DBO_tnt_route.select(SqlCondition condition,
SqlOrder order) |
static DBO_tnt_pk_composed[] |
DBO_tnt_pk_composed.select(SqlCondition condition,
SqlOrder order) |
static DBO_tnt_pktype[] |
DBO_tnt_pktype.select(SqlCondition condition,
SqlOrder order) |
static DBO_tnt_persistent_type[] |
DBO_tnt_persistent_type.select(SqlCondition condition,
SqlOrder order) |
static DBO_tnt_nopk[] |
DBO_tnt_nopk.select(SqlCondition condition,
SqlOrder order) |
static DBO_tnt_logmsg[] |
DBO_tnt_logmsg.select(SqlCondition condition,
SqlOrder order) |
static DBO_tnt_alltype[] |
DBO_tnt_alltype.select(SqlCondition condition,
SqlOrder order) |
static DBO_insert_def[] |
DBO_insert_def.select(SqlCondition condition,
SqlOrder order) |
static DBO_esprit_userlist_view[] |
DBO_esprit_userlist_view.select(SqlCondition condition,
SqlOrder order) |
static DBO_esprit_user[] |
DBO_esprit_user.select(SqlCondition condition,
SqlOrder order) |
static DBO_esprit_group[] |
DBO_esprit_group.select(SqlCondition condition,
SqlOrder order) |
Modifier and Type | Method and Description |
---|---|
void |
DBOXmlWriter.writeTable(DBObject master,
SqlCondition cond)
Writes the selected records of the table of the given DBObject master
|
void |
DBOXmlWriter.writeTable(DBObject master,
SqlCondition cond,
SqlOrder order)
Writes the selected records of the table of the given DBObject master in the given order
|
Modifier and Type | Method and Description |
---|---|
<T extends AbstractPersistentABO> |
ABOManager.aboFind(boolean withLock,
java.lang.Class<T> aboType,
SqlCondition condition)
Reads persistent ABOs from the database filtered by the given
SqlCondition . |
Modifier and Type | Method and Description |
---|---|
void |
ClientRecordTablePanel.load(SqlCondition condition,
SqlOrder order)
Delegates to the DBTable.
|
void |
ClientRecordTablePanel.search(SqlCondition condition,
SqlOrder order)
Delegates to the DBTable.
|
Modifier and Type | Method and Description |
---|---|
void |
RemoteDatabase.dbLoadRecords(DBRecord master,
DBLoadMonitor monitor,
SqlCondition condition) |
void |
RemoteDatabase.dbLoadRecords(DBRecord master,
DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
DBRecord[] |
RemoteDatabase.dbSearchRecords(DBRecord master,
SqlCondition condition,
SqlOrder order) |
DBRecord[] |
RemoteDatabase.dbSelectRecords(DBRecord master,
SqlCondition condition) |
DBRecord[] |
RemoteDatabase.dbSelectRecords(DBRecord master,
SqlCondition condition,
SqlOrder order) |
Constructor and Description |
---|
DBDeleteAgent(ClientContext clientCtx,
DBRecord record,
SqlCondition condition) |
DBLoadAgent(ClientContext clientCtx,
int chunkSize,
DBRecord master,
SqlCondition condition,
SqlOrder order) |
DBLoadAgent(ClientContext clientCtx,
int chunkSize,
DBRecordTableModel tableModel,
DBRecord master,
SqlCondition condition,
SqlOrder order) |
DBSelectAgent(ClientContext clientCtx,
DBRecord master,
SqlCondition condition,
SqlOrder order)
Reads a set of records from the database according to the given condition and order.
|
Modifier and Type | Method and Description |
---|---|
void |
AbstractDBRecordABO.dbLoad(DBLoadMonitor monitor,
SqlCondition condition) |
void |
AbstractDBRecordABO.dbLoad(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
void |
AbstractDBRecordABO.dbSearch(DBLoadMonitor monitor,
SqlCondition condition) |
void |
AbstractDBRecordABO.dbSearch(DBLoadMonitor monitor,
SqlCondition condition,
SqlOrder order) |
DBRecord[] |
AbstractDBRecordABO.dbSearch(SqlCondition condition) |
DBRecord[] |
AbstractDBRecordABO.dbSearch(SqlCondition condition,
SqlOrder order) |
DBRecord[] |
AbstractDBRecordABO.dbSelect(SqlCondition condition) |
DBRecord[] |
AbstractDBRecordABO.dbSelect(SqlCondition condition,
SqlOrder order) |
I[] |
AbstractPersistentABO.find(boolean withLock,
SqlCondition cond) |
Modifier and Type | Method and Description |
---|---|
void |
AbstractDatabaseBatchTask.sendFoundRecords(DBObject[] recs,
SqlCondition cond) |
Copyright © 2014 EsprIT-Systems. All Rights Reserved.