SQL畢業(yè)生信息管理系統(tǒng)

③學(xué)校用戶測試--學(xué)校登錄createprocSchLogin@SchIdchar(10)asbeginifexists(select*fromdbo.SchooluserswherecSchoolId=@SchId) begin selectcSchoolId學(xué)校編號,cSchoolCode學(xué)校密碼fromdbo.Schoolusers wherecSchoolId=@SchId return0 endelse print'NOtheidofcertionstudent' return1endgoexecSchLogin'00001'--修改學(xué)校注冊信息createprocedurealSchoolInfor@SchIdchar(5),@SchCodechar(10)=nullASBEGINIFEXISTS(SELECT*FROMdbo.SchoolusersWHEREcSchoolId=@SchId)BEGINIF@SchCodeISNOTNULL UPDATEdbo.SchoolusersSETcSchoolCode=@SchCodeWHEREdbo.Schoolusers.cSchoolId=@SchId IF@@ROWCOUNT>0 RETURN0 ENDELSE PRINT'NORECORDSFOUND!' RETURN1ENDGOexecalSchoolInfor@SchId='00001',@SchCode='1122334456'--刪除公告信息deleteNoticewherecNoticeNo=1--刪除學(xué)生信息createprocDelStuInfor(@StuIdchar(10))asbegindeclare@tran_namevarchar(30)select@tran_name='students_delete'begintran@tran_namedeletefromdbo.Stuuserswheredbo.Stuusers.cStudentsId=@StuIddeletefromdbo.StudentsSchoolwheredbo.StudentsSchool.cStudentsId=@StuIddeletefromdbo.StuSchoolRewardPunishwheredbo.StuSchoolRewardPunish.cStudentsId=@StuIddeletefromdbo.StudentContactwheredbo.StudentContact.cStudentsId=@StuIddeletefromdbo.ApplyJobInformationwheredbo.ApplyJobInformation.cStudentsId=@StuIddeletefromdbo.Educationwheredbo.Education.cStudentsId=@StuIddeletefromdbo.IntroduceYourselfwheredbo.IntroduceYourself.cStudentsId=@StuIddeletefromdbo.Studentswheredbo.Students.cStudentsId=@StuIdcommittran@tran_nameendexecDelStuInfor'2010121004'--刪除公司信息createprocDelComInfor(@ComIdchar(10))asbegindeclare@tran_name1varchar(30)select@tran_name1='students_delete'begintran@tran_name1deletefromdbo.CompanyUserswheredbo.CompanyUsers.cCompanyId=@ComIddeletefromdbo.RecruitmentInformationwheredbo.RecruitmentInformation.cCompanyId=@ComIddeletefromdbo.Companywheredbo.Company.cCompanyId=@ComIdcommittran@tran_name1endexecDelComInfor@ComId='0000000009'系統(tǒng)優(yōu)缺點分析優(yōu)點：在建立畢業(yè)生信息管理系統(tǒng)時，需求分析明確完善，完成了系統(tǒng)規(guī)定的要求。在該系統(tǒng)中建立的表格，在實體完整性，參照完整性以及用戶自定義完整性中都較全面，保證了數(shù)據(jù)的正確性和完整性。在對該系統(tǒng)進(jìn)行測試時，測試數(shù)據(jù)較多，能夠反映多組不同特點的數(shù)據(jù)，測試具有普遍性。對于用戶的使用功能，分別建立多個視圖與之對應(yīng)，簡潔方便。缺點：系統(tǒng)的安全性日后還有待于加強不具備根據(jù)畢業(yè)生記錄分析并且決策的功能，還未全面實現(xiàn)自