anyframe.core.query.ria.gauce
Interface IGauceQueryService

public interface IGauceQueryService

This is the interface used for manipulating database in developing the presentation layer using Gauce component which is the X-Internet solution of the Shift Software company.

In order to use GauceQueryService the anyframe.core.query.ria.impl.RiaQueryServiceImpl class has to be registered as Bean.

GauceQueryService Configuration Example:

 <bean name="riaQueryService" class="anyframe.core.query.ria.impl.RiaQueryServiceImpl">
      <property name="jdbcTemplate" ref="pagingNamedParamJdbcTemplate"/>
      <property name="lobHandler" ref="lobHandler"/>
      <property name="sqlRepository" ref="sqlLoader"/>
 </bean>
 <bean id="mipQueryService" class="anyframe.core.query.ria.gauce.impl.GauceQueryServiceImpl">
      <property name="riaQueryService" ref="riaQueryService"/>
      <property name="sqlRepository" ref="sqlLoader"/>
 </bean>
 
 <bean id="pagingNamedParamJdbcTemplate" 
          class="anyframe.core.query.impl.jdbc.PagingNamedParamJdbcTemplate">
      <constructor-arg index="0" ref="pagingJdbcTemplate"/>
      <constructor-arg index="1" ref="dataSource"/>
 </bean>
 

The GauceQueryService's configuration has riaQueryService, sqlRepository.

Author:

Soyon Lim, Byunghoon Woo

Method Summary

com.gauce.GauceDataSet	search(String queryId, com.gauce.GauceDataSet serarchParams) This is a method for querying using the GauceDataSet
int	update(Map queryMap, com.gauce.GauceDataSet updateParams) the method for inserting, updating and deleting using the GauceDataSet to the database.
int	update(Map queryMap, com.gauce.GauceDataSet updateParams, IGauceActionCommand actionCommand) This is the method for inserting, updating and deleting using the GauceDataSet to the database.

Method Detail

search

com.gauce.GauceDataSet search(String queryId,
                              com.gauce.GauceDataSet serarchParams)
                              throws Exception

This is a method for querying using the GauceDataSet

Parameters:

queryId - identifier of query statement to execute

dataSet - the GauceDataSet including the query conditions

Returns:

GauceDataSet of extracted out parameters

Throws:

QueryServiceException - if there is any problem executing the query

Exception

update

int update(Map queryMap,
           com.gauce.GauceDataSet updateParams)
           throws QueryServiceException

the method for inserting, updating and deleting using the GauceDataSet to the database.

Parameters:

queryMap - the map with status of row and query identifier. For insert status, the Map's key is insert, update status is update, delete status is delete. We decide the query id executed in using the Status value because in the GauceDataSet the value of appropriate row's Status is set.

dataSet - the GauceDataSet including the query conditions

Returns:

the number of records affected

Throws:

QueryServiceException - if there is any problem executing the query

update

int update(Map queryMap,
           com.gauce.GauceDataSet updateParams,
           IGauceActionCommand actionCommand)
           throws QueryServiceException

This is the method for inserting, updating and deleting using the GauceDataSet to the database. The IGauceActionCommand's implemented class containing the needed business logic is executed Before/after manipulating a database.

Parameters:

queryMap - the map with status of row and query identifier. For insert status, the Map's key is insert, update status is update, delete status is delete. We decide the query id executed in using the Status value because in the GauceDataSet the value of appropriate record's Status is set.

dataSet - the GauceDataSet including the query conditions

actionCommand - the GauceActionCommand including the business logic before/after the insert, update, delete execution.

Returns:

the number of records affected

Throws:

QueryServiceException - if there is any problem executing the query