1.SQLEXCEPTION對應(yīng)存儲過程中的所有異常
2.通過輸出參數(shù)，來返回事務(wù)是否執(zhí)行成功
3.一個疑問：為什么mysql事務(wù)執(zhí)行成功后，受影響的記錄數(shù)都是0呢？
下為SQL代碼：
-- Procedure "Users_Test" DDL
CREATE DEFINER=`root`@`%` PROCEDURE `Users_Test`(out pCode int)
begin
declare userID int default 0;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
begin
rollback;
SET pCode=1;
end;
set pCode = 0;
-- savepoint sp;
-- SET AUTOCOMMIT= 1;
start transaction;
-- call Users_WriteLog('haha ,log');
insert into Users_Login (LoginName,LoginPwd,Banned) values ('1234','0000',0);
set userID = @@IDENTITY;
insert into Users_Profile(UserID,UserName,CharactorName,HeadImageID,Sex,FromType,ProfileComplete)
values ( 5,'999999',10,1,1,0,1);
commit;
-- SELECT ROW_COUNT();
-- set rowcnt = mysql_affected_rows();
-- rollback to sp;
end;