com.ergotech.vib.historical

Class ResultSetToTwoDimensionalValueObject

java.lang.Object

com.ergotech.vib.historical.ResultSetToTwoDimensionalValueObject

public abstract class ResultSetToTwoDimensionalValueObject
extends java.lang.Object

This utility class provides a method to convert from a ResultSet to a TwoDimensionalValueObject

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	cvsRev The CVS Revision String.

Constructor Summary

Constructors

Constructor and Description
ResultSetToTwoDimensionalValueObject()

Method Summary

Modifier and Type	Method and Description
static ValueObjectInterface	convertToValueObject(java.sql.ResultSet rs, java.sql.Connection connection) This method will take the result set and move it to the 2D value object.
static java.lang.String	formatResultSet(java.sql.ResultSet rs) Used for debugging, this will print the results somewhat intelligently.

Methods inherited from class java.lang.Object

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

Field Detail

cvsRev

public static final java.lang.String cvsRev

The CVS Revision String.

See Also:

Constant Field Values

Constructor Detail

ResultSetToTwoDimensionalValueObject

public ResultSetToTwoDimensionalValueObject()

Method Detail

convertToValueObject

public static ValueObjectInterface convertToValueObject(java.sql.ResultSet rs,
                                                        java.sql.Connection connection)
                                                 throws java.sql.SQLException

This method will take the result set and move it to the 2D value object. If the first column is a TIMESTAMP or DATE type OR the value in the first column of the first row is a String in the format "yyyy-MM-dd HH:mm:ss.SSzzz" or "yyyy-MM-dd HH:mm:ss.SS" the returned TwoDimensionalValueObject will have one less column than the incoming result set, but will maintain a "readingTime".

Parameters:

rs -

Returns:

Throws:

java.sql.SQLException

formatResultSet

public static java.lang.String formatResultSet(java.sql.ResultSet rs)

Used for debugging, this will print the results somewhat intelligently.