<?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="这里为mapper接口类全名" >
<resultMap id="CusBaseMap0" type="java.util.HashMap">
<result column="DATATYPE" property="datatype" jdbcType="VARCHAR" />
<result column="DATAVALUE" property="datavalue" jdbcType="VARCHAR" />
</resultMap>
<resultMap id="CusBaseMap1" type="java.util.HashMap">
<result column="STARTTIME" property="starttime" jdbcType="VARCHAR" />
<result column="DATATYPE" property="datatype" jdbcType="VARCHAR" />
</resultMap>
<resultMap id="CusBaseMap2" type="java.util.HashMap">
<result column="DELAYPAYAMT" property="delaypayamt" jdbcType="VARCHAR" />
<result column="REDUC" property="reduc" jdbcType="VARCHAR" />
</resultMap>
<select id = "getConfigs" parameterType="java.util.Map" statementType="CALLABLE" >
{call pkg_interfaces.proc_getconfig(
<!--参数 输入/输出 jdbc类型 java接受类型 result类型(与上面对应)-->
#{p_curset,mode=OUT,jdbcType=CURSOR,javaType=java.sql.ResultSet,resultMap=CusBaseMap0},
#{p_cursettime,mode=OUT,jdbcType=CURSOR,javaType=java.sql.ResultSet,resultMap=CusBaseMap1},
#{p_pccursetrule,mode=OUT,jdbcType=CURSOR,javaType=java.sql.ResultSet,resultMap=CusBaseMap2}
)}
</select>
<!--具体实现为传入含游标的map,结果返回在传入的map中,从map获取数据-->
<update id="bankSave" statementType="CALLABLE" parameterType="此为传参model类全名">
{call pkg_interfaces.proc_UpdatePayBank(
#{datacode,mode=IN,jdbcType=VARCHAR},
#{dataname,mode=IN,jdbcType=VARCHAR},
#{chargecode,mode=IN,jdbcType=VARCHAR},
#{limitamt,mode=IN,jdbcType=INTEGER}
)}
</update>
</mapper>
mybatis & oracle & 存储过程调用实例
最新推荐文章于 2021-09-08 10:15:13 发布