📄 [mybatis] out변수가 있는 프로시저 호출 2023. 12. 5. 08:42
/* ServiceImpl */
regMap.put("p_in1","값1");
regMap.put("p_in2","값1");
regMap.put("p_out1","");
regMap.put("p_out2","");
regMap.put("p_out3","");
VO.명칭(regMap)
/* xml */
<select id="명칭" resultType="hashMap" statementType="callable">
call 패키지명.프로시저명
(
#{p_in1},
#{p_in2},
#{p_out1, mode=OUT, jdbcType=VARCHAR},
#{p_out2, mode=OUT, jdbcType=VARCHAR},
#{p_out3, mode=OUT, jdbcType=VARCHAR}
)
</select>
/* ServiceImpl */
regMap.put("p_in1","값1");
regMap.put("p_in2","값1");
regMap.put("p_out1","");
regMap.put("p_out2","");
regMap.put("p_out3","");
VO.명칭(regMap)
/* xml */
<select id="명칭" resultType="hashMap" statementType="callable">
call 패키지명.프로시저명
(
#{p_in1},
#{p_in2},
#{p_out1, mode=OUT, jdbcType=VARCHAR},
#{p_out2, mode=OUT, jdbcType=VARCHAR},
#{p_out3, mode=OUT, jdbcType=VARCHAR}
)
</select>반응형
