基于javaweb+JSP+Servlet宿舍管理系统

基于javaweb+JSP+Servlet宿舍管理系统(超级管理员、宿舍管理员、学生)

开发工具：eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

			
			//因为查询出来的结果包括表头信息，所以要指针下移一行，看是否有查询出来的数据
			//如有数据，就进入循环体，封装该行数据
			while (rs.next()) {
				User user = new User();
				//每一行的数据封装在一个实体bean中，根据字段名获取字段值，注意该字段是什么类型，就get什么类型
				user.setId(rs.getInt("id"));
				user.setCreateUserId(rs.getInt("create_user_id"));
				user.setDisabled(rs.getInt("disabled"));
				user.setName(rs.getString("name"));
				user.setPassWord(rs.getString("passWord"));
				user.setRoleId(rs.getInt("role_id"));
				user.setSex(rs.getString("sex"));
				user.setStuCode(rs.getString("stu_code"));
				user.setTel(rs.getString("tel"));
				user.setDormBuildId(rs.getInt("dormBuildId"));
				user.setDormCode(rs.getString("dorm_Code"));
				
				return user;
			}
		} catch (SQLException e) {

import java.util.List;

import com.demo.bean.DormBuild;
import com.demo.util.ConnectionFactory;

public class DormBuildDaoImpl implements DormBuildDao {

	@Override
	public DormBuild findByName(String name) {
		//① 获取连接（数据库地址  用户名 密码）
		Connection  connection = 	ConnectionFactory.getConnection();
		PreparedStatement preparedStatement = null;
		ResultSet rs = null;
		try {
			//② 准备SQL语句
			String sql = "select * from tb_dormbuild where name = ? ";
			//③ 获取集装箱或者说是车
			 preparedStatement = connection.prepareStatement(sql);
			//索引从1开始

        <link rel="stylesheet" href="assets/qunit.css" />
        <script src="assets/qunit.js">script>
        <script src="assets/qunit-logging.js">script> 
        <script src="assets/coverage.js">script>
        <script src="assets/jquery-1.7.1.min.js">script>
        <script src="../js/bootstrap-datetimepicker.min.js">script>

        <style>
            .datetimepicker {
                /* Appended to body, abs-pos off the page */
                position: absolute;
                display: none;
                top: -9999em;
                left: -9999em;
            }
        style>

        

			//默认查询第一页，需两个参数，当前页码pageIndex，每页展示的条数  
			PageModel pageModel = new PageModel();
			if(pageIndex != null && !pageIndex.equals("")) {
				pageModel.setPageIndex(Integer.parseInt(pageIndex));
			}
			List<User> students = userService.findStudent(dormBuildId,searchType,keyword,user,pageModel);
			//获取查询处理的总数量
			Integer  totalNum = userService.findTotalNum(dormBuildId,searchType,keyword,user);
			System.out.println("totalNum:"+totalNum);
			System.out.println("students:"+students);
			
			request.setAttribute("totalNum", totalNum);
			request.setAttribute("pageIndex", pageModel.getPageIndex());
			request.setAttribute("dormBuildId", dormBuildId);
			request.setAttribute("searchType", searchType);
			request.setAttribute("keyword", keyword);
			request.setAttribute("students", students);
			request.setAttribute("mainRight", "/WEB-INF/jsp/studentList.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			
		}else if(action != null & action.equals("preAdd")) {

		
		
		if(keyword != null && !keyword.equals("") && "name".equals(searchType)) {
			//根据名字查询
			sql.append("  and  user.name like '%"+keyword.trim()+"%'");
			
		}else if(keyword != null && !keyword.equals("") && "stuCode".equals(searchType)) {
			//根据学号查询
			sql.append(" and user.stu_code = '"+keyword.trim()+"'");
			
		}else if(keyword != null && !keyword.equals("") && "dormCode".equals(searchType)) {
			//根据宿舍编号查询
			sql.append(" and user.dorm_code = '"+keyword.trim()+"'");
			
		}else if(keyword != null && !keyword.equals("") && "sex".equals(searchType)) {
			//根据性别查询
			sql.append(" and user.sex = '"+keyword.trim()+"'");
		}
		else if(keyword != null && !keyword.equals("") && "tel".equals(searchType)) {
			//根据电话号码查询
			sql.append(" and user.tel = '"+keyword.trim()+"'");

	}

	@Override
	public void saveStudent(User user) {
		//① 获取连接（数据库地址  用户名 密码）
		Connection  connection = 	ConnectionFactory.getConnection();
		PreparedStatement preparedStatement = null;
		ResultSet  resultSet = null;
		try {
			//② 准备SQL语句
			//IFNULL(参数1，参数2)函数，用于判断第一个表达式是否为NULL，如果为NULL，则返回第二个参数的值。如果不为NULL，就返回第一个参数的值
			String sql = "INSERT INTO tb_user(NAME,PASSWORD,stu_code,dorm_code,sex,tel,dormBuildId,role_id,create_user_id) "
					+ "VALUE(?,?,?,?,?,?,?,?,?)";
			
			//③ 获取集装箱或者说是车  Statement.RETURN_GENERATED_KEYS指定返回生成的注解
			 preparedStatement = connection.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
			preparedStatement.setString(1, user.getName());
			preparedStatement.setString(2, user.getPassWord());
			preparedStatement.setString(3, user.getStuCode());
			preparedStatement.setString(4, user.getDormCode());
			preparedStatement.setString(5, user.getSex());
			preparedStatement.setString(6, user.getTel());

			sql.append(" and user.dormBuildId in (");
			for (int i = 0; i < builds.size(); i++) {
				sql.append(builds.get(i).getId()+",");
			}
			
			//删除最后一个,
			sql.deleteCharAt(sql.length()-1);
			sql.append(")");
		}
		
		System.out.println("sql:"+sql);
		
		return userDao.findTotalNum(sql.toString());
	}
	@Override
	public void updateStudent(User studentUpdate) {
		userDao.updateStudent(studentUpdate);
	}

			System.out.println("======保存宿舍管理员=========");
			String name = request.getParameter("name");
			String passWord = request.getParameter("passWord");
			String sex = request.getParameter("sex");
			String tel = request.getParameter("tel");
			//获取复选框中用户选中的宿舍楼
			String[] dormBuildIds = request.getParameterValues("dormBuildId");
			System.out.println("name:"+name+"  pass:"+passWord+"  sex:"+sex+"  tel:"+tel+"  dormBuildIds:"+Arrays.toString(dormBuildIds));
			
			if(id == null || id.equals("")) {
				//保存
				User user = new User(name, passWord, sex, tel, null, 1);
				user.setDisabled(0);
				
				//当前登录的用户

						<td>${record.user.dormCode}td>
						<td>${record.remark}td>
							<c:if test="${session_user.roleId != 2 }">
								<td>
									<button class="btn btn-mini btn-success" type="button" onclick="javascript:window.location='record.action?action=preUpdate&id=${record.id }'">修改button>
									<c:if test="${record.disabled ==0}">
										<button class="btn btn-mini btn-danger" type="button" onclick="deleteOrAcive(${record.id },1)">删除button>
									c:if>
									<c:if test="${record.disabled ==1}">
										<button class="btn btn-mini btn-danger" type="button" onclick="deleteOrAcive(${record.id },0)">激活button>
									c:if>
								td>
							c:if>

					dormBuildIdInputs[i].checked = true;
				}
				
			});
		}
	}
	
	
	$(document).ready(function(){
		$("#dormManager").addClass("active");
	});
script>
<div class="data_list">
		<div class="data_list_title">

}
package com.demo.servlet;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.demo.service.DormBuildService;
import com.demo.service.DormBuildServiceImpl;
import com.demo.bean.DormBuild;

/**
 * Servlet implementation class DormBuildServlet
 */
@WebServlet("/dormBuild.action")
public class DormBuildServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

---

运行环境

Java≥8、Tomcat≥8.0、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

技术框架

JSP Servlet MySQL JDBC Tomcat CSS JavaScript

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

超级管理员：登录退出、宿舍管理员管理、学生管理、宿舍楼管理、缺勤管理、修改密码

宿舍管理员：登录退出、学生管理、缺勤管理

学生：登录退出、缺勤查看

超级管理员

宿舍管理员

学生

---