网上关于Mybatis调用多游标参数存储过程的例子很少,今天正好用到,并写了个例子,记录下来,以备后用,希望对你也有所帮助!
环境:
Mybatis3
Oracle11g
JUnit4
Oracle Procedure:
create or replace procedure test_getDeliverys(
idList IN VARCHAR2,
cur_delivery out sys_refcursor,
cur_delivery1 out sys_refcursor)
is
begin
open cur_delivery for select ID,PUBMEMBERID from delivery;
open cur_delivery1 for select ID,PUBMEMBERID from delivery;
end test_getDeliverys;
接口:IDeliveryDAO
public void getDeliverys123(Map<String, Object> deliverys);
DeliveryMapper.xml
<resultMap id="dMap" type="com.rcollar.rcmtm.order.entity.Delivery">
<id column="ID" jdbcType="VARCHAR" property="id" /&