quadbase.reportdesigner.ReportAPI
Class DbData

java.lang.Object
  |
  +--quadbase.reportdesigner.ReportAPI.DbData

All Implemented Interfaces:

IResultSet, IRow

Direct Known Subclasses:

DbDataCollection

public class DbData

extends java.lang.Object

implements IResultSet

This class provides an implementation for the quadbase.reportdesigner.util.IResultSet interface using an array of data. IResultSet is used to provide input data to a report. DbData holds the data information necessary to plot a report. They are (i) data type for each column (ii) name for each column (iii) a list of data records

See Also:

IResultSet

Constructor Summary

protected	DbData() Allocates a new DbData Object
	DbData(java.lang.String s) Construct DbData by parsing the data value argument in HTML page
	DbData(java.lang.String[] fieldName, java.lang.Object[][] records) Construct a new DbData class
	DbData(java.lang.String[] dataType, java.lang.String[] fieldName, java.lang.String[][] records) Construct a new DbData class

Method Summary

java.lang.Object[][]	getData() Get the record data, field j of record i is stored in position [i][j] of the result as an Object of that type.
java.lang.String[]	getFieldName() Deprecated. Please use the getMetaData method to obtain this information
int[]	getFieldType() Deprecated. Please use the getMetaData method to obtain this information
IRSMetaData	getMetaData() Get the original data
java.lang.Object	getObject(int col) Get the object at the specified col
protected void	init(java.lang.String[] dataType, java.lang.String[] fieldName, java.lang.String[][] records) Initializes the DbData Object with data
boolean	next() Go to the next row

Methods inherited from class java.lang.Object

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

Constructor Detail

DbData

protected DbData()

Allocates a new DbData Object

DbData

public DbData(java.lang.String[] dataType,
              java.lang.String[] fieldName,
              java.lang.String[][] records)
       throws java.lang.IllegalArgumentException

Construct a new DbData class

Parameters:

dataType - an array of dataType specify by String. The following are valid data type recognize by the class.
integer : "int", "integer", "smallint", tinyint" or "short"
long : "long", "bigint"
numeric : "numeric"
decimal : "decimal"
float : "float", "real"
double : "double"
time : "time"
date : "date"
timestamp : "timestamp"
varchar : "string", "varchar"
longvarchar : "longvarchar"
boolean : "boolean", "logical", "bit"
Data type names are case insensitive.

fieldName - an array of name for each field in the record

records - array of record, record[i] consists of array of size n where n = size of dataType = size of fieldName. Each field j in i, i.e. record[i][j] represent the data pass as string. The class will convert the string to appropriate data type. For null field value use set record to null If there is a size mismatch or invalid record entry that can't convert to destination data type, an IllegalArgumentException is thrown.

DbData

public DbData(java.lang.String[] fieldName,
              java.lang.Object[][] records)
       throws java.lang.IllegalArgumentException

Construct a new DbData class

Parameters:

fieldName - an array of name for each field in the record

records - array of record, record[i] consists of array of size n where n = size of dataType = size of fieldName. Each field j in i, i.e. record[i][j] represent the data pass as string. The class will convert the string to appropriate data type. For null field value use set record to null If there is a size mismatch or invalid record entry that can't convert to destination data type, an IllegalArgumentException is thrown.

DbData

public DbData(java.lang.String s)
       throws java.lang.IllegalArgumentException

Construct DbData by parsing the data value argument in HTML page

Parameters:

s - string value from the HTML page

Method Detail

init

protected void init(java.lang.String[] dataType,
                    java.lang.String[] fieldName,
                    java.lang.String[][] records)
             throws java.lang.IllegalArgumentException

Initializes the DbData Object with data

Parameters:

dataType - an array of dataType specify by String. The following are valid data type recognize by the class.
integer : "int", "integer", "smallint", tinyint" or "short"
long : "long", "bigint"
numeric : "numeric"
decimal : "decimal"
float : "float", "real"
double : "double"
time : "time"
date : "date"
timestamp : "timestamp"
varchar : "string", "varchar"
longvarchar : "longvarchar"
boolean : "boolean", "logical", "bit"
Data type names are case insensitive.

fieldName - an array of name for each field in the record

records - array of record, record[i] consists of array of size n where n = size of dataType = size of fieldName. Each field j in i, i.e. record[i][j] represent the data pass as string. The class will convert the string to appropriate data type. For null field value use set record to null If there is a size mismatch or invalid record entry that can't convert to destination data type, an IllegalArgumentException is thrown.

getFieldName

public java.lang.String[] getFieldName()

Deprecated. Please use the getMetaData method to obtain this information

Get the field names for the data store in this class

Returns:

an array of field name

getFieldType

public int[] getFieldType()

Deprecated. Please use the getMetaData method to obtain this information

Get the field data type for the data store in this class.

Returns:

an array of integer represent the field data type. The integer is defined in jdbc/Types.class

getData

public java.lang.Object[][] getData()

Get the record data, field j of record i is stored in position [i][j] of the result as an Object of that type.

Returns:

2D array of record data.

next

public final boolean next()
                   throws java.lang.Exception

Go to the next row

Specified by:

next in interface IResultSet

getMetaData

public final IRSMetaData getMetaData()
                              throws java.lang.Exception

Get the original data

Specified by:

getMetaData in interface IResultSet

getObject

public final java.lang.Object getObject(int col)
                                 throws java.lang.Exception

Get the object at the specified col

Specified by:

getObject in interface IRow

Following copied from interface: quadbase.reportdesigner.util.IRow

Parameters:

colNo - The column number for the field, beginning with 1.

Returns:

The data value stored in that column field.