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.

Method Summary

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.
java.lang.Object	getValue(int n) Returns a value of a column.
java.lang.Object	getValue(java.lang.String name) Return a column in the native type.
java.lang.Object[]	getValueArray() Returns all the array of values.
int	getValueCount() Returns the number of contained values.
void	setValue(int n, java.lang.Object value) Sets a column value.
void	setValue(java.lang.String name, java.lang.Object value) Sets a column value in this row.
java.lang.String	toString() Converts this row in a string.

Methods inherited from class java.lang.Object

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

Method Detail

getValue

public java.lang.Object getValue(java.lang.String name)

Return a column in the native type.

Parameters:

name - The name of the column.

Returns:

The requested value.

setValue

public void setValue(java.lang.String name,
                     java.lang.Object value)

Sets a column value in this row.

Parameters:

name - The column name.

value - The value to be set.

getValue

public java.lang.Object getValue(int n)

Returns a value of a column.

Parameters:

n - The index of requested column.

Returns:

The requested value.

setValue

public void setValue(int n,
                     java.lang.Object value)

Sets a column value.

Parameters:

n - The index of requested column.

value - The new value to be set.

getValueCount

public int getValueCount()

Returns the number of contained values.

Returns:

The value count.

getValueArray

public java.lang.Object[] getValueArray()

Returns all the array of values.

Returns:

The complete array of values.

getString

public java.lang.String getString(java.lang.String name)

Return a column as a String.

Parameters:

name - The column name.

Returns:

The requested string.

getNumber

public java.lang.Number getNumber(java.lang.String name)

Return a column as a number

Parameters:

name - The column name.

Returns:

The column value.

getInteger

public java.lang.Integer getInteger(java.lang.String name)

Return a column as an Integer.

Parameters:

name - The column name.

Returns:

The column value.

getInt

public int getInt(java.lang.String name)

Return a column as an int.

Parameters:

name - The column name.

Returns:

The requested value.

getBytes

public byte[] getBytes(java.lang.String name)

Return a blob column as an array of bytes.

Parameters:

name - The column name.

Returns:

The requested array of bytes.

toString

public java.lang.String toString()

Converts this row in a string.

Overrides:

toString in class java.lang.Object

Returns:

The requested string.