Mybatis 调用存储过程

奥尔覅几22

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.sm.able.Userable">
<!-- 调用存储过程 -->
<select statementType="CALLABLE" id="executeAddUser" parameterType="User">
{call usp_add_user(#{id},#{name})}
</select>
<!-- 调用存储过程实现分页功能 ，带输出参数（游标，总页数）-->
<select statementType="CALLABLE" id="splitPage" parameterType="map">
{call usp_split_user(
#{tabName},#{currentPage},#{pageSize},#{total,mode=OUT,jdbcType=INTEGER},
#{result, mode=OUT, jdbcType=CURSOR,javaType=ResultSet,resultMap=userMap}
)}
</select>
<resultMap type="User" id="userMap">
<id column="id" property="id"/>
<result column="name" property="name" />
</resultMap>
</mapper>