基于android的学生宿舍管理系统毕业论文(编辑修改稿)

基于android的学生宿舍管理系统毕业论文(编辑修改稿)内容摘要：

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[notice]( [id] [int] IDENTITY(1,1) NOT NULL, [remark] [text] NULL, [time] [date] NULL, [u_id] [varchar](20) NULL, CONSTRAINT [PK_notice] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[lose] 失物招领表 Script Date: 04/13/2020 19:59:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[lose]( [id] [int] IDENTITY(1,1) NOT NULL, [remark] [text] NULL, [rg_u_id] [varchar](20) NOT NULL, [ls_u_id] [varchar](20) NOT NULL, CONSTRAINT [PK_lose] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[leaves] 留校申请表 Script Date: 04/13/2020 19:59:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[leaves]( [id] [int] IDENTITY(1,1) NOT NULL, [u_id] [varchar](20) NOT NULL, [remark] [text] NULL, CONSTRAINT [PK_leaves] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[evenrg] 晚归表 Script Date: 04/13/2020 19:59:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[evenrg]( [id] [int] IDENTITY(1,1) NOT NULL, [u_id] [varchar](20) NOT NULL, [time] [date] NULL, [remark] [text] NULL, CONSTRAINT [PK_evenrg] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Default [DF_sendwater_time] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[sendwater] ADD CONSTRAINT [DF_sendwater_time] DEFAULT (getdate()) FOR [time] GO /****** Object: ForeignKey [FK_room_dorm] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[room] WITH CHECK ADD CONSTRAINT [FK_room_dorm] FOREIGN KEY([d_id]) REFERENCES [dbo].[dorm] ([id]) GO ALTER TABLE [dbo].[room] CHECK CONSTRAINT [FK_room_dorm] GO /****** Object: ForeignKey [FK_sys_user_role] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[sys_user] WITH CHECK ADD CONSTRAINT [FK_sys_user_role] FOREIGN KEY([role]) REFERENCES [dbo].[role] ([id]) GO ALTER TABLE [dbo].[sys_user] CHECK CONSTRAINT [FK_sys_user_role] GO /****** Object: ForeignKey [FK_sys_user_room] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[sys_user] WITH CHECK ADD CONSTRAINT [FK_sys_user_room] FOREIGN KEY([room_id]) REFERENCES [dbo].[room] ([id]) GO ALTER TABLE [dbo].[sys_user] CHECK CONSTRAINT [FK_sys_user_room] GO /****** Object: ForeignKey [FK_sys_user_sys_user] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[sys_user] WITH CHECK ADD CONSTRAINT [FK_sys_user_sys_user] FOREIGN KEY([id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[sys_user] CHECK CONSTRAINT [FK_sys_user_sys_user] GO /****** Object: ForeignKey [FK_sendwater_sendwater] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[sendwater] WITH NOCHECK ADD CONSTRAINT [FK_sendwater_sendwater] FOREIGN KEY([u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[sendwater] CHECK CONSTRAINT [FK_sendwater_sendwater] GO /****** Object: ForeignKey [FK_repair_sys_user] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[repair] WITH CHECK ADD CONSTRAINT [FK_repair_sys_user] FOREIGN KEY([u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[repair] CHECK CONSTRAINT [FK_repair_sys_user] GO /****** Object: ForeignKey [FK_notice_sys_user] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[notice] WITH CHECK ADD CONSTRAINT [FK_notice_sys_user] FOREIGN KEY([u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[notice] CHECK CONSTRAINT [FK_notice_sys_user] GO /****** Object: ForeignKey [FK_lose_sys_user] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[lose] WITH CHECK ADD CONSTRAINT [FK_lose_sys_user] FOREIGN KEY([ls_u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[lose] CHECK CONSTRAINT [FK_lose_sys_user] GO /****** Object: ForeignKey [FK_lose_sys_user1] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[lose] WITH CHECK ADD CONSTRAINT [FK_lose_sys_user1] FOREIGN KEY([rg_u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[lose] CHECK CONSTRAINT [FK_lose_sys_user1] GO /****** Object: ForeignKey [FK_leaves_leaves] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[leaves] WITH CHECK ADD CONSTRAINT [FK_leaves_leaves] FOREIGN KEY([u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[leaves] CHECK CONSTRAINT [FK_leaves_leaves] GO /****** Object: ForeignKey [FK_evenrg_evenrg] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[evenrg] WITH CHECK ADD CONSTRAINT [FK_evenrg_evenrg] FOREIGN KEY([u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[evenrg] CHECK CONSTRAINT [FK_evenrg_evenrg] GO 服务器端详细设计 用服务 端采用 三层架构 UI、 BLL、 ：表现层（ Presentation layer）、业务逻辑层（ Business Logic Layer）、数据访问层（ Data access layer）。 区分层次的目的即为了。