sky.engine.connector.database
Class DBCachedRow

java.lang.Object
  sky.engine.connector.database.DBCachedRow

All Implemented Interfaces:

DBRow

public class DBCachedRow

extends java.lang.Object

implements DBRow

A row from the result set obtained after executing an SQL query. When a DBCachedRow method to get row data is invoked, the method first checks if the data has been already cached. If the data is already cached then the cached data is returned; otherwise, a call to underlying JDBC ResultSet or ResultSetMetaData object is made to fetch the data.

$RCSfile: DBCachedRow.java,v $
$Revision: 1.5 $, $Date: 2005/04/24 03:14:03 $

Field Summary

static FormattedResourceBundle

STRINGS

Constructor Summary

DBCachedRow(java.sql.ResultSet rset, java.sql.ResultSetMetaData rsmd)
Constructor

Method Summary

int	getColumnCount() Get total number of columns in this row.
java.lang.String	getColumnName(int pos) Get the name of column at the given position.
java.lang.String	getHTMLData(int pos) Get row data that appears undera given column, but replace all new lines in the data with <BR>
java.lang.String	getHTMLData(java.lang.String name) Get row data that appears undera given column, but replace all new lines in the data with <BR>
java.lang.String	getSQLData(int pos) Get row data that appears under a given column, but return a blank string in cases where data is sql "NULL" value in the database.
java.lang.String	getSQLData(java.lang.String name) Get row data that appears under a given column, but return a blank string in cases where data is sql "NULL" value in the database.
java.lang.String	getStringData(int pos) Get row data that appears under a given column, but return a blank string in cases where data is sql "NULL" value in the database.
java.lang.String	getStringData(java.lang.String name) Get row data that appears under a given column, but return a blank string in cases where data is sql "NULL" value in the database.
int	setColumnCount() REMOVE
java.lang.String	setColumnName(int pos, java.lang.String name) REMOVE
java.lang.String	setString(int pos, java.lang.String value) REMOVE
java.lang.String	setString(java.lang.String name, java.lang.String value) REMOVE
java.lang.String	toString() Convert this row to a string.

Methods inherited from class java.lang.Object

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

Field Detail

STRINGS

public static final FormattedResourceBundle STRINGS

Constructor Detail

DBCachedRow

public DBCachedRow(java.sql.ResultSet rset,
                   java.sql.ResultSetMetaData rsmd)

Constructor

Parameters:

rset - ResultSet obtained by executing a query.

rsmd - ResultSetMetaData obtained by executing a query.

Method Detail

getColumnCount

public int getColumnCount()
                   throws ErrorMessage

Get total number of columns in this row.

Specified by:

getColumnCount in interface DBRow

Returns:

column count.

Throws:

ErrorMessage - if there is a runtime error.

setColumnCount

public int setColumnCount()
                   throws ErrorMessage

REMOVE

Specified by:

setColumnCount in interface DBRow

Throws:

ErrorMessage

getStringData

public java.lang.String getStringData(int pos)
                               throws ErrorMessage

Get row data that appears under a given column, but return a blank string in cases where data is sql "NULL" value in the database.

Specified by:

getStringData in interface DBRow

Parameters:

pos - column id

Returns:

Row data that appears under a given column.

Throws:

ErrorMessage - if there is problem in getting the data.

getSQLData

public java.lang.String getSQLData(int pos)
                            throws ErrorMessage

Get row data that appears under a given column, but return a blank string in cases where data is sql "NULL" value in the database.

Specified by:

getSQLData in interface DBRow

Parameters:

pos - column id

Returns:

Row data that appears under a given column.

Throws:

ErrorMessage - if there is problem in getting the data.

getHTMLData

public java.lang.String getHTMLData(int pos)
                             throws ErrorMessage

Get row data that appears undera given column, but replace all new lines in the data with <BR>

Specified by:

getHTMLData in interface DBRow

Parameters:

pos - column id

Returns:

Row data that appears under a given column formatted as per HTML syntax rules.

Throws:

ErrorMessage - if there is a problem in getting and formatting the data.

setString

public java.lang.String setString(int pos,
                                  java.lang.String value)
                           throws ErrorMessage

REMOVE

Specified by:

setString in interface DBRow

Throws:

ErrorMessage

getStringData

public java.lang.String getStringData(java.lang.String name)
                               throws ErrorMessage

Get row data that appears under a given column, but return a blank string in cases where data is sql "NULL" value in the database.

Specified by:

getStringData in interface DBRow

Parameters:

name - column name

Returns:

Row data that appears under a given column.

Throws:

ErrorMessage - if there is problem in getting the data.

getSQLData

public java.lang.String getSQLData(java.lang.String name)
                            throws ErrorMessage

Get row data that appears under a given column, but return a blank string in cases where data is sql "NULL" value in the database.

Specified by:

getSQLData in interface DBRow

Parameters:

name - column name

Returns:

Row data that appears under a given column.

Throws:

ErrorMessage - if there is problem in getting the data.

getHTMLData

public java.lang.String getHTMLData(java.lang.String name)
                             throws ErrorMessage

Get row data that appears undera given column, but replace all new lines in the data with <BR>

Specified by:

getHTMLData in interface DBRow

Parameters:

name - column name

Returns:

Row data that appears under a given column formatted as per HTML syntax rules.

Throws:

ErrorMessage - if there is a problem in getting and formatting the data.

setString

public java.lang.String setString(java.lang.String name,
                                  java.lang.String value)
                           throws ErrorMessage

REMOVE

Specified by:

setString in interface DBRow

Throws:

ErrorMessage

getColumnName

public java.lang.String getColumnName(int pos)
                               throws ErrorMessage

Get the name of column at the given position.

Specified by:

getColumnName in interface DBRow

Parameters:

pos - column id.

Returns:

column name

Throws:

ErrorMessage - if there is problem getting the column name.

setColumnName

public java.lang.String setColumnName(int pos,
                                      java.lang.String name)
                               throws ErrorMessage

REMOVE

Specified by:

setColumnName in interface DBRow

Throws:

ErrorMessage

toString

public java.lang.String toString()

Convert this row to a string.

Specified by:

toString in interface DBRow

Returns:

String representation of this row.