RecordDao
package com.lero.dao; import com.lero.model.DormBuild; import com.lero.model.Record; 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 RecordDao { public List<Record> recordList(Connection con, Record s_record) throws Exception { List<Record> recordList = new ArrayList<Record>(); StringBuffer sb = new StringBuffer("select * from t_record t1"); if (StringUtil.isNotEmpty(s_record.getStudentNumber())) { sb.append(" and t1.studentNumber like '%" + s_record.getStudentNumber() + "%'"); } else if (StringUtil.isNotEmpty(s_record.getStudentName())) { sb.append(" and t1.studentName like '%" + s_record.getStudentName() + "%'"); } if (s_record.getDormBuildId() != 0) { sb.append(" and t1.dormBuildId=" + s_record.getDormBuildId()); } if (StringUtil.isNotEmpty(s_record.getDate())) { sb.append(" and t1.date=" + s_record.getDate()); } if (StringUtil.isNotEmpty(s_record.getStartDate())) { sb.append(" and TO_DAYS(t1.date)>=TO_DAYS('" + s_record.getStartDate() + "')"); } if (StringUtil.isNotEmpty(s_record.getEndDate())) { sb.append(" and TO_DAYS(t1.date)<=TO_DAYS('" + s_record.getEndDate() + "')"); } PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where")); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { Record record = new Record(); record.setRecordId(rs.getInt("recordId")); record.setStudentNumber(rs.getString("studentNumber")); record.setStudentName(rs.getString("studentName")); int dormBuildId = rs.getInt("dormBuildId"); record.setDormBuildId(dormBuildId); record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId)); record.setDormName(rs.getString("dormName")); record.setDate(rs.getString("date")); record.setDetail(rs.getString("detail")); recordList.add(record); } return recordList; } public List<Record> recordListWithBuild(Connection con, Record s_record, int buildId) throws Exception { List<Record> recordList = new ArrayList<Record>(); StringBuffer sb = new StringBuffer("select * from t_record t1"); if (StringUtil.isNotEmpty(s_record.getStudentNumber())) { sb.append(" and t1.studentNumber like '%" + s_record.getStudentNumber() + "%'"); } else if (StringUtil.isNotEmpty(s_record.getStudentName())) { sb.append(" and t1.studentName like '%" + s_record.getStudentName() + "%'"); } sb.append(" and t1.dormBuildId=" + buildId); if (StringUtil.isNotEmpty(s_record.getStartDate())) { sb.append(" and TO_DAYS(t1.date)>=TO_DAYS('" + s_record.getStartDate() + "')"); } if (StringUtil.isNotEmpty(s_record.getEndDate())) { sb.append(" and TO_DAYS(t1.date)<=TO_DAYS('" + s_record.getEndDate() + "')"); } PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where")); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { Record record = new Record(); record.setRecordId(rs.getInt("recordId")); record.setStudentNumber(rs.getString("studentNumber")); record.setStudentName(rs.getString("studentName")); int dormBuildId = rs.getInt("dormBuildId"); record.setDormBuildId(dormBuildId); record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId)); record.setDormName(rs.getString("dormName")); record.setDate(rs.getString("date")); record.setDetail(rs.getString("detail")); recordList.add(record); } return recordList; } public List<Record> recordListWithNumber(Connection con, Record s_record, String studentNumber) throws Exception { List<Record> recordList = new ArrayList<Record>(); StringBuffer sb = new StringBuffer("select * from t_record t1"); if (StringUtil.isNotEmpty(studentNumber)) { sb.append(" and t1.studentNumber =" + studentNumber); } if (StringUtil.isNotEmpty(s_record.getStartDate())) { sb.append(" and TO_DAYS(t1.date)>=TO_DAYS('" + s_record.getStartDate() + "')"); } if (StringUtil.isNotEmpty(s_record.getEndDate())) { sb.append(" and TO_DAYS(t1.date)<=TO_DAYS('" + s_record.getEndDate() + "')"); } PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where")); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { Record record = new Record(); record.setRecordId(rs.getInt("recordId")); record.setStudentNumber(rs.getString("studentNumber")); record.setStudentName(rs.getString("studentName")); int dormBuildId = rs.getInt("dormBuildId"); record.setDormBuildId(dormBuildId); record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId)); record.setDormName(rs.getString("dormName")); record.setDate(rs.getString("date")); record.setDetail(rs.getString("detail")); recordList.add(record); } return recordList; } public List<DormBuild> dormBuildList(Connection con) throws Exception { List<DormBuild> dormBuildList = new ArrayList<DormBuild>(); String sql = "select * from t_dormBuild"; PreparedStatement pstmt = con.prepareStatement(sql); 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 studentCount(Connection con, Student s_student)throws Exception { // StringBuffer sb = new StringBuffer("select count(*) as total from t_student t1"); // if(StringUtil.isNotEmpty(s_student.getName())) { // sb.append(" and t1.name like '%"+s_student.getName()+"%'"); // } else if(StringUtil.isNotEmpty(s_student.getStuNumber())) { // sb.append(" and t1.stuNum like '%"+s_student.getStuNumber()+"%'"); // } else if(StringUtil.isNotEmpty(s_student.getDormName())) { // sb.append(" and t1.dormName like '%"+s_student.getDormName()+"%'"); // } // if(s_student.getDormBuildId()!=0) { // sb.append(" and t1.dormBuildId="+s_student.getDormBuildId()); // } // PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where")); // ResultSet rs = pstmt.executeQuery(); // if(rs.next()) { // return rs.getInt("total"); // } else { // return 0; // } // } public Record recordShow(Connection con, String recordId) throws Exception { String sql = "select * from t_record t1 where t1.recordId=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, recordId); ResultSet rs = pstmt.executeQuery(); Record record = new Record(); if (rs.next()) { record.setRecordId(rs.getInt("recordId")); record.setStudentNumber(rs.getString("studentNumber")); record.setStudentName(rs.getString("studentName")); int dormBuildId = rs.getInt("dormBuildId"); record.setDormBuildId(dormBuildId); record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId)); record.setDormName(rs.getString("dormName")); record.setDate(rs.getString("date")); record.setDetail(rs.getString("detail")); } return record; } public int recordAdd(Connection con, Record record) throws Exception { String sql = "insert into t_record values(null,?,?,?,?,?,?)"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, record.getStudentNumber()); pstmt.setString(2, record.getStudentName()); pstmt.setInt(3, record.getDormBuildId()); pstmt.setString(4, record.getDormName()); pstmt.setString(5, record.getDate()); pstmt.setString(6, record.getDetail()); return pstmt.executeUpdate(); } public int recordDelete(Connection con, String recordId) throws Exception { String sql = "delete from t_record where recordId=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, recordId); return pstmt.executeUpdate(); } public int recordUpdate(Connection con, Record record) throws Exception { String sql = "update t_record set studentNumber=?,studentName=?,dormBuildId=?,dormName=?,detail=? where recordId=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, record.getStudentNumber()); pstmt.setString(2, record.getStudentName()); pstmt.setInt(3, record.getDormBuildId()); pstmt.setString(4, record.getDormName()); pstmt.setString(5, record.getDetail()); pstmt.setInt(6, record.getRecordId()); return pstmt.executeUpdate(); } }
StudentDao
package com.lero.dao; import com.lero.model.DormBuild; import com.lero.model.Student; 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 StudentDao { // public List<Student> studentList(Connection con, PageBean pageBean, Student s_student)throws Exception { // List<Student> studentList = new ArrayList<Student>(); // StringBuffer sb = new StringBuffer("select * from t_student t1"); // if(StringUtil.isNotEmpty(s_student.getName())) { // sb.append(" and t1.name like '%"+s_student.getName()+"%'"); // } else if(StringUtil.isNotEmpty(s_student.getStuNumber())) { // sb.append(" and t1.stuNum like '%"+s_student.getStuNumber()+"%'"); // } else if(StringUtil.isNotEmpty(s_student.getDormName())) { // sb.append(" and t1.dormName like '%"+s_student.getDormName()+"%'"); // } // if(s_student.getDormBuildId()!=0) { // sb.append(" and t1.dormBuildId="+s_student.getDormBuildId()); // } // if(pageBean != null) { // sb.append(" limit "+pageBean.getStart()+","+pageBean.getPageSize()); // } // PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where")); // ResultSet rs = pstmt.executeQuery(); // while(rs.next()) { // Student student=new Student(); // student.setStudentId(rs.getInt("studentId")); // int dormBuildId = rs.getInt("dormBuildId"); // student.setDormBuildId(dormBuildId); // student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId)); // student.setDormName(rs.getString("dormName")); // student.setName(rs.getString("name")); // student.setSex(rs.getString("sex")); // student.setStuNumber(rs.getString("stuNum")); // student.setTel(rs.getString("tel")); // student.setPassword(rs.getString("password")); // studentList.add(student); // } // return studentList; // } public static Student getNameById(Connection con, String studentNumber, int dormBuildId) throws Exception { String sql = "select * from t_student t1 where t1.stuNum=? and t1.dormBuildId=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, studentNumber); pstmt.setInt(2, dormBuildId); ResultSet rs = pstmt.executeQuery(); Student student = new Student(); if (rs.next()) { student.setName(rs.getString("name")); student.setDormBuildId(rs.getInt("dormBuildId")); student.setDormName(rs.getString("dormName")); } return student; } public List<Student> studentList(Connection con, Student s_student) throws Exception { List<Student> studentList = new ArrayList<Student>(); StringBuffer sb = new StringBuffer("select * from t_student t1"); if (StringUtil.isNotEmpty(s_student.getName())) { sb.append(" and t1.name like '%" + s_student.getName() + "%'"); } else if (StringUtil.isNotEmpty(s_student.getStuNumber())) { sb.append(" and t1.stuNum like '%" + s_student.getStuNumber() + "%'"); } else if (StringUtil.isNotEmpty(s_student.getDormName())) { sb.append(" and t1.dormName like '%" + s_student.getDormName() + "%'"); } if (s_student.getDormBuildId() != 0) { sb.append(" and t1.dormBuildId=" + s_student.getDormBuildId()); } PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where")); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { Student student = new Student(); student.setStudentId(rs.getInt("studentId")); int dormBuildId = rs.getInt("dormBuildId"); student.setDormBuildId(dormBuildId); student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId)); student.setDormName(rs.getString("dormName")); student.setName(rs.getString("name")); student.setSex(rs.getString("sex")); student.setStuNumber(rs.getString("stuNum")); student.setTel(rs.getString("tel")); student.setPassword(rs.getString("password")); studentList.add(student); } return studentList; } public boolean haveNameByNumber(Connection con, String studentNumber) throws Exception { String sql = "select * from t_student t1 where t1.stuNum=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, studentNumber); ResultSet rs = pstmt.executeQuery(); Student student = new Student(); if (rs.next()) { student.setName(rs.getString("name")); student.setDormBuildId(rs.getInt("dormBuildId")); student.setDormName(rs.getString("dormName")); return true; } return false; } public List<Student> studentListWithBuild(Connection con, Student s_student, int buildId) throws Exception { List<Student> studentList = new ArrayList<Student>(); StringBuffer sb = new StringBuffer("select * from t_student t1"); if (StringUtil.isNotEmpty(s_student.getName())) { sb.append(" and t1.name like '%" + s_student.getName() + "%'"); } else if (StringUtil.isNotEmpty(s_student.getStuNumber())) { sb.append(" and t1.stuNum like '%" + s_student.getStuNumber() + "%'"); } else if (StringUtil.isNotEmpty(s_student.getDormName())) { sb.append(" and t1.dormName like '%" + s_student.getDormName() + "%'"); } sb.append(" and t1.dormBuildId=" + buildId); PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where")); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { Student student = new Student(); student.setStudentId(rs.getInt("studentId")); int dormBuildId = rs.getInt("dormBuildId"); student.setDormBuildId(dormBuildId); student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId)); student.setDormName(rs.getString("dormName")); student.setName(rs.getString("name")); student.setSex(rs.getString("sex")); student.setStuNumber(rs.getString("stuNum")); student.setTel(rs.getString("tel")); student.setPassword(rs.getString("password")); studentList.add(student); } return studentList; } public List<DormBuild> dormBuildList(Connection con) throws Exception { List<DormBuild> dormBuildList = new ArrayList<DormBuild>(); String sql = "select * from t_dormBuild"; PreparedStatement pstmt = con.prepareStatement(sql); 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 studentCount(Connection con, Student s_student) throws Exception { StringBuffer sb = new StringBuffer("select count(*) as total from t_student t1"); if (StringUtil.isNotEmpty(s_student.getName())) { sb.append(" and t1.name like '%" + s_student.getName() + "%'"); } else if (StringUtil.isNotEmpty(s_student.getStuNumber())) { sb.append(" and t1.stuNum like '%" + s_student.getStuNumber() + "%'"); } else if (StringUtil.isNotEmpty(s_student.getDormName())) { sb.append(" and t1.dormName like '%" + s_student.getDormName() + "%'"); } if (s_student.getDormBuildId() != 0) { sb.append(" and t1.dormBuildId=" + s_student.getDormBuildId()); } PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where")); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { return rs.getInt("total"); } else { return 0; } } public Student studentShow(Connection con, String studentId) throws Exception { String sql = "select * from t_student t1 where t1.studentId=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, studentId); ResultSet rs = pstmt.executeQuery(); Student student = new Student(); if (rs.next()) { student.setStudentId(rs.getInt("studentId")); int dormBuildId = rs.getInt("dormBuildId"); student.setDormBuildId(dormBuildId); student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId)); student.setDormName(rs.getString("dormName")); student.setName(rs.getString("name")); student.setSex(rs.getString("sex")); student.setStuNumber(rs.getString("stuNum")); student.setTel(rs.getString("tel")); student.setPassword(rs.getString("password")); } return student; } public int studentAdd(Connection con, Student student) throws Exception { String sql = "insert into t_student values(null,?,?,?,?,?,?,?)"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, student.getStuNumber()); pstmt.setString(2, student.getPassword()); pstmt.setString(3, student.getName()); pstmt.setInt(4, student.getDormBuildId()); pstmt.setString(5, student.getDormName()); pstmt.setString(6, student.getSex()); pstmt.setString(7, student.getTel()); return pstmt.executeUpdate(); } public int studentDelete(Connection con, String studentId) throws Exception { String sql = "delete from t_student where studentId=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, studentId); return pstmt.executeUpdate(); } public int studentUpdate(Connection con, Student student) throws Exception { String sql = "update t_student set stuNum=?,password=?,name=?,dormBuildId=?,dormName=?,sex=?,tel=? where studentId=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, student.getStuNumber()); pstmt.setString(2, student.getPassword()); pstmt.setString(3, student.getName()); pstmt.setInt(4, student.getDormBuildId()); pstmt.setString(5, student.getDormName()); pstmt.setString(6, student.getSex()); pstmt.setString(7, student.getTel()); pstmt.setInt(8, student.getStudentId()); return pstmt.executeUpdate(); } }
UserDao
package com.lero.dao; import com.lero.model.Admin; import com.lero.model.DormManager; import com.lero.model.Student; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; public class UserDao { public Admin Login(Connection con, Admin admin) throws Exception { Admin resultAdmin = null; String sql = "select * from t_admin where userName=? and password=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, admin.getUserName()); pstmt.setString(2, admin.getPassword()); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { resultAdmin = new Admin(); resultAdmin.setAdminId(rs.getInt("adminId")); resultAdmin.setUserName(rs.getString("userName")); resultAdmin.setPassword(rs.getString("password")); resultAdmin.setName(rs.getString("name")); resultAdmin.setSex(rs.getString("sex")); resultAdmin.setTel(rs.getString("tel")); } return resultAdmin; } public DormManager Login(Connection con, DormManager dormManager) throws Exception { DormManager resultDormManager = null; String sql = "select * from t_dormmanager where userName=? and password=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, dormManager.getUserName()); pstmt.setString(2, dormManager.getPassword()); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { resultDormManager = new DormManager(); resultDormManager.setDormManagerId(rs.getInt("dormManId")); resultDormManager.setUserName(rs.getString("userName")); resultDormManager.setPassword(rs.getString("password")); resultDormManager.setDormBuildId(rs.getInt("dormBuildId")); resultDormManager.setName(rs.getString("name")); resultDormManager.setSex(rs.getString("sex")); resultDormManager.setTel(rs.getString("tel")); } return resultDormManager; } public Student Login(Connection con, Student student) throws Exception { Student resultStudent = null; String sql = "select * from t_student where stuNum=? and password=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, student.getStuNumber()); pstmt.setString(2, student.getPassword()); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { resultStudent = new Student(); resultStudent.setStudentId(rs.getInt("studentId")); resultStudent.setStuNumber(rs.getString("stuNum")); resultStudent.setPassword(rs.getString("password")); int dormBuildId = rs.getInt("dormBuildId"); resultStudent.setDormBuildId(dormBuildId); resultStudent.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId)); resultStudent.setDormName(rs.getString("dormName")); resultStudent.setName(rs.getString("name")); resultStudent.setSex(rs.getString("sex")); resultStudent.setTel(rs.getString("tel")); } return resultStudent; } public int adminUpdate(Connection con, int adminId, String password) throws Exception { String sql = "update t_admin set password=? where adminId=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, password); pstmt.setInt(2, adminId); return pstmt.executeUpdate(); } public int managerUpdate(Connection con, int managerId, String password) throws Exception { String sql = "update t_dormmanager set password=? where dormManId=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, password); pstmt.setInt(2, managerId); return pstmt.executeUpdate(); } public int studentUpdate(Connection con, int studentId, String password) throws Exception { String sql = "update t_student set password=? where studentId=?"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, password); pstmt.setInt(2, studentId); return pstmt.executeUpdate(); } }
PropertiesUtil
package com.lero.util; import java.io.IOException; import java.io.InputStream; import java.util.Properties; public class PropertiesUtil { public static String getValue(String key) { Properties prop = new Properties(); InputStream in = new PropertiesUtil().getClass().getResourceAsStream("/dorm.properties"); try { prop.load(in); } catch (IOException e) { e.printStackTrace(); } return (String) prop.get(key); } }
login.jsp
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8" %> <%@ page import="com.lero.model.Admin" %> <%@ page import="com.lero.model.DormManager" %> <%@ page import="com.lero.model.Student" %> <% if (request.getAttribute("user") == null) { String userName = null; String password = null; String userType = null; String remember = null; Cookie[] cookies = request.getCookies(); for (int i = 0; cookies != null && i < cookies.length; i++) { if (cookies[i].getName().equals("dormuser")) { userName = cookies[i].getValue().split("-")[0]; password = cookies[i].getValue().split("-")[1]; userType = cookies[i].getValue().split("-")[2]; remember = cookies[i].getValue().split("-")[3]; } } if (userName == null) { userName = ""; } if (password == null) { password = ""; } if (userType == null) { userType = ""; } else if ("admin".equals(userType)) { pageContext.setAttribute("user", new Admin(userName, password)); pageContext.setAttribute("userType", 1); } else if ("dormManager".equals(userType)) { pageContext.setAttribute("user", new DormManager(userName, password)); pageContext.setAttribute("userType", 2); } else if ("student".equals(userType)) { pageContext.setAttribute("user", new Student(userName, password)); pageContext.setAttribute("userType", 3); } if ("yes".equals(remember)) { pageContext.setAttribute("remember", 1); } } %> <html lang="zh"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>宿舍管理系统登录</title> <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap.css" rel="stylesheet"> <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap-responsive.css" rel="stylesheet"> <script src="${pageContext.request.contextPath}/bootstrap/js/jQuery.js"></script> <script src="${pageContext.request.contextPath}/bootstrap/js/bootstrap.js"></script> <script type="text/javascript"> function checkForm() { var userName = document.getElementById("userName").value; var password = document.getElementById("password").value; var userTypes = document.getElementsByName("userType"); var userType = null; for (var i = 0; i < userTypes.length; i++) { if (userTypes[i].checked) { userType = userTypes[i].value; break; } } if (userName == null || userName == "") { document.getElementById("error").innerHTML = "用户名不能为空"; return false; } if (password == null || password == "") { document.getElementById("error").innerHTML = "密码不能为空"; return false; } if (userType == null || userType == "") { document.getElementById("error").innerHTML = "请选择用户类型"; return false; } return true; } </script> <style type="text/css"> body { padding-top: 200px; padding-bottom: 40px; background-image: url('images/bg.jpg'); background-position: center; background-repeat: no-repeat; background-attachment: fixed; } .radio { padding-top: 10px; padding-bottom: 10px; } .form-signin-heading { text-align: center; } .form-signin { max-width: 300px; padding: 19px 29px 0px; margin: 0 auto 20px; background-color: #fff; border: 1px solid #e5e5e5; -webkit-border-radius: 5px; -moz-border-radius: 5px; border-radius: 5px; -webkit-box-shadow: 0 1px 2px rgba(0, 0, 0, .05); -moz-box-shadow: 0 1px 2px rgba(0, 0, 0, .05); box-shadow: 0 1px 2px rgba(0, 0, 0, .05); } .form-signin .form-signin-heading, .form-signin .checkbox { margin-bottom: 10px; } .form-signin input[type="text"], .form-signin input[type="password"] { font-size: 16px; height: auto; margin-bottom: 15px; padding: 7px 9px; } </style> </head> <body> <div class="container"> <form name="myForm" class="form-signin" action="login" method="post" onsubmit="return checkForm()"> <h2 class="form-signin-heading"><font color="gray">宿舍管理系统</font></h2> <input id="userName" name="userName" value="${user.userName }" type="text" class="input-block-level" placeholder="账号"> <input id="password" name="password" value="${user.password }" type="password" class="input-block-level" placeholder="密码"> <label class="radio inline"> <input id="admin" type="radio" name="userType" value="admin" checked/> 系统管理员 </label> <label class="radio inline"> <input id="dormManager" type="radio" name="userType" value="dormManager" ${userType==2?'checked':''} /> 宿舍管理员 </label> <label class="radio inline"> <input id="student" type="radio" name="userType" value="student" ${userType==3?'checked':''}/> 学生 </label> <label class="checkbox"> <input id="remember" name="remember" type="checkbox" value="remember-me" ${remember==1?'checked':''}>记住我 <font id="error" color="red">${error }</font> </label> <button class="btn btn-large btn-primary" type="submit">登录</button> <button class="btn btn-large btn-primary" type="button">重置</button> <p align="center" style="padding-top: 15px;">版权所有2021</p> </form> </div> </body> </html>
mainAdmin.jsp
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8" %> <html lang="zh"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>宿舍管理系统</title> <link href="${pageContext.request.contextPath}/style/dorm.css" rel="stylesheet"> <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap.css" rel="stylesheet"> <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap-responsive.css" rel="stylesheet"> <link href="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/css/bootstrap-datetimepicker.min.css" rel="stylesheet" media="screen"> <link rel="stylesheet" type="text/css" href="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstra.css"> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.js"></script> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.dataTables.js"></script> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/bootstrap.min.js"></script> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstrap.js"></script> <script type="text/javascript" src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/bootstrap-datetimepicker.js" charset="UTF-8"></script> <script type="text/javascript" src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/locales/bootstrap-datetimepicker.fr.js" charset="UTF-8"></script> <script src="${pageContext.request.contextPath}/bootstrap/js/bootstrap.js"></script> <script type="text/javascript"> $(document).ready(function () { $("#DataTables_Table_0_wrapper .row-fluid").remove(); }); </script> <style type="text/css"> .bs-docs-sidenav { background-color: #fff; border-radius: 6px; box-shadow: 0 1px 4px rgba(0, 0, 0, 0.067); padding: 0; width: 228px; } .bs-docs-sidenav > li > a { border: 1px solid #e5e5e5; display: block; padding: 8px 14px; margin: 0 0 -1px; } .bs-docs-sidenav > li:first-child > a { border-radius: 6px 6px 0 0; } .bs-docs-sidenav > li:last-child > a { border-radius: 0 0 6px 6px; } .bs-docs-sidenav > .active > a { border: 0 none; box-shadow: 1px 0 0 rgba(0, 0, 0, 0.1) inset, -1px 0 0 rgba(0, 0, 0, 0.1) inset; padding: 9px 15px; position: relative; text-shadow: 0 1px 0 rgba(0, 0, 0, 0.15); z-index: 2; } .bs-docs-sidenav .icon-chevron-right { float: right; margin-right: -6px; margin-top: 2px; opacity: 0.25; } .bs-docs-sidenav > li > a:hover { background-color: #f5f5f5; } .bs-docs-sidenav a:hover .icon-chevron-right { opacity: 0.5; } .bs-docs-sidenav .active .icon-chevron-right, .bs-docs-sidenav .active a:hover .icon-chevron-right { background-image: url("../img/glyphicons-halflings-white.png"); opacity: 1; } </style> </head> <body> <div class="container-fluid" style="padding-right: 0px;padding-left: 0px;"> <div region="north" style="height: 100px;background-image: url('images/bg.jpg')"> <div align="left" style="width: 80%;height:100px ;float: left;padding-top: 40px;padding-left: 30px;"><font color="white" size="6">宿舍管理系统</font></div> <div style="padding-top: 70px;padding-right: 20px;">当前用户： <font color="red">${currentUser.userName }</font> </div> </div> </div> <div class="container-fluid"> <div class="row-fluid"> <div class="span2 bs-docs-sidebar"> <ul class="nav nav-list bs-docs-sidenav"> <li><a href="blank"><i class="icon-chevron-right"></i>首页</a></li> <li><a href="dormManager?action=list"><i class="icon-chevron-right"></i>宿舍管理员管理</a></li> <li><a href="student?action=list"><i class="icon-chevron-right"></i>学生管理</a></li> <li><a href="dormBuild?action=list"><i class="icon-chevron-right"></i>宿舍楼管理</a></li> <li><a href="record?action=list"><i class="icon-chevron-right"></i>缺勤记录</a></li> <li><a href="password?action=preChange"><i class="icon-chevron-right"></i>修改密码</a></li> <li><a href="login.jsp"><i class="icon-chevron-right"></i>退出系统</a></li> </ul> </div> <div class="span10"> <jsp:include page="${mainPage==null?'admin/blank.jsp':mainPage}"></jsp:include> </div> </div> </div> </body> </html>
mainManager.jsp
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8" %> <html lang="zh"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>宿舍管理系统</title> <link href="${pageContext.request.contextPath}/style/dorm.css" rel="stylesheet"> <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap.css" rel="stylesheet"> <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap-responsive.css" rel="stylesheet"> <link href="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/css/bootstrap-datetimepicker.min.css" rel="stylesheet" media="screen"> <link rel="stylesheet" type="text/css" href="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstra.css"> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.js"></script> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.dataTables.js"></script> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/bootstrap.min.js"></script> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstrap.js"></script> <script type="text/javascript" src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/bootstrap-datetimepicker.js" charset="UTF-8"></script> <script type="text/javascript" src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/locales/bootstrap-datetimepicker.fr.js" charset="UTF-8"></script> <script src="${pageContext.request.contextPath}/bootstrap/js/bootstrap.js"></script> <script type="text/javascript"> $(document).ready(function () { $("#DataTables_Table_0_wrapper .row-fluid").remove(); }); </script> <style type="text/css"> .bs-docs-sidenav { background-color: #fff; border-radius: 6px; box-shadow: 0 1px 4px rgba(0, 0, 0, 0.067); padding: 0; width: 228px; } .bs-docs-sidenav > li > a { border: 1px solid #e5e5e5; display: block; padding: 8px 14px; margin: 0 0 -1px; } .bs-docs-sidenav > li:first-child > a { border-radius: 6px 6px 0 0; } .bs-docs-sidenav > li:last-child > a { border-radius: 0 0 6px 6px; } .bs-docs-sidenav > .active > a { border: 0 none; box-shadow: 1px 0 0 rgba(0, 0, 0, 0.1) inset, -1px 0 0 rgba(0, 0, 0, 0.1) inset; padding: 9px 15px; position: relative; text-shadow: 0 1px 0 rgba(0, 0, 0, 0.15); z-index: 2; } .bs-docs-sidenav .icon-chevron-right { float: right; margin-right: -6px; margin-top: 2px; opacity: 0.25; } .bs-docs-sidenav > li > a:hover { background-color: #f5f5f5; } .bs-docs-sidenav a:hover .icon-chevron-right { opacity: 0.5; } .bs-docs-sidenav .active .icon-chevron-right, .bs-docs-sidenav .active a:hover .icon-chevron-right { background-image: url("../img/glyphicons-halflings-white.png"); opacity: 1; } </style> </head> <body> <div class="container-fluid" style="padding-right: 0px;padding-left: 0px;"> <div region="north" style="height: 100px;background-image: url('images/bg.jpg')"> <div align="left" style="width: 80%;height:100px ;float: left;padding-top: 40px;padding-left: 30px;"><font color="white" size="6">宿舍管理系统</font></div> <div style="padding-top: 70px;padding-right: 20px;">当前用户： <font color="red">${currentUser.userName }</font> </div> </div> </div> <div class="container-fluid"> <div class="row-fluid"> <div class="span2 bs-docs-sidebar"> <ul class="nav nav-list bs-docs-sidenav"> <li><a href="blank"><i class="icon-chevron-right"></i>首页</a></li> <li><a href="student?action=list"><i class="icon-chevron-right"></i>学生查看</a></li> <li><a href="record?action=list"><i class="icon-chevron-right"></i>缺勤记录</a></li> <li><a href="password?action=preChange"><i class="icon-chevron-right"></i>修改密码</a></li> <li><a href="login.jsp"><i class="icon-chevron-right"></i>退出系统</a></li> </ul> </div> <div class="span10"> <jsp:include page="${mainPage==null?'admin/blank.jsp':mainPage}"></jsp:include> </div> </div> </div> </body> </html>
mainStudent.jsp
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8" %> <html lang="zh"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>宿舍管理系统</title> <link href="${pageContext.request.contextPath}/style/dorm.css" rel="stylesheet"> <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap.css" rel="stylesheet"> <link href="${pageContext.request.contextPath}/bootstrap/css/bootstrap-responsive.css" rel="stylesheet"> <link href="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/css/bootstrap-datetimepicker.min.css" rel="stylesheet" media="screen"> <link rel="stylesheet" type="text/css" href="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstra.css"> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.js"></script> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/jquery.dataTables.js"></script> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/bootstrap.min.js"></script> <script type="text/javascript" src="http://sandbox.runjs.cn/uploads/rs/238/n8vhm36h/dataTables.bootstrap.js"></script> <script type="text/javascript" src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/bootstrap-datetimepicker.js" charset="UTF-8"></script> <script type="text/javascript" src="${pageContext.request.contextPath}/bootstrap-datetimepicker-master/js/locales/bootstrap-datetimepicker.fr.js" charset="UTF-8"></script> <script src="${pageContext.request.contextPath}/bootstrap/js/bootstrap.js"></script> <script type="text/javascript"> $(document).ready(function () { $("#DataTables_Table_0_wrapper .row-fluid").remove(); }); </script> <style type="text/css"> .bs-docs-sidenav { background-color: #fff; border-radius: 6px; box-shadow: 0 1px 4px rgba(0, 0, 0, 0.067); padding: 0; width: 228px; } .bs-docs-sidenav > li > a { border: 1px solid #e5e5e5; display: block; padding: 8px 14px; margin: 0 0 -1px; } .bs-docs-sidenav > li:first-child > a { border-radius: 6px 6px 0 0; } .bs-docs-sidenav > li:last-child > a { border-radius: 0 0 6px 6px; } .bs-docs-sidenav > .active > a { border: 0 none; box-shadow: 1px 0 0 rgba(0, 0, 0, 0.1) inset, -1px 0 0 rgba(0, 0, 0, 0.1) inset; padding: 9px 15px; position: relative; text-shadow: 0 1px 0 rgba(0, 0, 0, 0.15); z-index: 2; } .bs-docs-sidenav .icon-chevron-right { float: right; margin-right: -6px; margin-top: 2px; opacity: 0.25; } .bs-docs-sidenav > li > a:hover { background-color: #f5f5f5; } .bs-docs-sidenav a:hover .icon-chevron-right { opacity: 0.5; } .bs-docs-sidenav .active .icon-chevron-right, .bs-docs-sidenav .active a:hover .icon-chevron-right { background-image: url("../img/glyphicons-halflings-white.png"); opacity: 1; } </style> </head> <body> <div class="container-fluid" style="padding-right: 0px;padding-left: 0px;"> <div region="north" style="height: 100px;background-image: url('images/bg.jpg')"> <div align="left" style="width: 80%;height:100px ;float: left;padding-top: 40px;padding-left: 30px;"><font color="white" size="6">宿舍管理系统</font></div> <div style="padding-top: 70px;padding-right: 20px;">当前用户： <font color="red">${currentUser.userName }</font> </div> </div> </div> <div class="container-fluid"> <div class="row-fluid"> <div class="span2 bs-docs-sidebar"> <ul class="nav nav-list bs-docs-sidenav"> <li><a href="blank"><i class="icon-chevron-right"></i>首页</a></li> <li><a href="record?action=list"><i class="icon-chevron-right"></i>缺勤记录</a></li> <li><a href="password?action=preChange"><i class="icon-chevron-right"></i>修改密码</a></li> <li><a href="login.jsp"><i class="icon-chevron-right"></i>退出系统</a></li> </ul> </div> <div class="span10"> <jsp:include page="${mainPage==null?'admin/blank.jsp':mainPage}"></jsp:include> </div> </div> </div> </body> </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存储数据
