介绍:
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;