Mybatis调用存储过程

1、insert

    <insert id="addUser" parameterType="com.po.User" statementType="CALLABLE">
        {call insert_user(
        #{id,mode=OUT,jdbcType=INTEGER},#{name,mode=IN},#{sex,mode=IN},#{age,mode=IN})}
    </insert>

 

2、delete

<delete id="deleteUser" parameterType="Integer" statementType="CALLABLE">
       {call deleteUser(#{id,mode=IN})}
</delete>

 

3、update

    <update id="updateUser" parameterType="user" statementType="CALLABLE">
        {call updateUser(#{id,mode=IN},#{name,mode=IN},#{sex,mode=IN},#{age,mode=IN})}
    </update>

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

资料来源：https://blog.csdn.net/dwenxue/article/details/82257944

转载于:https://www.cnblogs.com/Dream2hc/p/database11495767.html