Mysql´æ´¢¹ý³Ì£¨ËÄ£©——Òì³£´¦Àí

ÓÐʱºò£¬²»Ï£Íû´æ´¢¹ý³ÌÅ׳ö´íÎóÖÐÖ¹Ö´ÐУ¬¶øÊÇÏ£Íû·µ»ØÒ»¸ö´íÎóÂë¡£
Mysql
Ö§³ÖÒì³£´¦Àí£¬Í¨¹ý¶¨Òå
CONTINUE/EXIT
Òì³£´¦ÀíµÄ
HANDLER
À´²¶»ñ
SQLWARNING/NOT FOUND/SQLEXCEPTION
£¨¾¯¸æ
/
ÎÞÊý¾Ý
/
ÆäËûÒì³££©¡£ÆäÖУ¬
FOR
ºóÃæ¿ÉÒÔ¸ÄΪ
SQLWARNING,
NOT FOUND, SQLEXCEPTION
À´Ö¸Ê¾ËùÓÐÒì³£¶¼´¦Àí£¬Ï൱ÓÚ
oracle
ÖеÄ
others
¡£ÀýÈ磬µ±²»½øÐÐÒì³£´¦Àíʱ£¬ÒÔÏ´úÂ뽫ֱ½ÓÅ׳öÒ»¸ö
ERROR 1062 (23000)
´íÎó£º
        
Sql
code 4-1:
CREATE PROCEDURE test_proc_ins1(
IN i_id INT,
IN i_name VARCHAR(100)
)
BEGIN
INSERT INTO testproc VALUES (i_id,i_name);
INSERT INTO testproc VALUES (i_id,i_name);
END;
 
¾­¹ýÒì³£´¦Àíºó£¬¿ÉÒÔ±ÜÃâÅ׳ö´íÎ󣬶øÊǶ¨ÒåÒ»¸ö·µ»Ø²ÎÊý
o_ret
¸³ÓèÌØÊâÖµÀ´±íʾʧ°Ü£¬ÕâÑù£¬ÔÚ
java
´úÂëÖУ¬¿ÉÒÔͨ¹ý»ñÈ¡·µ»ØÖµ¶ø²»ÊDz¶»ñÒì³£µÄ·½Ê½À´´¦ÀíÒµÎñÂß¼­¡£ÀýÈ罫·µ»ØÖµÉèÖÃΪ
-1:
        
Sql
code 4-2:
CREATE PROCEDURE test_proc_ins1(
IN i_id INT,
IN i_name VARCHAR(100),
OUT o_ret INT)
BEGIN
DECLARE EXIT HANDLER FOR SQLSTATE '23000' set o_ret = -1;
-- Ò²¿ÉÒÔÕâÑùʹÓãº
-- DECLARE EXIT HANDLER FOR SQLWARNING,NOT FOUND,SQLEXCEPTION set o_ret=-1;
INSERT INTO testproc VALUES (i_id,i_name);
INSERT INTO testproc VALUES (i_id,i_name);
set o_ret = 1;
END;