org.objectweb.telosys.dal.dao
Class SqlRequests

java.lang.Object
  extended byorg.objectweb.telosys.dal.dao.SqlRequests

public class SqlRequests
extends java.lang.Object


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

SqlRequests

public SqlRequests(java.lang.String table,
                   java.lang.String[] keyColumns,
                   java.lang.String[] dataColumns)

SqlRequests

public SqlRequests(java.lang.String table,
                   java.lang.String[] keyColumns,
                   java.lang.String[] dataColumns,
                   java.lang.String sAutoInc)
Method Detail

createQuery

public ListQuery createQuery(int iKeySize,
                             java.lang.String sQueryCriteria,
                             java.lang.String sQueryEndOfSelect)

alterSqlSelectWithJoin

public void alterSqlSelectWithJoin(java.lang.String sJoinTables,
                                   java.lang.String sJoinColumns,
                                   java.lang.String sJoinCriteria)
Change the SQL SELECT by adding a JOIN

Parameters:
sJoinTables -
sJoinColumns -
sJoinCriteria -

getSqlSelect

public java.lang.String getSqlSelect()
Returns the SQL SELECT request

Returns:
the SQL Select clause

getSqlSelect

public java.lang.String getSqlSelect(java.lang.String sOptionalClause)
Returns the SQL SELECT request adding the optional clause at the end

Parameters:
sOptionalClause -
Returns:
the SQL Select clause

getSqlExists

public java.lang.String getSqlExists()
Returns the SQL SELECT COUNT request

Returns:

getSqlInsert

public java.lang.String getSqlInsert()
Returns the SQL INSERT request

Returns:

getSqlUpdate

public java.lang.String getSqlUpdate()
Returns the SQL UPDATE request

Returns:

getSqlDelete

public java.lang.String getSqlDelete()
Returns the SQL DELETE request

Returns:

getTableName

public java.lang.String getTableName()
Returns the TABLE NAME

Returns:

getAutoIncColumn

public java.lang.String getAutoIncColumn()
Returns the 'Auto-Inc' column if any (or NULL)

Returns:

hasAutoIncColumn

public boolean hasAutoIncColumn()
Returns true if the table has an 'Auto-Inc' column

Returns:

getAllColumnsList

public java.lang.String getAllColumnsList()
Returns the list of all the columns (coma separated)

Returns:

getWhereCriteria

public java.lang.String getWhereCriteria()
Returns the where criteria of the requests

Returns:

toString

public java.lang.String toString()