org.objectweb.telosys.dal.dao
Class SqlRequests

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

public class SqlRequests
extends java.lang.Object

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

SqlRequests

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

Parameters:
table - the table
keyColumns - the columns of the Primary Key
dataColumns - the other columns of the table ( not in the Primary Key )

SqlRequests

public 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

Parameters:
table - the table
keyColumns - the columns of the Primary Key
dataColumns - the other columns of the table ( not in the Primary Key )
sAutoInc - the name the "auto incremented" column
Method Detail

createQuery

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

Parameters:
iKeySize - number of parameters for the query ( the number of '?' in the string : 0 to N )
sQueryCriteria - the SQL criteria for the WHERE clause
sQueryEndOfSelect - the additional SQL clause ( e.g. : "order by ..." )
Returns:

alterSqlSelectWithJoin

public void alterSqlSelectWithJoin(java.lang.String sJoinTables,
                                   java.lang.String sJoinColumns,
                                   java.lang.String sJoinCriteria)
Changes 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()