开发者

How to use stored procedure in ibatis? [closed]

Closed. This question needs to be more focused. It is not currently accepting answers.

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 question

How 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>
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜