数据库课程设计jsp选题系统sqlserver.7z

USE [design] GO /****** Object: Table [dbo].[rolelinkmenu] Script Date: 04/25/2015 08:46:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[rolelinkmenu]( [linkid] [int] IDENTITY(1,1) NOT NULL, [roleid] [int] NULL, [menuid] [int] NULL, PRIMARY KEY CLUSTERED ( [linkid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[rolelinkmenu] ON INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (1, 1, 1) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (2, 1, 2) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (3, 1, 3) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (4, 1, 4) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (8, 2, 4) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (9, 3, 5) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (10, 3, 6) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (11, 2, 7) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (12, 1, 8) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (13, 2, 8) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (14, 3, 8) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (19, 4, 1) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (20, 4, 2) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (21, 4, 3) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (22, 4, 4) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (23, 4, 5) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (24, 4, 6) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (25, 4, 7) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (26, 4, 8) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (27, 4, 9) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (28, 2, 11) INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (29, 5, 4) SET IDENTITY_INSERT [dbo].[rolelinkmenu] OFF /****** Object: Table [dbo].[role] Script Date: 04/25/2015 08:46:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[role]( [roleid] [int] IDENTITY(1,1) NOT NULL, [rolename] [nvarchar](255) NULL, [roledesc] [nvarchar](255) NULL, PRIMARY KEY CLUSTERED ( [roleid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[role] ON INSERT [dbo].[role] ([roleid], [rolename], [roledesc]) VALUES (1, N'超级管理员', N'这是超级管理员，类似与年纪主任级别 现有的角色不能删除') INSERT [dbo].[role] ([roleid], [rolename], [roledesc]) VALUES (2, N'教师', N'负责出题') INSERT [dbo].[role] ([roleid], [rolename], [roledesc]) VALUES (3, N'学生', N'学生就是用来做毕业设计的') INSERT [dbo].[role] ([roleid], [rolename], [roledesc]) VALUES (5, N'超级出题员', N'专门负责出题') SET IDENTITY_INSERT [dbo].[role] OFF /****** Object: Table [dbo].[progress] Script Date: 04/25/2015 08:46:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[progress]( [proid] [int] IDENTITY(1,1) NOT NULL, [title] [nvarchar](255) NULL, [mycontent] [nvarchar](4000) NULL, [prodate] [date] NULL, PRIMARY KEY CLUSTERED ( [proid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[progress] ON INSERT [dbo].[progress] ([proid], [title], [mycontent], [prodate]) VALUES (1, N'2013年进度安排', N'<p class="MsoNormal" style="margin-left:0cm;text-align:left;text-indent:21.0pt;vertical-align:baseline;" align="left"> <span style="font-family:宋体;"><sp�