javatools.db
Class DbRow

java.lang.Object
  |
  +--javatools.db.DbRow

public class DbRow
extends java.lang.Object

A row of tabular data. This class can return fields in different formats. Care should be taken not to ask for a field in an inappropriate format. e.g. don't ask for a field of letters as a number.

TODO: More conversions can probably be done. e.g. convert varchar fields made of numbers into integers etc.


Field Summary
(package private)  DbTable table
           
(package private)  java.lang.Object[] values
           
 
Constructor Summary
(package private) DbRow(DbTable table)
          Not public.
 
Method Summary
 boolean getBool(java.lang.String name)
           
 java.lang.Boolean getBoolean(java.lang.String name)
           
 byte[] getBytes(java.lang.String name)
          Return a blob column as an array of bytes.
 int getInt(java.lang.String name)
          Return a column as an int.
 java.lang.Integer getInteger(java.lang.String name)
          Return a column as an Integer.
 java.lang.Number getNumber(java.lang.String name)
          Return a column as a number
 java.lang.String getString(java.lang.String name)
          Return a column as a String.
 DbTable getTable()
           
 java.lang.Object getValue(int n)
           
 java.lang.Object getValue(java.lang.String name)
          Return a column in the native type.
 java.lang.String toString()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

table

DbTable table

values

java.lang.Object[] values
Constructor Detail

DbRow

DbRow(DbTable table)
Not public. Use DbIterator.nextRow()

Method Detail

getTable

public DbTable getTable()

getValue

public java.lang.Object getValue(java.lang.String name)
                          throws DbException
Return a column in the native type.

DbException

getValue

public java.lang.Object getValue(int n)

getString

public java.lang.String getString(java.lang.String name)
                           throws DbException
Return a column as a String.

DbException

getNumber

public java.lang.Number getNumber(java.lang.String name)
                           throws DbException
Return a column as a number

DbException

getInteger

public java.lang.Integer getInteger(java.lang.String name)
                             throws DbException
Return a column as an Integer.

DbException

getBoolean

public java.lang.Boolean getBoolean(java.lang.String name)
                             throws DbException
DbException

getBool

public boolean getBool(java.lang.String name)
                throws DbException
DbException

getInt

public int getInt(java.lang.String name)
           throws DbException
Return a column as an int.

DbException

getBytes

public byte[] getBytes(java.lang.String name)
                throws DbException
Return a blob column as an array of bytes.

DbException

toString

public java.lang.String toString()
Overrides:
toString in class java.lang.Object