org.apache.tapestry.contrib.table.model.sql
Class SimpleSqlTableDataSource

java.lang.Object
  extended by org.apache.tapestry.contrib.table.model.sql.SimpleSqlTableDataSource
All Implemented Interfaces:
ISqlTableDataSource

public class SimpleSqlTableDataSource
extends java.lang.Object
implements ISqlTableDataSource

Author:
mindbridge

Constructor Summary
SimpleSqlTableDataSource(ISqlConnectionSource objConnSource, java.lang.String strTableName)
           
SimpleSqlTableDataSource(ISqlConnectionSource objConnSource, java.lang.String strTableName, java.lang.String strWhereClause)
           
 
Method Summary
 void closeResultSet(java.sql.ResultSet objResultSet)
           
protected  java.lang.String generateColumnList(SqlTableColumnModel objColumnModel)
           
protected  java.lang.String generateCountQuery()
           
protected  java.lang.String generateDataQuery(SqlTableColumnModel objColumnModel, SimpleTableState objState)
           
protected  java.lang.String generateLimitClause(ITablePagingState objPagingState)
           
protected  java.lang.String generateOrderByClause(ITableSortingState objSortingState)
           
protected  java.lang.String generateWhereClause()
           
 ISqlConnectionSource getConnSource()
          Returns the connSource.
 java.sql.ResultSet getCurrentRows(SqlTableColumnModel objColumnModel, SimpleTableState objState)
           
 int getRowCount()
           
 java.lang.String getTableName()
          Returns the tableName.
 java.lang.String getWhereClause()
          Returns the whereClause.
protected  java.lang.String quoteObjectName(java.lang.String strObject)
           
 void setConnSource(ISqlConnectionSource connSource)
          Sets the connSource.
 void setTableName(java.lang.String tableName)
          Sets the tableName.
 void setWhereClause(java.lang.String whereClause)
          Sets the whereClause.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

SimpleSqlTableDataSource

public SimpleSqlTableDataSource(ISqlConnectionSource objConnSource,
                                java.lang.String strTableName)

SimpleSqlTableDataSource

public SimpleSqlTableDataSource(ISqlConnectionSource objConnSource,
                                java.lang.String strTableName,
                                java.lang.String strWhereClause)
Method Detail

getRowCount

public int getRowCount()
                throws java.sql.SQLException
Specified by:
getRowCount in interface ISqlTableDataSource
Throws:
java.sql.SQLException
See Also:
ISqlTableDataSource.getRowCount()

getCurrentRows

public java.sql.ResultSet getCurrentRows(SqlTableColumnModel objColumnModel,
                                         SimpleTableState objState)
                                  throws java.sql.SQLException
Specified by:
getCurrentRows in interface ISqlTableDataSource
Throws:
java.sql.SQLException
See Also:
ISqlTableDataSource.getCurrentRows(SqlTableColumnModel, SimpleTableState)

closeResultSet

public void closeResultSet(java.sql.ResultSet objResultSet)
Specified by:
closeResultSet in interface ISqlTableDataSource
See Also:
ISqlTableDataSource.closeResultSet(ResultSet)

quoteObjectName

protected java.lang.String quoteObjectName(java.lang.String strObject)

getTableName

public java.lang.String getTableName()
Returns the tableName.

Returns:
String

setTableName

public void setTableName(java.lang.String tableName)
Sets the tableName.

Parameters:
tableName - The tableName to set

getConnSource

public ISqlConnectionSource getConnSource()
Returns the connSource.

Returns:
ISqlConnectionSource

setConnSource

public void setConnSource(ISqlConnectionSource connSource)
Sets the connSource.

Parameters:
connSource - The connSource to set

getWhereClause

public java.lang.String getWhereClause()
Returns the whereClause.

Returns:
String

setWhereClause

public void setWhereClause(java.lang.String whereClause)
Sets the whereClause.

Parameters:
whereClause - The whereClause to set

generateColumnList

protected java.lang.String generateColumnList(SqlTableColumnModel objColumnModel)

generateWhereClause

protected java.lang.String generateWhereClause()

generateOrderByClause

protected java.lang.String generateOrderByClause(ITableSortingState objSortingState)

generateLimitClause

protected java.lang.String generateLimitClause(ITablePagingState objPagingState)

generateDataQuery

protected java.lang.String generateDataQuery(SqlTableColumnModel objColumnModel,
                                             SimpleTableState objState)

generateCountQuery

protected java.lang.String generateCountQuery()