MySql 存储过程例子

我的宝贝们

DROP PROCEDURE IF EXISTS student_procedure;
CREATE PROCEDURE student_procedure()
BEGIN
        //声明变量
        DECLARE name VARCHAR(64);
        DECLARE sex VARCHAR(32);
        DECLARE phone VARCHAR(32);
        DECLARE cert VARCHAR(32);
        DECLARE birth VARCHAR(32);
        DECLARE studentCode VARCHAR(32);
        DECLARE schoolId VARCHAR(32);
        DECLARE gradeId VARCHAR(32);
        DECLARE classNum VARCHAR(32);
        DECLARE s int DEFAULT 0;
        //查询结果放到实体
        DECLARE students CURSOR FOR select name,sex,phone,cert,birth,student_code,school_id,grade_id,class_num from yk_student where del_flag='0' and is_up = '0';
        DECLARE CONTINUE HANDLER FOR NOT FOUND SET s=1;
        OPEN students;
                //实体的值赋值给变量
                FETCH students INTO name,sex,phone,cert,birth,nation,place,studentCode,schoolId,gradeId,classNum,sysOrgCode;
                //循环实体操作数据
                WHILE s <> 1 DO
                        IF cert IS NOT NULL AND cert <> '' THEN
                                //执行要操作的逻辑
                        ELSEIF name IS NOT NULL AND name <> '' AND phone IS NOT NULL AND phone <> '' THEN
                                //执行要操作的逻辑
                        END IF;
                FETCH students INTO name,sex,phone,cert,birth,studentCode,schoolId,gradeId,classNum;
                END WHILE;
        CLOSE students;
END