java.lang.Objectorg.objectweb.telosys.dal.dao.SqlRequests
Each instance this class holds all the SQL requets required by a standard DAO
to acces a table.
There's an instance of SqlRequests in each DAO.
Constructor Summary | |
SqlRequests(java.lang.String table,
java.lang.String[] keyColumns,
java.lang.String[] dataColumns)
Constructor |
|
SqlRequests(java.lang.String table,
java.lang.String[] keyColumns,
java.lang.String[] dataColumns,
java.lang.String sAutoInc)
Constructor for tables with an "auto incremented" column |
Method Summary | |
void |
alterSqlSelectWithJoin(java.lang.String sJoinTables,
java.lang.String sJoinColumns,
java.lang.String sJoinCriteria)
Changes the SQL SELECT by adding a JOIN |
ListQuery |
createQuery(int iKeySize,
java.lang.String sQueryCriteria,
java.lang.String sQueryEndOfSelect)
Creates a ListQuery |
java.lang.String |
getAllColumnsList()
Returns the list of all the columns (coma separated) |
java.lang.String |
getAutoIncColumn()
Returns the 'Auto-Inc' column if any (or NULL) |
java.lang.String |
getSqlDelete()
Returns the SQL DELETE request |
java.lang.String |
getSqlExists()
Returns the SQL SELECT COUNT request |
java.lang.String |
getSqlInsert()
Returns the SQL INSERT request |
java.lang.String |
getSqlSelect()
Returns the SQL SELECT request |
java.lang.String |
getSqlSelect(java.lang.String sOptionalClause)
Returns the SQL SELECT request adding the optional clause at the end |
java.lang.String |
getSqlUpdate()
Returns the SQL UPDATE request |
java.lang.String |
getTableName()
Returns the TABLE NAME |
java.lang.String |
getWhereCriteria()
Returns the where criteria of the requests |
boolean |
hasAutoIncColumn()
Returns true if the table has an 'Auto-Inc' column |
java.lang.String |
toString()
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Constructor Detail |
public SqlRequests(java.lang.String table, java.lang.String[] keyColumns, java.lang.String[] dataColumns)
table
- the tablekeyColumns
- the columns of the Primary KeydataColumns
- the other columns of the table ( not in the Primary Key )public SqlRequests(java.lang.String table, java.lang.String[] keyColumns, java.lang.String[] dataColumns, java.lang.String sAutoInc)
table
- the tablekeyColumns
- the columns of the Primary KeydataColumns
- the other columns of the table ( not in the Primary Key )sAutoInc
- the name the "auto incremented" columnMethod Detail |
public ListQuery createQuery(int iKeySize, java.lang.String sQueryCriteria, java.lang.String sQueryEndOfSelect)
iKeySize
- number of parameters for the query ( the number of '?' in the string : 0 to N )sQueryCriteria
- the SQL criteria for the WHERE clausesQueryEndOfSelect
- the additional SQL clause ( e.g. : "order by ..." )
public void alterSqlSelectWithJoin(java.lang.String sJoinTables, java.lang.String sJoinColumns, java.lang.String sJoinCriteria)
sJoinTables
- sJoinColumns
- sJoinCriteria
- public java.lang.String getSqlSelect()
public java.lang.String getSqlSelect(java.lang.String sOptionalClause)
sOptionalClause
-
public java.lang.String getSqlExists()
public java.lang.String getSqlInsert()
public java.lang.String getSqlUpdate()
public java.lang.String getSqlDelete()
public java.lang.String getTableName()
public java.lang.String getAutoIncColumn()
public boolean hasAutoIncColumn()
public java.lang.String getAllColumnsList()
public java.lang.String getWhereCriteria()
public java.lang.String toString()