procedure

################################所有存储过程############################

/*====================================================================*/
/* PROCEDURE                                                          */
/*按照考生比例确定招生人数，将排名在前面的考生插入到录取表，计算分数线*/
/*====================================================================*/
delimiter $$
CREATE PROCEDURE proc_cutoff_point(in p_sumstu int, out p_point int)
begin
set p_point = p_sumstu * 0.8;
#select id into outfile 'C:/Users/Ron Kou/Documents/mysql_dir/temp_extoad.txt'
#fields terminated by ','
#optionally enclosed by '"'
#lines terminated by '\r\n'
#from examinee order by score desc limit p_point;
insert into admission_list(id)( select id from examinee order by score desc limit p_point);

SELECT 
    MIN(score)
INTO p_point FROM
    admission_list AS a
        JOIN
    examinee AS e
WHERE
    a.id = e.id;
end $$
delimiter ;
/*==============================================================*/
/* PROCEDURE                                                    */
/*计算考生总数                                                  */
/*==============================================================*/
delimiter $$
CREATE PROCEDURE proc_sumstu(out p_sumstu int)
begin
select COUNT(*) into p_sumstu from examinee;
end $$
delimiter ;
/*==============================================================*/
/* procedure  查询录取名单中学生复试成绩                                  */
/*============================================================= */
DELIMITER $$
create procedure check_score()
comment '查询录取名单中学生复试成绩'
begin
SELECT 
    id, reexamine_score
FROM
    admission_list;
end$$
DELIMITER ;


/*==============================================================*/
/* procedure  往考生档案中添加条目                                        */
/*==============================================================*/
DELIMITER $$
create procedure addcan(in p_id varchar(11),in p_name varchar(10),in p_sex boolean,in p_age int,in p_school varchar(20),in p_fresh boolean,in p_major_code varchar(10),in p_region varchar(10))
begin
insert into candidates_file (id, name, sex, age, school, fresh,major_code, region)
values (p_id,p_name, p_sex,  p_age,  p_school,  p_fresh,  p_major_code,  p_region);
end$$
DELIMITER ;