介绍:
JavaWeb校园宿舍管理系统(JSP),mysql数据库,eclipse开发工具
项目截图:
数据库表:
CREATE TABLE t_admin
(
adminId
int(11) NOT NULL AUTO_INCREMENT,
userName
varchar(20) DEFAULT NULL,
password
varchar(20) DEFAULT NULL,
name
varchar(20) DEFAULT NULL,
sex
varchar(10) DEFAULT NULL,
tel
varchar(20) DEFAULT NULL,
PRIMARY KEY (adminId
)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*Data for the table t_admin
*/
insert into t_admin
(adminId
,userName
,password
,name
,sex
,tel
) values (1,‘admin’,‘111’,‘Lero’,‘男’,‘123’);
/*Table structure for table t_dorm
*/
DROP TABLE IF EXISTS t_dorm
;
CREATE TABLE t_dorm
(
dormId
int(11) NOT NULL AUTO_INCREMENT,
dormBuildId
int(11) DEFAULT NULL,
dormName
varchar(20) DEFAULT NULL,
dormType
varchar(20) DEFAULT NULL,
dormNumber
int(11) DEFAULT NULL,
dormTel
varchar(20) DEFAULT NULL,
PRIMARY KEY (dormId
)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*Data for the table t_dorm
*/
insert into t_dorm
(dormId
,dormBuildId
,dormName
,dormType
,dormNumber
,dormTel
) values (1,1,‘220’,‘男’,6,‘110’);
/*Table structure for table t_dormbuild
*/
DROP TABLE IF EXISTS t_dormbuild
;
CREATE TABLE t_dormbuild
(
dormBuildId
int(11) NOT NULL AUTO_INCREMENT,
dormBuildName
varchar(20) DEFAULT NULL,
dormBuildDetail
varchar(50) DEFAULT NULL,
PRIMARY KEY (dormBuildId
)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*Data for the table t_dormbuild
*/
insert into t_dormbuild
(dormBuildId
,dormBuildName
,dormBuildDetail
) values (1,‘1栋’,‘这是一栋。。。’),(4,‘2栋’,‘这是2栋’),(5,‘3栋’,’’),(6,‘4栋’,’’),(7,‘5栋’,’’),(8,‘6栋’,’’);
/*Table structure for table t_dormmanager
*/
DROP TABLE IF EXISTS t_dormmanager
;
CREATE TABLE t_dormmanager
(
dormManId
int(11) NOT NULL AUTO_INCREMENT,
userName
varchar(20) DEFAULT NULL,
password
varchar(20) DEFAULT NULL,
dormBuildId
int(11) DEFAULT NULL,
name
varchar(20) DEFAULT NULL,
sex
varchar(20) DEFAULT NULL,
tel
varchar(20) DEFAULT NULL,
PRIMARY KEY (dormManId
)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*Data for the table t_dormmanager
*/
insert into t_dormmanager
(dormManId
,userName
,password
,dormBuildId
,name
,sex
,tel
) values (2,‘manager2’,‘123’,4,‘小张’,‘男’,‘123’),(3,‘manager3’,‘123’,1,‘小李’,‘女’,‘123’),(4,‘manager4’,‘123’,5,‘小陈’,‘男’,‘123’),(5,‘manager5’,‘123’,NULL,‘小宋’,‘男’,‘123’),(7,‘manager6’,‘123’,NULL,'呵呵 ',‘女’,‘123’),(8,‘manager1’,‘123’,6,‘小白’,‘男’,‘123’),(9,‘manager7’,‘123’,7,‘哈哈’,‘女’,‘123’);
/*Table structure for table t_record
*/
DROP TABLE IF EXISTS t_record
;
CREATE TABLE t_record
(
recordId
int(11) NOT NULL AUTO_INCREMENT,
studentNumber
varchar(20) DEFAULT NULL,
studentName
varchar(30) DEFAULT NULL,
dormBuildId
int(11) DEFAULT NULL,
dormName
varchar(11) DEFAULT NULL,
date
date DEFAULT NULL,
detail
varchar(50) DEFAULT NULL,
PRIMARY KEY (recordId
)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;