Package com.oopsclick.silk.dbo

Class DataProvider

  • public class DataProvider
extends java.lang.Object
    The Class DataProvider interfaces with the programmer and provided methods to operate SQL operations.
    Author:
    Italo Osorio

    • Constructor Summary

      Constructors 
      Constructor Description
      DataProvider​(java.lang.String ormFileLocation)
      Instantiates a new data provider using the ormFileLocation
      DataProvider​(java.lang.String ormFileLocation, int debugLevel)
      Instantiates a new data provider.
      DataProvider​(java.lang.String ormFileLocation, int debugLevel, javax.servlet.http.HttpSession session)
      Instantiates a new data provider.
      DataProvider​(java.lang.String ormFileLocation, RequestObject requestObject)
      Instantiates a new data provider.
      DataProvider​(java.lang.String ormFileLocation, RequestObject requestObject, ResponseObject responseObject, int debugLevel, javax.servlet.http.HttpSession session)
      Instantiates a new data provider.
      DataProvider​(java.lang.String ormFileLocation, RequestObject requestObject, javax.servlet.http.HttpSession session)
      Instantiates a new data provider.
      DataProvider​(java.lang.String ormFileLocation, javax.servlet.http.HttpSession session)
      Instantiates a new data provider.

    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      int batch()
      Executes the BATCH action.
      void cleanOperation()
      Cleans the operation items to received new values.
      int delete()
      Executes the DELETE action.
      int exec​(java.lang.String operationName)
      Executes the operation identify by the name provided
      java.util.Map<java.lang.String,​java.lang.Object> findItem​(java.lang.String searchColumn, java.lang.Object searchValue)  
      java.lang.Object findItem​(java.lang.String searchColumn, java.lang.Object searchValue, java.lang.String returnColumn)  
      java.time.LocalDateTime getDateItem​(int index, java.lang.String column)
      Gets the item's column from the data Array Collection at the provided index, casted to the type Date.
      java.time.LocalDateTime getDateItem​(int index, java.lang.String column, java.time.LocalDateTime nullValue)
      Gets the item's column from the data Array Collection at the provided index casted to the type Date.
      java.time.LocalDateTime getDateItem​(java.lang.String column)
      Gets the item's column from the data Array Collection at position 0, casted to the type Date.
      java.lang.String getDateStringItem​(int index, java.lang.String column)
      Gets the item's column from the data Array Collection at the provided index, formated to "yyyy-MM-dd", and casted to the type String.
      java.lang.String getDateStringItem​(int index, java.lang.String column, java.lang.String dateFormat)
      Gets the item's column from the data Array Collection at the provided index, using the provided format, and casted to the type String.
      java.lang.String getDateStringItem​(java.lang.String column)
      Gets the item's column from the data Array Collection at position 0, formated to "yyyy-MM-dd", and casted to the type String.
      java.lang.String getDateStringItem​(java.lang.String column, java.lang.String dateFormat)
      Gets the item's column from the data Array Collection at position 0, using the provided format, and casted to the type String.
      java.lang.Double getDoubleItem​(int index, java.lang.String column)
      Gets the item's column from the data Array Collection at the provided index, casted to the type Double.
      java.lang.Double getDoubleItem​(int index, java.lang.String column, java.lang.Double nullValue)
      Gets the item's column from the data Array Collection at the provided index, casted to the type Double.
      java.lang.Double getDoubleItem​(java.lang.String column)
      Gets the item's column from the data Array Collection at position 0, casted to the type Double.
      java.lang.String getDoubleStringItem​(int index, java.lang.String column)
      Gets the item's column from the data Array Collection at the provided index, formated as "#,###,##0.00", and casted to the type String.
      java.lang.String getDoubleStringItem​(int index, java.lang.String column, java.lang.String doubleFormat)
      Gets the item's column from the data Array Collection at the provided index, using the provided format, and casted to the type String.
      java.lang.String getDoubleStringItem​(java.lang.String column)
      Gets the item's column from the data Array Collection at position 0, formated as "#,###,##0.00", and casted to the type String.
      java.lang.String getDoubleStringItem​(java.lang.String column, java.lang.String doubleFormat)
      Gets the item's column from the data Array Collection at position 0, using the provided format, and casted to the type String.
      java.lang.String getEscapeString​(int index, java.lang.String column)  
      java.lang.String getEscapeString​(int index, java.lang.String column, java.lang.String nullValue)  
      java.lang.String getEscapeString​(java.lang.String column)  
      int getIntItem​(int index, java.lang.String column)
      Gets the item's column from the data Array Collection at the provided index, casted to the type Integer.
      int getIntItem​(int index, java.lang.String column, int nullValue)
      Gets the item's column from the data Array Collection at the provided index, casted to the type Integer.
      int getIntItem​(java.lang.String column)
      Gets the item's column from the data Array Collection at position 0, casted to the type Integer.
      java.lang.String getIntStringItem​(int index, java.lang.String column)
      Gets the item's column from the data Array Collection at the provided index, formated as "#,###,##", and casted to the type String.
      java.lang.String getIntStringItem​(int index, java.lang.String column, java.lang.String intFormat)
      Gets the item's column from the data Array Collection at the provided index, in the provided format, and casted to the type String.
      java.lang.String getIntStringItem​(java.lang.String column)
      Gets the item's column from the data Array Collection at position 0, formated as "#,###,##", and casted to the type String.
      java.lang.String getIntStringItem​(java.lang.String column, java.lang.String intFormat)
      Gets the item's column from the data Array Collection at position 0, using the provided format, and casted to the type String.
      java.lang.Object getItem​(java.lang.String column)
      Gets the item's column from the first element in data Array Collection
      java.lang.Object getItemAt​(int index)
      Gets the item from the data Array Collection at the provided position
      java.lang.Object getItemAt​(int index, java.lang.String column)
      Gets the item's column from the data Array Collection at the provided index position
      java.lang.Long getLongItem​(int index, java.lang.String column)
      Gets the item's column from the data Array Collection at the provided index, casted to the type Long.
      java.lang.Long getLongItem​(int index, java.lang.String column, java.lang.Long nullValue)
      Gets the item's column from the data Array Collection at the provided index casted to the type Long.
      java.lang.Long getLongItem​(java.lang.String column)
      Gets the item's column from the data Array Collection at position 0, casted to the type Long.
      int getNewPkIntValue()
      Gets the new value of the last insert process as String;
      java.lang.String getNewPkStringValue()
      Gets the new value of the last insert process as String;
      java.lang.Object getNewPkValue()
      Gets the new PK value of the last insert process.
      RequestObject getRequestObject()
      Gets the request object.
      ResponseObject getResponseObject()
      Gets the return object.
      java.lang.String getStringItem​(int index, java.lang.String column)
      Gets the item's column from the data Array Collection at the provided index, casted to the type String.
      java.lang.String getStringItem​(int index, java.lang.String column, java.lang.String nullValue)
      Gets the item's column from the data Array Collection at the provided index, casted to the type String.
      java.lang.String getStringItem​(java.lang.String column)
      Gets the item's column from the data Array Collection at position 0, casted to the type String.
      java.time.LocalTime getTimeItem​(int index, java.lang.String column)
      Gets the item's column from the data Array Collection at the provided index, casted to the type Date.
      java.time.LocalTime getTimeItem​(int index, java.lang.String column, java.time.LocalTime nullValue)
      Gets the item's column from the data Array Collection at the provided index casted to the type Date.
      java.time.LocalTime getTimeItem​(java.lang.String column)
      Gets the item's column from the data Array Collection at position 0, casted to the type Date.
      java.lang.String getTimeStringItem​(int index, java.lang.String column)
      Gets the item's column from the data Array Collection at the provided index, formated to "yyyy-MM-dd", and casted to the type String.
      java.lang.String getTimeStringItem​(int index, java.lang.String column, java.lang.String dateFormat)
      Gets the item's column from the data Array Collection at the provided index, using the provided format, and casted to the type String.
      java.lang.String getTimeStringItem​(java.lang.String column)
      Gets the item's column from the data Array Collection at position 0, formated to "yyyy-MM-dd", and casted to the type String.
      java.lang.String getTimeStringItem​(java.lang.String column, java.lang.String dateFormat)
      Gets the item's column from the data Array Collection at position 0, using the provided format, and casted to the type String.
      int insert()
      Executes the INSERT action.
      int length()  
      int select()
      Executes the SELECT action using the "default" select's name.
      int select​(java.lang.String selectName)
      Executes the SELECT action using the provided select's name.
      void setAuthorizationList​(java.lang.String authorizationList)
      Set the authorizationList
      void setLangID​(java.lang.String lang)
      Set the language
      void setOperationAction​(int index, java.lang.String action)
      Sets the operation item action at the operation list index position.
      void setOperationItem​(int index, java.lang.String column, java.lang.Object value)
      Sets the operation item at the operation list index position.
      void setOperationItem​(java.lang.String column, java.lang.Object value)
      Sets the operation item for a single operation item.
      void setParameter​(java.lang.String column, java.lang.Object value)
      Sets the parameter information setting the type based on the value object's class with secure as false.
      void setParameter​(java.lang.String column, java.lang.Object value, int secure)
      Sets the parameter information setting the type based on the value object's class.
      void setParameter​(java.lang.String column, java.lang.Object value, java.lang.Class<?> type)
      Sets the parameter information with secure as false;
      void setParameter​(java.lang.String column, java.lang.Object value, java.lang.Class<?> type, int secure)
      Sets the parameter information.
      void setRequestObject​(RequestObject requestObject)
      Sets the request object.
      void setResponseObject​(ResponseObject responseObject)
      Sets the return object.
      void setSession​(javax.servlet.http.HttpSession session)
      Sets the session attributes if necessary
      int size()
      Returns the number of element in the data Array Collection.
      int update()
      Executes the UPDATE action.

      • Methods inherited from class java.lang.Object

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

    • Constructor Detail

      • DataProvider

        public DataProvider​(java.lang.String ormFileLocation)
             throws java.io.IOException,
                    javax.xml.parsers.ParserConfigurationException,
                    org.xml.sax.SAXException,
                    SilkException
        Instantiates a new data provider using the ormFileLocation
        Parameters:
        ormFileLocation - the ORM file location
        Throws:
        java.io.IOException - Signals that an I/O exception has occurred.
        javax.xml.parsers.ParserConfigurationException - the parser configuration exception
        org.xml.sax.SAXException - the SAX exception
        SilkException - the silk exception

      • DataProvider

        public DataProvider​(java.lang.String ormFileLocation,
                    int debugLevel)
             throws java.io.IOException,
                    javax.xml.parsers.ParserConfigurationException,
                    org.xml.sax.SAXException,
                    SilkException
        Instantiates a new data provider.
        Parameters:
        ormFileLocation - the ORM file location
        debugLevel - the debug level
        Throws:
        java.io.IOException - Signals that an I/O exception has occurred.
        javax.xml.parsers.ParserConfigurationException - the parser configuration exception
        org.xml.sax.SAXException - the SAX exception
        SilkException - the silk exception

      • DataProvider

        public DataProvider​(java.lang.String ormFileLocation,
                    RequestObject requestObject)
             throws java.io.IOException,
                    javax.xml.parsers.ParserConfigurationException,
                    org.xml.sax.SAXException,
                    SilkException
        Instantiates a new data provider.
        Parameters:
        ormFileLocation - the ORM file location
        requestObject - the request object
        Throws:
        java.io.IOException - Signals that an I/O exception has occurred.
        javax.xml.parsers.ParserConfigurationException - the parser configuration exception
        org.xml.sax.SAXException - the SAX exception
        SilkException - the silk exception

      • DataProvider

        public DataProvider​(java.lang.String ormFileLocation,
                    javax.servlet.http.HttpSession session)
             throws java.io.IOException,
                    javax.xml.parsers.ParserConfigurationException,
                    org.xml.sax.SAXException,
                    SilkException
        Instantiates a new data provider.
        Parameters:
        ormFileLocation - the ORM file location
        session - the session
        Throws:
        java.io.IOException - Signals that an I/O exception has occurred.
        javax.xml.parsers.ParserConfigurationException - the parser configuration exception
        org.xml.sax.SAXException - the SAX exception
        SilkException - the silk exception

      • DataProvider

        public DataProvider​(java.lang.String ormFileLocation,
                    int debugLevel,
                    javax.servlet.http.HttpSession session)
             throws java.io.IOException,
                    javax.xml.parsers.ParserConfigurationException,
                    org.xml.sax.SAXException,
                    SilkException
        Instantiates a new data provider.
        Parameters:
        ormFileLocation - the ORM file location
        debugLevel - the debug level
        session - the session
        Throws:
        java.io.IOException - Signals that an I/O exception has occurred.
        javax.xml.parsers.ParserConfigurationException - the parser configuration exception
        org.xml.sax.SAXException - the SAX exception
        SilkException - the silk exception

      • DataProvider

        public DataProvider​(java.lang.String ormFileLocation,
                    RequestObject requestObject,
                    javax.servlet.http.HttpSession session)
             throws java.io.IOException,
                    javax.xml.parsers.ParserConfigurationException,
                    org.xml.sax.SAXException,
                    SilkException
        Instantiates a new data provider.
        Parameters:
        ormFileLocation - the ORM file location
        session - the session
        requestObject - the request object
        Throws:
        java.io.IOException - Signals that an I/O exception has occurred.
        javax.xml.parsers.ParserConfigurationException - the parser configuration exception
        org.xml.sax.SAXException - the SAX exception
        SilkException - the silk exception

      • DataProvider

        public DataProvider​(java.lang.String ormFileLocation,
                    RequestObject requestObject,
                    ResponseObject responseObject,
                    int debugLevel,
                    javax.servlet.http.HttpSession session)
             throws java.io.IOException,
                    javax.xml.parsers.ParserConfigurationException,
                    org.xml.sax.SAXException,
                    SilkException
        Instantiates a new data provider.
        Parameters:
        ormFileLocation - the ORM file location
        requestObject - the request object
        responseObject - the return object
        debugLevel - the level of the returned debugging information
        session - the session
        Throws:
        java.io.IOException - Signals that an I/O exception has occurred.
        javax.xml.parsers.ParserConfigurationException - the parser configuration exception
        org.xml.sax.SAXException - the SAX exception
        SilkException - the silk exception

    • Method Detail

      • setSession

        public void setSession​(javax.servlet.http.HttpSession session)
        Sets the session attributes if necessary
        Parameters:
        session - the HTTP session object

      • getRequestObject

        public RequestObject getRequestObject()
        Gets the request object.
        Returns:
        the request object

      • setRequestObject

        public void setRequestObject​(RequestObject requestObject)
        Sets the request object.
        Parameters:
        requestObject - the object with the data requested

      • getResponseObject

        public ResponseObject getResponseObject()
        Gets the return object.
        Returns:
        the return object

      • setResponseObject

        public void setResponseObject​(ResponseObject responseObject)
        Sets the return object.
        Parameters:
        responseObject - the object to be returned

      • setParameter

        public void setParameter​(java.lang.String column,
                         java.lang.Object value,
                         java.lang.Class<?> type,
                         int secure)
        Sets the parameter information.
        Parameters:
        column - the column
        value - the value
        type - the type
        secure - the secure

      • setParameter

        public void setParameter​(java.lang.String column,
                         java.lang.Object value,
                         java.lang.Class<?> type)
        Sets the parameter information with secure as false;
        Parameters:
        column - the column
        value - the value
        type - the type

      • setParameter

        public void setParameter​(java.lang.String column,
                         java.lang.Object value,
                         int secure)
        Sets the parameter information setting the type based on the value object's class.
        Parameters:
        column - the column
        value - the value
        secure - the secure

      • setParameter

        public void setParameter​(java.lang.String column,
                         java.lang.Object value)
        Sets the parameter information setting the type based on the value object's class with secure as false.
        Parameters:
        column - the column
        value - the value

      • setOperationItem

        public void setOperationItem​(java.lang.String column,
                             java.lang.Object value)
        Sets the operation item for a single operation item. If this method is used any extra operation item gets removed.
        Parameters:
        column - the column
        value - the value

      • setOperationItem

        public void setOperationItem​(int index,
                             java.lang.String column,
                             java.lang.Object value)
        Sets the operation item at the operation list index position.
        Parameters:
        index - the operation list position
        column - the column
        value - the value

      • setOperationAction

        public void setOperationAction​(int index,
                               java.lang.String action)
        Sets the operation item action at the operation list index position.
        Parameters:
        index - the operation list position
        action - the action for this operation item

      • getStringItem

        public java.lang.String getStringItem​(int index,
                                      java.lang.String column,
                                      java.lang.String nullValue)
        Gets the item's column from the data Array Collection at the provided index, casted to the type String. If the value is null returns the provided nullValue.
        Parameters:
        index - the item position
        column - the column's name
        nullValue - the null value to return
        Returns:
        String

      • getStringItem

        public java.lang.String getStringItem​(int index,
                                      java.lang.String column)
        Gets the item's column from the data Array Collection at the provided index, casted to the type String. If the value is null returns empty String.
        Parameters:
        index - the item position
        column - the column's name
        Returns:
        String

      • getStringItem

        public java.lang.String getStringItem​(java.lang.String column)
        Gets the item's column from the data Array Collection at position 0, casted to the type String. If the value is null returns empty String.
        Parameters:
        column - the column's name
        Returns:
        String

      • getEscapeString

        public java.lang.String getEscapeString​(int index,
                                        java.lang.String column,
                                        java.lang.String nullValue)

      • getEscapeString

        public java.lang.String getEscapeString​(int index,
                                        java.lang.String column)

      • getEscapeString

        public java.lang.String getEscapeString​(java.lang.String column)

      • getIntItem

        public int getIntItem​(int index,
                      java.lang.String column,
                      int nullValue)
        Gets the item's column from the data Array Collection at the provided index, casted to the type Integer. If the value is null returns the provided nullValue.
        Parameters:
        index - the item position
        column - the column's name
        nullValue - the null value to return
        Returns:
        Integer

      • getIntItem

        public int getIntItem​(int index,
                      java.lang.String column)
        Gets the item's column from the data Array Collection at the provided index, casted to the type Integer. If the value is null returns 0.
        Parameters:
        index - the item position
        column - the column's name
        Returns:
        Integer

      • getIntItem

        public int getIntItem​(java.lang.String column)
        Gets the item's column from the data Array Collection at position 0, casted to the type Integer. If the value is null returns 0.
        Parameters:
        column - the column's name
        Returns:
        Integer

      • getIntStringItem

        public java.lang.String getIntStringItem​(int index,
                                         java.lang.String column,
                                         java.lang.String intFormat)
        Gets the item's column from the data Array Collection at the provided index, in the provided format, and casted to the type String. If the value is null returns an empty String.
        Parameters:
        index - the item position
        column - the column's name
        intFormat - the format pattern
        Returns:
        String

      • getIntStringItem

        public java.lang.String getIntStringItem​(int index,
                                         java.lang.String column)
        Gets the item's column from the data Array Collection at the provided index, formated as "#,###,##", and casted to the type String. If the value is null returns an empty String.
        Parameters:
        index - the item position
        column - the column's name
        Returns:
        String

      • getIntStringItem

        public java.lang.String getIntStringItem​(java.lang.String column,
                                         java.lang.String intFormat)
        Gets the item's column from the data Array Collection at position 0, using the provided format, and casted to the type String. If the value is null returns an empty String.
        Parameters:
        column - the column's name
        intFormat - the format pattern
        Returns:
        String

      • getIntStringItem

        public java.lang.String getIntStringItem​(java.lang.String column)
        Gets the item's column from the data Array Collection at position 0, formated as "#,###,##", and casted to the type String. If the value is null returns an empty String.
        Parameters:
        column - the column's name
        Returns:
        String

      • getDoubleItem

        public java.lang.Double getDoubleItem​(int index,
                                      java.lang.String column,
                                      java.lang.Double nullValue)
        Gets the item's column from the data Array Collection at the provided index, casted to the type Double. If the value is null returns the provided nullValue.
        Parameters:
        index - the item position
        column - the column's name
        nullValue - the null value to return
        Returns:
        Double

      • getDoubleItem

        public java.lang.Double getDoubleItem​(int index,
                                      java.lang.String column)
        Gets the item's column from the data Array Collection at the provided index, casted to the type Double. If the value is null returns 0.0.
        Parameters:
        index - the item position
        column - the column's name
        Returns:
        Double

      • getDoubleItem

        public java.lang.Double getDoubleItem​(java.lang.String column)
        Gets the item's column from the data Array Collection at position 0, casted to the type Double. If the value is null returns 0.0.
        Parameters:
        column - the column's name
        Returns:
        Double

      • getDoubleStringItem

        public java.lang.String getDoubleStringItem​(int index,
                                            java.lang.String column,
                                            java.lang.String doubleFormat)
        Gets the item's column from the data Array Collection at the provided index, using the provided format, and casted to the type String. If the value is null returns an empty String.
        Parameters:
        index - the item position
        column - the column's name
        doubleFormat - the format pattern
        Returns:
        String

      • getDoubleStringItem

        public java.lang.String getDoubleStringItem​(int index,
                                            java.lang.String column)
        Gets the item's column from the data Array Collection at the provided index, formated as "#,###,##0.00", and casted to the type String. If the value is null returns an empty String.
        Parameters:
        index - the item position
        column - the column's name
        Returns:
        String

      • getDoubleStringItem

        public java.lang.String getDoubleStringItem​(java.lang.String column,
                                            java.lang.String doubleFormat)
        Gets the item's column from the data Array Collection at position 0, using the provided format, and casted to the type String. If the value is null returns an empty String.
        Parameters:
        column - the column's name
        doubleFormat - the format pattern
        Returns:
        String

      • getDoubleStringItem

        public java.lang.String getDoubleStringItem​(java.lang.String column)
        Gets the item's column from the data Array Collection at position 0, formated as "#,###,##0.00", and casted to the type String. If the value is null returns an empty String.
        Parameters:
        column - the column's name
        Returns:
        String

      • getLongItem

        public java.lang.Long getLongItem​(int index,
                                  java.lang.String column,
                                  java.lang.Long nullValue)
        Gets the item's column from the data Array Collection at the provided index casted to the type Long. If the value is null returns the provided nullValue.
        Parameters:
        index - the item position
        column - the column's name
        nullValue - the null value to return
        Returns:
        Long

      • getLongItem

        public java.lang.Long getLongItem​(int index,
                                  java.lang.String column)
        Gets the item's column from the data Array Collection at the provided index, casted to the type Long. If the value is null returns 0L.
        Parameters:
        index - the item position
        column - the column's name
        Returns:
        Long

      • getLongItem

        public java.lang.Long getLongItem​(java.lang.String column)
        Gets the item's column from the data Array Collection at position 0, casted to the type Long. If the value is null returns 0L.
        Parameters:
        column - the column's name
        Returns:
        Long

      • getDateItem

        public java.time.LocalDateTime getDateItem​(int index,
                                           java.lang.String column,
                                           java.time.LocalDateTime nullValue)
        Gets the item's column from the data Array Collection at the provided index casted to the type Date. If the value is null returns the provided nullValue.
        Parameters:
        index - the item position
        column - the column's name
        nullValue - the null value to return
        Returns:
        Date

      • getDateItem

        public java.time.LocalDateTime getDateItem​(int index,
                                           java.lang.String column)
        Gets the item's column from the data Array Collection at the provided index, casted to the type Date. If the value is null returns null.
        Parameters:
        index - the item position
        column - the column's name
        Returns:
        Date

      • getDateItem

        public java.time.LocalDateTime getDateItem​(java.lang.String column)
        Gets the item's column from the data Array Collection at position 0, casted to the type Date. If the value is null returns null.
        Parameters:
        column - the column's name
        Returns:
        Date

      • getDateStringItem

        public java.lang.String getDateStringItem​(int index,
                                          java.lang.String column,
                                          java.lang.String dateFormat)
        Gets the item's column from the data Array Collection at the provided index, using the provided format, and casted to the type String. If the value is null returns an empty String.
        Parameters:
        index - the item position
        column - the column's name
        dateFormat - the format pattern
        Returns:
        String

      • getDateStringItem

        public java.lang.String getDateStringItem​(int index,
                                          java.lang.String column)
        Gets the item's column from the data Array Collection at the provided index, formated to "yyyy-MM-dd", and casted to the type String. If the value is null returns an empty String.
        Parameters:
        index - the item position
        column - the column's name
        Returns:
        String

      • getDateStringItem

        public java.lang.String getDateStringItem​(java.lang.String column,
                                          java.lang.String dateFormat)
        Gets the item's column from the data Array Collection at position 0, using the provided format, and casted to the type String. If the value is null returns an empty String.
        Parameters:
        column - the column's name
        dateFormat - the format pattern
        Returns:
        String

      • getDateStringItem

        public java.lang.String getDateStringItem​(java.lang.String column)
        Gets the item's column from the data Array Collection at position 0, formated to "yyyy-MM-dd", and casted to the type String. If the value is null returns an empty String.
        Parameters:
        column - the column's name
        Returns:
        String

      • getTimeItem

        public java.time.LocalTime getTimeItem​(int index,
                                       java.lang.String column,
                                       java.time.LocalTime nullValue)
        Gets the item's column from the data Array Collection at the provided index casted to the type Date. If the value is null returns the provided nullValue.
        Parameters:
        index - the item position
        column - the column's name
        nullValue - the null value to return
        Returns:
        Date

      • getTimeItem

        public java.time.LocalTime getTimeItem​(int index,
                                       java.lang.String column)
        Gets the item's column from the data Array Collection at the provided index, casted to the type Date. If the value is null returns null.
        Parameters:
        index - the item position
        column - the column's name
        Returns:
        Date

      • getTimeItem

        public java.time.LocalTime getTimeItem​(java.lang.String column)
        Gets the item's column from the data Array Collection at position 0, casted to the type Date. If the value is null returns null.
        Parameters:
        column - the column's name
        Returns:
        Date

      • getTimeStringItem

        public java.lang.String getTimeStringItem​(int index,
                                          java.lang.String column,
                                          java.lang.String dateFormat)
        Gets the item's column from the data Array Collection at the provided index, using the provided format, and casted to the type String. If the value is null returns an empty String.
        Parameters:
        index - the item position
        column - the column's name
        dateFormat - the format pattern
        Returns:
        String

      • getTimeStringItem

        public java.lang.String getTimeStringItem​(int index,
                                          java.lang.String column)
        Gets the item's column from the data Array Collection at the provided index, formated to "yyyy-MM-dd", and casted to the type String. If the value is null returns an empty String.
        Parameters:
        index - the item position
        column - the column's name
        Returns:
        String

      • getTimeStringItem

        public java.lang.String getTimeStringItem​(java.lang.String column,
                                          java.lang.String dateFormat)
        Gets the item's column from the data Array Collection at position 0, using the provided format, and casted to the type String. If the value is null returns an empty String.
        Parameters:
        column - the column's name
        dateFormat - the format pattern
        Returns:
        String

      • getTimeStringItem

        public java.lang.String getTimeStringItem​(java.lang.String column)
        Gets the item's column from the data Array Collection at position 0, formated to "yyyy-MM-dd", and casted to the type String. If the value is null returns an empty String.
        Parameters:
        column - the column's name
        Returns:
        String

      • getItemAt

        public java.lang.Object getItemAt​(int index,
                                  java.lang.String column)
        Gets the item's column from the data Array Collection at the provided index position
        Parameters:
        index - the item position
        column - the column
        Returns:
        the item

      • getItem

        public java.lang.Object getItem​(java.lang.String column)
        Gets the item's column from the first element in data Array Collection
        Parameters:
        column - the column
        Returns:
        the item

      • getItemAt

        public java.lang.Object getItemAt​(int index)
        Gets the item from the data Array Collection at the provided position
        Parameters:
        index - the position
        Returns:
        the item

      • findItem

        public java.lang.Object findItem​(java.lang.String searchColumn,
                                 java.lang.Object searchValue,
                                 java.lang.String returnColumn)

      • findItem

        public java.util.Map<java.lang.String,​java.lang.Object> findItem​(java.lang.String searchColumn,
                                                                       java.lang.Object searchValue)

      • select

        public int select​(java.lang.String selectName)
           throws java.lang.Exception,
                  org.springframework.dao.DataAccessException,
                  SilkException
        Executes the SELECT action using the provided select's name.
        Parameters:
        selectName - the name of the select to operate
        Returns:
        An integer with the number of rows returned.
        Throws:
        org.springframework.dao.DataAccessException - the data access exception
        SilkException - the silk exception
        java.lang.Exception

      • select

        public int select()
           throws java.lang.Exception,
                  org.springframework.dao.DataAccessException,
                  SilkException
        Executes the SELECT action using the "default" select's name.
        Returns:
        An integer with the number of rows returned.
        Throws:
        org.springframework.dao.DataAccessException - the data access exception
        SilkException - the silk exception
        java.lang.Exception

      • insert

        public int insert()
           throws java.lang.Exception,
                  org.springframework.dao.DataAccessException,
                  SilkException
        Executes the INSERT action.
        Returns:
        integer, 1 if successful or 0 if failure
        Throws:
        org.springframework.dao.DataAccessException - the data access exception
        SilkException - the silk exception
        java.lang.Exception

      • getNewPkValue

        public java.lang.Object getNewPkValue()
        Gets the new PK value of the last insert process.
        Returns:
        the value

      • getNewPkStringValue

        public java.lang.String getNewPkStringValue()
        Gets the new value of the last insert process as String;
        Returns:
        the value

      • getNewPkIntValue

        public int getNewPkIntValue()
        Gets the new value of the last insert process as String;
        Returns:
        the value

      • update

        public int update()
           throws java.lang.Exception,
                  org.springframework.dao.DataAccessException,
                  SilkException
        Executes the UPDATE action.
        Returns:
        integer, 1 if successful or 0 if failure
        Throws:
        org.springframework.dao.DataAccessException - the data access exception
        SilkException - the silk exception
        java.lang.Exception

      • delete

        public int delete()
           throws java.lang.Exception,
                  org.springframework.dao.DataAccessException,
                  SilkException
        Executes the DELETE action.
        Returns:
        integer, 1 if successful or 0 if failure
        Throws:
        org.springframework.dao.DataAccessException - the data access exception
        SilkException - the silk exception
        java.lang.Exception

      • batch

        public int batch()
          throws java.lang.Exception,
                 org.springframework.dao.DataAccessException,
                 SilkException
        Executes the BATCH action.
        Returns:
        integer, 1 if successful or 0 if failure
        Throws:
        org.springframework.dao.DataAccessException - the data access exception
        SilkException - the silk exception
        java.lang.Exception

      • exec

        public int exec​(java.lang.String operationName)
         throws java.lang.Exception,
                org.springframework.dao.DataAccessException,
                SilkException
        Executes the operation identify by the name provided
        Parameters:
        operationName - the operation
        Returns:
        integer, 1 if successful or 0 if failure
        Throws:
        org.springframework.dao.DataAccessException - the data access exception
        SilkException - the silk exception
        java.lang.Exception

      • size

        public int size()
        Returns the number of element in the data Array Collection.
        Returns:
        number of element in data

      • length

        public int length()

      • cleanOperation

        public void cleanOperation()
        Cleans the operation items to received new values.

      • setLangID

        public void setLangID​(java.lang.String lang)
        Set the language
        Parameters:
        lang - the language

      • setAuthorizationList

        public void setAuthorizationList​(java.lang.String authorizationList)
        Set the authorizationList
        Parameters:
        authorizationList - the authorization keywords list