com.sdb.dbwork

Class PrepareQuery

java.lang.Object

com.sdb.dbwork.PrepareQuery

Direct Known Subclasses:

PrepQueryWithRef

public class PrepareQuery
extends java.lang.Object

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

Field Summary

Fields

Modifier and Type	Field and Description
static int	BG This integer represent of Bigger.
static int	BGE This integer represent of Bigger or Equal.
static int	DATE This integer represent of data type.
static int	EQ This integer represent of Equal.
protected java.lang.String[]	equalityStr
protected java.lang.String	errorString
static int	INTEGER This integer represent of data type.
protected boolean	isLocale
static int	LK This integer represent of Like.
static int	NEQ This integer represent of Not Equal.
static int	NUMBER This integer represent of data type.
protected java.lang.String	queryStr
protected java.lang.String[]	queryString
static int	SM This integer represent of Smaller.
static int	SME This integer represent of Smaller or Equal.
static int	STRING This integer represent of data type.

Constructor Summary

Constructors

Constructor and Description
PrepareQuery() PrepareQuery class can use for preparing basic sql sentences.

Method Summary

Modifier and Type	Method and Description
void	convert2EQLs(int[] equalityInt) This method convert integers to sql comparison operators.
java.lang.String[]	getEqualityStr() For getting equalityStr
java.lang.String	getErrorString() For getting errorString
java.lang.String	getQueryStr() For getting queryStr
java.lang.String[]	setDelete(java.lang.String tableName, java.lang.String keyField, java.lang.String keyData) This method creates and return the delete statement string array.
void	setEqualityStr(java.lang.String[] equalityStr) For setting equalityStr
java.lang.String[]	setInsert(java.lang.String tableName, java.lang.String[] fieldNames, java.lang.String[] formData, int[] fieldTypes, DateFormatter dateFormatter) This method creates the database insert statement and returns as a string array.
java.lang.String[]	setSelect(java.lang.String tableName, java.lang.String[] fieldNames, java.lang.String[] formData, int[] selectFTs, java.lang.String orderBy, DateFormatter dateFormatter, java.lang.String[] selectFields) Creates and returns the database query statement (select).
java.lang.String[]	setUpdate(java.lang.String tableName, java.lang.String[] fieldNames, java.lang.String[] formData, int[] fieldTypes, DateFormatter dateFormatter) Creates and returns a database change statement string array.

Methods inherited from class java.lang.Object

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

Field Detail

STRING

public static final int STRING

This integer represent of data type.

See Also:

Constant Field Values

INTEGER

public static final int INTEGER

This integer represent of data type.

See Also:

Constant Field Values

DATE

public static final int DATE

This integer represent of data type.

See Also:

Constant Field Values

NUMBER

public static final int NUMBER

This integer represent of data type.

See Also:

Constant Field Values

EQ

public static final int EQ

This integer represent of Equal.

See Also:

Constant Field Values

SM

public static final int SM

This integer represent of Smaller.

See Also:

Constant Field Values

BG

public static final int BG

This integer represent of Bigger.

See Also:

Constant Field Values

SME

public static final int SME

This integer represent of Smaller or Equal.

See Also:

Constant Field Values

BGE

public static final int BGE

This integer represent of Bigger or Equal.

See Also:

Constant Field Values

NEQ

public static final int NEQ

This integer represent of Not Equal.

See Also:

Constant Field Values

LK

public static final int LK

This integer represent of Like.

See Also:

Constant Field Values

equalityStr

protected java.lang.String[] equalityStr

queryString

protected java.lang.String[] queryString

errorString

protected java.lang.String errorString

queryStr

protected java.lang.String queryStr

isLocale

protected boolean isLocale

Constructor Detail

PrepareQuery

public PrepareQuery()

PrepareQuery class can use for preparing basic sql sentences.

Parameters:

isLocale - It is for selecting locale or English.

Method Detail

convert2EQLs

public void convert2EQLs(int[] equalityInt)

This method convert integers to sql comparison operators.

Parameters:

equalityInt - Integer representation of comparison operators.

setSelect

public java.lang.String[] setSelect(java.lang.String tableName,
                                    java.lang.String[] fieldNames,
                                    java.lang.String[] formData,
                                    int[] selectFTs,
                                    java.lang.String orderBy,
                                    DateFormatter dateFormatter,
                                    java.lang.String[] selectFields)

Creates and returns the database query statement (select).

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.

selectFTs - 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 - DateFormatter instance for formatting for dates.

selectFields - List of selected fields from view.

Returns:

Returns a String array of query statements.

setInsert

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

This method creates the database insert statement and returns as a string array.

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.

dateFormatter - The DateFormatter instance to format dates.

Returns:

Returns a new record set sequence in the [] format.

setUpdate

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

Creates and returns a database change statement string array.

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.

dateFormatter - The DateFormatter instance to format dates.

Returns:

Returns an array of substitution statements.

setDelete

public java.lang.String[] setDelete(java.lang.String tableName,
                                    java.lang.String keyField,
                                    java.lang.String keyData)

This method creates and return the delete statement string array.

Parameters:

tableName - The table name to be accessed.

keyField - The key field name of the table to access.

keyData - Key field data.

Returns:

Returns a string of delete sentences in [] format.

getEqualityStr

public java.lang.String[] getEqualityStr()

For getting equalityStr

Returns:

equalityStr

setEqualityStr

public void setEqualityStr(java.lang.String[] equalityStr)

For setting equalityStr

Parameters:

equalityStr -

getErrorString

public java.lang.String getErrorString()

For getting errorString

Returns:

errorString

getQueryStr

public java.lang.String getQueryStr()

For getting queryStr

Returns:

queryStr