\u4e0b\u9762\u7684\u8fd9\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u5185\u5bb9\u6d89\u53ca \u5224\u65ad \u5faa\u73af \u5f02\u5e38\u7684\u5904\u7406\uff0c\u529f\u80fd\u662f\u8f93\u5165\u4e00\u4e2a\u503c\u6839\u636e\u8fd9\u4e2a\u503c\u67e5\u8be2\u51fa\u6570\u636e\u540e\u8fd4\u56de\u4fe1\u606f<\/p>\n
DROP PROCEDURE IF EXISTS GetEmployeeName;\nDELIMITER \/\/\n\nCREATE PROCEDURE GetEmployeeName(\n IN p_employee_id INT,\n\n OUT p_employee_name VARCHAR(255)\n)\nBEGIN\n DECLARE done INT DEFAULT FALSE;\n DECLARE emp_name VARCHAR(255);\n\n -- \u58f0\u660e\u6e38\u6807\n DECLARE cur CURSOR FOR\n SELECT employee_name\n FROM employees;\n WHERE employee_id = p_employee_id;\n\n -- \u5b9a\u4e49\u5f53\u6e38\u6807\u672a\u627e\u5230\u6570\u636e\u65f6\u6267\u884c\u7684\u5904\u7406\u65b9\u6cd5\n DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;\n\n -- \u6253\u5f00\u6e38\u6807\n OPEN cur;\n\n -- \u5faa\u73af\u8bfb\u53d6\u6e38\u6807\u6570\u636e\n read_loop: LOOP\n FETCH cur INTO emp_name;\n IF done THEN\n LEAVE read_loop;\n END IF;\n -- SELECT SLEEP(5);\n insert into tool values(concat(emp_name,CURRENT_TIMESTAMP));\n END LOOP;\n\n -- \u5173\u95ed\u6e38\u6807\n CLOSE cur;\n\n -- \u5904\u7406\u672a\u627e\u5230\u6570\u636e\u7684\u60c5\u51b5\n IF emp_name IS NULL THEN\n SET p_employee_name = 'Employee not found';\n ELSE\n SET p_employee_name = emp_name;\n END IF;\n\n -- \u6f14\u793a\u6761\u4ef6\u5904\u7406\n IF p_employee_id < 0 THEN\n SIGNAL SQLSTATE '45000'\n SET MESSAGE_TEXT = 'Employee ID cannot be negative';\n END IF;\n\n -- \u6f14\u793a\u5f02\u5e38\u5904\u7406\n BEGIN\n DECLARE EXIT HANDLER FOR SQLEXCEPTION\n BEGIN\n SET p_employee_name = 'An error occurred';\n END;\n\n -- \u5176\u4ed6\u5904\u7406\u8bed\u53e5\n\n END;\nEND \/\/\n\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u5148\u4ece\u6709\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u5f00\u59cb\u770b \u4e0b\u9762\u7684\u8fd9\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u5185\u5bb9\u6d89\u53ca \u5224\u65ad \u5faa\u73af \u5f02\u5e38\u7684\u5904\u7406\uff0c\u529f\u80fd\u662f\u8f93\u5165\u4e00\u4e2a\u503c\u6839\u636e\u8fd9\u4e2a\u503c\u67e5\u8be2\u51fa […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[],"_links":{"self":[{"href":"http:\/\/www.specialwu.com\/index.php?rest_route=\/wp\/v2\/posts\/2284"}],"collection":[{"href":"http:\/\/www.specialwu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.specialwu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.specialwu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.specialwu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2284"}],"version-history":[{"count":1,"href":"http:\/\/www.specialwu.com\/index.php?rest_route=\/wp\/v2\/posts\/2284\/revisions"}],"predecessor-version":[{"id":2285,"href":"http:\/\/www.specialwu.com\/index.php?rest_route=\/wp\/v2\/posts\/2284\/revisions\/2285"}],"wp:attachment":[{"href":"http:\/\/www.specialwu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.specialwu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2284"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.specialwu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}