SQL毕业生信息管理系统

③学校用户测试--学校登录createprocSchLogin@SchIdchar(10)asbeginifexists(select*fromdbo.SchooluserswherecSchoolId=@SchId) begin selectcSchoolId学校编号,cSchoolCode学校密码fromdbo.Schoolusers wherecSchoolId=@SchId return0 endelse print'NOtheidofcertionstudent' return1endgoexecSchLogin'00001'--修改学校注册信息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--删除学生信息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'系统优缺点分析优点：在建立毕业生信息管理系统时，需求分析明确完善，完成了系统规定的要求。在该系统中建立的表格，在实体完整性，参照完整性以及用户自定义完整性中都较全面，保证了数据的正确性和完整性。在对该系统进行测试时，测试数据较多，能够反映多组不同特点的数据，测试具有普遍性。对于用户的使用功能，分别建立多个视图与之对应，简洁方便。缺点：系统的安全性日后还有待于加强不具备根据毕业生记录分析并且决策的功能，还未全面实现自