Package com.ribs.datasource

Class RMSQLUtils

java.lang.Object

com.ribs.datasource.RMSQLUtils

public class RMSQLUtils
extends Object

SQL Utility methods.

Constructor Summary

Constructors

Constructor	Description
RMSQLUtils()

Method Summary

Modifier and Type	Method	Description
static Map	getMapWithoutResultSets(Map aMap, int aDepth)	Returns map where any ResultSets have been converted to Lists.
static List	getResultSetAsListOfMaps(ResultSet aResultSet, int aLimit, String aClassName)	Returns a list of maps for a given ResultSet (adds aName as "Class" of maps).

Methods inherited from class java.lang.Object

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

Constructor Details

RMSQLUtils

public RMSQLUtils()

Method Details

getResultSetAsListOfMaps

public static List getResultSetAsListOfMaps(ResultSet aResultSet,
 int aLimit,
 String aClassName)

Returns a list of maps for a given ResultSet (adds aName as "Class" of maps).

Parameters:

aResultSet - the result set to be converted to a list of maps.

aLimit - the fetch limit for the list of maps. Use -1, 0 or Integer.MAX_VALUE for unlimited.

aClassName - an optional class name to be added to the record maps as Class=aClassName (null if not wanted).

getMapWithoutResultSets

public static Map getMapWithoutResultSets(Map aMap,
 int aDepth)

Returns map where any ResultSets have been converted to Lists. Copies the original Map if ResultSets exist.

Parameters:

aMap - the map to be stripped of result sets.

aDepth - the depth to traverse any nested maps or lists (suggested value: 2).