org.apache.oozie.util.db

Class SqlStatement.ResultSetReader

java.lang.Object

org.apache.oozie.util.db.SqlStatement.ResultSetReader

Enclosing class:

SqlStatement

public static class SqlStatement.ResultSetReader
extends java.lang.Object

ResultSetReader is used to parse the result set and gives methods for getting appropriate type of data given the column name

Method Summary

Methods

Modifier and Type	Method and Description
void	close() Close the Result Set
<T> T	get(java.lang.Class<T> clazz, Schema.Column col) Get the Column data given its type and name
java.lang.Boolean	getBoolean(Schema.Column col) Get the Boolean Column
byte[]	getByteArray(Schema.Column col) Get the data for columns with blob type
java.lang.Long	getLong(Schema.Column col) Get the Numeric data
java.lang.String	getString(Schema.Column col) Get a String Column
java.sql.Timestamp	getTimestamp(Schema.Column col) Get the Timestamp Column
boolean	next() Move the Result Set to next record

Methods inherited from class java.lang.Object

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

Method Detail

next

public boolean next()
             throws java.sql.SQLException

Move the Result Set to next record

Returns:

true if there is a next record

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Close the Result Set

Throws:

java.sql.SQLException

get

public <T> T get(java.lang.Class<T> clazz,
        Schema.Column col)
      throws java.sql.SQLException

Get the Column data given its type and name

Type Parameters:

T - Type of the column

Parameters:

clazz - Class of the Type

col - Column name

Returns:

Column data

Throws:

java.sql.SQLException

getByteArray

public byte[] getByteArray(Schema.Column col)
                    throws java.sql.SQLException

Get the data for columns with blob type

Parameters:

col - Column name

Returns:

Column data

Throws:

java.sql.SQLException

getString

public java.lang.String getString(Schema.Column col)
                           throws java.sql.SQLException

Get a String Column

Parameters:

col - Column Name

Returns:

Column data

Throws:

java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(Schema.Column col)
                                throws java.sql.SQLException

Get the Timestamp Column

Parameters:

col - Column name

Returns:

Column data

Throws:

java.sql.SQLException

getBoolean

public java.lang.Boolean getBoolean(Schema.Column col)
                             throws java.sql.SQLException

Get the Boolean Column

Parameters:

col - Column name

Returns:

Column data

Throws:

java.sql.SQLException

getLong

public java.lang.Long getLong(Schema.Column col)
                       throws java.sql.SQLException

Get the Numeric data

Parameters:

col - Column name

Returns:

Column data

Throws:

java.sql.SQLException