技术: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;