- MySQL存储过程中的错误处理 参考链接: http://blog.csdn.net/liyongshun82/article/details/52813711
- mybatis中调用存储过程 参考链接: https://www.cnblogs.com/hellokitty1/p/5807392.html
存储过程:
CREATE PROCEDURE `sp_combine_admin_group`(IN `group_id1` int(11), IN `group_id2` int(11),IN `admin_user_id` int(11),IN `group_name` varchar(64),IN `description` varchar(1024), out `t_error` INT(11))
BEGIN
DECLARE new_group_id int(11);
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=0;
SET t_error = 1;
START TRANSACTION;
INSERT INTO admin_group (`group_name`,`description`) values ( group_name,description);
SET new_group_id =LAST_INSERT_ID();
UPDATE group_special_power SET group_id= new_group_id where group_id =group_id1 or group_id= group_id2;
UPDATE group_menu_power SET group_id= new_group_id where group_id =group_id1 or group_id= group_id2;
UPDATE group_hospital_power SET group_id= new_group_id where group_id =group_id1 or group_id= group_id2;
UPDATE admin_user SET is_admin=0 , admin_group_id=new_group_id where admin_group_id =group_id1 or admin_group_id= group_id2;
UPDATE admin_user SET is_admin=1 where id=admin_user_id;
DELETE FROM admin_group where id =group_id1 or id= group_id2;
IF t_error = 0 THEN
ROLLBACK;
ELSE
COMMIT;
END IF;
END;
–Mapper.xml文件调用存储过程
<insert id="insertAdminGroupCombine" parameterType="org.system.entity.admin.AdminGroup" useGeneratedKeys="true" keyColumn="id" statementType="CALLABLE" >
{call sp_combine_admin_group(
#{group_id1,jdbcType=INTEGER,mode=IN},
#{group_id2,jdbcType=INTEGER,mode=IN},
#{admin_user_id,jdbcType=INTEGER,mode=IN},
#{group_name,jdbcType=VARCHAR,mode=IN},
#{description,jdbcType=VARCHAR,mode=IN},
#{t_error,jdbcType=INTEGER,mode=OUT})}
</insert>