com.reportmill.datasource
Class RMSQLUtils

java.lang.Object
  com.reportmill.datasource.RMSQLUtils

public class RMSQLUtils
extends java.lang.Object

SQL Utility methods.

Constructor Summary

RMSQLUtils()

Method Summary

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

Methods inherited from class java.lang.Object

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

Constructor Detail

RMSQLUtils

public RMSQLUtils()

Method Detail

getResultSetAsListOfMaps

public static java.util.List getResultSetAsListOfMaps(java.sql.ResultSet aResultSet,
                                                      int aLimit,
                                                      java.lang.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 java.util.Map getMapWithoutResultSets(java.util.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).