MyBatis 프로시저 호출, result parameterMap

Java

----------------------------------------------------------------

public void testProc(SqlSession session) throws SQLException {

    HashMap<String, String> param = new HashMap<String, String>();

    param.put("param1", "aa");

    param.put("param2", "cc");

    param.put("resultCd", "");

    param.put("resultMsg", "");

    

    session.selectOne("UserStatOld.testProc", param);

    

    System.out.println("resultCd  : " + param.get("resultCd"));

    System.out.println("resultMsg  : " + param.get("resultMsg"));

}

XML

----------------------------------------------------------------

<parameterMap id="procMap" type="HashMap">

    <parameter property="param1" mode="IN" jdbcType="VARCHAR" javaType="java.lang.String" />

    <parameter property="param2" mode="IN" jdbcType="VARCHAR" javaType="java.lang.String" />

    <parameter property="resultCd" mode="OUT" jdbcType="VARCHAR" javaType="String" />

    <parameter property="resultMsg" mode="OUT" jdbcType="VARCHAR" javaType="String" />

</parameterMap>

<select id="testProc" statementType="CALLABLE" parameterMap="procMap">

    {call PR_TEST(?, ?, ?, ?)}

</select>