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 and Description
UstraPostgreProcedureManager(javax.sql.DataSource dataSource)

Method Summary

Modifier and Type	Method and Description
protected org.springframework.jdbc.core.simple.SimpleJdbcCall	createSimpleJdbcCall(ProcedureCallOption<?> option) SimpleJdbcCall 객체 생성
protected java.util.List<java.lang.String>	getResultSetKeys(java.util.List<org.springframework.jdbc.core.SqlParameter> params) CURSOR 유형의 파라메터를 추출
java.util.List<org.springframework.jdbc.core.SqlParameter>	getSqlParameters(java.lang.String procedureName, java.lang.String schemaName, java.lang.String databaseName, java.lang.String dataSourceName) 프로시저의 파라메터 목록 생성
protected int	getSqlType(java.lang.String dataType) SQL 유형 조회
protected java.util.Map<java.lang.String,java.lang.Object>	mapParameter(java.util.Map<java.lang.String,java.lang.Object> parameterMap, java.util.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 Detail

UstraPostgreProcedureManager

public UstraPostgreProcedureManager(javax.sql.DataSource dataSource)

Method Detail

getSqlParameters

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

Description copied from class: UstraProcedureManager

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

Specified by:

getSqlParameters in class UstraProcedureManager

Parameters:

procedureName - 프로시져 명

schemaName - 스키마 명

databaseName - 데이터베이스 명

dataSourceName - 데이터소스 명

Returns:

파라메터 목록

getSqlType

protected int getSqlType(java.lang.String dataType)

SQL 유형 조회

Parameters:

dataType -

Returns:

mapParameter

protected java.util.Map<java.lang.String,java.lang.Object> mapParameter(java.util.Map<java.lang.String,java.lang.Object> parameterMap,
                                                                        java.util.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 java.util.List<java.lang.String> getResultSetKeys(java.util.List<org.springframework.jdbc.core.SqlParameter> params)

Description copied from class: UstraProcedureManager

CURSOR 유형의 파라메터를 추출

Specified by:

getResultSetKeys in class UstraProcedureManager

Returns: