How to use stored procedure in ibatis? [closed]
Want to improve this question? Update the question so it focuses on one problem only by editing this post.
Closed 8 years ago.
开发者_StackOverflow中文版 Improve this questionHow to use stored procedure in ibatis?
Like this:
<procedure id="getUserEmail"
parameterClass="java.lang.String" resultClass="java.lang.String">
{call SP_getUserEmail(#username#)}
</procedure>
It should be something like this in mybatis 3:
<update id="myProcCall" parameterType="map" statementType="CALLABLE">
{
call MY_PROC(#{param1, javaType=String, jdbcType=VARCHAR,
mode=IN},#{param2, javaType=String, jdbcType=VARCHAR,
mode=IN)
}
</update>
精彩评论