com.sdb.dbwork

Class ExecTableWithRef

java.lang.Object

com.sdb.dbwork.ExecuteTable

com.sdb.dbwork.ExecTableWithRef

public class ExecTableWithRef
extends ExecuteTable

ExecuteTableAdvanced is the class that automates database operations. With this class, database queries are automatically generated and the process is completed by executing queries.
For the creation of a sample;
p.execTableWithRef = new ExecTableWithRef(runDB, tableNames, fieldNames, fieldTypes, orderBy, selectFields, selectFTs, dateFormatter, refTableNames, refFieldNames, refFieldMatchs, messageBean);
It is enough to write like this code.
Next action;
dbQuery = p.execTableWR.tableActionWR(p.action, p.formData, p.prepQueryWR);
if(dbQuery) {
p.tableData = p.execTableWR.selectData(p.dataType);
}
else
p.tableData = null;
to run the method.
The important thing to consider here is to determine the variables in both the binding and the method correctly.

Field Summary

Fields inherited from class com.sdb.dbwork.ExecuteTable

BATCH, DATASOURCE, DATE, dateData, dbQuery, doubleData, DRIVERMANAGER, errorString, EXECUTE, fieldCount, fieldNames, fieldTypes, INTEGER, integerData, isAfterCommit, isDebug, keyField, messageBean, messages, messageScript, NUMBER, orderBy, QUERY, queryString, resultMessage, runDB, selectFields, selectFTs, STRING, stringData, tableData, tableNames, UPDATE

Constructor Summary

Constructors

Constructor and Description

ExecTableWithRef(RunDB runDB, java.lang.String[] tableNames, java.lang.String[] fieldNames, int[] fieldTypes, java.lang.String orderBy, java.lang.String[] selectFields, int[] selectFTs, DateFormatter dateFormatter, java.lang.String[] refTableNames, java.lang.String[] refFieldNames, int[] refFieldMatchs, MessageBean messageBean) The basic variables of the constructor include database, table, form, and field information.

Method Summary

Modifier and Type	Method and Description
boolean	tableActionWR(java.lang.String action, java.lang.String[] formData, PrepQueryWithRef pqAdvanced) Perform table movements (select, insert, update, or delete) with reference data and return result data.

Methods inherited from class com.sdb.dbwork.ExecuteTable

closeAll, getDefErrStr, getDefMsgScr, getDefResMsg, getErrorString, getMessageBean, getMessages, getMessageScript, getNewRecord, getQueryString, getResultMessage, initMessages, isDebug, selectData, setAfterCommit, setDebug, setDefErrStr, setDefMsgScr, setDefResMsg, setMessageBean, setMessages, setQueryString, tableAction

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ExecTableWithRef

public ExecTableWithRef(RunDB runDB,
                        java.lang.String[] tableNames,
                        java.lang.String[] fieldNames,
                        int[] fieldTypes,
                        java.lang.String orderBy,
                        java.lang.String[] selectFields,
                        int[] selectFTs,
                        DateFormatter dateFormatter,
                        java.lang.String[] refTableNames,
                        java.lang.String[] refFieldNames,
                        int[] refFieldMatchs,
                        MessageBean messageBean)

The basic variables of the constructor include database, table, form, and field information. In this way, the connection between the database and form is established and transactions are automated.

Parameters:

runDB - For connecting the database and executing processes.

tableNames - The table names to be accessed.

fieldNames - Names of fields of the table to access.

fieldTypes - The data types of the fields of the table to access.

orderBy - The field names to sort in the query statement to be generated.

selectFields - List of selected fields from view.

selectFTs - The data types of the fields of the table to access.

dateFormatter - instance for Formatting for dates.

refTableNames - The reference table name to be accessed.

refFieldNames - The string of names of the fields of reference tables to be accessed.

refFieldMatchs - Sequence of the reference fields to be accessed.

messageBean - MessageBean instance for getting general messages.

Method Detail

tableActionWR

public boolean tableActionWR(java.lang.String action,
                             java.lang.String[] formData,
                             PrepQueryWithRef pqAdvanced)

Perform table movements (select, insert, update, or delete) with reference data and return result data.

Parameters:

action - The action variable determines which action will take.

formData - Taken data from the form in String array

pqAdvanced - Represent of The PrepQueryWithRef instance for setting queries.

Returns:

If the DB action succeeds, it returns true, otherwise returns false.