com.sdb.dbwork

Class ExecuteTable

java.lang.Object

com.sdb.dbwork.ExecuteTable

Direct Known Subclasses:

ExecTableWithRef

public class ExecuteTable
extends java.lang.Object

ExecuteTable 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;
executeTable = new ExecuteTable (dbName, tableName, fieldNames, fieldTypes, orderBy, dateFormatter, selectFields, selectFTs, messageBean);
It is enough to write a code like this.
Next action;
tableData = (String[][]) executeTable.tableAction(action, formData, prepareQuery); to run the method.
The important thing to consider here is to determine the variables in both the constructor and the method correctly.

Field Summary

Fields

Modifier and Type	Field and Description
static int	BATCH This integer represent of batch processes.
static int	DATASOURCE This integer represent of DB connection type for data source.
static int	DATE This integer represent of data type for date.
protected java.sql.Date[][]	dateData
protected boolean	dbQuery
protected java.lang.Double[][]	doubleData
static int	DRIVERMANAGER This integer represent of DB connection type for driver manager.
protected java.lang.String	errorString
static int	EXECUTE This integer represent of execute sql execution type.
protected int	fieldCount
protected java.lang.String[]	fieldNames
protected int[]	fieldTypes
static int	INTEGER This integer represent of data type for integer.
protected java.lang.Integer[][]	integerData
protected boolean	isAfterCommit
protected boolean	isDebug
protected java.lang.String	keyField
protected MessageBean	messageBean MessageBean instance for getting default messages.
protected java.lang.String[]	messages
protected java.lang.String	messageScript
static int	NUMBER This integer represent of data type for double.
protected java.lang.String	orderBy
static int	QUERY This integer represent of select sql execution type.
protected java.lang.String	queryString
protected java.lang.String	resultMessage
protected RunDB	runDB RunDB instance for executing DB processes.
protected java.lang.String[]	selectFields
protected int[]	selectFTs
static int	STRING This integer represent of data type for string.
protected java.lang.String[][]	stringData
protected java.lang.Object[][]	tableData
protected java.lang.String[]	tableNames
static int	UPDATE This integer represent of insert, update, delete sql execution types.

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
void	closeAll() For calling RunDB class closeAll() method.
java.lang.String	getDefErrStr() For getting defErrStr.
java.lang.String	getDefMsgScr() For getting defMsgScr.
java.lang.String	getDefResMsg() For getting defResMsg.
java.lang.String	getErrorString() For getting errorString.
MessageBean	getMessageBean() For getting messageBean.
java.lang.String[]	getMessages() For retrieving message strings in String array.
java.lang.String	getMessageScript() For getting messageScript.
java.lang.String[]	getNewRecord(java.lang.String[] unqFields, java.lang.String[] unqFieldData, int[] unqFieldTypes, PrepareQuery prepareQuery) When new record is recorded to DB, probably you don't know id of new record.
java.lang.String	getQueryString() For getting queryString.
java.lang.String	getResultMessage() For getting resultMessage.
void	initMessages() For initializing default messages.
boolean	isDebug() For getting isDebug.
java.lang.Object[][]	selectData(int dataType) The base object type array returns the selected data of the return database.
void	setAfterCommit(boolean isAfterCommit) For setting isAfterCommit.
void	setDebug(boolean isDebug) For setting isDebug.
void	setDefErrStr(java.lang.String defErrStr) For setting defErrStr.
void	setDefMsgScr(java.lang.String defMsgScr) For setting defMsgScr.
void	setDefResMsg(java.lang.String defResMsg) For setting defResMsg.
void	setMessageBean(MessageBean messageBean) For setting messageBean
void	setMessages(java.lang.String[] messages) For setting messages
void	setQueryString(java.lang.String sqlString) For setting sqlString.
boolean	tableAction(java.lang.String action, java.lang.String[] formData, PrepareQuery prepareQuery) Perform table movements (select, insert, update, or delete) and return data.

Methods inherited from class java.lang.Object

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

Field Detail

EXECUTE

public static final int EXECUTE

This integer represent of execute sql execution type.

See Also:

Constant Field Values

QUERY

public static final int QUERY

This integer represent of select sql execution type.

See Also:

Constant Field Values

UPDATE

public static final int UPDATE

This integer represent of insert, update, delete sql execution types.

See Also:

Constant Field Values

BATCH

public static final int BATCH

This integer represent of batch processes.

See Also:

Constant Field Values

DATASOURCE

public static final int DATASOURCE

This integer represent of DB connection type for data source.

See Also:

Constant Field Values

DRIVERMANAGER

public static final int DRIVERMANAGER

This integer represent of DB connection type for driver manager.

See Also:

Constant Field Values

STRING

public static final int STRING

This integer represent of data type for string.

See Also:

Constant Field Values

INTEGER

public static final int INTEGER

This integer represent of data type for integer.

See Also:

Constant Field Values

DATE

public static final int DATE

This integer represent of data type for date.

See Also:

Constant Field Values

NUMBER

public static final int NUMBER

This integer represent of data type for double.

See Also:

Constant Field Values

tableNames

protected java.lang.String[] tableNames

fieldNames

protected java.lang.String[] fieldNames

selectFields

protected java.lang.String[] selectFields

fieldTypes

protected int[] fieldTypes

selectFTs

protected int[] selectFTs

keyField

protected java.lang.String keyField

orderBy

protected java.lang.String orderBy

queryString

protected java.lang.String queryString

fieldCount

protected int fieldCount

stringData

protected java.lang.String[][] stringData

integerData

protected java.lang.Integer[][] integerData

dateData

protected java.sql.Date[][] dateData

doubleData

protected java.lang.Double[][] doubleData

tableData

protected java.lang.Object[][] tableData

runDB

protected RunDB runDB

RunDB instance for executing DB processes.

messageBean

protected MessageBean messageBean

MessageBean instance for getting default messages.

errorString

protected java.lang.String errorString

messageScript

protected java.lang.String messageScript

resultMessage

protected java.lang.String resultMessage

messages

protected java.lang.String[] messages

dbQuery

protected boolean dbQuery

isAfterCommit

protected boolean isAfterCommit

isDebug

protected boolean isDebug

Constructor Detail

ExecuteTable

public ExecuteTable(RunDB runDB,
                    java.lang.String[] tableNames,
                    java.lang.String[] fieldNames,
                    int[] fieldTypes,
                    java.lang.String orderBy,
                    DateFormatter dateFormatter,
                    java.lang.String[] selectFields,
                    int[] selectFTs,
                    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.

dateFormatter - The DateFormatter instance to format dates.

selectFields - List of selected fields from view.

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

messageBean - The MessageBean instance for getting general messages.

Method Detail

initMessages

public void initMessages()

For initializing default messages.

selectData

public java.lang.Object[][] selectData(int dataType)

The base object type array returns the selected data of the return database. An error message (errorString) will occur if there is no data return.

Parameters:

dataType - The type of data you want to retrieve.

Returns:

Returns the array according to data type and data object in [number of records][field count] format.

getNewRecord

public java.lang.String[] getNewRecord(java.lang.String[] unqFields,
                                       java.lang.String[] unqFieldData,
                                       int[] unqFieldTypes,
                                       PrepareQuery prepareQuery)

When new record is recorded to DB, probably you don't know id of new record. At this point this method send unique field data and retrieve this record with id.

Parameters:

unqFields - Unique fields names in string array.

unqFieldData - Unique fields data in string array.

unqFieldTypes - Unique fields types in integer array.

prepareQuery - PrepareQuery instance for setting select query.

Returns:

String array for retrieving new record with id.

tableAction

public boolean tableAction(java.lang.String action,
                           java.lang.String[] formData,
                           PrepareQuery prepareQuery)

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

Parameters:

action - The action variable determines which action will take.

formData - Taken data from the form in String array

prepareQuery - Represent of The PrepareQuery instance for setting queries.

Returns:

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

closeAll

public void closeAll()

For calling RunDB class closeAll() method.

getQueryString

public java.lang.String getQueryString()

For getting queryString.

Returns:

queryString

getErrorString

public java.lang.String getErrorString()

For getting errorString.

Returns:

queryString

setQueryString

public void setQueryString(java.lang.String sqlString)

For setting sqlString.

Parameters:

sqlString -

getMessageScript

public java.lang.String getMessageScript()

For getting messageScript.

Returns:

messageScript

getResultMessage

public java.lang.String getResultMessage()

For getting resultMessage.

Returns:

resultMessage

getMessages

public java.lang.String[] getMessages()

For retrieving message strings in String array.

Returns:

setMessages

public void setMessages(java.lang.String[] messages)

For setting messages

Parameters:

messages -

getMessageBean

public MessageBean getMessageBean()

For getting messageBean.

Returns:

messageBean

setMessageBean

public void setMessageBean(MessageBean messageBean)

For setting messageBean

Parameters:

messageBean -

setDefErrStr

public void setDefErrStr(java.lang.String defErrStr)

For setting defErrStr.

Parameters:

defErrStr -

setDefMsgScr

public void setDefMsgScr(java.lang.String defMsgScr)

For setting defMsgScr.

Parameters:

defMsgScr -

setDefResMsg

public void setDefResMsg(java.lang.String defResMsg)

For setting defResMsg.

Parameters:

defResMsg -

getDefErrStr

public java.lang.String getDefErrStr()

For getting defErrStr.

Returns:

defErrStr

getDefMsgScr

public java.lang.String getDefMsgScr()

For getting defMsgScr.

Returns:

defMsgScr

getDefResMsg

public java.lang.String getDefResMsg()

For getting defResMsg.

Returns:

defResMsg

isDebug

public boolean isDebug()

For getting isDebug.

Returns:

defResMsg

setDebug

public void setDebug(boolean isDebug)

For setting isDebug.

Parameters:

isDebug -

setAfterCommit

public void setAfterCommit(boolean isAfterCommit)

For setting isAfterCommit.

Parameters:

isAfterCommit -