Package com.isomorphic.sql

Class SQLTransform

java.lang.Object
com.isomorphic.sql.SQLTransform
public class SQLTransform extends Object
SQLTransform provides helper methods for converting java.sql.ResultSet objects to desired return data structures. See the DataSource Operations section of the client reference docs for a mapping of operationType to expected data structure.

  • Method Summary

    Modifier and Type
    Method
    Description
    static List
    toListOfMaps(ResultSet rs)
    Converts all rows of a ResultSet object to return a List of Map objects.
    static List
    toListOfMaps(ResultSet rs, long numRows)
    Converts a ResultSet object to return a List of Map objects for the number of rows given by numRows.

  • Method Details

    • toListOfMaps

      public static List toListOfMaps(ResultSet rs) throws Exception
      Converts all rows of a ResultSet object to return a List of Map objects.

      Parameters:
      rs - object to be converted
      Returns:
      list containing the result as a map of name-value pairs
      Throws:
      SQLException - propagates any errors encountered in connecting to the data source
      Exception

    • toListOfMaps

      public static List toListOfMaps(ResultSet rs, long numRows) throws Exception
      Converts a ResultSet object to return a List of Map objects for the number of rows given by numRows. This expanded signature is primarily useful if you're responding to a paged request.
      Parameters:
      rs - object to be converted
      numRows - the number of rows to convert
      Returns:
      list containing the result as a java.util.Map of name-value pairs
      Throws:
      SQLException - propagates any errors encountered in connecting to the data source
      Exception