weave.utils

Class SQLResult

java.lang.Object

weave.utils.SQLResult

public class SQLResult
extends java.lang.Object

This is a lightweight object that holds the data in a 2D Array from a ResultSet. The column names and their corresponding type are stored in an array (columnNames and columnTypes respectively)

Author:

Andy Dufilie

Field Summary

Fields

Modifier and Type	Field and Description
java.lang.String[]	columnNames An array of column names from the ResultSetMetaData of the original ResultSet.
int[]	columnTypes An array of column types from the ResultSetMetaData of the original ResultSet.
static int	FETCH_SIZE
java.lang.Object[][]	rows A table of values from the original ResultSet.

Constructor Summary

Constructors

Constructor and Description
SQLResult(java.sql.ResultSet rs)
SQLResult(java.sql.ResultSet rs, boolean convertToStrings)

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	toString()

Methods inherited from class java.lang.Object

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

Field Detail

FETCH_SIZE

public static final int FETCH_SIZE

See Also:

Constant Field Values

columnNames

public java.lang.String[] columnNames

An array of column names from the ResultSetMetaData of the original ResultSet.

columnTypes

public int[] columnTypes

An array of column types from the ResultSetMetaData of the original ResultSet.

rows

public java.lang.Object[][] rows

A table of values from the original ResultSet.

Constructor Detail

SQLResult

public SQLResult(java.sql.ResultSet rs)
          throws java.sql.SQLException

Throws:

java.sql.SQLException

SQLResult

public SQLResult(java.sql.ResultSet rs,
         boolean convertToStrings)
          throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

Returns:

A CSV representation of the data.

See Also:

Object.toString()