|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Object | +--JProjects.eab.data.DASQLGenerator
Generates SQL for Manager classes.
| 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 |
public DASQLGenerator(java.lang.String tbl,
java.lang.String[] pkCols,
java.lang.String[] cols,
java.lang.String[] mPk)
tbl - table's namepkCols - column's names for columns that constitute primary keycols - 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 |
public java.lang.String genUpdate(java.lang.String tblQual,
boolean[] modified)
tblQual - qualifier of the tablemodified - array of columns modification indicators. Sequance must
correspond those that in constructor's cols arguments.public java.lang.String genInsert(java.lang.String tblQual)
tblQual - qualifier of the table.public java.lang.String genDelete(java.lang.String tblQual)
tblQual - qualifier of the table.
public java.lang.String genUpdateDataId(java.lang.String tblQual,
boolean[] modified)
tblQual - qualifier of the tablemodified - array of columns modification indicators. Sequance must
correspond those that in constructor's cols arguments.
public java.lang.String genUpdateFetched(java.lang.String tblQual,
boolean[] idModified,
boolean[] modified)
tblQual - qualifier of the tableidModified - 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.
public java.lang.String genUpdateDataIdFetched(java.lang.String tblQual,
boolean[] idModified)
tblQual - qualifier of the tableidModified - array of columns modification indicators. Sequance must
correspond those that in constructor's mPk argument.
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||