[Mybatis] Mybatis Procedure 호출

※ Mybatis 에서 DB Procedure 호출하는 방법

 

1. Mapper xml

<select id="id" statementType="CALLABLE" parameterType="HashMap"> 
{ CALL 프로시저명( 
      #{param1}, 
      #{param2, mode=IN, jdbcType=VARCHAR, javaType=String}, 
      #{param3, mode=OUT, jdbcType=VARCHAR, javaType=String}, 
} 
</select>

 

2. 호출 java

Map<String, Object> call = new HashMap<String, Object>();
call.put("param1", "a");
call.put("param2", "a"); 
System.out.println( call.toString() );
// param1 = a , param2 = a
dao.callProcedure( call );
System.out.println( call.toString() );
// param1 = a , param2 = a , param3 = procedure_result