public abstract class UstraProcedureManager
extends java.lang.Object
| Modifier and Type | Field and Description |
|---|---|
protected org.springframework.jdbc.core.JdbcTemplate |
jdbcTemplate |
| Constructor and Description |
|---|
UstraProcedureManager(javax.sql.DataSource dataSource) |
UstraProcedureManager(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate) |
| Modifier and Type | Method and Description |
|---|---|
protected org.springframework.jdbc.core.simple.SimpleJdbcCall |
applyOptionFunctionJdbcCall(org.springframework.jdbc.core.simple.SimpleJdbcCall jdbcCall,
ProcedureCallOption<?> option,
java.util.List<org.springframework.jdbc.core.SqlParameter> sqlParameters)
Function Option 적용
|
protected org.springframework.jdbc.core.simple.SimpleJdbcCall |
applyOptionProcedureJdbcCall(org.springframework.jdbc.core.simple.SimpleJdbcCall jdbcCall,
ProcedureCallOption<?> option,
java.util.List<org.springframework.jdbc.core.SqlParameter> sqlParameters)
Procedure Option 적용
|
<R> ProcedureCallResult<R> |
call(ProcedureCallOption<R> option)
프로시져를 호출
|
protected org.springframework.jdbc.core.simple.SimpleJdbcCall |
createSimpleJdbcCall(ProcedureCallOption<?> option)
SimpleJdbcCall 객체 생성
|
protected abstract java.util.List<java.lang.String> |
getResultSetKeys(java.util.List<org.springframework.jdbc.core.SqlParameter> params)
CURSOR 유형의 파라메터를 추출
|
abstract 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 boolean |
hasParameterKey(org.springframework.jdbc.core.SqlParameter sqlParameter,
java.util.Map<java.lang.String,java.lang.Object> parameterMap)
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)
호출 전 파라메터를 필터링 한다.
|
protected void |
normalizeOption(ProcedureCallOption<?> option)
프로시져 옵션을 정규화 한다.
|
protected java.util.Map<java.lang.String,java.lang.Object> |
normalizeParameter(java.lang.Object parameter,
ProcedureCallOption<?> option)
파라메터를 정규화 한다.
|
protected <R> R |
normalizeReturnValue(java.util.Map<java.lang.String,java.lang.Object> returnMap,
ProcedureCallOption<R> option)
결과 값을 정규화 한다.
|
public UstraProcedureManager(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate)
public UstraProcedureManager(javax.sql.DataSource dataSource)
public abstract 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)
procedureName - 프로시져 명schemaName - 스키마 명databaseName - 데이터베이스 명dataSourceName - 데이터소스 명protected abstract java.util.List<java.lang.String> getResultSetKeys(java.util.List<org.springframework.jdbc.core.SqlParameter> params)
params - public <R> ProcedureCallResult<R> call(@NonNull ProcedureCallOption<R> option)
R - 반환 형식option - 호출 옵션protected org.springframework.jdbc.core.simple.SimpleJdbcCall createSimpleJdbcCall(@NonNull
ProcedureCallOption<?> option)
option - protected org.springframework.jdbc.core.simple.SimpleJdbcCall applyOptionProcedureJdbcCall(org.springframework.jdbc.core.simple.SimpleJdbcCall jdbcCall,
@NonNull
ProcedureCallOption<?> option,
java.util.List<org.springframework.jdbc.core.SqlParameter> sqlParameters)
jdbcCall - jdbcCalloption - 호출 옵션sqlParameters - SQL 파라메터 목록protected org.springframework.jdbc.core.simple.SimpleJdbcCall applyOptionFunctionJdbcCall(org.springframework.jdbc.core.simple.SimpleJdbcCall jdbcCall,
@NonNull
ProcedureCallOption<?> option,
java.util.List<org.springframework.jdbc.core.SqlParameter> sqlParameters)
jdbcCall - jdbcCalloption - 호출 옵션sqlParameters - SQL 파라메터 목록protected void normalizeOption(@NonNull
ProcedureCallOption<?> option)
option - protected java.util.Map<java.lang.String,java.lang.Object> normalizeParameter(java.lang.Object parameter,
@NonNull
ProcedureCallOption<?> option)
parameter - 파라메터option - 옵션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,
@NonNull
ProcedureCallOption<?> option)
parameterMap - 파라메터sqlParameters - SQL 파라메터 목록option - 옵션protected boolean hasParameterKey(org.springframework.jdbc.core.SqlParameter sqlParameter,
java.util.Map<java.lang.String,java.lang.Object> parameterMap)
sqlParameter - SQL 파라메터parameterMap - 파라메터 Mapprotected <R> R normalizeReturnValue(java.util.Map<java.lang.String,java.lang.Object> returnMap,
@NonNull
ProcedureCallOption<R> option)
returnMap - option -