学生宿舍管理信息系统设计源程序代码 SQL server 2000

CREATE DataBase Virgo; USE Virgo; CREATE TABLE DB_StuInfo ( stuNo char(13) primary key not null, stuName varchar(10) not null, stuSex char(2) not null, stuTime DateTime not null, stuDepart varchar(18) not null, stuPro varchar(18) not null, stuElse text ); Create Table DB_DormInfo ( dormId int identity(1,1) primary key, buildArea varchar(10) not null, buildNo int not null, dormNo int not null, bedNum int not null, dormElse text ); CREATE TABLE DB_ManageInfo ( loginId int identity(1,1) primary key, loginNo varchar(10) not null, loginPwd varchar(13) not null, loginType varchar(10) not null ); CREATE TABLE DB_DormRegister ( stuNo char(9) primary key not null, buildArea varchar(10) not null, buildNo int not null, dormNo int not null ); CREATE TABLE DB_DormRepair ( repairId int identity(1,1) primary key, buildArea varchar(10) not null, buildNo int not null, dormNo int not null, RepairTime datetime not null, dormJob text not null, repairResult text ); CREATE TABLE DB_BuildInfo ( buildId int identity(1,1) primary key, buildArea varchar(10) not null, buildNo int not null, buildMsg char(4) not null ); CREATE TABLE DB_SubInfo ( subNo int identity(1,1) primary key, subDepart varchar(18) not null, subPro varchar(18) not null, subCode char(8) not null ); CREATE Table DB_DormDes ( msgId int identity(1,1) primary key, buildArea varchar(10) not null, buildNo int not null, dormNo int not null, foulsTime datetime not null, dormMsg text not null, dormResult text ); /*管理员信息*/ insert into DB_ManageInfo(loginNo,loginPwd,loginType) values ('admin','admin','总务处'); insert into DB_ManageInfo(loginNo,loginPwd,loginType) values ('admin','admin','维修部'); insert into DB_ManageInfo(loginNo,loginPwd,loginType) values ('admin','admin','楼管会'); /*高校开设专业(略)*/ insert into DB_SubInfo(subDepart,subPro,subCode) values ('计算机科学与技术系','计算机科学与技术','0201'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('计算机科学与技术系','计算机基础','0202'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('计算机科学与技术系','数学','0203'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('工商管理系','工商管理','0301'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('工商管理系','会计学','0302'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('工商管理系','工程管理','0303'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('商学系','市场营销','0401'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('商学系','电子商务','0402'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('经济学系','金融学','0501'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('经济学系','国际经济与贸易','0502'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('法律系','法学','0601'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('商学系','市场营销','0401'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('外语系','英语','0701'); insert into DB_SubInfo(subDepart,subPro,subCode) values ('人文社科系','行政管理','0801'); /*高校宿舍资源(略)*/ insert into DB_BuildInfo(buildArea,buildNo,buildMsg) values ('东区',1,'女'); insert into DB_BuildInfo(buildArea,buildNo,buildMsg) values ('东区',2,'女'); insert into DB_BuildInfo(buildArea,buildNo,buildMsg) values ('东区',3,'男'); insert into DB_BuildInfo(buildArea,buildNo,buildMsg) values ('西区',9,'女'); insert into DB_BuildInfo(buildArea,buildNo,buildMsg) values ('西区',10,'男'); insert into DB_BuildInfo(buildArea,buildNo,buildMsg) values ('西区',11,'女');