Namespace SDBCS.dbwork

Classes

ExecTableWithRef

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.

ExecuteTable

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.

PrepareQuery

PrepareQuery is the class that creates basic database phrases.
Use of a sample;
insertQuery = PrepareQuery.setInsert(tableName, fieldNames, formData, fieldTypes, dateFormatter);

PrepQueryWithRef

PrepQueryWithRef is the class that creates advanced database phrases with references.
Use of a sample;
String[] insertQuery = PrepareQuery.setInsert(tableName, fieldNames, formData, fieldTypes, refFieldMatchs, refData, dateFormatter);

RunDB

RunDB is the class that performs basic database operations. It is prepared for direct use or used by ExecuteTable.
Example;
runDB = new RunDB(connType);
runDB.setDB(jndiName);
queryString[0] = "select linked_page, theme from vt_jbc_page_link where link_name = '"+linkName+"'";
if(!runDB.runQuery(queryString, 0, RunDB.QUERY)) errorString = runDB.errorString;
else resultSet = runDB.getResultSet();