Package com.oopsclick.silk.dbo

Class SqlController

java.lang.Object

org.springframework.dao.support.DaoSupport

org.springframework.jdbc.core.support.JdbcDaoSupport

com.oopsclick.silk.dbo.SqlController

All Implemented Interfaces:

org.springframework.beans.factory.InitializingBean

public class SqlController
extends org.springframework.jdbc.core.support.JdbcDaoSupport

The SqlController class is used as a JAVA bean. Its functionality is to act as the ORM Controller. It connects to the database and receives objects from the DataProvider to execute SQL Commands.

Constructor Summary

Constructors

Constructor	Description
SqlController()

Method Summary

Modifier and Type	Method	Description
ResponseObject	exec(ObjectStructure objectStructure, RequestObject requestObject, ResponseObject responseObject)	exec operation.
ResponseObject	get(ObjectStructure objectStructure, RequestObject requestObject, ResponseObject responseObject, javax.servlet.http.HttpSession session)	The get method executes the SELECT operation in the database.
ResponseObject	set(ObjectStructure objectStructure, RequestObject requestObject, ResponseObject responseObject)	The set method executes INSERT, UPDATE or DELETE
void	setTranslatorIn(java.lang.String translatorIn)	Set the function use to store translation.
void	setTranslatorOut(java.lang.String translatorOut)	Set the function to get translation Load from applicationContext.xml

Methods inherited from class org.springframework.jdbc.core.support.JdbcDaoSupport

getDataSource, getJdbcTemplate, setDataSource, setJdbcTemplate

Methods inherited from class org.springframework.dao.support.DaoSupport

afterPropertiesSet

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlController

public SqlController()

Method Detail

setTranslatorIn

public void setTranslatorIn(java.lang.String translatorIn)

Set the function use to store translation. Load from applicationContext.xml.

Parameters:

translatorIn - the new translator in

setTranslatorOut

public void setTranslatorOut(java.lang.String translatorOut)

Set the function to get translation Load from applicationContext.xml

Parameters:

translatorOut - the new translator out

get

public ResponseObject get(ObjectStructure objectStructure,
                          RequestObject requestObject,
                          ResponseObject responseObject,
                          javax.servlet.http.HttpSession session)
                   throws java.lang.Exception,
                          org.springframework.dao.DataAccessException,
                          SilkException

The get method executes the SELECT operation in the database.

Parameters:

objectStructure - the object structure

requestObject - the request object

responseObject - the return object

session - the session being used

Returns:

the return object

Throws:

org.springframework.dao.DataAccessException - the data access exception

SilkException - the silk exception

java.lang.Exception

set

public ResponseObject set(ObjectStructure objectStructure,
                          RequestObject requestObject,
                          ResponseObject responseObject)
                   throws java.lang.Exception,
                          org.springframework.dao.DataAccessException,
                          SilkException

The set method executes INSERT, UPDATE or DELETE

Parameters:

objectStructure - the object structure

requestObject - the request object

responseObject - the return object

Returns:

the return object

Throws:

org.springframework.dao.DataAccessException - the data access exception

SilkException - the silk exception

java.lang.Exception

exec

public ResponseObject exec(ObjectStructure objectStructure,
                           RequestObject requestObject,
                           ResponseObject responseObject)
                    throws java.lang.Exception,
                           org.springframework.dao.DataAccessException,
                           SilkException

exec operation.

Parameters:

objectStructure - the object structure

requestObject - the request object

responseObject - the return object

Returns:

the return object

Throws:

org.springframework.dao.DataAccessException - the data access exception

SilkException - the silk exception

java.lang.Exception