anyframe.core.query
Class AbstractDAO

java.lang.Object
  anyframe.core.query.AbstractDAO

public class AbstractDAO
extends Object

This is a Wrapper class in order to use with the IQueryService API easily The approproaching logic for the data is handled by inheritting this class in each of the DAO class.

Author:

Soyon Lim, JongHoon Kim

Constructor Summary

AbstractDAO()

Method Summary

protected int	create(String tableName, List targetList) Execute the INSERT query statement using the targetList including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined createId(default='create').
protected int	create(String tableName, Map targetMap) Execute the INSERT query statement by targetMap including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined createId(default='create').
protected int	create(String tableName, Object targetObj) Execute the INSERT query statement using the targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined createId(default='create').
protected int	create(String tableName, Object[] targetObjs) Execute the INSERT query statement using the Object array including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined createId(default='create')
protected int	create(String tableName, Object targetObj1, Object targetObj2) After finding the appropriate queryId by combining the inputted table name and defined createId(default='create'), execute the INSERT query statement using the two targetObject including the inputted value.
protected Object	findByPk(String tableName, List targetList) Execute the SELECT query statement for unitary query using the targetList including the inputted value, after finding the queryId and the inputted table name and defined findPrefix(default='find').
protected Object	findByPk(String tableName, Map targetMap) Execute the SELECT query statement for unitary query using the targetMap including the inputted value, after finding the appropriate queryId in combining the findByPkPostfix(default='ByPk').
protected Object	findByPk(String tableName, Object targetObj) Execute the SELECT query statement for unitary query using the targetObject including the inputted value, after finding the queryId, the inputted table name and defined findPrefix(default='find').
protected Object	findByPk(String tableName, Object[] targetObjs) Execute the SELECT query statement for unitary query using the Object array including the variable value, after finding the appropriate queryId in combining the inputted the table name and defined findPrefix(default='find').
protected Collection	findList(String tableName, List targetObjs) Execute the SELECT query statement using the targetList including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined findPrefix(default='find').
protected Collection	findList(String tableName, List targetList, int pageIndex, int pageSize) Execute the SELECT query statement using the pageIndex and pageSize containin the paging info and targetList including the inputted value, after findding the appropriate queryId in combining the inputted table name, findPrefix(default='find') and findListPostfix(default-'List').
protected Collection	findList(String tableName, Map targetMap) Exeucte the SELECT query statement using the targetMap including the input value, after finding the appropriate queryId in combining the inputted table name and findPrefix(default='find').
protected Collection	findList(String tableName, Map targetMap, int pageIndex, int pageSize) Execute the SELECT query statement using the pageIndex and pageSize containing the paging info and targetMap including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined findPrefix(default='find').
protected Collection	findList(String tableName, Object targetObj) Execute the SELECT query statement using the targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined findListPostfix(default='List').
protected Collection	findList(String tableName, Object[] targetObjs) Execute the SELECT query statement using the Object array including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined findPrefix(default='find').
protected Collection	findList(String tableName, Object targetObj, int pageIndex, int pageSize) Execute the SELECT query statement using pageIndex and pageSize containing the paging info and targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined findPrefix(default'find').
protected Page	findListWithPaging(String tableName, List targetObjs, int pageIndex, int pageSize) Execute the SELECT query statement using the pageIndex, pageSize and targetList including the inputted value, after finding the appropriate queryId in combining the inputted table name, defined findPrefix(default='find') and findListPostfix(default='List').
protected Page	findListWithPaging(String tableName, List targetObjs, int pageIndex, int pageSize, int pageUnit) Execute the SELECT query statement using the pageIndex and pageSize including the paging info, targetList including the inputted value, after finding the appropriate queryId in combining the inputted table name defined in findPrefix (default='find') and findListPostfix(default="List').
protected Page	findListWithPaging(String tableName, Map targetMap, int pageIndex, int pageSize) Execute the SELECT query statement using the pageIndex and pageSize containing the paging info and targetMap including the inputted value, after finding the appropriate queryId in combining the table name, defined findPrefix(default='find') and findListPostfix(default="List').
protected Page	findListWithPaging(String tableName, Map targetMap, int pageIndex, int pageSize, int pageUnit) Execute the SELECT query statement using the pageIndex, pageSize and pageUnit including the paging info, and targetMap including the inputted value, after finding the appropriate queryId in combining the tablename, defined findPrefix(default='find') and findListPostfix(default='List').
protected Page	findListWithPaging(String tableName, Object[] targetObjs, int pageIndex, int pageSize) Execute the SELECT query statement using the pageIndex and pageSize including the paging info and Object array including the inputted value, after finding the appropriate queryId in combining the inputted table name, defined findPrefix(default='find') and findListPostfix(default='List').
protected Page	findListWithPaging(String tableName, Object[] targetObjs, int pageIndex, int pageSize, int pageUnit) Execute the SELECT query statement using the pageIndex and pageSize including the paging info and Object order including the variable name, after finding the appropriate queryId in combining the inputted table name, defined findPrefix(default='find') and findListPostfix(default='List').
protected Page	findListWithPaging(String tableName, Object targetObj, int pageIndex, int pageSize) Execute the SELECT query statement using the pageIndex and pageSize including the paging info and targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name, defined findPrefix(default='find') and findListPostfix(default='List').
protected Page	findListWithPaging(String tableName, Object targetObj, int pageIndex, int pageSize, int pageUnit) Execute the SELECT query statement using the pageIndex, pageSize and pageUnit containing the paging info and targObject including the inputted value, after finding the appropriate queryId in combining the inputted table name, findPrefix(default='find') and findListPostfix(default='List').
IQueryService	getQueryService()
protected int	remove(String tableName, List targetObjs) Execute the DELETE query statement using the targetList including the input value, after finding the appropriate queryId in combining the the input table name and defined removeId(default='remove').
protected int	remove(String tableName, Map targetMap) Execute the DELETE query statement using the targetMap including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined removeId(default='remove').
protected int	remove(String tableName, Object targetObj) Execute the DELETE query statement using the targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name and (removeId(default='remove');
protected int	remove(String tableName, Object[] targetObjs) Execute the DELETE query statement using the Object array including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined removeId(default='remove')
protected int	remove(String tableName, Object targetObj1, Object targetObj2) Execute the DELETE query statement using the two targetObject including the input value, after finding the appropriate queryId in combining the inputted table name and defined updateId(default='remove').'
void	setCreateId(String createId)
void	setFindByPkPostfix(String findByPkPostfix)
void	setFindListPostfix(String findListPostfix)
void	setFindPrefix(String findPrefix)
void	setQueryService(IQueryService queryService)
void	setRemoveId(String removeId)
void	setUpdateId(String updateId)
void	setVariableName(String variableName)
protected int	update(String tableName, List targetList) Execute the UPDATE query statement using the targetList including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined updateId(default='update').
protected int	update(String tableName, Map targetMap) Execute the UPDATE query statement using the targetMap including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined updateId(default='create').
protected int	update(String tableName, Object targetObj) Execute the UPDATE query statement using the targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined updateId(default='update')
protected int	update(String tableName, Object[] targetObjs) Execute the UPDATE query statement using the object array including the inputted value, after finding the appropriate queryId in combining the inputted table name and the defined updateId(default='update')
protected int	update(String tableName, Object targetObj1, Object targetObj2) Execute the UPDATE query statement using the two targetObject including the input value, after finding the appropriate queryId in combining the inputted table name and defined updateId(default='update').'

Methods inherited from class java.lang.Object

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

Constructor Detail

AbstractDAO

public AbstractDAO()

Method Detail

getQueryService

public IQueryService getQueryService()

setQueryService

public void setQueryService(IQueryService queryService)

setVariableName

public void setVariableName(String variableName)

setCreateId

public void setCreateId(String createId)

setRemoveId

public void setRemoveId(String removeId)

setUpdateId

public void setUpdateId(String updateId)

setFindPrefix

public void setFindPrefix(String findPrefix)

setFindByPkPostfix

public void setFindByPkPostfix(String findByPkPostfix)

setFindListPostfix

public void setFindListPostfix(String findListPostfix)

create

protected int create(String tableName,
                     Object targetObj)
              throws QueryServiceException

Execute the INSERT query statement using the targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined createId(default='create').

Parameters:

tableName - table name

targetObj - including the needed inputted name at query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

create

protected int create(String tableName,
                     Map targetMap)
              throws QueryServiceException

Execute the INSERT query statement by targetMap including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined createId(default='create'). At execution of the appropriate query statement, extract the object included in the Map and for each object's variable name, define as the key of appropriate object inside the Map

Parameters:

tableName - table name

targetMap - Map including the needed inputted value at the query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

create

protected int create(String tableName,
                     Object targetObj1,
                     Object targetObj2)
              throws QueryServiceException

After finding the appropriate queryId by combining the inputted table name and defined createId(default='create'), execute the INSERT query statement using the two targetObject including the inputted value. At the execution of the appropriate query statement, first, the targetObject's variable name adds 1 to the defined variableNmae(default='vo'), the second targetObject's variable name adds 2 to the defined variableName.

Parameters:

tableName -

targetObj1 - The first object including the needed input value at the query execution

targetObj2 - The second object including the needed input value at the query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

create

protected int create(String tableName,
                     List targetList)
              throws QueryServiceException

Execute the INSERT query statement using the targetList including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined createId(default='create'). At the execution of appropriate query statement, extract the object included in the List and afterwards, define as (variableName + order) type by reflecting the extracted order for the object's variable name.

Parameters:

tableName - table name

targetList - List including the needed input object at the query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

create

protected int create(String tableName,
                     Object[] targetObjs)
              throws QueryServiceException

Execute the INSERT query statement using the Object array including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined createId(default='create')

Parameters:

tableName - table name

targetObjs - Object Array including the needed input object at the query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

update

protected int update(String tableName,
                     Object targetObj)
              throws QueryServiceException

Execute the UPDATE query statement using the targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined updateId(default='update')

Parameters:

tableName - table name

targetObj - Object including the needed input object at the query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

update

protected int update(String tableName,
                     Map targetMap)
              throws QueryServiceException

Execute the UPDATE query statement using the targetMap including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined updateId(default='create'). At the execution of the appropriate query statement, extract the object included in the Map at the execution of the appropriate query statement

Parameters:

tableName - table name

targetMap - The map including the needed input value at the query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

update

protected int update(String tableName,
                     List targetList)
              throws QueryServiceException

Execute the UPDATE query statement using the targetList including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined updateId(default='update'). Define as (variableName+order) type by reflecting the extracted order for the variable name of the object

Parameters:

tableName - table name

targetList - List including the needed input variable at the execution of the query

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

update

protected int update(String tableName,
                     Object targetObj1,
                     Object targetObj2)
              throws QueryServiceException

Execute the UPDATE query statement using the two targetObject including the input value, after finding the appropriate queryId in combining the inputted table name and defined updateId(default='update').' At execution of the appropriate query statement, the first targetObject's variable name adds 1 to defined variableName(default='vo'), for the second targetObject's variable, 2 is added to the defined variableName.

Parameters:

tableName - table name

targetObj1 - first object including the needed input value at the execution of the query statement

targetObj2 - Second object including the needed input value at the query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

update

protected int update(String tableName,
                     Object[] targetObjs)
              throws QueryServiceException

Execute the UPDATE query statement using the object array including the inputted value, after finding the appropriate queryId in combining the inputted table name and the defined updateId(default='update')

Parameters:

tableName - table name

targetObjs - Object Array including the needed input value at the query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

remove

protected int remove(String tableName,
                     Object targetObj)
              throws QueryServiceException

Execute the DELETE query statement using the targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name and (removeId(default='remove');

Parameters:

tableName - table name

targetObj - Object including the needed input value at the query execution.

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

remove

protected int remove(String tableName,
                     Map targetMap)
              throws QueryServiceException

Execute the DELETE query statement using the targetMap including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined removeId(default='remove'). At the execution of appropriate query statement, after the extraction of the object from the Map, for each object's variable name, define as key of appropriate object included in the map.

Parameters:

tableName - table name

targetMap - the Map including the needed input value at the execution of query statement

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

remove

protected int remove(String tableName,
                     Object targetObj1,
                     Object targetObj2)
              throws QueryServiceException

Execute the DELETE query statement using the two targetObject including the input value, after finding the appropriate queryId in combining the inputted table name and defined updateId(default='remove').' At execution of the appropriate query statement, the first targetObject's variable name adds 1 to defined variableName(default='vo'), for the second targetObject's variable, 2 is added to the defined variableName.

Parameters:

tableName - table name

targetObj1 - first object including the needed input value at the execution of the query statement

targetObj2 - Second object including the needed input value at the query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

remove

protected int remove(String tableName,
                     List targetObjs)
              throws QueryServiceException

Execute the DELETE query statement using the targetList including the input value, after finding the appropriate queryId in combining the the input table name and defined removeId(default='remove'). Define as (variableName + order) type reflecting the extraction order for the variable name of each object after extracting the object included in the List at the execution of the appropriate query statement.

Parameters:

tableName - table name

targetList - the List including the needed input value at query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

remove

protected int remove(String tableName,
                     Object[] targetObjs)
              throws QueryServiceException

Execute the DELETE query statement using the Object array including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined removeId(default='remove')

Parameters:

tableName - table name

targetObjs - Object Array including the needed input value at the query execution

Returns:

the number of rows affected

Throws:

QueryServiceException - if there is any problem executing the query

findByPk

protected Object findByPk(String tableName,
                          Object targetObj)
                   throws QueryServiceException

Execute the SELECT query statement for unitary query using the targetObject including the inputted value, after finding the queryId, the inputted table name and defined findPrefix(default='find').

Parameters:

tableName - table name

targetObj - Object including the needed input value of query execution

Returns:

unitary querying result. Transmits the Null in the case the query result value is non-existent.

Throws:

QueryServiceException - if there is any problem executing the query

findByPk

protected Object findByPk(String tableName,
                          Map targetMap)
                   throws QueryServiceException

Execute the SELECT query statement for unitary query using the targetMap including the inputted value, after finding the appropriate queryId in combining the findByPkPostfix(default='ByPk'). Define as key of the appropriate object included in the map for the variable name of each object.

Parameters:

tableName - table name

targetMap - Map including the needed input value at the query execution

Returns:

unitary querying result. Transmits the Null in the case the query result value is non-existent.

Throws:

QueryServiceException - if there is any problem executing the query

findByPk

protected Object findByPk(String tableName,
                          List targetList)
                   throws QueryServiceException

Execute the SELECT query statement for unitary query using the targetList including the inputted value, after finding the queryId and the inputted table name and defined findPrefix(default='find'). Define key as (variableName + order) type by reflecting the extraction order for the variable name of each object after extracting object included in the List at the appropriate query statement.

Parameters:

tableName -

targetList - the List including the needed input value at the query execution

Returns:

unitary querying result. Transmits the Null in the case the query result value is non-existent.

Throws:

QueryServiceException - if there is any problem executing the query

findByPk

protected Object findByPk(String tableName,
                          Object[] targetObjs)
                   throws QueryServiceException

Execute the SELECT query statement for unitary query using the Object array including the variable value, after finding the appropriate queryId in combining the inputted the table name and defined findPrefix(default='find').

Parameters:

tableName - table name

targetObjs - Object Array including the needed inputted value at the query execution

Returns:

unitary querying result. Transmits the Null in the case the query result value is non-existent.

Throws:

QueryServiceException - if there is any problem executing the query

findList

protected Collection findList(String tableName,
                              Object targetObj)
                       throws QueryServiceException

Execute the SELECT query statement using the targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined findListPostfix(default='List').

Parameters:

tableName - table name

targetObj - Object including the needed input value at query exeuction

Returns:

Object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query

findList

protected Collection findList(String tableName,
                              Map targetMap)
                       throws QueryServiceException

Exeucte the SELECT query statement using the targetMap including the input value, after finding the appropriate queryId in combining the inputted table name and findPrefix(default='find'). Define as key of the appropriate object included in the Map for the variable name of each object after extracting the object included in the map at the query execution.

Parameters:

tableName - table name

targetMap - the Map including the needed inputted value at the query execution

Returns:

Object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query

findList

protected Collection findList(String tableName,
                              List targetObjs)
                       throws QueryServiceException

Execute the SELECT query statement using the targetList including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined findPrefix(default='find'). Define key as (variableName + order) type in reflecting the extraction order for the variable name of each object after extracting the object included in the List at the query execution time.

Parameters:

tableName - table name

targetList - the List including the needed input object at the query execution

Returns:

the object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query

findList

protected Collection findList(String tableName,
                              Object[] targetObjs)
                       throws QueryServiceException

Execute the SELECT query statement using the Object array including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined findPrefix(default='find').

Parameters:

tableName - table name

targetObjs - Object Array including the needed input value at query execution

Returns:

Object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query

findList

protected Collection findList(String tableName,
                              Object targetObj,
                              int pageIndex,
                              int pageSize)
                       throws QueryServiceException

Execute the SELECT query statement using pageIndex and pageSize containing the paging info and targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined findPrefix(default'find'). In order to obtain the result handled in paging, the pageIndex and pageSize has to be bigger than 0.

Parameters:

tableName - table name

targetObj - the object including the needed input value at query execution

pageIndex - page number which expected to be displayed.

pageSize - maximum number of data that can be displayed.

Returns:

the object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query

findList

protected Collection findList(String tableName,
                              Map targetMap,
                              int pageIndex,
                              int pageSize)
                       throws QueryServiceException

Execute the SELECT query statement using the pageIndex and pageSize containing the paging info and targetMap including the inputted value, after finding the appropriate queryId in combining the inputted table name and defined findPrefix(default='find'). Define as the appropriate object's key value included in the Map for the variable name of each object after extracting the object included in the Map at the execution of appropriate query statement. In order to obtain the result handled in paging, the pageIndex and pageSize have to be bigger than 0.

Parameters:

tableName - table name

targetMap - the Map including the needed variable value at execution of query statement

pageIndex - page number which expected to be displayed.

pageSize - maximum number of data that can be displayed.

Returns:

the object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query

findList

protected Collection findList(String tableName,
                              List targetList,
                              int pageIndex,
                              int pageSize)
                       throws QueryServiceException

Execute the SELECT query statement using the pageIndex and pageSize containin the paging info and targetList including the inputted value, after findding the appropriate queryId in combining the inputted table name, findPrefix(default='find') and findListPostfix(default-'List'). Define key as (variableName + order) type for reflecting the extraction order for the variable name of each object after extracting the object included in the List at the execution of query statement. In order to obtain the result handled in paging, the pageIndex and pageSize have to be bigger than 0.

Parameters:

tableName - table name

targetList - the List including the needed input object at the execution of the query statement

pageIndex - page number which expected to be displayed.

pageSize - maximum number of data that can be displayed.

Returns:

the object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query

findListWithPaging

protected Page findListWithPaging(String tableName,
                                  Object targetObj,
                                  int pageIndex,
                                  int pageSize)
                           throws QueryServiceException

Execute the SELECT query statement using the pageIndex and pageSize including the paging info and targetObject including the inputted value, after finding the appropriate queryId in combining the inputted table name, defined findPrefix(default='find') and findListPostfix(default='List'). Tranmits the result as anyframe.common.Page's object type handled in paginavigator tag for supporting for the ease at developing of the UI. In order to obtain the result handled in the paging, the pageIndex and pageSize have to be 0.

Parameters:

tableName - table name

targetObj - the object included in the needed input variable at the query execution

pageIndex - page number which expected to be displayed.

pageSize - maximum number of data that can be displayed.

Returns:

the page object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query

findListWithPaging

protected Page findListWithPaging(String tableName,
                                  Object targetObj,
                                  int pageIndex,
                                  int pageSize,
                                  int pageUnit)
                           throws QueryServiceException

Execute the SELECT query statement using the pageIndex, pageSize and pageUnit containing the paging info and targObject including the inputted value, after finding the appropriate queryId in combining the inputted table name, findPrefix(default='find') and findListPostfix(default='List'). Transmit by changing as anyframe.common.Page's object type handled in paginavigator tag for providing ease in the developing of UI for the result. In order to obtain the result from paging, the pageIndex, pageSize have to be bigger than 0.

Parameters:

tableName - table name

targetObj - the object including the inputted name at the query execution

pageIndex - page number which expected to be displayed.

pageSize - maximum number of data that can be displayed.

pageUnit - page unit which expected to be displayed.

Returns:

the Page object including the query result

Throws:

QueryServiceException - if there is any problem executing the query

findListWithPaging

protected Page findListWithPaging(String tableName,
                                  Map targetMap,
                                  int pageIndex,
                                  int pageSize)
                           throws QueryServiceException

Execute the SELECT query statement using the pageIndex and pageSize containing the paging info and targetMap including the inputted value, after finding the appropriate queryId in combining the table name, defined findPrefix(default='find') and findListPostfix(default="List'). Define as the appropriate object's key value included in the Map for the variable name of each object after extracting the object included in the Map at the execution of appropriate query statement. Transmit by changing as anyframe.common.Page object type handled in the paginavigator tag for providing ease in developing of the UI for the execution result (page unit is set as 10). In order to obtain the result handled by paging, the pageIndex and pageSize have to be bigger than 0.

Parameters:

tableName - table name

targetMap - the Map including the needed inputted value at the query execution

pageIndex - page number which expected to be displayed.

pageSize - maximum number of data that can be displayed.

Returns:

the Page object including the query result

Throws:

QueryServiceException - if there is any problem executing the query

findListWithPaging

protected Page findListWithPaging(String tableName,
                                  Map targetMap,
                                  int pageIndex,
                                  int pageSize,
                                  int pageUnit)
                           throws QueryServiceException

Execute the SELECT query statement using the pageIndex, pageSize and pageUnit including the paging info, and targetMap including the inputted value, after finding the appropriate queryId in combining the tablename, defined findPrefix(default='find') and findListPostfix(default='List'). Transmit by changing anyframe.common.Page object value handled in the paginavigator tag for supporting ease at the developing of UI for the execution result. In order to obtain the result handled with paging. the pageIndex and pageSize have to be bigger than 0.

Parameters:

tableName - table name

targetMap - the Map including the needed input value at the query execution

pageIndex - page number which expected to be displayed.

pageSize - maximum number of data that can be displayed.

pageUnit - page unit which expected to be displayed.

Returns:

the Page object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query

findListWithPaging

protected Page findListWithPaging(String tableName,
                                  List targetObjs,
                                  int pageIndex,
                                  int pageSize)
                           throws QueryServiceException

Execute the SELECT query statement using the pageIndex, pageSize and targetList including the inputted value, after finding the appropriate queryId in combining the inputted table name, defined findPrefix(default='find') and findListPostfix(default='List'). Define key as (variableName + order) type in reflecting the extraction order for variable name of each object after extracting the object included in the List at the execution of handled query. Transmit by changing as anyframe.common.Page object handled the paginavigator tage for supporting ease at the developgin of UI for the execution result (page unit is set as 10.) In order to obtain the result handled with paging, the pageIndex, and pageSize have to be bigger than 0.

Parameters:

tableName - table name

targetList - the List including the inputted object at the query exeuction

pageIndex - page number which expected to be displayed.

pageSize - maximum number of data that can be displayed.

Returns:

the Page object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query

findListWithPaging

protected Page findListWithPaging(String tableName,
                                  List targetObjs,
                                  int pageIndex,
                                  int pageSize,
                                  int pageUnit)
                           throws QueryServiceException

Execute the SELECT query statement using the pageIndex and pageSize including the paging info, targetList including the inputted value, after finding the appropriate queryId in combining the inputted table name defined in findPrefix (default='find') and findListPostfix(default="List'). Define key as (variableName + order) type in reflecting the extraction order for the variable name of each object after extracting the object included in the List at the query execution. Trasmit by changing as anyframe.common.Page object type handled in paginavigator rag for supporting ease at developing of UI for the execution result. In order to handle the paging, the pageIndex and pageSize have to be bigger than 0.

Parameters:

tableName - table name

targetList - the List including the needed input object at query execution

pageIndex - page number which expected to be displayed.

pageSize - maximum number of data that can be displayed.

pageUnit - page unit which expected to be displayed.

Returns:

the Page object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query

findListWithPaging

protected Page findListWithPaging(String tableName,
                                  Object[] targetObjs,
                                  int pageIndex,
                                  int pageSize)
                           throws QueryServiceException

Execute the SELECT query statement using the pageIndex and pageSize including the paging info and Object array including the inputted value, after finding the appropriate queryId in combining the inputted table name, defined findPrefix(default='find') and findListPostfix(default='List'). Trasmit by changing the anyframe.common.Page variable type handled in paginavigator tag for supporting ease at developing of UI for the execution result. (page unit is set as 10). In order to obtain the result handled in the paging, the pageIndex and pageSize have to be bigger than 0.

Parameters:

tableName - table name

targetObjs - the Object Array including the needed query info at query execution

pageIndex - page number which expected to be displayed.

pageSize - maximum number of data that can be displayed.

Returns:

the Page object containing the query result.

Throws:

QueryServiceException - if there is any problem executing the query

findListWithPaging

protected Page findListWithPaging(String tableName,
                                  Object[] targetObjs,
                                  int pageIndex,
                                  int pageSize,
                                  int pageUnit)
                           throws QueryServiceException

Execute the SELECT query statement using the pageIndex and pageSize including the paging info and Object order including the variable name, after finding the appropriate queryId in combining the inputted table name, defined findPrefix(default='find') and findListPostfix(default='List'). Transmit by chaning as anyframe.common.Page object type handled in the paginavigator tag for supporting ease of developing of UI for the execution result. In order to obtain the result handled in paging, the pageIndex and pageSize have to be bigger than 0.

Parameters:

tableName - table name

targetObjs - the Object Array including the needed inputted value at the query execution

pageIndex - page number which expected to be displayed.

pageSize - maximum number of data that can be displayed.

pageUnit - page unit which expected to be displayed.

Returns:

the Page object containing the query result

Throws:

QueryServiceException - if there is any problem executing the query