我的学习空间

DELIMITER $
CREATE PROCEDURE sp_salaryAnalysis(In dname CHAR(10))
DETERMINISTIC
BEGIN
SELECT AVG(___) AS avgbsalary 
FROM tb_salary, tb_department, tb_employee WHERE tb_employee.dno = tb_department.dno ___ tb_employee.eno=tb_salary.eno AND tb_department.dname = ___;
END$
DELIMITER ;

DELIMITER $
CREATE FUNCTION fn_sex(eid INT)   
___ CHAR(20)      
DETERMINISTIC      
BEGIN                   
   DECLARE msex CHAR(2);   
   SELECT sex INTO msex FROM tb_employee  WHERE eno = ___;   
   IF msex IS ___ THEN         
       RETURN(SELECT '没有该职工');
   ELSEIF msex = '女' THEN
       RETURN(SELECT '女');
   ELSE RETURN(SELECT  '男');
   END IF;   
END$
DELIMITER ;

<?php
	 //*********Found********
	$con= ____________("localhost:3306","root","")
   		 or die("no database!<br>");
 		mysql_select_db ("db_salary",$con) or die( "database fail！<br>");
		mysql_query("SET NAMES gbk");   
	if(isset($_GET['jno']))
	{
//*********Found********
		$jno=$_GET['____'];
		$sql_onejob='select ename,sex,birthday
		from tb_employee,tb_job 
		where tb_employee.jobno = tb_job.jno
		and  tb_job.jno='.$jno;
//*********Found********
		$result_onejob=mysql_query(_________,$con);
?>
		<table border='1px'>
		  <caption>员工详情</caption>
		  <tr>
			<td>员工姓名</td>
			<td>性别</td>
			<td>出生日期</td>
		  </tr>
<?php
//*********Found********
  while(____________=mysql_fetch_array($result_onejob)){
?>
  <tr> 
    <td><?php echo $row_onejob[0];?></td>
    <td><?php echo $row_onejob[1];?></td>
	<td><?php echo $row_onejob[2];?></td>
  </tr>
<?php
  }
 ?> 
  </table>
   <a href="sj3.php">Back</a>
 <?php
	}
	else{
		$sql_job="SELECT jno,jobtitle FROM tb_job";
		$result_jobs=mysql_query($sql_job,$con);
?>
		<table border='1px'>
		<caption>所有职务</caption>
		  <tr>
			<td>职务编号</td>
			<td>职务名称</td>
			<td>工资详情</td>
		  </tr>
<?php
  while($rows_jobs=mysql_fetch_array($result_jobs)){
?>
  <tr> 
    <td><?php echo $rows_jobs[0];?></td>
    <td><?php echo $rows_jobs[1];?></td>
	<td><a href="/sj3.php?jno=<?php echo $rows_jobs[0];?>">查看</a></td>
  </tr>
<?php
	}
	?> 
	</table><br/><br/>
	
<?php	
  }
//*********Found********
  mysql_close(____); ?>