Package org.fbsql.servlet

Class QueryUtils

  • public class QueryUtils
extends java.lang.Object
    Provides utility methods for convert ResutlSet to JSON.

    • Field Summary

      Fields 
      Modifier and Type Field Description
      static int RESULT_FORMAT_ARRAY_OF_ARRAYS
      Format results as JSON array of arrays 2D-array (this format may be useful in case you want to hide ResultSet column names from client)
      static int RESULT_FORMAT_ARRAY_OF_OBJECTS
      Format results as JSON array of objects Default format

    • Constructor Summary

      Constructors 
      Constructor Description
      QueryUtils()  

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static byte[] compress​(byte[] bs, int compressionLevel)
      Compress byte array using ZLIB compression algorithm
      static java.util.List<java.util.Map<java.lang.String,​java.lang.String>> convertJsonArrayOfObjectsToListOfMaps​(java.lang.String jsonArrayOfObjects)
      Parse JSON array of objects
      static java.lang.String convertToJsonArray​(java.util.List<java.lang.String> paramJsons)  
      static java.lang.String convertToJsonArray​(java.util.List<java.util.Map<java.lang.String,​java.lang.String>> list, int resultSetFormat)
      Converts list of results to JSON array
      static java.lang.String convertToJsonObject​(java.util.List<java.util.Map<java.lang.String,​java.lang.String>> list, int resultSetFormat)
      Converts list with only one element (list.size() == 1) to JSON object
      static ReadyResult createReadyResult​(java.util.List<java.util.Map<java.lang.String,​java.lang.String>> list, int resultSetFormat, int compressionLevel, java.util.Base64.Encoder encoder)
      Converts list of results to ReadyResult object
      static java.util.List<java.util.Map<java.lang.String,​java.lang.String>> listOfMapsToListOfMapsJsonValues​(java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> list, java.util.Base64.Encoder encoder)
      Converts list of maps to list of maps Json strings
      private static void map2JsonArray​(java.util.Map<java.lang.String,​java.lang.String> map, java.lang.StringBuilder sb)
      Converts map to JSON array
      private static void map2JsonObject​(java.util.Map<java.lang.String,​java.lang.String> map, java.lang.StringBuilder sb)
      Converts map to JSON object
      static java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> resutlSetToListOfMaps​(java.sql.ResultSet rs)
      Converts ResutlSet to list of maps
      static java.util.List<java.util.Map<java.lang.String,​java.lang.String>> resutlSetToListOfMapsJsonValues​(java.sql.ResultSet rs, java.util.Base64.Encoder encoder)  
      static java.lang.String valueToJsonString​(java.lang.Object value, java.util.Base64.Encoder encoder)  

      • Methods inherited from class java.lang.Object

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

    • Method Detail

      • convertJsonArrayOfObjectsToListOfMaps

        public static java.util.List<java.util.Map<java.lang.String,​java.lang.String>> convertJsonArrayOfObjectsToListOfMaps​(java.lang.String jsonArrayOfObjects)
        Parse JSON array of objects
        Parameters:
        jsonArrayOfObjects -
        Returns:

      • createReadyResult

        public static ReadyResult createReadyResult​(java.util.List<java.util.Map<java.lang.String,​java.lang.String>> list,
                                            int resultSetFormat,
                                            int compressionLevel,
                                            java.util.Base64.Encoder encoder)
                                     throws java.sql.SQLException,
                                            java.io.IOException
        Converts list of results to ReadyResult object
        Parameters:
        list - - result list to convert
        resultSetFormat - - result set format
        encoder - - Base64 encoder
        Returns:
        - ReadyResult object
        Throws:
        java.sql.SQLException
        java.io.IOException

      • listOfMapsToListOfMapsJsonValues

        public static java.util.List<java.util.Map<java.lang.String,​java.lang.String>> listOfMapsToListOfMapsJsonValues​(java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> list,
                                                                                                                      java.util.Base64.Encoder encoder)
                                                                                                               throws java.sql.SQLException,
                                                                                                                      java.io.IOException
        Converts list of maps to list of maps Json strings
        Parameters:
        rs - - ResultSet to convert
        encoder - - Base64 encoder
        Returns:
        - list of maps
        Throws:
        java.sql.SQLException
        java.io.IOException

      • resutlSetToListOfMapsJsonValues

        public static java.util.List<java.util.Map<java.lang.String,​java.lang.String>> resutlSetToListOfMapsJsonValues​(java.sql.ResultSet rs,
                                                                                                                     java.util.Base64.Encoder encoder)
                                                                                                              throws java.sql.SQLException,
                                                                                                                     java.io.IOException
        Throws:
        java.sql.SQLException
        java.io.IOException

      • valueToJsonString

        public static java.lang.String valueToJsonString​(java.lang.Object value,
                                                 java.util.Base64.Encoder encoder)
                                          throws java.sql.SQLException
        Parameters:
        value -
        encoder -
        Returns:
        Throws:
        java.sql.SQLException

      • resutlSetToListOfMaps

        public static java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> resutlSetToListOfMaps​(java.sql.ResultSet rs)
                                                                                                    throws java.sql.SQLException,
                                                                                                           java.io.IOException
        Converts ResutlSet to list of maps
        Parameters:
        rs - - ResultSet to convert
        encoder - - Base64 encoder
        Returns:
        - list of maps
        Throws:
        java.sql.SQLException
        java.io.IOException

      • convertToJsonArray

        public static java.lang.String convertToJsonArray​(java.util.List<java.lang.String> paramJsons)

      • convertToJsonArray

        public static java.lang.String convertToJsonArray​(java.util.List<java.util.Map<java.lang.String,​java.lang.String>> list,
                                                  int resultSetFormat)
        Converts list of results to JSON array
        Parameters:
        list - - result list to convert
        resultSetFormat - - result set format
        Returns:
        - JSON array

      • convertToJsonObject

        public static java.lang.String convertToJsonObject​(java.util.List<java.util.Map<java.lang.String,​java.lang.String>> list,
                                                   int resultSetFormat)
        Converts list with only one element (list.size() == 1) to JSON object
        Parameters:
        list - - result list with only one element (list.size() == 1) to convert
        resultSetFormat - - result set format
        Returns:
        - JSON object

      • map2JsonArray

        private static void map2JsonArray​(java.util.Map<java.lang.String,​java.lang.String> map,
                                  java.lang.StringBuilder sb)
        Converts map to JSON array
        Parameters:
        map - - map to convert
        sb - - StringBuilder to output results

      • map2JsonObject

        private static void map2JsonObject​(java.util.Map<java.lang.String,​java.lang.String> map,
                                   java.lang.StringBuilder sb)
        Converts map to JSON object
        Parameters:
        map - - map to convert
        sb - - StringBuilder to output results

      • compress

        public static byte[] compress​(byte[] bs,
                              int compressionLevel)
                       throws java.io.IOException
        Compress byte array using ZLIB compression algorithm
        Parameters:
        bs - - source byte array
        Returns:
        - compressed byte array
        Throws:
        java.io.IOException