Package com.gsitm.ustra.java.data.utils.procedure

Class UstraPostgreProcedureManager

java.lang.Object

com.gsitm.ustra.java.data.utils.procedure.UstraProcedureManager

com.gsitm.ustra.java.data.utils.procedure.UstraPostgreProcedureManager

public class UstraPostgreProcedureManager
extends UstraProcedureManager

Postgre ProcedureManager

Field Summary

Fields inherited from class com.gsitm.ustra.java.data.utils.procedure.UstraProcedureManager

jdbcTemplate

Constructor Summary

Constructors

Constructor	Description
UstraPostgreProcedureManager(DataSource dataSource)

Method Summary

Modifier and Type	Method	Description
protected org.springframework.jdbc.core.simple.SimpleJdbcCall	createSimpleJdbcCall(ProcedureCallOption<?> option)	SimpleJdbcCall 객체 생성
protected List<String>	getResultSetKeys(List<org.springframework.jdbc.core.SqlParameter> params)	CURSOR 유형의 파라메터를 추출
List<org.springframework.jdbc.core.SqlParameter>	getSqlParameters(String procedureName, String schemaName, String databaseName, String dataSourceName)	프로시저의 파라메터 목록 생성
protected int	getSqlType(String dataType)	SQL 유형 조회
protected Map<String,Object>	mapParameter(Map<String,Object> parameterMap, List<org.springframework.jdbc.core.SqlParameter> sqlParameters, ProcedureCallOption<?> option)	호출 전 파라메터를 필터링 한다.

Methods inherited from class com.gsitm.ustra.java.data.utils.procedure.UstraProcedureManager

applyOptionFunctionJdbcCall, applyOptionProcedureJdbcCall, call, hasParameterKey, normalizeOption, normalizeParameter, normalizeReturnValue

Methods inherited from class java.lang.Object

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

Constructor Details

UstraPostgreProcedureManager

public UstraPostgreProcedureManager(DataSource dataSource)

Method Details

getSqlParameters

public List<org.springframework.jdbc.core.SqlParameter> getSqlParameters(String procedureName,
 String schemaName,
 String databaseName,
 String dataSourceName)

Description copied from class: UstraProcedureManager

프로시저의 파라메터 목록 생성

Specified by:

getSqlParameters in class UstraProcedureManager

Parameters:

procedureName - 프로시져 명

schemaName - 스키마 명

databaseName - 데이터베이스 명

dataSourceName - 데이터소스 명

Returns:

파라메터 목록

getSqlType

protected int getSqlType(String dataType)

SQL 유형 조회

Parameters:

dataType -

Returns:

mapParameter

protected Map<String,Object> mapParameter(Map<String,Object> parameterMap,
 List<org.springframework.jdbc.core.SqlParameter> sqlParameters,
 ProcedureCallOption<?> option)

Description copied from class: UstraProcedureManager

호출 전 파라메터를 필터링 한다.

Overrides:

mapParameter in class UstraProcedureManager

Parameters:

parameterMap - 파라메터

sqlParameters - SQL 파라메터 목록

option - 옵션

Returns:

호출 파라메터 목록

createSimpleJdbcCall

protected org.springframework.jdbc.core.simple.SimpleJdbcCall createSimpleJdbcCall(ProcedureCallOption<?> option)

Description copied from class: UstraProcedureManager

SimpleJdbcCall 객체 생성

Overrides:

createSimpleJdbcCall in class UstraProcedureManager

Returns:

SimpleJdbcCall 객체

getResultSetKeys

protected List<String> getResultSetKeys(List<org.springframework.jdbc.core.SqlParameter> params)

Description copied from class: UstraProcedureManager

CURSOR 유형의 파라메터를 추출

Specified by:

getResultSetKeys in class UstraProcedureManager

Returns: