Package com.ribs.datasource

Class RMSQLUtils

  • public class RMSQLUtils
extends java.lang.Object
    SQL Utility methods.

    • Constructor Summary

      Constructors 
      Constructor Description
      RMSQLUtils()  

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      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

        clone, equals, finalize, 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).