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,'女');
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
VirgoMis.rar (96个子文件)
codefans.net
源程序代码
VirgoMis
VirgoMis.sln 914B
VirgoMis
StuInfoRegister.Designer.cs 12KB
BuildInfo.resx 6KB
RepairRecord.cs 1KB
FoulsFeedback.Designer.cs 15KB
DormRepair.resx 6KB
RepairRecord.resx 6KB
DormFouls.resx 6KB
About.Designer.cs 2KB
bin
Debug
VirgoMis.vshost.exe.manifest 490B
VirgoMis.pdb 170KB
VirgoMis.vshost.exe 14KB
BuildInfo.cs 13KB
About.resx 6KB
RepairFeedback.cs 5KB
About.cs 445B
Icos
About.ICO 1KB
Close.ICO 1KB
Configure.ico 1KB
Virgo.ico 137KB
Thumbs.db 26KB
App.ico 137KB
DormRegister.cs 9KB
RepairRecord.Designer.cs 4KB
Program.cs 487B
obj
Debug
VirgoMis.MRegister.resources 180B
VirgoMis.DormRegister.resources 180B
VirgoMis.csproj.FileListAbsolute.txt 2KB
VirgoMis.About.resources 180B
VirgoMis.MUpdate.resources 180B
VirgoMis.DormInfo.resources 180B
VirgoMis.Login.resources 170KB
VirgoMis.StuInfoSearch.resources 180B
VirgoMis.pdb 170KB
VirgoMis.WFMain.resources 142KB
VirgoMis.RepairFeedback.resources 180B
VirgoMis.DormFouls.resources 180B
VirgoMis.DormRepair.resources 180B
VirgoMis.RepairRecord.resources 180B
VirgoMis.Properties.Resources.resources 180B
TempPE
Properties.Resources.Designer.cs.dll 5KB
VirgoMis.BuildInfo.resources 180B
VirgoMis.StuInfoRegister.resources 180B
Refactor
VirgoMis.csproj.GenerateResource.Cache 2KB
VirgoMis.FoulsFeedback.resources 180B
VirgoMis.FoulsRecord.resources 180B
UserHelper.cs 283B
DormInfo.cs 17KB
MUpdate.cs 10KB
DormInfo.resx 6KB
RepairFeedback.Designer.cs 15KB
DormRegister.resx 6KB
StuInfoRegister.cs 5KB
FoulsRecord.cs 1KB
RepairFeedback.resx 6KB
Image
Loginbg.jpg 33KB
Thumbs.db 13KB
Login.resx 261KB
FoulsFeedback.resx 6KB
MRegister.cs 4KB
StuInfoRegister.resx 6KB
VirgoMis.csproj 9KB
DBHelper.cs 3KB
MUpdate.Designer.cs 15KB
DormFouls.Designer.cs 10KB
StuInfoSearch.Designer.cs 12KB
FoulsRecord.resx 6KB
MUpdate.resx 6KB
DormRepair.cs 6KB
WFMain.resx 218KB
MRegister.Designer.cs 8KB
DormFouls.cs 5KB
StuInfoSearch.cs 7KB
WFMain.Designer.cs 19KB
DormRepair.Designer.cs 10KB
Thumbs.db 7KB
Login.Designer.cs 5KB
MRegister.resx 6KB
DormRegister.Designer.cs 18KB
StuInfoSearch.resx 6KB
BuildInfo.Designer.cs 21KB
WFMain.cs 5KB
FoulsRecord.Designer.cs 4KB
FoulsFeedback.cs 5KB
Login.cs 4KB
Properties
Resources.resx 5KB
Settings.settings 249B
AssemblyInfo.cs 1KB
Settings.Designer.cs 1KB
Resources.Designer.cs 3KB
App.ico 137KB
DormInfo.Designer.cs 27KB
VirgoMIS.suo 48KB
可执行程序
VirgoMis.exe 552KB
高校学生宿舍信息管理系统[使用说明]
高校学生宿舍信息管理系统[使用说明].doc 23KB
Sql Statement.txt 4KB
共 96 条
- 1
资源评论
- ewfewfgef2015-09-06设计非常好,对我很有用,虽然少了点东西!
- TJXUNwu2013-01-20挺好的,实用价值高
- 一只疯狂的程序猿2012-12-15挺不错的,就是没有包含数据库的源文件
- gyk_net2012-12-24讲的挺细的 不错
夜中雨滴
- 粉丝: 224
- 资源: 130
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功