Module de.chojo.sadu.mapper

Package de.chojo.sadu.mapper.util

Class Results

java.lang.Object

de.chojo.sadu.mapper.util.Results

public final class Results
extends Object

Utility class to handle and extract data from ResultSets and ResultSetMetaData

Method Summary

Modifier and Type	Method	Description
static Set<String>	columnNames(ResultSet set)	Get a set of column names in this result set
static Set<String>	columnNames(ResultSetMetaData meta)	Get a set of column names in this result set
static Set<String>	columnTypes(ResultSetMetaData meta)
static List<Long>	generatedKeys(Statement stmt)
static Optional<Integer>	getFirstColumnIndexOfType(ResultSetMetaData meta, List<SqlType> types)	Extracts the column index (1 based) of the first column with the requested type.

Methods inherited from class java.lang.Object

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

Method Details

columnNames

public static Set<String> columnNames(ResultSet set)
                               throws SQLException

Get a set of column names in this result set

Parameters:

set - result set.

Returns:

set of column names.

Throws:

SQLException - if a database access error occurs.

columnNames

public static Set<String> columnNames(ResultSetMetaData meta)
                               throws SQLException

Get a set of column names in this result set

Parameters:

meta - result set meta.

Returns:

set of column names.

Throws:

SQLException - if a database access error occurs.

getFirstColumnIndexOfType

public static Optional<Integer> getFirstColumnIndexOfType(ResultSetMetaData meta,
 List<SqlType> types)
                                                   throws SQLException

Extracts the column index (1 based) of the first column with the requested type.

Parameters:

meta - meta of the result set

types - a list of valid types where the index will be returned

Returns:

the index of the column with the first type contained in types

Throws:

SQLException - if a database access error occurs

columnTypes

public static Set<String> columnTypes(ResultSetMetaData meta)
                               throws SQLException

Throws:

SQLException

generatedKeys

public static List<Long> generatedKeys(Statement stmt)
                                throws SQLException

Throws:

SQLException