超简单选课管理系统

录入时间：10/21/2022 07:06:35

Cinque Terre

下载该模板需支付 0 机遇币想要下载吗？先去登录

### 用户信息
用户类型|用户名|密码
-|-|-
老师|文曲星君|123
管理员|admin|admin
学生|张三|123

### 数据库

如果直接导入bak文件需要数据库版本为2012以上，如果低于该版本，可以运行以下语句生成数据库。

创建Demo数据库
在Demo库下执行表生成语句
```

-- ----------------------------
-- Table structure for Course
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Course]') AND type IN ('U'))
	DROP TABLE [dbo].[Course]
GO

CREATE TABLE [dbo].[Course] (
  [Id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Name] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Teacher] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Credit] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[Course] SET (LOCK_ESCALATION = TABLE)
GO

-- ----------------------------
-- Records of Course
-- ----------------------------
INSERT INTO [dbo].[Course] ([Id], [Name], [Teacher], [Credit]) VALUES (N'1', N'动物繁殖行为学', N'文曲星君', N'10')
GO

-- ----------------------------
-- Table structure for CourseRecord
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[CourseRecord]') AND type IN ('U'))
	DROP TABLE [dbo].[CourseRecord]
GO

CREATE TABLE [dbo].[CourseRecord] (
  [SID] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [cID] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[CourseRecord] SET (LOCK_ESCALATION = TABLE)
GO

-- ----------------------------
-- Records of CourseRecord
-- ----------------------------
INSERT INTO [dbo].[CourseRecord] ([SID], [cID]) VALUES (N'1', N'1')
GO

-- ----------------------------
-- Table structure for Student
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Student]') AND type IN ('U'))
	DROP TABLE [dbo].[Student]
GO

CREATE TABLE [dbo].[Student] (
  [Id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Name] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Password] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Class] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Birthday] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [JG] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[Student] SET (LOCK_ESCALATION = TABLE)
GO

-- ----------------------------
-- Records of Student
-- ----------------------------
INSERT INTO [dbo].[Student] ([Id], [Name], [Password], [Class], [Birthday], [JG]) VALUES (N'1', N'张三', N'123', N'1', N'2022-12-12', N'浙江杭州')
GO

INSERT INTO [dbo].[Student] ([Id], [Name], [Password], [Class], [Birthday], [JG]) VALUES (N'2', N'李四', N'1', N'1', N'2009-12-12', N'南京')
GO

INSERT INTO [dbo].[Student] ([Id], [Name], [Password], [Class], [Birthday], [JG]) VALUES (N'3', N'王五', N'123456', N'1', N'2009-11-11', N'上海')
GO

-- ----------------------------
-- Table structure for Teacher
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Teacher]') AND type IN ('U'))
	DROP TABLE [dbo].[Teacher]
GO

CREATE TABLE [dbo].[Teacher] (
  [Id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Name] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Password] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [ZC] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[Teacher] SET (LOCK_ESCALATION = TABLE)
GO

-- ----------------------------
-- Records of Teacher
-- ----------------------------
INSERT INTO [dbo].[Teacher] ([Id], [Name], [Password], [ZC]) VALUES (N'1', N'文曲星君', N'123', N'浙大叫兽')
GO

INSERT INTO [dbo].[Teacher] ([Id], [Name], [Password], [ZC]) VALUES (N'2', N'大哥大', N'123', N'北大叫兽')
GO

INSERT INTO [dbo].[Teacher] ([Id], [Name], [Password], [ZC]) VALUES (N'3', N'大飞', N'123', N'精华叫兽')
GO
```