mysql游标使用模版

BEGIN 
 /** 
 * 
 * 游标模版 
 * @author xuyw 
 * @email xyw10000@163.com 
 * @date 2014-05-19 
 */ 
 /*游标数据变量 uid*/ 
 DECLARE uid VARCHAR(128); 
 DECLARE done INT DEFAULT 0; 
 
 /*查询所有用户*/ 
 DECLARE cur CURSOR FOR SELECT xxx FROM xx; 
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; 
 OPEN cur; 
 /* 开始循环*/ 
 REPEAT 
 /* 提取游标里的数据*/ 
 FETCH cur INTO uid; 
 IF done =0 THEN 
 执行你的业务 
 END IF; 
 UNTIL done=1 
 END REPEAT; 
 /*关闭游标*/ 
 CLOSE cur; 
END;