Package com.isomorphic.sql
Class SQLTransform
java.lang.Object
com.isomorphic.sql.SQLTransform
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 TypeMethodDescriptionstatic List
Converts all rows of aResultSet
object to return aList
ofMap
objects.static List
toListOfMaps
(ResultSet rs, long numRows) Converts aResultSet
object to return aList
ofMap
objects for the number of rows given bynumRows
.
-
Method Details
-
toListOfMaps
Converts all rows of aResultSet
object to return aList
ofMap
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 sourceException
-
toListOfMaps
Converts aResultSet
object to return aList
ofMap
objects for the number of rows given bynumRows
. This expanded signature is primarily useful if you're responding to a paged request.- Parameters:
rs
- object to be convertednumRows
- 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 sourceException
-