081基于JSP校园宿舍管理系统
技术：jsp+servlet+mysql+java+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;
/*Data for the table t_record */
insert into t_record(recordId,studentNumber,studentName,dormBuildId,dormName,date,detail) values (1,‘002’,‘李四’,4,‘120’,‘2014-01-01’,‘123’),(3,‘007’,‘测试1’,1,‘221’,‘2014-08-11’,‘123’),(4,‘005’,‘赵起’,4,‘220’,‘2014-08-12’,’…’),(5,‘006’,‘王珂珂’,4,‘111’,‘2014-08-12’,‘00’),(6,‘004’,‘李进’,6,‘220’,‘2014-08-12’,’…’),(7,‘004’,‘李进’,6,‘220’,‘2014-08-12’,‘22’);
/*Table structure for table t_student */
DROP TABLE IF EXISTS t_student;
CREATE TABLE t_student (studentId int(11) NOT NULL AUTO_INCREMENT,stuNum varchar(20) DEFAULT NULL,password varchar(20) DEFAULT NULL,name varchar(20) DEFAULT NULL,dormBuildId int(11) DEFAULT NULL,dormName varchar(11) DEFAULT NULL,sex varchar(10) DEFAULT NULL,tel varchar(15) DEFAULT NULL,
PRIMARY KEY (studentId)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;