br.ufscar.saci.base.database

Class ResultSetHelper

java.lang.Object

br.ufscar.saci.base.database.ResultSetHelper

public class ResultSetHelper
extends Object

Constructor Summary

Constructors

Constructor and Description
ResultSetHelper(ResultSet rs)

Method Summary

Methods

Modifier and Type	Method and Description
boolean	getBoolean(String name) Returns an non null boolean from the result set.
Date	getDate(String name) Returns a partial date (year, month and day) from the database.
Date	getDateTime(String name) Returns a full date (from seconds to year) from the database.
double	getDouble(String name) Returns a non null double from the result set.
Double	getDoubleNull(String name) Returns a possible null double from the result set.
float	getFloat(String name) Returns a non null float from the result set.
Float	getFloatNull(String name) Returns a possible null float from the result set.
int	getInt(String name) Returns a non null int from the result set.
Integer	getInteger(String name) Returns a possibly null integer from the result set.
ResultSet	GetResultSet()
String	getString(String name) Returns a string from the result set (non null).
Date	getTime(String name) Returns a partial date (hour, minute, second) from the database.

Methods inherited from class java.lang.Object

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

Constructor Detail

ResultSetHelper

public ResultSetHelper(ResultSet rs)

Method Detail

GetResultSet

public ResultSet GetResultSet()

getBoolean

public boolean getBoolean(String name)
                   throws SQLException

Returns an non null boolean from the result set.

Parameters:

name -

Returns:

Throws:

SQLException

getDateTime

public Date getDateTime(String name)
                 throws SQLException

Returns a full date (from seconds to year) from the database.

Parameters:

name -

Returns:

Throws:

SQLException

getDate

public Date getDate(String name)
             throws SQLException

Returns a partial date (year, month and day) from the database.

Parameters:

name -

Returns:

Throws:

SQLException

getDouble

public double getDouble(String name)
                 throws SQLException

Returns a non null double from the result set.

Parameters:

name -

Returns:

Throws:

SQLException

getDoubleNull

public Double getDoubleNull(String name)
                     throws SQLException

Returns a possible null double from the result set.

Parameters:

name -

Returns:

Throws:

SQLException

getFloat

public float getFloat(String name)
               throws SQLException

Returns a non null float from the result set.

Parameters:

name -

Returns:

Throws:

SQLException

getFloatNull

public Float getFloatNull(String name)
                   throws SQLException

Returns a possible null float from the result set.

Parameters:

name -

Returns:

Throws:

SQLException

getInt

public int getInt(String name)
           throws SQLException

Returns a non null int from the result set.

Parameters:

name -

Returns:

Throws:

SQLException

getInteger

public Integer getInteger(String name)
                   throws SQLException

Returns a possibly null integer from the result set.

Parameters:

name -

Returns:

Throws:

SQLException

getString

public String getString(String name)
                 throws SQLException

Returns a string from the result set (non null).

Note: null string in a database doesn't make much sense. For convenience, null is never returned ("" is used instead).

Parameters:

name -

Returns:

Throws:

SQLException

getTime

public Date getTime(String name)
             throws SQLException

Returns a partial date (hour, minute, second) from the database.

Parameters:

name -

Returns:

Throws:

SQLException