spring mvc调用mysql存储过程_关于spring mvc + mybatis 调用存储过程

最近在写一个 spring mvc + mybatis 调用mysql 存储过程， 进行批量添加 ，返回了条数 但是没有执行添加操作 ， 不知道哪里出错了 ， 希望各位大神帮忙看看

mapper

service

dao

controller

存储过程 testPro

BEGIN

DECLARE id varchar(36);

DECLARE goodsId varchar(36);

DECLARE done INT DEFAULT FALSE;

declare fetchSeqCursor cursor for SELECT * FROM tmp_print;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

declare CONTINUE HANDLER for sqlexception

create temporary table if not exists promGoods (

ID VARCHAR(36),

PROMOTION_ID VARCHAR(36),

GOODS_ID VARCHAR(36)

);

START TRANSACTION;

open fetchSeqCursor;

seq_loop:loop

fetch fetchSeqCursor into id,goodsId;

IF done THEN

LEAVE seq_loop;

END IF;

SET @resaultCount = (SELECT count(*) FROM promGoods WHERE PROMOTION_ID = promotionId AND GOODS_ID = goodsId);

IF @resaultCount = 0 THEN

INSERT INTO promGoods(ID,PROMOTION_ID,GOODS_ID) VALUES (id,promotionId,goodsId);

END IF;

END LOOP;

CLOSE fetchSeqCursor;

SET resaultCount = (SELECT count(*) FROM promGoods WHERE PROMOTION_ID = promotionId );

IF resaultCount = 0 THEN

ROLLBACK;

ELSE

COMMIT;

END IF;

END

存储过程 sp_print_result：

BEGIN

-- Get the separated string.

declare cnt int default 0;

declare i int default 0;

set cnt = func_get_split_string_total(goodsId,',');

drop table if exists tmp_print;

create temporary table tmp_print (id VARCHAR(36) not null,goodsId VARCHAR(36) not null);

while i < cnt

do

set i = i + 1;

insert into tmp_print(id,goodsId) values (func_get_split_string(id,',',i),func_get_split_string(goodsId,',',i));

end while;

SET resaultCount = cnt;

END

目前 问题 ：controller 两个resault 可以接受返回参数， 但是临时表中数据不执行添加操作