学生宿舍管理系统设计方案

ULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[Entry](?[EntryId][int]IDENTITY(1,1)NOTNULL,?[EntryStatus][int]NOTNULL,?[StuNo][int]NOTNULL,?[Time][nvarchar](50)NOTNULL,CONSTRAINT[PK_Entry]PRIMARYKEYCLUSTERED(?[EntryId]ASC)WITH(PAD_INDEX=OFF,PUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Table[dbo].[Dormitory]ScriptDate:06/19/201416:42:12******/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[Dormitory](?[DormitoryId][int]IDENTITY(1,1)NOTNULL,?[DormitoryName][nvarchar](50)NOTNULL,?[InputNum][int]NOTNULL,CONSTRAINT[PK_Dormitory]PRIMARYKEYCLUSTERED(?[DormitoryId]ASC)WITH(PAD_INDEX=OFF,PUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO创建之后的数据库4.功能模块设计用户账号4.1用户帐号模块登录系统退出系统用户帐号模块功能模块图