com.databasesandlife.util.jdbc

Class DbTransaction.DbQueryResultRow

java.lang.Object

com.databasesandlife.util.jdbc.DbTransaction.DbQueryResultRow

Enclosing class:

DbTransaction

public static class DbTransaction.DbQueryResultRow
extends Object

Method Summary

Modifier and Type	Method and Description
InputStream	getBinaryStream(String col) for the bytea/blob data type - returns the stream, does not convert to byte[]
Boolean	getBoolean(String col)
byte[]	getByteArray(String col) for the bytea/blob data type - returns byte[]
List<String>	getColumnNames()
Date	getDate(String col)
Double	getDouble(String col)
<T extends Enum<T>> T	getEnum(String col, Class<T> clazz)
<T extends Enum<T>> T[]	getEnumArray(String col, Class<? extends T> componentClass) The SELECT must supply a VARCHAR[] as PostgreSQL JDBC driver does not implement ENUM[].
Integer	getInt(String col)
Integer[]	getIntegerArray(String col)
org.joda.time.LocalDate	getJodatimeLocalDate(String col) Deprecated. prefer getLocalDate(String) (using java.time) rather than this method (using jodatime)
org.joda.time.LocalTime	getJodatimeLocalTime(String col) Deprecated. prefer getLocalTime(String) (using java.time) rather than this method (using jodatime)
java.time.LocalDate	getLocalDate(String col)
java.time.LocalTime	getLocalTime(String col)
Long	getLong(String col)
String	getString(String col)
String[]	getStringArray(String col)
YearMonthDay	getYearMonthDay(String col) Reads column as string and expects "YYYY-MM-DD" format
boolean	hasColumn(String columnName)

Methods inherited from class java.lang.Object

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

Method Detail

hasColumn

public boolean hasColumn(String columnName)

getColumnNames

public List<String> getColumnNames()

getBoolean

public Boolean getBoolean(String col)

getString

public String getString(String col)

getInt

public Integer getInt(String col)

getLong

public Long getLong(String col)

getDouble

public Double getDouble(String col)

getBinaryStream

public InputStream getBinaryStream(String col)

for the bytea/blob data type - returns the stream, does not convert to byte[]

Parameters:

col - column name

Returns:

InputStream

getByteArray

public byte[] getByteArray(String col)

for the bytea/blob data type - returns byte[]

Parameters:

col - column name

Returns:

byte[];

getDate

public Date getDate(String col)

getStringArray

public String[] getStringArray(String col)

getIntegerArray

public Integer[] getIntegerArray(String col)

getYearMonthDay

public YearMonthDay getYearMonthDay(String col)

Reads column as string and expects "YYYY-MM-DD" format

getJodatimeLocalDate

public org.joda.time.LocalDate getJodatimeLocalDate(String col)

Deprecated. prefer getLocalDate(String) (using java.time) rather than this method (using jodatime)

getJodatimeLocalTime

public org.joda.time.LocalTime getJodatimeLocalTime(String col)

Deprecated. prefer getLocalTime(String) (using java.time) rather than this method (using jodatime)

getLocalDate

public java.time.LocalDate getLocalDate(String col)

getLocalTime

public java.time.LocalTime getLocalTime(String col)

getEnum

public <T extends Enum<T>> T getEnum(String col,
                                     Class<T> clazz)

getEnumArray

public <T extends Enum<T>> T[] getEnumArray(String col,
                                            Class<? extends T> componentClass)

The SELECT must supply a VARCHAR[] as PostgreSQL JDBC driver does not implement ENUM[]. For example SELECT my_enum_array::VARCHAR[] ....