com.sdb.dbwork

Class PrepQueryWithRef

java.lang.Object

com.sdb.dbwork.PrepareQuery

com.sdb.dbwork.PrepQueryWithRef

public class PrepQueryWithRef
extends PrepareQuery

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);

Field Summary

Fields inherited from class com.sdb.dbwork.PrepareQuery

BG, BGE, DATE, EQ, equalityStr, errorString, INTEGER, isLocale, LK, NEQ, NUMBER, queryStr, queryString, SM, SME, STRING

Constructor Summary

Constructors

Constructor and Description
PrepQueryWithRef() The constructor set locale boolean by super usage.

Method Summary

Modifier and Type	Method and Description
java.lang.String[]	setInsert(java.lang.String tableName, java.lang.String[] fieldNames, java.lang.String[] formData, int[] fieldTypes, int[] refFieldMatchs, java.lang.String[] refData, DateFormatter dateFormatter) Creates a sql insert sentence and returns it.
void	setKeyField(java.lang.String keyField) If you want key field name different from id, you can set it.
void	setKeyFields(java.lang.String[] keyFields) If you want key field names different each other, you can set them.
java.lang.String[]	setRefSelect(int[] fieldTypes, java.lang.String[] formData, java.lang.String[] refTableNames, java.lang.String[] refFieldNames, int[] refFieldMatchs) Creates and returns the database query statement for the reference table.
java.lang.String[]	setUpdate(java.lang.String tableName, java.lang.String[] fieldNames, java.lang.String[] formData, int[] fieldTypes, int[] refFieldMatchs, java.lang.String[] refData, DateFormatter dateFormatter) Creates and returns a database update statement.

Methods inherited from class com.sdb.dbwork.PrepareQuery

convert2EQLs, getEqualityStr, getErrorString, getQueryStr, setDelete, setEqualityStr, setInsert, setSelect, setUpdate

Methods inherited from class java.lang.Object

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

Constructor Detail

PrepQueryWithRef

public PrepQueryWithRef()

The constructor set locale boolean by super usage. The class can use for preparing sql sentences with reference data.

Parameters:

isLocale - If it is locale set true, else set false.

Method Detail

setRefSelect

public java.lang.String[] setRefSelect(int[] fieldTypes,
                                       java.lang.String[] formData,
                                       java.lang.String[] refTableNames,
                                       java.lang.String[] refFieldNames,
                                       int[] refFieldMatchs)

Creates and returns the database query statement for the reference table.

Parameters:

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

formData - An array of data from the form to be used in the SQL statement.

refTableNames - The desired 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.

Returns:

Returns an array of query statements.

setInsert

public java.lang.String[] setInsert(java.lang.String tableName,
                                    java.lang.String[] fieldNames,
                                    java.lang.String[] formData,
                                    int[] fieldTypes,
                                    int[] refFieldMatchs,
                                    java.lang.String[] refData,
                                    DateFormatter dateFormatter)

Creates a sql insert sentence and returns it.

Parameters:

tableName - The table name to be accessed.

fieldNames - Names of fields of the table to access.

formData - An array of data from the HTML form to be used in the SQL statement.

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

refFieldMatchs - Sequence of the reference fields to be accessed.

refData - A set of reference data from the reference table to be used in the SQL statement.

dateFormatter - The DateFormatter instance to format dates.

Returns:

Returns a new recordset sequence in the String[] format.

setUpdate

public java.lang.String[] setUpdate(java.lang.String tableName,
                                    java.lang.String[] fieldNames,
                                    java.lang.String[] formData,
                                    int[] fieldTypes,
                                    int[] refFieldMatchs,
                                    java.lang.String[] refData,
                                    DateFormatter dateFormatter)

Creates and returns a database update statement.

Parameters:

tableName - The table name to be accessed.

fieldNames - Names of fields of the table to access.

formData - An array of data from the HTML form to be used in the SQL statement.

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

refFieldMatchs - Sequence of the reference fields to be accessed.

refData - A set of reference data from the reference table to be used in the SQL statement.

dateFormatter - The DateFormatter instance to format dates.

Returns:

Returns an String array of substitution statements.

setKeyField

public void setKeyField(java.lang.String keyField)

If you want key field name different from id, you can set it. I must be same at other reference tables. Or ....

Parameters:

keyField -

setKeyFields

public void setKeyFields(java.lang.String[] keyFields)

If you want key field names different each other, you can set them.

Parameters:

keyFields -