java.lang.Objectorg.objectweb.telosys.dal.dao.SqlRequests
Constructor Summary | |
SqlRequests(java.lang.String table,
java.lang.String[] keyColumns,
java.lang.String[] dataColumns)
|
|
SqlRequests(java.lang.String table,
java.lang.String[] keyColumns,
java.lang.String[] dataColumns,
java.lang.String sAutoInc)
|
Method Summary | |
void |
alterSqlSelectWithJoin(java.lang.String sJoinTables,
java.lang.String sJoinColumns,
java.lang.String sJoinCriteria)
Change the SQL SELECT by adding a JOIN |
ListQuery |
createQuery(int iKeySize,
java.lang.String sQueryCriteria,
java.lang.String sQueryEndOfSelect)
|
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)
public SqlRequests(java.lang.String table, java.lang.String[] keyColumns, java.lang.String[] dataColumns, java.lang.String sAutoInc)
Method Detail |
public ListQuery createQuery(int iKeySize, java.lang.String sQueryCriteria, java.lang.String sQueryEndOfSelect)
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()