com.javaranch.db
Class TableFacade

java.lang.Object
  |
  +--com.javaranch.db.TableFacade

public class TableFacade

extends java.lang.Object

Constructor Summary

TableFacade(DBFacade db, java.lang.String tableName)

Method Summary

void	delete(java.sql.Connection con, java.lang.String searchColumn, java.lang.String searchText)
void	delete(java.lang.String searchColumn, java.lang.String searchText)
DBFacade	getDBFacade()
java.lang.String	getTableName()
void	insert(java.sql.Connection con, java.util.Map data)
void	insert(java.util.Map data)
long	insertAndGetID(java.sql.Connection con, java.util.Map data)
long	insertAndGetID(java.sql.Connection con, java.util.Map data, java.lang.String idColumnName)
long	insertAndGetID(java.util.Map data)
long	insertAndGetID(java.util.Map data, java.lang.String idColumnName)
DBResults	search(java.sql.Connection con, java.lang.String[] dataColumns) Get all rows.
DBResults	search(java.sql.Connection con, java.lang.String searchColumn, int[] searchValues, java.lang.String[] dataColumns)
DBResults	search(java.sql.Connection con, java.lang.String searchColumn, int searchValue, java.lang.String[] dataColumns)
DBResults	search(java.sql.Connection con, java.lang.String whereClause, java.lang.String[] dataColumns)
DBResults	search(java.sql.Connection con, java.lang.String searchColumn, java.lang.String[] searchText, java.lang.String[] dataColumns)
DBResults	search(java.sql.Connection con, java.lang.String searchColumn, java.lang.String searchText, java.lang.String[] dataColumns)
DBResults	search(java.lang.String[] dataColumns) Get all rows.
DBResults	search(java.lang.String searchColumn, int[] searchValues, java.lang.String[] dataColumns)
DBResults	search(java.lang.String searchColumn, int searchValue, java.lang.String[] dataColumns)
DBResults	search(java.lang.String whereClause, java.lang.String[] dataColumns)
DBResults	search(java.lang.String searchColumn, java.lang.String[] searchText, java.lang.String[] dataColumns)
DBResults	search(java.lang.String searchColumn, java.lang.String searchText, java.lang.String[] dataColumns)
void	setDBFacade(DBFacade db)
void	setTableName(java.lang.String tableName)
void	update(java.sql.Connection con, java.lang.String whereClause, java.util.Map data)
void	update(java.sql.Connection con, java.lang.String column, java.lang.String searchText, java.util.Map data)
void	update(java.lang.String searchColumn, java.lang.String searchText, java.util.Map data)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TableFacade

public TableFacade(DBFacade db,
                   java.lang.String tableName)

Method Detail

getTableName

public java.lang.String getTableName()

setTableName

public void setTableName(java.lang.String tableName)

getDBFacade

public DBFacade getDBFacade()

setDBFacade

public void setDBFacade(DBFacade db)

search

public DBResults search(java.sql.Connection con,
                        java.lang.String whereClause,
                        java.lang.String[] dataColumns)
                 throws java.sql.SQLException

java.sql.SQLException

search

public DBResults search(java.lang.String whereClause,
                        java.lang.String[] dataColumns)
                 throws java.sql.SQLException

java.sql.SQLException

search

public DBResults search(java.sql.Connection con,
                        java.lang.String searchColumn,
                        java.lang.String searchText,
                        java.lang.String[] dataColumns)
                 throws java.sql.SQLException

java.sql.SQLException

search

public DBResults search(java.sql.Connection con,
                        java.lang.String searchColumn,
                        java.lang.String[] searchText,
                        java.lang.String[] dataColumns)
                 throws java.sql.SQLException

java.sql.SQLException

search

public DBResults search(java.lang.String searchColumn,
                        java.lang.String searchText,
                        java.lang.String[] dataColumns)
                 throws java.sql.SQLException

java.sql.SQLException

search

public DBResults search(java.lang.String searchColumn,
                        java.lang.String[] searchText,
                        java.lang.String[] dataColumns)
                 throws java.sql.SQLException

java.sql.SQLException

search

public DBResults search(java.sql.Connection con,
                        java.lang.String searchColumn,
                        int searchValue,
                        java.lang.String[] dataColumns)
                 throws java.sql.SQLException

java.sql.SQLException

search

public DBResults search(java.sql.Connection con,
                        java.lang.String searchColumn,
                        int[] searchValues,
                        java.lang.String[] dataColumns)
                 throws java.sql.SQLException

java.sql.SQLException

search

public DBResults search(java.lang.String searchColumn,
                        int searchValue,
                        java.lang.String[] dataColumns)
                 throws java.sql.SQLException

java.sql.SQLException

search

public DBResults search(java.lang.String searchColumn,
                        int[] searchValues,
                        java.lang.String[] dataColumns)
                 throws java.sql.SQLException

java.sql.SQLException

search

public DBResults search(java.sql.Connection con,
                        java.lang.String[] dataColumns)
                 throws java.sql.SQLException

Get all rows.

java.sql.SQLException

search

public DBResults search(java.lang.String[] dataColumns)
                 throws java.sql.SQLException

Get all rows.

java.sql.SQLException

update

public void update(java.sql.Connection con,
                   java.lang.String whereClause,
                   java.util.Map data)
            throws java.sql.SQLException

java.sql.SQLException

update

public void update(java.sql.Connection con,
                   java.lang.String column,
                   java.lang.String searchText,
                   java.util.Map data)
            throws java.sql.SQLException

java.sql.SQLException

update

public void update(java.lang.String searchColumn,
                   java.lang.String searchText,
                   java.util.Map data)
            throws java.sql.SQLException

java.sql.SQLException

delete

public void delete(java.sql.Connection con,
                   java.lang.String searchColumn,
                   java.lang.String searchText)
            throws java.sql.SQLException

java.sql.SQLException

delete

public void delete(java.lang.String searchColumn,
                   java.lang.String searchText)
            throws java.sql.SQLException

java.sql.SQLException

insert

public void insert(java.sql.Connection con,
                   java.util.Map data)
            throws java.sql.SQLException

java.sql.SQLException

insert

public void insert(java.util.Map data)
            throws java.sql.SQLException

java.sql.SQLException

insertAndGetID

public long insertAndGetID(java.util.Map data)
                    throws java.sql.SQLException

java.sql.SQLException

insertAndGetID

public long insertAndGetID(java.sql.Connection con,
                           java.util.Map data)
                    throws java.sql.SQLException

java.sql.SQLException

insertAndGetID

public long insertAndGetID(java.util.Map data,
                           java.lang.String idColumnName)
                    throws java.sql.SQLException

java.sql.SQLException

insertAndGetID

public long insertAndGetID(java.sql.Connection con,
                           java.util.Map data,
                           java.lang.String idColumnName)
                    throws java.sql.SQLException

java.sql.SQLException