JProjects.eab.data
Class DASQLGenerator

java.lang.Object
  |
  +--JProjects.eab.data.DASQLGenerator

public class DASQLGenerator
extends java.lang.Object
implements java.io.Serializable

Generates SQL for Manager classes.

Author:
Alexander Jaremenko
< jarem@altavista.net >
See Also:
Serialized Form

Constructor Summary
DASQLGenerator(java.lang.String tbl, java.lang.String[] pkCols, java.lang.String[] cols, java.lang.String[] mPk)
          Public constructor.
 
Method Summary
 java.lang.String genDelete(java.lang.String tblQual)
          Generates parametrized SQL delete statement for table.
 java.lang.String genInsert(java.lang.String tblQual)
          Generates parametrized SQL insert statement for table.
 java.lang.String genUpdate(java.lang.String tblQual, boolean[] modified)
          Generates parametrized SQL update statement for table.
 java.lang.String genUpdateDataId(java.lang.String tblQual, boolean[] modified)
          Generates parametrized SQL update statement for table's primary key.
 java.lang.String genUpdateDataIdFetched(java.lang.String tblQual, boolean[] idModified)
          Generates parametrized update statement for positioned update.
 java.lang.String genUpdateFetched(java.lang.String tblQual, boolean[] idModified, boolean[] modified)
          Generates parametrized update statement for positioned update.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

DASQLGenerator

public DASQLGenerator(java.lang.String tbl,
                      java.lang.String[] pkCols,
                      java.lang.String[] cols,
                      java.lang.String[] mPk)
Public constructor.
Parameters:
tbl - table's name
pkCols - column's names for columns that constitute primary key
cols - other column's names of the table. May be null.
mPk - primary key column's names that can be modified. May be null.
Method Detail

genUpdate

public java.lang.String genUpdate(java.lang.String tblQual,
                                  boolean[] modified)
Generates parametrized SQL update statement for table. Assumes that at least one element of modified array is true.
Parameters:
tblQual - qualifier of the table
modified - array of columns modification indicators. Sequance must correspond those that in constructor's cols arguments.

genInsert

public java.lang.String genInsert(java.lang.String tblQual)
Generates parametrized SQL insert statement for table.
Parameters:
tblQual - qualifier of the table.
Returns:
- generated SQL statement.

genDelete

public java.lang.String genDelete(java.lang.String tblQual)
Generates parametrized SQL delete statement for table.
Parameters:
tblQual - qualifier of the table.
Returns:
- generated SQL statement.

genUpdateDataId

public java.lang.String genUpdateDataId(java.lang.String tblQual,
                                        boolean[] modified)
Generates parametrized SQL update statement for table's primary key. Assumes that at least one element of modified array is true.
Parameters:
tblQual - qualifier of the table
modified - array of columns modification indicators. Sequance must correspond those that in constructor's cols arguments.

genUpdateFetched

public java.lang.String genUpdateFetched(java.lang.String tblQual,
                                         boolean[] idModified,
                                         boolean[] modified)
Generates parametrized update statement for positioned update.
Parameters:
tblQual - qualifier of the table
idModified - array of columns modification indicators. Sequance must correspond those that in constructor's mPk argument.
modified - array of columns modification indicators. Sequance must correspond those that in constructor's cols argument.

genUpdateDataIdFetched

public java.lang.String genUpdateDataIdFetched(java.lang.String tblQual,
                                               boolean[] idModified)
Generates parametrized update statement for positioned update.
Parameters:
tblQual - qualifier of the table
idModified - array of columns modification indicators. Sequance must correspond those that in constructor's mPk argument.