devbox
盐析白兔
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

IDEA+Java+Servlet+JSP+Bootstrap+Mysql实现Web学生宿舍管理系统_基于java web 学生宿舍管理信息系统代码idea

作者：盐析白兔 | 2024-05-27 11:20:41

赞

踩

基于java web 学生宿舍管理信息系统代码idea

目录

一、系统介绍

1.开发环境

2.技术选型

3.系统功能

4.数据库

5.工程截图

二、系统展示

1.登录界面

2.学生-主页面

3.学生-缺勤记录

4.学生-修改密码

5.宿舍管理员-主页面

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

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

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

9.系统管理员-主页面

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

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

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

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

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

三、部分代码

DormBuildDao

DormManagerDao

RecordDao

StudentDao

UserDao

PropertiesUtil

login.jsp

mainAdmin.jsp

mainManager.jsp

mainStudent.jsp

四、其他

1.其他系统实现

1.JavaWeb系统系列实现

2.JavaSwing系统系列实现

2.获取源码

3.运行项目

4.备注

5.支持博主

一、系统介绍


1.开发环境

开发工具：IDEA2018.2

JDK版本：jdk1.8

Mysql版本：8.0.13


2.技术选型

1.后端：使用Java+Servlet进行开发，使用过滤器来验证用户是否登录，使用MVC进行分层。

2.数据库：使用JDBC连接数据库，使用getResourceAsStream获取数据库配置文件的信息。

3.前端：使用Bootstrap作为前端框架来开发，使用到jstl来遍历数据。jsp来展示页面。

3.系统功能

1.学生

1.登录系统

2.缺勤记录

缺勤记录查询

3.修改密码

4.退出系统

2.宿舍管理员

1.登录系统

2.学生查看

查看学生信息

3.缺勤记录管理

缺勤记录的增删改查。

4.修改密码

5.退出系统

3.系统管理员

1.登录系统

2.宿舍管理员管理

宿舍管理员信息的增删改查。

3.学生信息管理

学生信息的增删改查。

4.宿舍楼信息管理

宿舍楼信息的增删改查。

5.缺勤记录管理

缺勤记录删除

6.修改密码

7.退出系统

4.数据库

  1. /*
  2.  Navicat Premium Data Transfer
  4.  Source Server         : Mysql
  5.  Source Server Type    : MySQL
  6.  Source Server Version : 80013
  7.  Source Host           : localhost:3306
  8.  Source Schema         : jsp_servlet_drom
  10.  Target Server Type    : MySQL
  11.  Target Server Version : 80013
  12.  File Encoding         : 65001
  14.  Date: 22/07/2021 20:46:38
  15. */
  16.  
  17. SET NAMES utf8mb4;
  18. SET FOREIGN_KEY_CHECKS = 0;
  19.  
  20. -- ----------------------------
  21. -- Table structure for t_admin
  22. -- ----------------------------
  23. DROP TABLE IF EXISTS `t_admin`;
  24. CREATE TABLE `t_admin`  (
  25.   `adminId` int(11) NOT NULL AUTO_INCREMENT,
  26.   `userName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  27.   `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  28.   `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  29.   `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  30.   `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  31.   PRIMARY KEY (`adminId`) USING BTREE
  32. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  33.  
  34. -- ----------------------------
  35. -- Records of t_admin
  36. -- ----------------------------
  37. INSERT INTO `t_admin` VALUES (1, 'admin', 'admin', '管理员', '男', '1828888888');
  38.  
  39. -- ----------------------------
  40. -- Table structure for t_dorm
  41. -- ----------------------------
  42. DROP TABLE IF EXISTS `t_dorm`;
  43. CREATE TABLE `t_dorm`  (
  44.   `dormId` int(11) NOT NULL AUTO_INCREMENT,
  45.   `dormBuildId` int(11) NULL DEFAULT NULL,
  46.   `dormName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  47.   `dormType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  48.   `dormNumber` int(11) NULL DEFAULT NULL,
  49.   `dormTel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  50.   PRIMARY KEY (`dormId`) USING BTREE
  51. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  52.  
  53. -- ----------------------------
  54. -- Records of t_dorm
  55. -- ----------------------------
  56. INSERT INTO `t_dorm` VALUES (1, 1, '220', '男', 4, '110');
  57.  
  58. -- ----------------------------
  59. -- Table structure for t_dormbuild
  60. -- ----------------------------
  61. DROP TABLE IF EXISTS `t_dormbuild`;
  62. CREATE TABLE `t_dormbuild`  (
  63.   `dormBuildId` int(11) NOT NULL AUTO_INCREMENT,
  64.   `dormBuildName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  65.   `dormBuildDetail` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  66.   PRIMARY KEY (`dormBuildId`) USING BTREE
  67. ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  68.  
  69. -- ----------------------------
  70. -- Records of t_dormbuild
  71. -- ----------------------------
  72. INSERT INTO `t_dormbuild` VALUES (1, '1栋', '一栋信息介绍');
  73. INSERT INTO `t_dormbuild` VALUES (2, '2栋', '二栋信息介绍');
  74. INSERT INTO `t_dormbuild` VALUES (3, '3栋', '三栋信息介绍');
  75. INSERT INTO `t_dormbuild` VALUES (4, '4栋', '四栋信息介绍');
  76. INSERT INTO `t_dormbuild` VALUES (5, '5栋', '五栋信息介绍');
  77.  
  78. -- ----------------------------
  79. -- Table structure for t_dormmanager
  80. -- ----------------------------
  81. DROP TABLE IF EXISTS `t_dormmanager`;
  82. CREATE TABLE `t_dormmanager`  (
  83.   `dormManId` int(11) NOT NULL AUTO_INCREMENT,
  84.   `userName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  85.   `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  86.   `dormBuildId` int(11) NULL DEFAULT NULL,
  87.   `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  88.   `sex` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  89.   `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  90.   PRIMARY KEY (`dormManId`) USING BTREE
  91. ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  92.  
  93. -- ----------------------------
  94. -- Records of t_dormmanager
  95. -- ----------------------------
  96. INSERT INTO `t_dormmanager` VALUES (1, 'dromadmin', '123456', 4, '宿舍管理员', '男', '18212346589');
  97.  
  98. -- ----------------------------
  99. -- Table structure for t_record
  100. -- ----------------------------
  101. DROP TABLE IF EXISTS `t_record`;
  102. CREATE TABLE `t_record`  (
  103.   `recordId` int(11) NOT NULL AUTO_INCREMENT,
  104.   `studentNumber` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  105.   `studentName` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  106.   `dormBuildId` int(11) NULL DEFAULT NULL,
  107.   `dormName` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  108.   `date` date NULL DEFAULT NULL,
  109.   `detail` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  110.   PRIMARY KEY (`recordId`) USING BTREE
  111. ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  112.  
  113. -- ----------------------------
  114. -- Records of t_record
  115. -- ----------------------------
  116. INSERT INTO `t_record` VALUES (1, '001', '李四', 4, '120', '2014-01-01', '回家');
  117.  
  118. -- ----------------------------
  119. -- Table structure for t_student
  120. -- ----------------------------
  121. DROP TABLE IF EXISTS `t_student`;
  122. CREATE TABLE `t_student`  (
  123.   `studentId` int(11) NOT NULL AUTO_INCREMENT,
  124.   `stuNum` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  125.   `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  126.   `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  127.   `dormBuildId` int(11) NULL DEFAULT NULL,
  128.   `dormName` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  129.   `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  130.   `tel` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  131.   PRIMARY KEY (`studentId`) USING BTREE
  132. ) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  133.  
  134. -- ----------------------------
  135. -- Records of t_student
  136. -- ----------------------------
  137. INSERT INTO `t_student` VALUES (1, '001', '123456', '李四', 4, '120', '男', '123456');
  138. INSERT INTO `t_student` VALUES (2, '002', '123456', '王五', 5, '201', '男', '123456');
  139.  
  140. SET FOREIGN_KEY_CHECKS = 1;

5.工程截图

 

二、系统展示

1.登录界面

 

2.学生-主页面

 

3.学生-缺勤记录

 

 

4.学生-修改密码

 

5.宿舍管理员-主页面

 

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

 

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

 

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

 

9.系统管理员-主页面

 

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

 

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

 

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

 

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

 

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

三、部分代码

DormBuildDao

  1. package com.lero.dao;
  2.  
  3. import com.lero.model.DormBuild;
  4. import com.lero.model.DormManager;
  5. import com.lero.model.PageBean;
  6. import com.lero.util.StringUtil;
  7.  
  8. import java.sql.Connection;
  9. import java.sql.PreparedStatement;
  10. import java.sql.ResultSet;
  11. import java.util.ArrayList;
  12. import java.util.List;
  13.  
  14. public class DormBuildDao {
  15.  
  16.     public static String dormBuildName(Connection con, int dormBuildId) throws Exception {
  17.         String sql = "select * from t_dormBuild where dormBuildId=?";
  18.         PreparedStatement pstmt = con.prepareStatement(sql);
  19.         pstmt.setInt(1, dormBuildId);
  20.         ResultSet rs = pstmt.executeQuery();
  21.         if (rs.next()) {
  22.             return rs.getString("dormBuildName");
  23.         }
  24.         return null;
  25.     }
  26.  
  27.     public List<DormBuild> dormBuildList(Connection con, PageBean pageBean, DormBuild s_dormBuild) throws Exception {
  28.         List<DormBuild> dormBuildList = new ArrayList<DormBuild>();
  29.         StringBuffer sb = new StringBuffer("select * from t_dormBuild t1");
  30.         if (StringUtil.isNotEmpty(s_dormBuild.getDormBuildName())) {
  31.             sb.append(" where t1.dormBuildName like '%" + s_dormBuild.getDormBuildName() + "%'");
  32.         }
  33.         if (pageBean != null) {
  34.             sb.append(" limit " + pageBean.getStart() + "," + pageBean.getPageSize());
  35.         }
  36.         PreparedStatement pstmt = con.prepareStatement(sb.toString());
  37.         ResultSet rs = pstmt.executeQuery();
  38.         while (rs.next()) {
  39.             DormBuild dormBuild = new DormBuild();
  40.             dormBuild.setDormBuildId(rs.getInt("dormBuildId"));
  41.             dormBuild.setDormBuildName(rs.getString("dormBuildName"));
  42.             dormBuild.setDetail(rs.getString("dormBuildDetail"));
  43.             dormBuildList.add(dormBuild);
  44.         }
  45.         return dormBuildList;
  46.     }
  47.  
  48.     public int dormBuildCount(Connection con, DormBuild s_dormBuild) throws Exception {
  49.         StringBuffer sb = new StringBuffer("select count(*) as total from t_dormBuild t1");
  50.         if (StringUtil.isNotEmpty(s_dormBuild.getDormBuildName())) {
  51.             sb.append(" where t1.dormBuildName like '%" + s_dormBuild.getDormBuildName() + "%'");
  52.         }
  53.         PreparedStatement pstmt = con.prepareStatement(sb.toString());
  54.         ResultSet rs = pstmt.executeQuery();
  55.         if (rs.next()) {
  56.             return rs.getInt("total");
  57.         } else {
  58.             return 0;
  59.         }
  60.     }
  61.  
  62.     public DormBuild dormBuildShow(Connection con, String dormBuildId) throws Exception {
  63.         String sql = "select * from t_dormBuild t1 where t1.dormBuildId=?";
  64.         PreparedStatement pstmt = con.prepareStatement(sql);
  65.         pstmt.setString(1, dormBuildId);
  66.         ResultSet rs = pstmt.executeQuery();
  67.         DormBuild dormBuild = new DormBuild();
  68.         if (rs.next()) {
  69.             dormBuild.setDormBuildId(rs.getInt("dormBuildId"));
  70.             dormBuild.setDormBuildName(rs.getString("dormBuildName"));
  71.             dormBuild.setDetail(rs.getString("dormBuildDetail"));
  72.         }
  73.         return dormBuild;
  74.     }
  75.  
  76.     public int dormBuildAdd(Connection con, DormBuild dormBuild) throws Exception {
  77.         String sql = "insert into t_dormBuild values(null,?,?)";
  78.         PreparedStatement pstmt = con.prepareStatement(sql);
  79.         pstmt.setString(1, dormBuild.getDormBuildName());
  80.         pstmt.setString(2, dormBuild.getDetail());
  81.         return pstmt.executeUpdate();
  82.     }
  83.  
  84.     public int dormBuildDelete(Connection con, String dormBuildId) throws Exception {
  85.         String sql = "delete from t_dormBuild where dormBuildId=?";
  86.         PreparedStatement pstmt = con.prepareStatement(sql);
  87.         pstmt.setString(1, dormBuildId);
  88.         return pstmt.executeUpdate();
  89.     }
  90.  
  91.     public int dormBuildUpdate(Connection con, DormBuild dormBuild) throws Exception {
  92.         String sql = "update t_dormBuild set dormBuildName=?,dormBuildDetail=? where dormBuildId=?";
  93.         PreparedStatement pstmt = con.prepareStatement(sql);
  94.         pstmt.setString(1, dormBuild.getDormBuildName());
  95.         pstmt.setString(2, dormBuild.getDetail());
  96.         pstmt.setInt(3, dormBuild.getDormBuildId());
  97.         return pstmt.executeUpdate();
  98.     }
  99.  
  100.     public boolean existManOrDormWithId(Connection con, String dormBuildId) throws Exception {
  101.         boolean isExist = false;
  102. //		String sql="select * from t_dormBuild,t_dormManager,t_connection where dormManId=managerId and dormBuildId=buildId and dormBuildId=?";
  103.         String sql = "select *from t_dormManager where dormBuildId=?";
  104.         PreparedStatement pstmt = con.prepareStatement(sql);
  105.         pstmt.setString(1, dormBuildId);
  106.         ResultSet rs = pstmt.executeQuery();
  107.         if (rs.next()) {
  108.             isExist = true;
  109.         } else {
  110.             isExist = false;
  111.         }
  112.         String sql1 = "select * from t_dormBuild t1,t_dorm t2 where t1.dormBuildId=t2.dormBuildId and t1.dormBuildId=?";
  113.         PreparedStatement p = con.prepareStatement(sql1);
  114.         p.setString(1, dormBuildId);
  115.         ResultSet r = pstmt.executeQuery();
  116.         if (r.next()) {
  117.             return isExist;
  118.         } else {
  119.             return false;
  120.         }
  121.     }
  122.  
  123.     public List<DormManager> dormManWithoutBuild(Connection con) throws Exception {
  124.         List<DormManager> dormManagerList = new ArrayList<DormManager>();
  125.         String sql = "SELECT * FROM t_dormManager WHERE dormBuildId IS NULL OR dormBuildId=0";
  126.         PreparedStatement pstmt = con.prepareStatement(sql);
  127.         ResultSet rs = pstmt.executeQuery();
  128.         while (rs.next()) {
  129.             DormManager dormManager = new DormManager();
  130.             dormManager.setDormBuildId(rs.getInt("dormBuildId"));
  131.             dormManager.setDormManagerId(rs.getInt("dormManId"));
  132.             dormManager.setName(rs.getString("name"));
  133.             dormManager.setUserName(rs.getString("userName"));
  134.             dormManager.setSex(rs.getString("sex"));
  135.             dormManager.setTel(rs.getString("tel"));
  136.             dormManagerList.add(dormManager);
  137.         }
  138.         return dormManagerList;
  139.     }
  140.  
  141.     public List<DormManager> dormManWithBuildId(Connection con, String dormBuildId) throws Exception {
  142.         List<DormManager> dormManagerList = new ArrayList<DormManager>();
  143.         String sql = "select *from t_dormManager where dormBuildId=?";
  144.         PreparedStatement pstmt = con.prepareStatement(sql);
  145.         pstmt.setString(1, dormBuildId);
  146.         ResultSet rs = pstmt.executeQuery();
  147.         while (rs.next()) {
  148.             DormManager dormManager = new DormManager();
  149.             dormManager.setDormBuildId(rs.getInt("dormBuildId"));
  150.             dormManager.setDormManagerId(rs.getInt("dormManId"));
  151.             dormManager.setName(rs.getString("name"));
  152.             dormManager.setUserName(rs.getString("userName"));
  153.             dormManager.setSex(rs.getString("sex"));
  154.             dormManager.setTel(rs.getString("tel"));
  155.             dormManagerList.add(dormManager);
  156.         }
  157.         return dormManagerList;
  158.     }
  159.  
  160.     public int managerUpdateWithId(Connection con, String dormManagerId, String dormBuildId) throws Exception {
  161.         String sql = "update t_dormManager set dormBuildId=? where dormManId=?";
  162.         PreparedStatement pstmt = con.prepareStatement(sql);
  163.         pstmt.setString(1, dormBuildId);
  164.         pstmt.setString(2, dormManagerId);
  165.         return pstmt.executeUpdate();
  166.     }
  167. }

DormManagerDao

  1. package com.lero.dao;
  2.  
  3. import com.lero.model.DormManager;
  4. import com.lero.model.PageBean;
  5. import com.lero.util.StringUtil;
  6.  
  7. import java.sql.Connection;
  8. import java.sql.PreparedStatement;
  9. import java.sql.ResultSet;
  10. import java.util.ArrayList;
  11. import java.util.List;
  12.  
  13. public class DormManagerDao {
  14.  
  15.     public List<DormManager> dormManagerList(Connection con, PageBean pageBean, DormManager s_dormManager) throws Exception {
  16.         List<DormManager> dormManagerList = new ArrayList<DormManager>();
  17.         StringBuffer sb = new StringBuffer("SELECT * FROM t_dormManager t1 ORDER BY t1.userName");
  18.         if (StringUtil.isNotEmpty(s_dormManager.getName())) {
  19.             sb.append(" where t1.name like '%" + s_dormManager.getName() + "%'");
  20.         } else if (StringUtil.isNotEmpty(s_dormManager.getUserName())) {
  21.             sb.append(" where t1.userName like '%" + s_dormManager.getUserName() + "%'");
  22.         }
  23.         if (pageBean != null) {
  24.             sb.append(" limit " + pageBean.getStart() + "," + pageBean.getPageSize());
  25.         }
  26.         PreparedStatement pstmt = con.prepareStatement(sb.toString());
  27.         ResultSet rs = pstmt.executeQuery();
  28.         while (rs.next()) {
  29.             DormManager dormManager = new DormManager();
  30.             dormManager.setDormManagerId(rs.getInt("dormManId"));
  31.             int dormBuildId = rs.getInt("dormBuildId");
  32.             dormManager.setDormBuildId(dormBuildId);
  33.             dormManager.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
  34.             dormManager.setName(rs.getString("name"));
  35.             dormManager.setSex(rs.getString("sex"));
  36.             dormManager.setUserName(rs.getString("userName"));
  37.             dormManager.setTel(rs.getString("tel"));
  38.             dormManager.setPassword(rs.getString("password"));
  39.             dormManagerList.add(dormManager);
  40.         }
  41.         return dormManagerList;
  42.     }
  43.  
  44.     public int dormManagerCount(Connection con, DormManager s_dormManager) throws Exception {
  45.         StringBuffer sb = new StringBuffer("select count(*) as total from t_dormManager t1");
  46.         if (StringUtil.isNotEmpty(s_dormManager.getName())) {
  47.             sb.append(" where t1.name like '%" + s_dormManager.getName() + "%'");
  48.         } else if (StringUtil.isNotEmpty(s_dormManager.getUserName())) {
  49.             sb.append(" where t1.userName like '%" + s_dormManager.getUserName() + "%'");
  50.         }
  51.         PreparedStatement pstmt = con.prepareStatement(sb.toString());
  52.         ResultSet rs = pstmt.executeQuery();
  53.         if (rs.next()) {
  54.             return rs.getInt("total");
  55.         } else {
  56.             return 0;
  57.         }
  58.     }
  59.  
  60.     public DormManager dormManagerShow(Connection con, String dormManagerId) throws Exception {
  61.         String sql = "select * from t_dormManager t1 where t1.dormManId=?";
  62.         PreparedStatement pstmt = con.prepareStatement(sql);
  63.         pstmt.setString(1, dormManagerId);
  64.         ResultSet rs = pstmt.executeQuery();
  65.         DormManager dormManager = new DormManager();
  66.         if (rs.next()) {
  67.             dormManager.setDormManagerId(rs.getInt("dormManId"));
  68.             dormManager.setDormBuildId(rs.getInt("dormBuildId"));
  69.             dormManager.setName(rs.getString("name"));
  70.             dormManager.setSex(rs.getString("sex"));
  71.             dormManager.setUserName(rs.getString("userName"));
  72.             dormManager.setTel(rs.getString("tel"));
  73.             dormManager.setPassword(rs.getString("password"));
  74.         }
  75.         return dormManager;
  76.     }
  77.  
  78.     public int dormManagerAdd(Connection con, DormManager dormManager) throws Exception {
  79.         String sql = "insert into t_dormManager values(null,?,?,null,?,?,?)";
  80.         PreparedStatement pstmt = con.prepareStatement(sql);
  81.         pstmt.setString(1, dormManager.getUserName());
  82.         pstmt.setString(2, dormManager.getPassword());
  83.         pstmt.setString(3, dormManager.getName());
  84.         pstmt.setString(4, dormManager.getSex());
  85.         pstmt.setString(5, dormManager.getTel());
  86.         return pstmt.executeUpdate();
  87.     }
  88.  
  89.     public int dormManagerDelete(Connection con, String dormManagerId) throws Exception {
  90.         String sql = "delete from t_dormManager where dormManId=?";
  91.         PreparedStatement pstmt = con.prepareStatement(sql);
  92.         pstmt.setString(1, dormManagerId);
  93.         return pstmt.executeUpdate();
  94.     }
  95.  
  96.     public int dormManagerUpdate(Connection con, DormManager dormManager) throws Exception {
  97.         String sql = "update t_dormManager set userName=?,password=?,name=?,sex=?,tel=? where dormManId=?";
  98.         PreparedStatement pstmt = con.prepareStatement(sql);
  99.         pstmt.setString(1, dormManager.getUserName());
  100.         pstmt.setString(2, dormManager.getPassword());
  101.         pstmt.setString(3, dormManager.getName());
  102.         pstmt.setString(4, dormManager.getSex());
  103.         pstmt.setString(5, dormManager.getTel());
  104.         pstmt.setInt(6, dormManager.getDormManagerId());
  105.         return pstmt.executeUpdate();
  106.     }
  107.  
  108.     public boolean haveManagerByUser(Connection con, String userName) throws Exception {
  109.         String sql = "select * from t_dormmanager t1 where t1.userName=?";
  110.         PreparedStatement pstmt = con.prepareStatement(sql);
  111.         pstmt.setString(1, userName);
  112.         ResultSet rs = pstmt.executeQuery();
  113.         if (rs.next()) {
  114.             return true;
  115.         }
  116.         return false;
  117.     }
  118.  
  119.  
  120. }

RecordDao

  1. package com.lero.dao;
  2.  
  3. import com.lero.model.DormBuild;
  4. import com.lero.model.Record;
  5. import com.lero.util.StringUtil;
  6.  
  7. import java.sql.Connection;
  8. import java.sql.PreparedStatement;
  9. import java.sql.ResultSet;
  10. import java.util.ArrayList;
  11. import java.util.List;
  12.  
  13. public class RecordDao {
  14.     public List<Record> recordList(Connection con, Record s_record) throws Exception {
  15.         List<Record> recordList = new ArrayList<Record>();
  16.         StringBuffer sb = new StringBuffer("select * from t_record t1");
  17.         if (StringUtil.isNotEmpty(s_record.getStudentNumber())) {
  18.             sb.append(" and t1.studentNumber like '%" + s_record.getStudentNumber() + "%'");
  19.         } else if (StringUtil.isNotEmpty(s_record.getStudentName())) {
  20.             sb.append(" and t1.studentName like '%" + s_record.getStudentName() + "%'");
  21.         }
  22.         if (s_record.getDormBuildId() != 0) {
  23.             sb.append(" and t1.dormBuildId=" + s_record.getDormBuildId());
  24.         }
  25.         if (StringUtil.isNotEmpty(s_record.getDate())) {
  26.             sb.append(" and t1.date=" + s_record.getDate());
  27.         }
  28.         if (StringUtil.isNotEmpty(s_record.getStartDate())) {
  29.             sb.append(" and TO_DAYS(t1.date)>=TO_DAYS('" + s_record.getStartDate() + "')");
  30.         }
  31.         if (StringUtil.isNotEmpty(s_record.getEndDate())) {
  32.             sb.append(" and TO_DAYS(t1.date)<=TO_DAYS('" + s_record.getEndDate() + "')");
  33.         }
  34.         PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where"));
  35.         ResultSet rs = pstmt.executeQuery();
  36.         while (rs.next()) {
  37.             Record record = new Record();
  38.             record.setRecordId(rs.getInt("recordId"));
  39.             record.setStudentNumber(rs.getString("studentNumber"));
  40.             record.setStudentName(rs.getString("studentName"));
  41.             int dormBuildId = rs.getInt("dormBuildId");
  42.             record.setDormBuildId(dormBuildId);
  43.             record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
  44.             record.setDormName(rs.getString("dormName"));
  45.             record.setDate(rs.getString("date"));
  46.             record.setDetail(rs.getString("detail"));
  47.             recordList.add(record);
  48.         }
  49.         return recordList;
  50.     }
  51.  
  52.     public List<Record> recordListWithBuild(Connection con, Record s_record, int buildId) throws Exception {
  53.         List<Record> recordList = new ArrayList<Record>();
  54.         StringBuffer sb = new StringBuffer("select * from t_record t1");
  55.         if (StringUtil.isNotEmpty(s_record.getStudentNumber())) {
  56.             sb.append(" and t1.studentNumber like '%" + s_record.getStudentNumber() + "%'");
  57.         } else if (StringUtil.isNotEmpty(s_record.getStudentName())) {
  58.             sb.append(" and t1.studentName like '%" + s_record.getStudentName() + "%'");
  59.         }
  60.         sb.append(" and t1.dormBuildId=" + buildId);
  61.         if (StringUtil.isNotEmpty(s_record.getStartDate())) {
  62.             sb.append(" and TO_DAYS(t1.date)>=TO_DAYS('" + s_record.getStartDate() + "')");
  63.         }
  64.         if (StringUtil.isNotEmpty(s_record.getEndDate())) {
  65.             sb.append(" and TO_DAYS(t1.date)<=TO_DAYS('" + s_record.getEndDate() + "')");
  66.         }
  67.         PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where"));
  68.         ResultSet rs = pstmt.executeQuery();
  69.         while (rs.next()) {
  70.             Record record = new Record();
  71.             record.setRecordId(rs.getInt("recordId"));
  72.             record.setStudentNumber(rs.getString("studentNumber"));
  73.             record.setStudentName(rs.getString("studentName"));
  74.             int dormBuildId = rs.getInt("dormBuildId");
  75.             record.setDormBuildId(dormBuildId);
  76.             record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
  77.             record.setDormName(rs.getString("dormName"));
  78.             record.setDate(rs.getString("date"));
  79.             record.setDetail(rs.getString("detail"));
  80.             recordList.add(record);
  81.         }
  82.         return recordList;
  83.     }
  84.  
  85.     public List<Record> recordListWithNumber(Connection con, Record s_record, String studentNumber) throws Exception {
  86.         List<Record> recordList = new ArrayList<Record>();
  87.         StringBuffer sb = new StringBuffer("select * from t_record t1");
  88.         if (StringUtil.isNotEmpty(studentNumber)) {
  89.             sb.append(" and t1.studentNumber =" + studentNumber);
  90.         }
  91.         if (StringUtil.isNotEmpty(s_record.getStartDate())) {
  92.             sb.append(" and TO_DAYS(t1.date)>=TO_DAYS('" + s_record.getStartDate() + "')");
  93.         }
  94.         if (StringUtil.isNotEmpty(s_record.getEndDate())) {
  95.             sb.append(" and TO_DAYS(t1.date)<=TO_DAYS('" + s_record.getEndDate() + "')");
  96.         }
  97.         PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where"));
  98.         ResultSet rs = pstmt.executeQuery();
  99.         while (rs.next()) {
  100.             Record record = new Record();
  101.             record.setRecordId(rs.getInt("recordId"));
  102.             record.setStudentNumber(rs.getString("studentNumber"));
  103.             record.setStudentName(rs.getString("studentName"));
  104.             int dormBuildId = rs.getInt("dormBuildId");
  105.             record.setDormBuildId(dormBuildId);
  106.             record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
  107.             record.setDormName(rs.getString("dormName"));
  108.             record.setDate(rs.getString("date"));
  109.             record.setDetail(rs.getString("detail"));
  110.             recordList.add(record);
  111.         }
  112.         return recordList;
  113.     }
  114.  
  115.     public List<DormBuild> dormBuildList(Connection con) throws Exception {
  116.         List<DormBuild> dormBuildList = new ArrayList<DormBuild>();
  117.         String sql = "select * from t_dormBuild";
  118.         PreparedStatement pstmt = con.prepareStatement(sql);
  119.         ResultSet rs = pstmt.executeQuery();
  120.         while (rs.next()) {
  121.             DormBuild dormBuild = new DormBuild();
  122.             dormBuild.setDormBuildId(rs.getInt("dormBuildId"));
  123.             dormBuild.setDormBuildName(rs.getString("dormBuildName"));
  124.             dormBuild.setDetail(rs.getString("dormBuildDetail"));
  125.             dormBuildList.add(dormBuild);
  126.         }
  127.         return dormBuildList;
  128.     }
  129. //	
  130. //	public int studentCount(Connection con, Student s_student)throws Exception {
  131. //		StringBuffer sb = new StringBuffer("select count(*) as total from t_student t1");
  132. //		if(StringUtil.isNotEmpty(s_student.getName())) {
  133. //			sb.append(" and t1.name like '%"+s_student.getName()+"%'");
  134. //		} else if(StringUtil.isNotEmpty(s_student.getStuNumber())) {
  135. //			sb.append(" and t1.stuNum like '%"+s_student.getStuNumber()+"%'");
  136. //		} else if(StringUtil.isNotEmpty(s_student.getDormName())) {
  137. //			sb.append(" and t1.dormName like '%"+s_student.getDormName()+"%'");
  138. //		}
  139. //		if(s_student.getDormBuildId()!=0) {
  140. //			sb.append(" and t1.dormBuildId="+s_student.getDormBuildId());
  141. //		}
  142. //		PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where"));
  143. //		ResultSet rs = pstmt.executeQuery();
  144. //		if(rs.next()) {
  145. //			return rs.getInt("total");
  146. //		} else {
  147. //			return 0;
  148. //		}
  149. //	}
  150.  
  151.     public Record recordShow(Connection con, String recordId) throws Exception {
  152.         String sql = "select * from t_record t1 where t1.recordId=?";
  153.         PreparedStatement pstmt = con.prepareStatement(sql);
  154.         pstmt.setString(1, recordId);
  155.         ResultSet rs = pstmt.executeQuery();
  156.         Record record = new Record();
  157.         if (rs.next()) {
  158.             record.setRecordId(rs.getInt("recordId"));
  159.             record.setStudentNumber(rs.getString("studentNumber"));
  160.             record.setStudentName(rs.getString("studentName"));
  161.             int dormBuildId = rs.getInt("dormBuildId");
  162.             record.setDormBuildId(dormBuildId);
  163.             record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
  164.             record.setDormName(rs.getString("dormName"));
  165.             record.setDate(rs.getString("date"));
  166.             record.setDetail(rs.getString("detail"));
  167.         }
  168.         return record;
  169.     }
  170.  
  171.     public int recordAdd(Connection con, Record record) throws Exception {
  172.         String sql = "insert into t_record values(null,?,?,?,?,?,?)";
  173.         PreparedStatement pstmt = con.prepareStatement(sql);
  174.         pstmt.setString(1, record.getStudentNumber());
  175.         pstmt.setString(2, record.getStudentName());
  176.         pstmt.setInt(3, record.getDormBuildId());
  177.         pstmt.setString(4, record.getDormName());
  178.         pstmt.setString(5, record.getDate());
  179.         pstmt.setString(6, record.getDetail());
  180.         return pstmt.executeUpdate();
  181.     }
  182.  
  183.     public int recordDelete(Connection con, String recordId) throws Exception {
  184.         String sql = "delete from t_record where recordId=?";
  185.         PreparedStatement pstmt = con.prepareStatement(sql);
  186.         pstmt.setString(1, recordId);
  187.         return pstmt.executeUpdate();
  188.     }
  189.  
  190.     public int recordUpdate(Connection con, Record record) throws Exception {
  191.         String sql = "update t_record set studentNumber=?,studentName=?,dormBuildId=?,dormName=?,detail=? where recordId=?";
  192.         PreparedStatement pstmt = con.prepareStatement(sql);
  193.         pstmt.setString(1, record.getStudentNumber());
  194.         pstmt.setString(2, record.getStudentName());
  195.         pstmt.setInt(3, record.getDormBuildId());
  196.         pstmt.setString(4, record.getDormName());
  197.         pstmt.setString(5, record.getDetail());
  198.         pstmt.setInt(6, record.getRecordId());
  199.         return pstmt.executeUpdate();
  200.     }
  201.  
  202.  
  203. }

StudentDao

  1. package com.lero.dao;
  2.  
  3. import com.lero.model.DormBuild;
  4. import com.lero.model.Student;
  5. import com.lero.util.StringUtil;
  6.  
  7. import java.sql.Connection;
  8. import java.sql.PreparedStatement;
  9. import java.sql.ResultSet;
  10. import java.util.ArrayList;
  11. import java.util.List;
  12.  
  13. public class StudentDao {
  14.  
  15. //	public List<Student> studentList(Connection con, PageBean pageBean, Student s_student)throws Exception {
  16. //		List<Student> studentList = new ArrayList<Student>();
  17. //		StringBuffer sb = new StringBuffer("select * from t_student t1");
  18. //		if(StringUtil.isNotEmpty(s_student.getName())) {
  19. //			sb.append(" and t1.name like '%"+s_student.getName()+"%'");
  20. //		} else if(StringUtil.isNotEmpty(s_student.getStuNumber())) {
  21. //			sb.append(" and t1.stuNum like '%"+s_student.getStuNumber()+"%'");
  22. //		} else if(StringUtil.isNotEmpty(s_student.getDormName())) {
  23. //			sb.append(" and t1.dormName like '%"+s_student.getDormName()+"%'");
  24. //		}
  25. //		if(s_student.getDormBuildId()!=0) {
  26. //			sb.append(" and t1.dormBuildId="+s_student.getDormBuildId());
  27. //		}
  28. //		if(pageBean != null) {
  29. //			sb.append(" limit "+pageBean.getStart()+","+pageBean.getPageSize());
  30. //		}
  31. //		PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where"));
  32. //		ResultSet rs = pstmt.executeQuery();
  33. //		while(rs.next()) {
  34. //			Student student=new Student();
  35. //			student.setStudentId(rs.getInt("studentId"));
  36. //			int dormBuildId = rs.getInt("dormBuildId");
  37. //			student.setDormBuildId(dormBuildId);
  38. //			student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
  39. //			student.setDormName(rs.getString("dormName"));
  40. //			student.setName(rs.getString("name"));
  41. //			student.setSex(rs.getString("sex"));
  42. //			student.setStuNumber(rs.getString("stuNum"));
  43. //			student.setTel(rs.getString("tel"));
  44. //			student.setPassword(rs.getString("password"));
  45. //			studentList.add(student);
  46. //		}
  47. //		return studentList;
  48. //	}
  49.  
  50.     public static Student getNameById(Connection con, String studentNumber, int dormBuildId) throws Exception {
  51.         String sql = "select * from t_student t1 where t1.stuNum=? and t1.dormBuildId=?";
  52.         PreparedStatement pstmt = con.prepareStatement(sql);
  53.         pstmt.setString(1, studentNumber);
  54.         pstmt.setInt(2, dormBuildId);
  55.         ResultSet rs = pstmt.executeQuery();
  56.         Student student = new Student();
  57.         if (rs.next()) {
  58.             student.setName(rs.getString("name"));
  59.             student.setDormBuildId(rs.getInt("dormBuildId"));
  60.             student.setDormName(rs.getString("dormName"));
  61.         }
  62.         return student;
  63.     }
  64.  
  65.     public List<Student> studentList(Connection con, Student s_student) throws Exception {
  66.         List<Student> studentList = new ArrayList<Student>();
  67.         StringBuffer sb = new StringBuffer("select * from t_student t1");
  68.         if (StringUtil.isNotEmpty(s_student.getName())) {
  69.             sb.append(" and t1.name like '%" + s_student.getName() + "%'");
  70.         } else if (StringUtil.isNotEmpty(s_student.getStuNumber())) {
  71.             sb.append(" and t1.stuNum like '%" + s_student.getStuNumber() + "%'");
  72.         } else if (StringUtil.isNotEmpty(s_student.getDormName())) {
  73.             sb.append(" and t1.dormName like '%" + s_student.getDormName() + "%'");
  74.         }
  75.         if (s_student.getDormBuildId() != 0) {
  76.             sb.append(" and t1.dormBuildId=" + s_student.getDormBuildId());
  77.         }
  78.         PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where"));
  79.         ResultSet rs = pstmt.executeQuery();
  80.         while (rs.next()) {
  81.             Student student = new Student();
  82.             student.setStudentId(rs.getInt("studentId"));
  83.             int dormBuildId = rs.getInt("dormBuildId");
  84.             student.setDormBuildId(dormBuildId);
  85.             student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
  86.             student.setDormName(rs.getString("dormName"));
  87.             student.setName(rs.getString("name"));
  88.             student.setSex(rs.getString("sex"));
  89.             student.setStuNumber(rs.getString("stuNum"));
  90.             student.setTel(rs.getString("tel"));
  91.             student.setPassword(rs.getString("password"));
  92.             studentList.add(student);
  93.         }
  94.         return studentList;
  95.     }
  96.  
  97.     public boolean haveNameByNumber(Connection con, String studentNumber) throws Exception {
  98.         String sql = "select * from t_student t1 where t1.stuNum=?";
  99.         PreparedStatement pstmt = con.prepareStatement(sql);
  100.         pstmt.setString(1, studentNumber);
  101.         ResultSet rs = pstmt.executeQuery();
  102.         Student student = new Student();
  103.         if (rs.next()) {
  104.             student.setName(rs.getString("name"));
  105.             student.setDormBuildId(rs.getInt("dormBuildId"));
  106.             student.setDormName(rs.getString("dormName"));
  107.             return true;
  108.         }
  109.         return false;
  110.     }
  111.  
  112.     public List<Student> studentListWithBuild(Connection con, Student s_student, int buildId) throws Exception {
  113.         List<Student> studentList = new ArrayList<Student>();
  114.         StringBuffer sb = new StringBuffer("select * from t_student t1");
  115.         if (StringUtil.isNotEmpty(s_student.getName())) {
  116.             sb.append(" and t1.name like '%" + s_student.getName() + "%'");
  117.         } else if (StringUtil.isNotEmpty(s_student.getStuNumber())) {
  118.             sb.append(" and t1.stuNum like '%" + s_student.getStuNumber() + "%'");
  119.         } else if (StringUtil.isNotEmpty(s_student.getDormName())) {
  120.             sb.append(" and t1.dormName like '%" + s_student.getDormName() + "%'");
  121.         }
  122.         sb.append(" and t1.dormBuildId=" + buildId);
  123.         PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where"));
  124.         ResultSet rs = pstmt.executeQuery();
  125.         while (rs.next()) {
  126.             Student student = new Student();
  127.             student.setStudentId(rs.getInt("studentId"));
  128.             int dormBuildId = rs.getInt("dormBuildId");
  129.             student.setDormBuildId(dormBuildId);
  130.             student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
  131.             student.setDormName(rs.getString("dormName"));
  132.             student.setName(rs.getString("name"));
  133.             student.setSex(rs.getString("sex"));
  134.             student.setStuNumber(rs.getString("stuNum"));
  135.             student.setTel(rs.getString("tel"));
  136.             student.setPassword(rs.getString("password"));
  137.             studentList.add(student);
  138.         }
  139.         return studentList;
  140.     }
  141.  
  142.     public List<DormBuild> dormBuildList(Connection con) throws Exception {
  143.         List<DormBuild> dormBuildList = new ArrayList<DormBuild>();
  144.         String sql = "select * from t_dormBuild";
  145.         PreparedStatement pstmt = con.prepareStatement(sql);
  146.         ResultSet rs = pstmt.executeQuery();
  147.         while (rs.next()) {
  148.             DormBuild dormBuild = new DormBuild();
  149.             dormBuild.setDormBuildId(rs.getInt("dormBuildId"));
  150.             dormBuild.setDormBuildName(rs.getString("dormBuildName"));
  151.             dormBuild.setDetail(rs.getString("dormBuildDetail"));
  152.             dormBuildList.add(dormBuild);
  153.         }
  154.         return dormBuildList;
  155.     }
  156.  
  157.     public int studentCount(Connection con, Student s_student) throws Exception {
  158.         StringBuffer sb = new StringBuffer("select count(*) as total from t_student t1");
  159.         if (StringUtil.isNotEmpty(s_student.getName())) {
  160.             sb.append(" and t1.name like '%" + s_student.getName() + "%'");
  161.         } else if (StringUtil.isNotEmpty(s_student.getStuNumber())) {
  162.             sb.append(" and t1.stuNum like '%" + s_student.getStuNumber() + "%'");
  163.         } else if (StringUtil.isNotEmpty(s_student.getDormName())) {
  164.             sb.append(" and t1.dormName like '%" + s_student.getDormName() + "%'");
  165.         }
  166.         if (s_student.getDormBuildId() != 0) {
  167.             sb.append(" and t1.dormBuildId=" + s_student.getDormBuildId());
  168.         }
  169.         PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where"));
  170.         ResultSet rs = pstmt.executeQuery();
  171.         if (rs.next()) {
  172.             return rs.getInt("total");
  173.         } else {
  174.             return 0;
  175.         }
  176.     }
  177.  
  178.     public Student studentShow(Connection con, String studentId) throws Exception {
  179.         String sql = "select * from t_student t1 where t1.studentId=?";
  180.         PreparedStatement pstmt = con.prepareStatement(sql);
  181.         pstmt.setString(1, studentId);
  182.         ResultSet rs = pstmt.executeQuery();
  183.         Student student = new Student();
  184.         if (rs.next()) {
  185.             student.setStudentId(rs.getInt("studentId"));
  186.             int dormBuildId = rs.getInt("dormBuildId");
  187.             student.setDormBuildId(dormBuildId);
  188.             student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
  189.             student.setDormName(rs.getString("dormName"));
  190.             student.setName(rs.getString("name"));
  191.             student.setSex(rs.getString("sex"));
  192.             student.setStuNumber(rs.getString("stuNum"));
  193.             student.setTel(rs.getString("tel"));
  194.             student.setPassword(rs.getString("password"));
  195.         }
  196.         return student;
  197.     }
  198.  
  199.     public int studentAdd(Connection con, Student student) throws Exception {
  200.         String sql = "insert into t_student values(null,?,?,?,?,?,?,?)";
  201.         PreparedStatement pstmt = con.prepareStatement(sql);
  202.         pstmt.setString(1, student.getStuNumber());
  203.         pstmt.setString(2, student.getPassword());
  204.         pstmt.setString(3, student.getName());
  205.         pstmt.setInt(4, student.getDormBuildId());
  206.         pstmt.setString(5, student.getDormName());
  207.         pstmt.setString(6, student.getSex());
  208.         pstmt.setString(7, student.getTel());
  209.         return pstmt.executeUpdate();
  210.     }
  211.  
  212.     public int studentDelete(Connection con, String studentId) throws Exception {
  213.         String sql = "delete from t_student where studentId=?";
  214.         PreparedStatement pstmt = con.prepareStatement(sql);
  215.         pstmt.setString(1, studentId);
  216.         return pstmt.executeUpdate();
  217.     }
  218.  
  219.     public int studentUpdate(Connection con, Student student) throws Exception {
  220.         String sql = "update t_student set stuNum=?,password=?,name=?,dormBuildId=?,dormName=?,sex=?,tel=? where studentId=?";
  221.         PreparedStatement pstmt = con.prepareStatement(sql);
  222.         pstmt.setString(1, student.getStuNumber());
  223.         pstmt.setString(2, student.getPassword());
  224.         pstmt.setString(3, student.getName());
  225.         pstmt.setInt(4, student.getDormBuildId());
  226.         pstmt.setString(5, student.getDormName());
  227.         pstmt.setString(6, student.getSex());
  228.         pstmt.setString(7, student.getTel());
  229.         pstmt.setInt(8, student.getStudentId());
  230.         return pstmt.executeUpdate();
  231.     }
  232.  
  233.  
  234. }

UserDao

  1. package com.lero.dao;
  2.  
  3. import com.lero.model.Admin;
  4. import com.lero.model.DormManager;
  5. import com.lero.model.Student;
  6.  
  7. import java.sql.Connection;
  8. import java.sql.PreparedStatement;
  9. import java.sql.ResultSet;
  10.  
  11. public class UserDao {
  12.  
  13.     public Admin Login(Connection con, Admin admin) throws Exception {
  14.         Admin resultAdmin = null;
  15.         String sql = "select * from t_admin where userName=? and password=?";
  16.         PreparedStatement pstmt = con.prepareStatement(sql);
  17.         pstmt.setString(1, admin.getUserName());
  18.         pstmt.setString(2, admin.getPassword());
  19.         ResultSet rs = pstmt.executeQuery();
  20.         if (rs.next()) {
  21.             resultAdmin = new Admin();
  22.             resultAdmin.setAdminId(rs.getInt("adminId"));
  23.             resultAdmin.setUserName(rs.getString("userName"));
  24.             resultAdmin.setPassword(rs.getString("password"));
  25.             resultAdmin.setName(rs.getString("name"));
  26.             resultAdmin.setSex(rs.getString("sex"));
  27.             resultAdmin.setTel(rs.getString("tel"));
  28.         }
  29.         return resultAdmin;
  30.     }
  31.  
  32.     public DormManager Login(Connection con, DormManager dormManager) throws Exception {
  33.         DormManager resultDormManager = null;
  34.         String sql = "select * from t_dormmanager where userName=? and password=?";
  35.         PreparedStatement pstmt = con.prepareStatement(sql);
  36.         pstmt.setString(1, dormManager.getUserName());
  37.         pstmt.setString(2, dormManager.getPassword());
  38.         ResultSet rs = pstmt.executeQuery();
  39.         if (rs.next()) {
  40.             resultDormManager = new DormManager();
  41.             resultDormManager.setDormManagerId(rs.getInt("dormManId"));
  42.             resultDormManager.setUserName(rs.getString("userName"));
  43.             resultDormManager.setPassword(rs.getString("password"));
  44.             resultDormManager.setDormBuildId(rs.getInt("dormBuildId"));
  45.             resultDormManager.setName(rs.getString("name"));
  46.             resultDormManager.setSex(rs.getString("sex"));
  47.             resultDormManager.setTel(rs.getString("tel"));
  48.         }
  49.         return resultDormManager;
  50.     }
  51.  
  52.     public Student Login(Connection con, Student student) throws Exception {
  53.         Student resultStudent = null;
  54.         String sql = "select * from t_student where stuNum=? and password=?";
  55.         PreparedStatement pstmt = con.prepareStatement(sql);
  56.         pstmt.setString(1, student.getStuNumber());
  57.         pstmt.setString(2, student.getPassword());
  58.         ResultSet rs = pstmt.executeQuery();
  59.         if (rs.next()) {
  60.             resultStudent = new Student();
  61.             resultStudent.setStudentId(rs.getInt("studentId"));
  62.             resultStudent.setStuNumber(rs.getString("stuNum"));
  63.             resultStudent.setPassword(rs.getString("password"));
  64.             int dormBuildId = rs.getInt("dormBuildId");
  65.             resultStudent.setDormBuildId(dormBuildId);
  66.             resultStudent.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
  67.             resultStudent.setDormName(rs.getString("dormName"));
  68.             resultStudent.setName(rs.getString("name"));
  69.             resultStudent.setSex(rs.getString("sex"));
  70.             resultStudent.setTel(rs.getString("tel"));
  71.         }
  72.         return resultStudent;
  73.     }
  74.  
  75.     public int adminUpdate(Connection con, int adminId, String password) throws Exception {
  76.         String sql = "update t_admin set password=? where adminId=?";
  77.         PreparedStatement pstmt = con.prepareStatement(sql);
  78.         pstmt.setString(1, password);
  79.         pstmt.setInt(2, adminId);
  80.         return pstmt.executeUpdate();
  81.     }
  82.  
  83.     public int managerUpdate(Connection con, int managerId, String password) throws Exception {
  84.         String sql = "update t_dormmanager set password=? where dormManId=?";
  85.         PreparedStatement pstmt = con.prepareStatement(sql);
  86.         pstmt.setString(1, password);
  87.         pstmt.setInt(2, managerId);
  88.         return pstmt.executeUpdate();
  89.     }
  90.  
  91.     public int studentUpdate(Connection con, int studentId, String password) throws Exception {
  92.         String sql = "update t_student set password=? where studentId=?";
  93.         PreparedStatement pstmt = con.prepareStatement(sql);
  94.         pstmt.setString(1, password);
  95.         pstmt.setInt(2, studentId);
  96.         return pstmt.executeUpdate();
  97.     }
  98.  
  99. }

PropertiesUtil

  1. package com.lero.util;
  2.  
  3. import java.io.IOException;
  4. import java.io.InputStream;
  5. import java.util.Properties;
  6.  
  7. public class PropertiesUtil {
  8.  
  9.     public static String getValue(String key) {
  10.         Properties prop = new Properties();
  11.         InputStream in = new PropertiesUtil().getClass().getResourceAsStream("/dorm.properties");
  12.         try {
  13.             prop.load(in);
  14.         } catch (IOException e) {
  15.             e.printStackTrace();
  16.         }
  17.         return (String) prop.get(key);
  18.     }
  19. }

login.jsp

  1. <%@ page language="java" contentType="text/html; charset=utf-8"
  2.          pageEncoding="utf-8" %>
  3. <%@ page import="com.lero.model.Admin" %>
  4. <%@ page import="com.lero.model.DormManager" %>
  5. <%@ page import="com.lero.model.Student" %>
  6. <%
  7.     if (request.getAttribute("user") == null) {
  8.         String userName = null;
  9.         String password = null;
  10.         String userType = null;
  11.         String remember = null;
  12.  
  13.         Cookie[] cookies = request.getCookies();
  14.         for (int i = 0; cookies != null && i < cookies.length; i++) {
  15.             if (cookies[i].getName().equals("dormuser")) {
  16.                 userName = cookies[i].getValue().split("-")[0];
  17.                 password = cookies[i].getValue().split("-")[1];
  18.                 userType = cookies[i].getValue().split("-")[2];
  19.                 remember = cookies[i].getValue().split("-")[3];
  20.             }
  21.         }
  22.  
  23.         if (userName == null) {
  24.             userName = "";
  25.         }
  26.  
  27.         if (password == null) {
  28.             password = "";
  29.         }
  30.  
  31.         if (userType == null) {
  32.             userType = "";
  33.         } else if ("admin".equals(userType)) {
  34.             pageContext.setAttribute("user", new Admin(userName, password));
  35.             pageContext.setAttribute("userType", 1);
  36.         } else if ("dormManager".equals(userType)) {
  37.             pageContext.setAttribute("user", new DormManager(userName, password));
  38.             pageContext.setAttribute("userType", 2);
  39.         } else if ("student".equals(userType)) {
  40.             pageContext.setAttribute("user", new Student(userName, password));
  41.             pageContext.setAttribute("userType", 3);
  42.         }
  43.  
  44.         if ("yes".equals(remember)) {
  45.             pageContext.setAttribute("remember", 1);
  46.         }
  47.  
  48.     }
  49. %>
  50. <html lang="zh">
  51. <head>
  52.     <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  53.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  54.     <title>宿舍管理系统登录</title>
  55.     <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap.css" rel="stylesheet">
  56.     <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap-responsive.css" rel="stylesheet">
  57.     <script src="${pageContext.request.contextPath}/bootstrap/js/jQuery.js"></script>
  58.     <script src="${pageContext.request.contextPath}/bootstrap/js/bootstrap.js"></script>
  59.     <script type="text/javascript">
  60.         function checkForm() {
  61.             var userName = document.getElementById("userName").value;
  62.             var password = document.getElementById("password").value;
  63.             var userTypes = document.getElementsByName("userType");
  64.             var userType = null;
  65.             for (var i = 0; i < userTypes.length; i++) {
  66.                 if (userTypes[i].checked) {
  67.                     userType = userTypes[i].value;
  68.                     break;
  69.                 }
  70.             }
  71.             if (userName == null || userName == "") {
  72.                 document.getElementById("error").innerHTML = "用户名不能为空";
  73.                 return false;
  74.             }
  75.             if (password == null || password == "") {
  76.                 document.getElementById("error").innerHTML = "密码不能为空";
  77.                 return false;
  78.             }
  79.             if (userType == null || userType == "") {
  80.                 document.getElementById("error").innerHTML = "请选择用户类型";
  81.                 return false;
  82.             }
  83.             return true;
  84.         }
  85.     </script>
  86.  
  87.     <style type="text/css">
  88.         body {
  89.             padding-top: 200px;
  90.             padding-bottom: 40px;
  91.             background-image: url('images/bg.jpg');
  92.             background-position: center;
  93.             background-repeat: no-repeat;
  94.             background-attachment: fixed;
  95.         }
  96.  
  97.         .radio {
  98.             padding-top: 10px;
  99.             padding-bottom: 10px;
  100.         }
  101.  
  102.         .form-signin-heading {
  103.             text-align: center;
  104.         }
  105.  
  106.         .form-signin {
  107.             max-width: 300px;
  108.             padding: 19px 29px 0px;
  109.             margin: 0 auto 20px;
  110.             background-color: #fff;
  111.             border: 1px solid #e5e5e5;
  112.             -webkit-border-radius: 5px;
  113.             -moz-border-radius: 5px;
  114.             border-radius: 5px;
  115.             -webkit-box-shadow: 0 1px 2px rgba(0, 0, 0, .05);
  116.             -moz-box-shadow: 0 1px 2px rgba(0, 0, 0, .05);
  117.             box-shadow: 0 1px 2px rgba(0, 0, 0, .05);
  118.         }
  119.  
  120.         .form-signin .form-signin-heading,
  121.         .form-signin .checkbox {
  122.             margin-bottom: 10px;
  123.         }
  124.  
  125.         .form-signin input[type="text"],
  126.         .form-signin input[type="password"] {
  127.             font-size: 16px;
  128.             height: auto;
  129.             margin-bottom: 15px;
  130.             padding: 7px 9px;
  131.         }
  132.     </style>
  133.  
  134. </head>
  135. <body>
  136. <div class="container">
  137.     <form name="myForm" class="form-signin" action="login" method="post" onsubmit="return checkForm()">
  138.         <h2 class="form-signin-heading"><font color="gray">宿舍管理系统</font></h2>
  139.         <input id="userName" name="userName" value="${user.userName }" type="text" class="input-block-level"
  140.                placeholder="账号">
  141.         <input id="password" name="password" value="${user.password }" type="password" class="input-block-level"
  142.                placeholder="密码">
  143.         <label class="radio inline">
  144.             <input id="admin" type="radio" name="userType" value="admin" checked/> 系统管理员
  145.         </label>
  146.         <label class="radio inline">
  147.             <input id="dormManager" type="radio" name="userType" value="dormManager" ${userType==2?'checked':''} />
  148.             宿舍管理员
  149.         </label>
  150.         <label class="radio inline">
  151.             <input id="student" type="radio" name="userType" value="student"  ${userType==3?'checked':''}/> 学生
  152.         </label>
  153.         <label class="checkbox">
  154.             <input id="remember" name="remember" type="checkbox" value="remember-me" ${remember==1?'checked':''}>记住我
  155.             &nbsp;&nbsp;&nbsp;&nbsp; <font id="error" color="red">${error }</font>
  156.         </label>
  157.         <button class="btn btn-large btn-primary" type="submit">登录</button>
  158.         &nbsp;&nbsp;&nbsp;&nbsp;
  159.         <button class="btn btn-large btn-primary" type="button">重置</button>
  160.  
  161.         <p align="center" style="padding-top: 15px;">版权所有2021</p>
  162.     </form>
  163. </div>
  164. </body>
  165. </html>

mainAdmin.jsp

  1. <%@ page language="java" contentType="text/html; charset=utf-8"
  2.          pageEncoding="utf-8" %>
  3. <html lang="zh">
  4. <head>
  5.     <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.     <title>宿舍管理系统</title>
  8.     <link href="${pageContext.request.contextPath}/style/dorm.css" rel="stylesheet">
  9.     <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap.css" rel="stylesheet">
  10.     <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap-responsive.css" rel="stylesheet">
  11.     <link href="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/css/bootstrap-datetimepicker.min.css"
  12.           rel="stylesheet" media="screen">
  13.     <link rel="stylesheet" type="text/css"
  14.           href="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstra.css">
  15.     <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.js"></script>
  16.     <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.dataTables.js"></script>
  17.     <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/bootstrap.min.js"></script>
  18.     <script type="text/javascript"
  19.             src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstrap.js"></script>
  20.     <script type="text/javascript"
  21.             src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/bootstrap-datetimepicker.js"
  22.             charset="UTF-8"></script>
  23.     <script type="text/javascript"
  24.             src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/locales/bootstrap-datetimepicker.fr.js"
  25.             charset="UTF-8"></script>
  26.     <script src="${pageContext.request.contextPath}/bootstrap/js/bootstrap.js"></script>
  27.  
  28.     <script type="text/javascript">
  29.         $(document).ready(function () {
  30.             $("#DataTables_Table_0_wrapper .row-fluid").remove();
  31.         });
  32.     </script>
  33.     <style type="text/css">
  34.         .bs-docs-sidenav {
  35.             background-color: #fff;
  36.             border-radius: 6px;
  37.             box-shadow: 0 1px 4px rgba(0, 0, 0, 0.067);
  38.             padding: 0;
  39.             width: 228px;
  40.         }
  41.  
  42.         .bs-docs-sidenav > li > a {
  43.             border: 1px solid #e5e5e5;
  44.             display: block;
  45.             padding: 8px 14px;
  46.             margin: 0 0 -1px;
  47.         }
  48.  
  49.         .bs-docs-sidenav > li:first-child > a {
  50.             border-radius: 6px 6px 0 0;
  51.         }
  52.  
  53.         .bs-docs-sidenav > li:last-child > a {
  54.             border-radius: 0 0 6px 6px;
  55.         }
  56.  
  57.         .bs-docs-sidenav > .active > a {
  58.             border: 0 none;
  59.             box-shadow: 1px 0 0 rgba(0, 0, 0, 0.1) inset, -1px 0 0 rgba(0, 0, 0, 0.1) inset;
  60.             padding: 9px 15px;
  61.             position: relative;
  62.             text-shadow: 0 1px 0 rgba(0, 0, 0, 0.15);
  63.             z-index: 2;
  64.         }
  65.  
  66.         .bs-docs-sidenav .icon-chevron-right {
  67.             float: right;
  68.             margin-right: -6px;
  69.             margin-top: 2px;
  70.             opacity: 0.25;
  71.         }
  72.  
  73.         .bs-docs-sidenav > li > a:hover {
  74.             background-color: #f5f5f5;
  75.         }
  76.  
  77.         .bs-docs-sidenav a:hover .icon-chevron-right {
  78.             opacity: 0.5;
  79.         }
  80.  
  81.         .bs-docs-sidenav .active .icon-chevron-right, .bs-docs-sidenav .active a:hover .icon-chevron-right {
  82.             background-image: url("../img/glyphicons-halflings-white.png");
  83.             opacity: 1;
  84.         }
  85.     </style>
  86.  
  87. </head>
  88. <body>
  89. <div class="container-fluid" style="padding-right: 0px;padding-left: 0px;">
  90.     <div region="north" style="height: 100px;background-image: url('images/bg.jpg')">
  91.         <div align="left" style="width: 80%;height:100px ;float: left;padding-top: 40px;padding-left: 30px;"><font
  92.                 color="white" size="6">宿舍管理系统</font></div>
  93.         <div style="padding-top: 70px;padding-right: 20px;">当前用户：&nbsp;<font color="red">${currentUser.userName }</font>
  94.         </div>
  95.     </div>
  96. </div>
  97. <div class="container-fluid">
  98.     <div class="row-fluid">
  99.         <div class="span2 bs-docs-sidebar">
  100.             <ul class="nav nav-list bs-docs-sidenav">
  101.                 <li><a href="blank"><i class="icon-chevron-right"></i>首页</a></li>
  102.                 <li><a href="dormManager?action=list"><i class="icon-chevron-right"></i>宿舍管理员管理</a></li>
  103.                 <li><a href="student?action=list"><i class="icon-chevron-right"></i>学生管理</a></li>
  104.                 <li><a href="dormBuild?action=list"><i class="icon-chevron-right"></i>宿舍楼管理</a></li>
  105.                 <li><a href="record?action=list"><i class="icon-chevron-right"></i>缺勤记录</a></li>
  106.                 <li><a href="password?action=preChange"><i class="icon-chevron-right"></i>修改密码</a></li>
  107.                 <li><a href="login.jsp"><i class="icon-chevron-right"></i>退出系统</a></li>
  108.             </ul>
  109.         </div>
  110.         <div class="span10">
  111.             <jsp:include page="${mainPage==null?'admin/blank.jsp':mainPage}"></jsp:include>
  112.         </div>
  113.     </div>
  114. </div>
  115. </body>
  116. </html>

mainManager.jsp

  1. <%@ page language="java" contentType="text/html; charset=utf-8"
  2.          pageEncoding="utf-8" %>
  3. <html lang="zh">
  4. <head>
  5.     <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.     <title>宿舍管理系统</title>
  8.     <link href="${pageContext.request.contextPath}/style/dorm.css" rel="stylesheet">
  9.     <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap.css" rel="stylesheet">
  10.     <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap-responsive.css" rel="stylesheet">
  11.     <link href="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/css/bootstrap-datetimepicker.min.css"
  12.           rel="stylesheet" media="screen">
  13.     <link rel="stylesheet" type="text/css"
  14.           href="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstra.css">
  15.     <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.js"></script>
  16.     <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.dataTables.js"></script>
  17.     <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/bootstrap.min.js"></script>
  18.     <script type="text/javascript"
  19.             src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstrap.js"></script>
  20.     <script type="text/javascript"
  21.             src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/bootstrap-datetimepicker.js"
  22.             charset="UTF-8"></script>
  23.     <script type="text/javascript"
  24.             src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/locales/bootstrap-datetimepicker.fr.js"
  25.             charset="UTF-8"></script>
  26.     <script src="${pageContext.request.contextPath}/bootstrap/js/bootstrap.js"></script>
  27.  
  28.     <script type="text/javascript">
  29.         $(document).ready(function () {
  30.             $("#DataTables_Table_0_wrapper .row-fluid").remove();
  31.         });
  32.     </script>
  33.     <style type="text/css">
  34.         .bs-docs-sidenav {
  35.             background-color: #fff;
  36.             border-radius: 6px;
  37.             box-shadow: 0 1px 4px rgba(0, 0, 0, 0.067);
  38.             padding: 0;
  39.             width: 228px;
  40.         }
  41.  
  42.         .bs-docs-sidenav > li > a {
  43.             border: 1px solid #e5e5e5;
  44.             display: block;
  45.             padding: 8px 14px;
  46.             margin: 0 0 -1px;
  47.         }
  48.  
  49.         .bs-docs-sidenav > li:first-child > a {
  50.             border-radius: 6px 6px 0 0;
  51.         }
  52.  
  53.         .bs-docs-sidenav > li:last-child > a {
  54.             border-radius: 0 0 6px 6px;
  55.         }
  56.  
  57.         .bs-docs-sidenav > .active > a {
  58.             border: 0 none;
  59.             box-shadow: 1px 0 0 rgba(0, 0, 0, 0.1) inset, -1px 0 0 rgba(0, 0, 0, 0.1) inset;
  60.             padding: 9px 15px;
  61.             position: relative;
  62.             text-shadow: 0 1px 0 rgba(0, 0, 0, 0.15);
  63.             z-index: 2;
  64.         }
  65.  
  66.         .bs-docs-sidenav .icon-chevron-right {
  67.             float: right;
  68.             margin-right: -6px;
  69.             margin-top: 2px;
  70.             opacity: 0.25;
  71.         }
  72.  
  73.         .bs-docs-sidenav > li > a:hover {
  74.             background-color: #f5f5f5;
  75.         }
  76.  
  77.         .bs-docs-sidenav a:hover .icon-chevron-right {
  78.             opacity: 0.5;
  79.         }
  80.  
  81.         .bs-docs-sidenav .active .icon-chevron-right, .bs-docs-sidenav .active a:hover .icon-chevron-right {
  82.             background-image: url("../img/glyphicons-halflings-white.png");
  83.             opacity: 1;
  84.         }
  85.     </style>
  86.  
  87. </head>
  88. <body>
  89. <div class="container-fluid" style="padding-right: 0px;padding-left: 0px;">
  90.     <div region="north" style="height: 100px;background-image: url('images/bg.jpg')">
  91.         <div align="left" style="width: 80%;height:100px ;float: left;padding-top: 40px;padding-left: 30px;"><font
  92.                 color="white" size="6">宿舍管理系统</font></div>
  93.         <div style="padding-top: 70px;padding-right: 20px;">当前用户：&nbsp;<font color="red">${currentUser.userName }</font>
  94.         </div>
  95.     </div>
  96. </div>
  97. <div class="container-fluid">
  98.     <div class="row-fluid">
  99.         <div class="span2 bs-docs-sidebar">
  100.             <ul class="nav nav-list bs-docs-sidenav">
  101.                 <li><a href="blank"><i class="icon-chevron-right"></i>首页</a></li>
  102.                 <li><a href="student?action=list"><i class="icon-chevron-right"></i>学生查看</a></li>
  103.                 <li><a href="record?action=list"><i class="icon-chevron-right"></i>缺勤记录</a></li>
  104.                 <li><a href="password?action=preChange"><i class="icon-chevron-right"></i>修改密码</a></li>
  105.                 <li><a href="login.jsp"><i class="icon-chevron-right"></i>退出系统</a></li>
  106.             </ul>
  107.         </div>
  108.         <div class="span10">
  109.             <jsp:include page="${mainPage==null?'admin/blank.jsp':mainPage}"></jsp:include>
  110.         </div>
  111.     </div>
  112. </div>
  113. </body>
  114. </html>

mainStudent.jsp

  1. <%@ page language="java" contentType="text/html; charset=utf-8"
  2.          pageEncoding="utf-8" %>
  3. <html lang="zh">
  4. <head>
  5.     <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.     <title>宿舍管理系统</title>
  8.     <link href="${pageContext.request.contextPath}/style/dorm.css" rel="stylesheet">
  9.     <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap.css" rel="stylesheet">
  10.     <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap-responsive.css" rel="stylesheet">
  11.     <link href="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/css/bootstrap-datetimepicker.min.css"
  12.           rel="stylesheet" media="screen">
  13.     <link rel="stylesheet" type="text/css"
  14.           href="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstra.css">
  15.     <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.js"></script>
  16.     <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.dataTables.js"></script>
  17.     <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/bootstrap.min.js"></script>
  18.     <script type="text/javascript"
  19.             src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstrap.js"></script>
  20.     <script type="text/javascript"
  21.             src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/bootstrap-datetimepicker.js"
  22.             charset="UTF-8"></script>
  23.     <script type="text/javascript"
  24.             src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/locales/bootstrap-datetimepicker.fr.js"
  25.             charset="UTF-8"></script>
  26.     <script src="${pageContext.request.contextPath}/bootstrap/js/bootstrap.js"></script>
  27.  
  28.     <script type="text/javascript">
  29.         $(document).ready(function () {
  30.             $("#DataTables_Table_0_wrapper .row-fluid").remove();
  31.         });
  32.     </script>
  33.     <style type="text/css">
  34.         .bs-docs-sidenav {
  35.             background-color: #fff;
  36.             border-radius: 6px;
  37.             box-shadow: 0 1px 4px rgba(0, 0, 0, 0.067);
  38.             padding: 0;
  39.             width: 228px;
  40.         }
  41.  
  42.         .bs-docs-sidenav > li > a {
  43.             border: 1px solid #e5e5e5;
  44.             display: block;
  45.             padding: 8px 14px;
  46.             margin: 0 0 -1px;
  47.         }
  48.  
  49.         .bs-docs-sidenav > li:first-child > a {
  50.             border-radius: 6px 6px 0 0;
  51.         }
  52.  
  53.         .bs-docs-sidenav > li:last-child > a {
  54.             border-radius: 0 0 6px 6px;
  55.         }
  56.  
  57.         .bs-docs-sidenav > .active > a {
  58.             border: 0 none;
  59.             box-shadow: 1px 0 0 rgba(0, 0, 0, 0.1) inset, -1px 0 0 rgba(0, 0, 0, 0.1) inset;
  60.             padding: 9px 15px;
  61.             position: relative;
  62.             text-shadow: 0 1px 0 rgba(0, 0, 0, 0.15);
  63.             z-index: 2;
  64.         }
  65.  
  66.         .bs-docs-sidenav .icon-chevron-right {
  67.             float: right;
  68.             margin-right: -6px;
  69.             margin-top: 2px;
  70.             opacity: 0.25;
  71.         }
  72.  
  73.         .bs-docs-sidenav > li > a:hover {
  74.             background-color: #f5f5f5;
  75.         }
  76.  
  77.         .bs-docs-sidenav a:hover .icon-chevron-right {
  78.             opacity: 0.5;
  79.         }
  80.  
  81.         .bs-docs-sidenav .active .icon-chevron-right, .bs-docs-sidenav .active a:hover .icon-chevron-right {
  82.             background-image: url("../img/glyphicons-halflings-white.png");
  83.             opacity: 1;
  84.         }
  85.     </style>
  86.  
  87. </head>
  88. <body>
  89. <div class="container-fluid" style="padding-right: 0px;padding-left: 0px;">
  90.     <div region="north" style="height: 100px;background-image: url('images/bg.jpg')">
  91.         <div align="left" style="width: 80%;height:100px ;float: left;padding-top: 40px;padding-left: 30px;"><font
  92.                 color="white" size="6">宿舍管理系统</font></div>
  93.         <div style="padding-top: 70px;padding-right: 20px;">当前用户：&nbsp;<font color="red">${currentUser.userName }</font>
  94.         </div>
  95.     </div>
  96. </div>
  97. <div class="container-fluid">
  98.     <div class="row-fluid">
  99.         <div class="span2 bs-docs-sidebar">
  100.             <ul class="nav nav-list bs-docs-sidenav">
  101.                 <li><a href="blank"><i class="icon-chevron-right"></i>首页</a></li>
  102.                 <li><a href="record?action=list"><i class="icon-chevron-right"></i>缺勤记录</a></li>
  103.                 <li><a href="password?action=preChange"><i class="icon-chevron-right"></i>修改密码</a></li>
  104.                 <li><a href="login.jsp"><i class="icon-chevron-right"></i>退出系统</a></li>
  105.             </ul>
  106.         </div>
  107.         <div class="span10">
  108.             <jsp:include page="${mainPage==null?'admin/blank.jsp':mainPage}"></jsp:include>
  109.         </div>
  110.     </div>
  111. </div>
  112. </body>
  113. </html>

四、其他

1.其他系统实现

1.JavaWeb系统系列实现

Java+JSP实现学生图书管理系统

Java+JSP实现学生信息管理系统

Java+JSP实现用户信息管理系统

Java+Servlet+JSP实现航空订票系统

Java+Servlet+JSP实现新闻发布系统

Java+Servlet+JSP实现学生信息管理系统

Java+Servlet+JSP实现学生选课管理系统

Java+Servlet+JSP实现学生成绩管理系统-1

Java+Servlet+JSP实现学生成绩管理系统-2

Java+Servlet+JSP实现宠物诊所管理系统

Java+SSM+JSP实现网上考试系统

Java+SSH+JSP实现在线考试系统

Java+Springboot+Mybatis+Bootstrap+Maven实现网上商城系统

2.JavaSwing系统系列实现

Java+Swing实现斗地主游戏

Java+Swing实现图书管理系统

Java+Swing实现医院管理系统

Java+Swing实现考试管理系统

Java+Swing实现仓库管理系统-1

Java+Swing实现仓库管理系统-2

Java+Swing实现自助取款机系统

Java+Swing实现通讯录管理系统

Java+Swing实现停车场管理系统

Java+Swing实现学生信息管理系统

Java+Swing实现学生宿舍管理系统

Java+Swing实现学生选课管理系统

Java+Swing实现学生成绩管理系统

Java+Swing实现学校教材管理系统

Java+Swing实现学校教务管理系统

Java+Swing实现企业人事管理系统

Java+Swing实现电子相册管理系统

Java+Swing实现超市管理系统-TXT存储数据

Java+Swing实现自助取款机系统-TXT存储数据

Java+Swing实现宠物商店管理系统-TXT存储数据

2.获取源码

点击以下链接获取源码，数据库文件在sql文件下面。

Java+Servlet+JSP+Bootstrap+Mysql学生宿舍管理系统源码

3.运行项目

请点击以下链接，部署你的项目。

IDEA如何导入JavaWeb项目超详细视频教程

4.备注

如有侵权请联系我删除。

5.支持博主

如果您觉得此文对您有帮助，请点赞加关注加收藏。祝您生活愉快！想要获取其他资源可关注左侧微信公众号获取！

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/盐析白兔/article/detail/631620
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号