mysql存储过程标准模板

CREATE DEFINER=`root`@`localhost` PROCEDURE `phoneDeal`()
BEGIN
  declare user_no1 varchar (100);
  declare user_name2 varchar (100);
  DECLARE t_error INTEGER DEFAULT 0;
  DECLARE done INT DEFAULT 0;
  DECLARE cur1 CURSOR FOR
  select
    user_no,
    user_name
  from
    comm_system_user
  where user_id < 100;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
  DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error = 1;
  OPEN cur1;
  START TRANSACTION;
  emp_loop :
  LOOP
    FETCH cur1 INTO user_no1,
    user_name2;
    IF done = 1
    THEN LEAVE emp_loop;
    END IF;
    select
      user_no1;
    -- TODO
   END LOOP emp_loop;
  IF t_error = 1
  THEN ROLLBACK;
  ELSE COMMIT;
  END IF;
  CLOSE cur1;
END