Package com.oopsclick.silk.dbo

Class SqlOperation

  • public class SqlOperation
extends java.lang.Object
    The SqlCommand object stores information related to an SQL command defined on the ORM file.

    This object provides the methods to execute the SQL commands.

    Author:
    Italo Osorio

    • Constructor Summary

      Constructors 
      Constructor Description
      SqlOperation​(org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate jdbcTemplate, ObjectStructure objectStructure, RequestObject requestObject, ResponseObject responseObject, javax.servlet.http.HttpSession session)
      SqlOperation Constructor

    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      int authorization​(java.lang.String name)
      Executes Authorization
      ResponseObject get()
      Executes Select operation
      ResponseObject set​(int index)
      Executes INSERT, UPDATE, DELETE, EXEC operation base on the requested action.
      int trigger​(java.lang.String action, java.lang.String when)
      Executes trigger operation base on the action and when provided.

      • Methods inherited from class java.lang.Object

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

    • Constructor Detail

      • SqlOperation

        public SqlOperation​(org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate jdbcTemplate,
                    ObjectStructure objectStructure,
                    RequestObject requestObject,
                    ResponseObject responseObject,
                    javax.servlet.http.HttpSession session)
        SqlOperation Constructor
        Parameters:
        jdbcTemplate - the JdbcTemplate
        objectStructure - the ObjectStructure
        requestObject - the RequestObject
        responseObject - the responseObject
        session - the session being used

    • Method Detail

      • get

        public ResponseObject get()
                   throws java.lang.Exception,
                          org.springframework.dao.DataAccessException,
                          SilkException
        Executes Select operation
        Returns:
        responseObject the objected returned
        Throws:
        SilkException - the silk exception
        java.lang.Exception
        org.springframework.dao.DataAccessException

      • set

        public ResponseObject set​(int index)
                   throws java.lang.Exception,
                          org.springframework.dao.DataAccessException,
                          SilkException
        Executes INSERT, UPDATE, DELETE, EXEC operation base on the requested action.
        Parameters:
        index - the position of the form item to set
        Returns:
        responseObject the objected returned
        Throws:
        SilkException - the silk exception
        java.lang.Exception
        org.springframework.dao.DataAccessException

      • trigger

        public int trigger​(java.lang.String action,
                   java.lang.String when)
            throws java.lang.Exception,
                   org.springframework.dao.DataAccessException,
                   SilkException
        Executes trigger operation base on the action and when provided.
        Parameters:
        action - the action trigger belongs to
        when - the moment the triggers will be executed
        Returns:
        operation results
        Throws:
        SilkException - the silk exception
        java.lang.Exception
        org.springframework.dao.DataAccessException

      • authorization

        public int authorization​(java.lang.String name)
                  throws java.lang.Exception,
                         SilkException
        Executes Authorization
        Parameters:
        name - the authorization name
        Returns:
        responseObject the objected returned
        Throws:
        SilkException - the silk exception
        java.lang.Exception