USE db_grade;
DELIMITER $$
CREATE PROCEDURE sp_course(________ ROWS INT)
BEGIN
DECLARE cid CHAR(10);
DECLARE FOUND BOOLEAN DEFAULT TRUE;
DECLARE cur_cno CURSOR FOR
SELECT cno FROM tb_course WHERE ________ = 1;
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET FOUND=FALSE;
SET ROWS=0;
OPEN cur_cno;
FETCH cur_cno INTO cid;
WHILE FOUND DO
SET ________ = ROWS+1;
FETCH cur_cno INTO cid;
END WHILE;
________ cur_cno;
END $$DELIMITER $$
CREATE TRIGGER tr_score BEFORE INSERT ON ________ FOR EACH ROW
BEGIN
________ tmp INT;
SET ________ = NEW.score;
IF tmp < 60 THEN
________ NEW.flag = '1';
END IF;
END $$
DELIMITER ;
<?php
$host="localhost"; $user="root"; $pwd="";
//**********found**********
__________ = "db_grade";
$conn=mysql_connect($host,$user,$pwd)
or die("连接数据库服务器失败。".mysql_error());
//**********found**********
_______________($db_name,$conn)
or die("连接数据库失败。".mysql_error());
mysql_query("set names 'gbk'");
?>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<head><title>各院系的班级数统计</title></head>
<body>
<?php
//**********found**********
$cmd="select department, count(classno) from tb_class group by ____________ order by department";
$result=mysql_query($cmd,$conn);
print "<table width=140 border=0 align=center>";
//**********found**********
if(________){
printf ("我校共有 %s 个院系\n", mysql_num_rows($result));
}
print "<table width=280 border=1 align=center>";
print "<caption>各院系班级数统计表</caption>";
print "<tr><td>院系名称</td><td>目前班级数</td></tr>";
while($row=mysql_fetch_array($result)){
//**********found**********
print "<tr><td>$row[0]</td><td>_________</td></tr>";
}
print "</table><br><br>"
?>
</body>
</html>
发表回复