大学C#考试管理系统教员完整项目包含数据库

if exists (select * from sysobjects where id = OBJECT_ID('[Admin]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Admin] CREATE TABLE [Admin] ( [AdminId] [int] IDENTITY (1, 1) NOT NULL, [LoginId] [varchar] (50) NOT NULL, [LoginPwd] [varchar] (50) NOT NULL) ALTER TABLE [Admin] WITH NOCHECK ADD CONSTRAINT [PK_Admin] PRIMARY KEY NONCLUSTERED ( [AdminId] ) SET IDENTITY_INSERT [Admin] ON INSERT [Admin] ([AdminId],[LoginId],[LoginPwd]) VALUES ( 1,'admin','00000') SET IDENTITY_INSERT [Admin] OFF if exists (select * from sysobjects where id = OBJECT_ID('[Class]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Class] CREATE TABLE [Class] ( [ClassId] [int] IDENTITY (1, 1) NOT NULL, [ClassName] [varchar] (50) NOT NULL, [GradeId] [int] NULL) ALTER TABLE [Class] WITH NOCHECK ADD CONSTRAINT [PK_Class] PRIMARY KEY NONCLUSTERED ( [ClassId] ) SET IDENTITY_INSERT [Class] ON INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 1,'S1101',1) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 2,'S1102',1) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 3,'S1103',1) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 4,'S1104',1) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 5,'S1105',1) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 6,'S1106',1) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 7,'S1107',1) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 9,'S1108',1) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 10,'S1109',1) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 11,'S1110',1) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 12,'S2101',2) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 13,'S2102',2) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 14,'S2103',2) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 15,'S2104',2) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 16,'S2105',2) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 17,'S2106',2) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 18,'S2107',2) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 19,'S2108',2) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 20,'S2109',2) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 21,'S2110',2) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 22,'Y2101',3) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 23,'Y2102',3) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 24,'Y2103',3) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 25,'Y2104',3) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 26,'Y2105',3) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 27,'Y2106',3) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 28,'Y2107',3) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 29,'Y2108',3) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 30,'Y2109',3) INSERT [Class] ([ClassId],[ClassName],[GradeId]) VALUES ( 31,'Y2110',3) SET IDENTITY_INSERT [Class] OFF if exists (select * from sysobjects where id = OBJECT_ID('[Grade]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Grade] CREATE TABLE [Grade] ( [GradeId] [int] IDENTITY (1, 1) NOT NULL, [GradeName] [varchar] (50) NOT NULL) ALTER TABLE [Grade] WITH NOCHECK ADD CONSTRAINT [PK_Grade] PRIMARY KEY NONCLUSTERED ( [GradeId] ) SET IDENTITY_INSERT [Grade] ON INSERT [Grade] ([GradeId],[GradeName]) VALUES ( 1,'S1') INSERT [Grade] ([GradeId],[GradeName]) VALUES ( 2,'S2') INSERT [Grade] ([GradeId],[GradeName]) VALUES ( 3,'Y2') SET IDENTITY_INSERT [Grade] OFF if exists (select * from sysobjects where id = OBJECT_ID('[Question]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Question] CREATE TABLE [Question] ( [QuestionId] [int] IDENTITY (1, 1) NOT NULL, [Question] [varchar] (500) NOT NULL, [Answer] [varchar] (50) NOT NULL, [Difficulty] [int] NOT NULL, [SubjectId] [int] NOT NULL, [OptionA] [varchar] (500) NOT NULL DEFAULT ((0)), [OptionB] [varchar] (500) NOT NULL DEFAULT ((0)), [OptionC] [varchar] (500) NOT NULL DEFAULT ((0)), [OptionD] [varchar] (500) NOT NULL DEFAULT ((0))) ALTER TABLE [Question] WITH NOCHECK ADD CONSTRAINT [PK_Question] PRIMARY KEY NONCLUSTERED ( [QuestionId] ) SET IDENTITY_INSERT [Question] ON SET IDENTITY_INSERT [Question] OFF if exists (select * from sysobjects where id = OBJECT_ID('[Student]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Student] CREATE TABLE [Student] ( [StudentId] [int] IDENTITY (1, 1) NOT NULL, [LoginId] [varchar] (50) NOT NULL, [LoginPwd] [varchar] (50) NOT NULL, [UserStateId] [int] NOT NULL DEFAULT ((1)), [ClassId] [int] NOT NULL, [StudentNO] [nvarchar] (255) NOT NULL, [StudentName] [nvarchar] (255) NOT NULL, [Sex] [nvarchar] (255) NOT NULL, [StudentIDNO] [nvarchar] (255) NULL, [Major] [nvarchar] (255) NULL, [SchoolBefore] [nvarchar] (255) NULL, [Phone] [nvarchar] (255) NULL, [Address] [nvarchar] (255) NULL, [PostalCode] [float] NULL, [CityWanted] [nvarchar] (255) NULL, [JobWanted] [nvarchar] (255) NULL, [Comment] [nvarchar] (255) NULL, [Email] [varchar] (50) NULL) ALTER TABLE [Student] WITH NOCHECK ADD CONSTRAINT [PK_Student] PRIMARY KEY NONCLUSTERED ( [StudentId] ) SET IDENTITY_INSERT [Student] ON INSERT [Student] ([StudentId],[LoginId],[LoginPwd],[UserStateId],[ClassId],[StudentNO],[StudentName],[Sex],[StudentIDNO],[Major],[SchoolBefore],[Phone],[Address],[CityWanted],[JobWanted]) VALUES ( 86,'LiJinxiang','12345',1,4,'12160329004888','李金香','女','140224810205242','计算机及其应用','无','13835231533/13503542995','北京海淀区北宫门','北京','软件工程师') INSERT [Student] ([StudentId],[LoginId],[LoginPwd],[UserStateId],[ClassId],[StudentNO],[StudentName],[Sex],[StudentIDNO],[Major],[SchoolBefore],[Phone],[Address],[PostalCode],[CityWanted],[JobWanted]) VALUES ( 88,'SunPeng','12345',1,6,'12160329006','孙鹏','男','210114198204160014','民族传统体育','无','13523656893','北京市体育大学',100083,'北京','软件工程师') INSERT [Student] ([StudentId],[LoginId],[LoginPwd],[UserStateId],[ClassId],[StudentNO],[StudentName],[Sex],[StudentIDNO],[Major],[SchoolBefore],[Phone],[Address],[PostalCode],[CityWanted],[JobWanted]) VALUES ( 89,'ZhangLiang','12345',1,7,'12160329007','张亮','男','110105198107311116','经济管理','无','13146688918/13366001666','北京市朝阳区安慧东里20号楼406室',100101,'北京','软件工程师') INSERT [Student] ([StudentId],[LoginId],[LoginPwd],[UserStateId],[ClassId],[StudentNO],[StudentName],[Sex],[StudentIDNO],[Major],[SchoolBefore],[Address],[PostalCode],[CityWanted],[JobWanted]) VALUES ( 90,'ZhangLihua','12452',1,9,'12160329008','张利华','女','142327198105011626','信息管理与信息系统','无','银川市石油城6区',750000,'北京','软件工程师') INSERT [Student] ([StudentId],[LoginId],[LoginPwd],[UserStateId],[ClassId],[StudentNO],[StudentName],[Sex],[StudentIDNO],[Major],[SchoolBefore],[Address],[PostalCode],[CityWanted],[JobWanted]) VALUES ( 91,'LiDifei','1111',1,10,'12160329009','李頔飞','男','110105830314753','化工','无','北京市昌平区王府公寓',100029,'北京','软件工程师') INSERT [Student] ([StudentId],[LoginId],[LoginPwd],[UserStateId],[ClassId],[StudentNO],[StudentName],[Sex],[StudentIDNO],[Major],[SchoolBefore],[Address],[PostalCode],[CityWanted],[JobWanted]) VALUES ( 92,'HouXiaonan','10222',1,11,'12160329010','侯潇楠','男','110107198108162119','经济管理','无','北京市石景山区广宁新立楼6号楼122号',100041,'北京','软件工程师') INSERT [Student] ([StudentId],[LoginId],[LoginPwd],[UserStateId],[ClassId],[StudentNO],[StudentName],[Sex],[StudentIDNO],[Major],[SchoolBefore],[Address],[PostalCode],[CityWanted],[JobWanted]) VALUES ( 93,'YangChao','12345',1,1,'12160329011','杨超','男','110108198401272719','计算机系统控制','无','北京市西二旗铭科苑3-11-502',100085,'北京','软件工程师') INSERT [Student] ([Stud