勤工助学管理系统(共38页)

1、附件1：学 号： 2012131113课 程 设 计题 目实验室勤工俭学管理系统学 院计信学院专 业金融信息化班 级1班学生姓名蒋汉指导教师张世勇2012年6月24日重庆(zhn qn)工商大学课程设计成绩评定表学院(xuyun)：计信学院(xuyun) 班级：金信1班 学生姓名：蒋汉 学号：2012131113项目分值优秀(100 x90)良好(90 x80)中等(80 x70)及格(70 x60)不及格(x1 ROLLBACKELSE BEGIN SELECT oldjobNo=jobNo2782 from DELETED SELECT newjobNo=jobNo2782 from IN

2、SERTED UPDATE Confirm2782 SET jobNo2782=newjobNo WHERE jobNo2782=oldjobNoEND创建删除触发器studentDelCREATE TRIGGER studentDelON Student2782FOR DELETEAS DECLARE studentNo char(7) IF(SELECT COUNT(*) FROM INSERTED)1 ROLLBACKELSE BEGIN DELETE FROM Student2782 WHERE studentNo2782 IN (SELECT studentNo FROM delet

3、ed) END创建存储(cn ch)过程proAdminCREATE PROCEDURE proAdmin(aNo char(4),sNo char(7) OUTPUT,jNo char(8) OUTPUT, sName varchar(20) OUTPUT)ASBEGIN SELECT sNo=a.studentNo2782,jNo=a.jobNo2782,sName=sortName2782 FROM Assign2782 a,Job2782 b,jobSort2782 c WHERE adminNo2782=aNo AND a.jobNo2782=b.jobNo2782 AND b.so

4、rtNo2782=c.sortNo2782END创建存储(cn ch)过程proStudentCREATE PROCEDURE proStudent(sName varchar(20),sNo char(7) OUTPUT, aNum int OUTPUT, level int OUTPUT)ASBEGIN DECLARE salary numeric(8,2) DECLARE myCur CURSOR FOR SELECT studentNo2782,absenceNum2782,level2782,salary2782 FROM Student2782 WHERE studentName2

5、782=sName OPEN myCur FETCH myCur INTO sNo,aNum,level,salary WHILE(FETCH_STATUS=0) BEGIN SELECT sNo,aNum,level,salary FETCH myCur into sNo,aNum,level,salary END CLOSE myCur DEALLOCATE myCurEND创建存储(cn ch)过程proCompanyCREATE PROCEDURE proCompany(cNo char(5),jNo char(8) OUTPUT, jName varchar(20) OUTPUT, pNeed int OUTPUT,salary numeric(8,2)ASBEGIN DECLARE myCur CURSOR FOR SELECT jobNo2782, jobName2782, personNeed2782, salary2782 FROM Company2782 a,Job2782 b WHERE panyNo2782=cNo AND panyNo2782=panyNo2782 OPEN myCur FETCH myCur INTO jNo,jName,pNeed,salary WHILE(FETCH_STATUS=0) BEGIN SELECT jNo,jNam