IDEA+Java+Servlet+JSP+Bootstrap+Mysql实现Web学生宿舍管理系统

DROP TABLE IF EXISTS t_dormbuild;

CREATE TABLE t_dormbuild (

dormBuildId int(11) NOT NULL AUTO_INCREMENT,

dormBuildName varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

dormBuildDetail varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

PRIMARY KEY (dormBuildId) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

---

– Records of t_dormbuild

---

INSERT INTO t_dormbuild VALUES (1, ‘1栋’, ‘一栋信息介绍’);

INSERT INTO t_dormbuild VALUES (2, ‘2栋’, ‘二栋信息介绍’);

INSERT INTO t_dormbuild VALUES (3, ‘3栋’, ‘三栋信息介绍’);

INSERT INTO t_dormbuild VALUES (4, ‘4栋’, ‘四栋信息介绍’);

INSERT INTO t_dormbuild VALUES (5, ‘5栋’, ‘五栋信息介绍’);

---

– Table structure for t_dormmanager

---

DROP TABLE IF EXISTS t_dormmanager;

CREATE TABLE t_dormmanager (

dormManId int(11) NOT NULL AUTO_INCREMENT,

userName varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

password varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

dormBuildId int(11) NULL DEFAULT NULL,

name varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

sex varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

tel varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

PRIMARY KEY (dormManId) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

---

– Records of t_dormmanager

---

INSERT INTO t_dormmanager VALUES (1, ‘dromadmin’, ‘123456’, 4, ‘宿舍管理员’, ‘男’, ‘18212346589’);

---

– Table structure for t_record

---

DROP TABLE IF EXISTS t_record;

CREATE TABLE t_record (

recordId int(11) NOT NULL AUTO_INCREMENT,

studentNumber varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

studentName varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

dormBuildId int(11) NULL DEFAULT NULL,

dormName varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

date date NULL DEFAULT NULL,

detail varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

PRIMARY KEY (recordId) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

---

– Records of t_record

---

INSERT INTO t_record VALUES (1, ‘001’, ‘李四’, 4, ‘120’, ‘2014-01-01’, ‘回家’);

---

– Table structure for t_student

---

DROP TABLE IF EXISTS t_student;

CREATE TABLE t_student (

studentId int(11) NOT NULL AUTO_INCREMENT,

stuNum varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

password varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

name varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

dormBuildId int(11) NULL DEFAULT NULL,

dormName varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

sex varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

tel varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

PRIMARY KEY (studentId) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

---

– Records of t_student

---

INSERT INTO t_student VALUES (1, ‘001’, ‘123456’, ‘李四’, 4, ‘120’, ‘男’, ‘123456’);

INSERT INTO t_student VALUES (2, ‘002’, ‘123456’, ‘王五’, 5, ‘201’, ‘男’, ‘123456’);

SET FOREIGN_KEY_CHECKS = 1;

5.工程截图

---

二、系统展示

======

1.登录界面

---

2.学生-主页面

---

3.学生-缺勤记录

---

4.学生-修改密码

---

5.宿舍管理员-主页面

---

6.宿舍管理员-学生查看

---

7.宿舍管理员-缺勤记录

---

8.宿舍管理员-修改密码

---

9.系统管理员-主页面

---

10.系统管理员-宿舍管理员管理

---

11.系统管理员-学生管理

---

12.系统管理员-宿舍楼管理

---

13.系统管理员-缺勤记录

---

14.系统管理员-修改密码

---

三、部分代码

======

DormBuildDao

---

package com.lero.dao;

import com.lero.model.DormBuild;

import com.lero.model.DormManager;

import com.lero.model.PageBean;

import com.lero.util.StringUtil;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.ArrayList;

import java.util.List;

public class DormBuildDao {

public static String dormBuildName(Connection con, int dormBuildId) throws Exception {

String sql = “select * from t_dormBuild where dormBuildId=?”;

PreparedStatement pstmt = con.prepareStatement(sql);

pstmt.setInt(1, dormBuildId);

ResultSet rs = pstmt.executeQuery();

if (rs.next()) {

return rs.getString(“dormBuildName”);

}

return null;

}

public List dormBuildList(Connection con, PageBean pageBean, DormBuild s_dormBuild) throws Exception {

List dormBuildList = new ArrayList();

StringBuffer sb = new StringBuffer(“select * from t_dormBuild t1”);

if (StringUtil.isNotEmpty(s_dormBuild.getDormBuildName())) {

sb.append(" where t1.dormBuildName like ‘%" + s_dormBuild.getDormBuildName() + "%’");

}

if (pageBean != null) {

sb.append(" limit " + pageBean.getStart() + “,” + pageBean.getPageSize());

}

PreparedStatement pstmt = con.prepareStatement(sb.toString());

ResultSet rs = pstmt.executeQuery();

while (rs.next()) {

DormBuild dormBuild = new DormBuild();

dormBuild.setDormBuildId(rs.getInt(“dormBuildId”));

dormBuild.setDormBuildName(rs.getString(“dormBuildName”));

dormBuild.setDetail(rs.getString(“dormBuildDetail”));

dormBuildList.add(dormBuild);

}

return dormBuildList;

}

public int dormBuildCount(Connection con, DormBuild s_dormBuild) throws Exception {

StringBuffer sb = new StringBuffer(“select count(*) as total from t_dormBuild t1”);

if (StringUtil.isNotEmpty(s_dormBuild.getDormBuildName())) {

sb.append(" where t1.dormBuildName like ‘%" + s_dormBuild.getDormBuildName() + "%’");

}

PreparedStatement pstmt = con.prepareStatement(sb.toString());

ResultSet rs = pstmt.executeQuery();

if (rs.next()) {

return rs.getInt(“total”);

} else {

return 0;

}

}

public DormBuild dormBuildShow(Connection con, String dormBuildId) throws Exception {

String sql = “select * from t_dormBuild t1 where t1.dormBuildId=?”;

PreparedStatement pstmt = con.prepareStatement(sql);

pstmt.setString(1, dormBuildId);

ResultSet rs = pstmt.executeQuery();

DormBuild dormBuild = new DormBuild();

if (rs.next()) {

dormBuild.setDormBuildId(rs.getInt(“dormBuildId”));

dormBuild.setDormBuildName(rs.getString(“dormBuildName”));

dormBuild.setDetail(rs.getString(“dormBuildDetail”));

}

return dormBuild;

}

public int dormBuildAdd(Connection con, DormBuild dormBuild) throws Exception {

String sql = “insert into t_dormBuild values(null,?,?)”;

PreparedStatement pstmt = con.prepareStatement(sql);

pstmt.setString(1, dormBuild.getDormBuildName());

pstmt.setString(2, dormBuild.getDetail());

return pstmt.executeUpdate();

}

public int dormBuildDelete(Connection con, String dormBuildId) throws Exception {

String sql = “delete from t_dormBuild where dormBuildId=?”;

PreparedStatement pstmt = con.prepareStatement(sql);

pstmt.setString(1, dormBuildId);

return pstmt.executeUpdate();

}

public int dormBuildUpdate(Connection con, DormBuild dormBuild) throws Exception {

String sql = “update t_dormBuild set dormBuildName=?,dormBuildDetail=? where dormBuildId=?”;

PreparedStatement pstmt = con.prepareStatement(sql);

pstmt.setString(1, dormBuild.getDormBuildName());

pstmt.setString(2, dormBuild.getDetail());

pstmt.setInt(3, dormBuild.getDormBuildId());

return pstmt.executeUpdate();

}

public boolean existManOrDormWithId(Connection con, String dormBuildId) throws Exception {

bool