Java项目：30 基于SpringBoot自习室座位预定系统

作者主页：舒克日记

���介：Java领域优质创作者、Java项目、学习资料、技术互助

文中获取源码

项目介绍

功能设计

管理员

1、用户管理

管理员可以新增、删除管理员

管理员可以删除学生

2、自习室管理

管理员可以新增自习室、设置自习室的座位数量、开放时间，对自习室进行管理

管理员可以管理学生的预订情况、可以强制退订

3、学院班级管理

管理员可以新增、修改、删除学院、班级(实际上这部分数据应该来源于教务系统)

4、个人管理

管理员可以对自己信息进行修改

学生

1、自习室管理

学生可以查看自习室座位的预定情况并进行预定

学生可以查看自己的预定情况，并退订

2、个人信息管理

学生可以修改自己的用户信息

点击查看演示视频

环境要求

1.运行环境：最好是java jdk1.8,我们在这个平台上运行的。其他版本理论上也可以。

2.IDE环境：IDEA,Eclipse,Myeclipse都可以。推荐IDEA;

3.tomcat环境：Tomcat7.x,8.X,9.x版本均可

4.硬件环境：windows7/8/10 4G内存以上；或者Mac OS;

5.是否Maven项目：是；查看源码目录中是否包含pom.xml;若包含，则为maven项目，否则为非maven.项目

6.数据库：MySql5.7/8.0等版本均可；

技术栈

• MySQL5.7

• Idea2020.3

• SpringBoot、Mybatis-plus、thymeleaf

• layui、jquery、xadmin

  使用说明

  1.使用Navicati或者其它工具，在mysql中创建对应sq文件名称的数据库，并导入项目的sql文件；

  2.使用IDEA/Eclipse/MyEclipse导入项目，修改配置，运行项目；

  3.将项目中config-propertiesi配置文件中的数据库配置改为自己的配置，然后运行；

  运行指导

  idea导入源码空间站顶目教程说明(Vindows版)-ssm篇：

  http://mtw.so/5MHvZq

  源码地址：http://codegym.top

  运行截图

  前端界面

  登录/注册页面

  管理员界面

  学生界面

  代码

  SeatServiceImpl

  package com.cxs.service.impl;import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;import com.cxs.dto.ReservationSeatDTO;import com.cxs.enums.ReservationMarkEnums;import com.cxs.mapper.ClassroomMapper;import com.cxs.mapper.ClazzMapper;import com.cxs.mapper.SeatOrderMapper;import com.cxs.mapper.StudentMapper;import com.cxs.model.Classroom;import com.cxs.model.Seat;import com.cxs.model.SeatOrder;import com.cxs.model.Student;import com.cxs.service.SeatService;import com.cxs.mapper.SeatMapper;import com.cxs.sourceBo.ClazzBo;import com.cxs.sourceBo.SeatBo;import com.cxs.sourceBo.SeatOrderBo;import com.cxs.vo.ReservationMarkVO;import com.cxs.vo.Result;import com.cxs.vo.SeatOrderDetailVO;import com.cxs.vo.SeatOrderInfoVO;import org.springframework.beans.BeanUtils;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import org.springframework.util.CollectionUtils;import java.lang.annotation.ElementType;import java.time.DayOfWeek;import java.time.Duration;import java.time.LocalDate;import java.time.LocalDateTime;import java.time.LocalTime;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;import java.util.function.Function;import java.util.stream.Collectors;/*** @author DELL* @description 针对表【t_seat(座位表)】的数据库操作Service实现* @createDate 2023-11-28 10:44:22*/@Servicepublic class SeatServiceImpl extends ServiceImpl    implements SeatService{    @Autowired    private SeatMapper seatMapper;    @Autowired    private ClassroomMapper classroomMapper;    @Autowired    private SeatOrderMapper seatOrderMapper;    @Autowired    private StudentMapper studentMapper;    @Autowired    private ClazzMapper clazzMapper;    @Override    public List getSeatListInfo(Integer id, LocalDate date) {        List childList = new ArrayList();        SeatBo bo = seatMapper.selectOrderInfoBySeatId(id, date);        if (null == bo) {            Seat seat = seatMapper.selectById(id);            bo = new SeatBo();            BeanUtils.copyProperties(seat, bo);        }        Classroom classroom = classroomMapper.selectById(bo.getClassroomId());        int start = classroom.getOpenTimeStart().getHour();        int end = classroom.getOpenTimeEnd().getHour();        List orderList = bo.getOrderList();        Map orderMap =  CollectionUtils.isEmpty(orderList) ? new HashMap() : orderList.stream().collect(Collectors.toMap(SeatOrder::getReservationMark, Function.identity(), (o1, o2) -> o1));        List reservationMarkVOList = ReservationMarkEnums.getReservationMarkVOList(start, end);        for (ReservationMarkVO reservationMarkVO : reservationMarkVOList) {            SeatOrderInfoVO v = new SeatOrderInfoVO();            v.setSeatId(bo.getId());            v.setReservationMark(reservationMarkVO.getMark());            v.setTimeRange(reservationMarkVO.getTimeRange());            v.setSno(bo.getSeatNo());            SeatOrder seatOrder = orderMap.get(reservationMarkVO.getMark());            if (null != seatOrder) {                v.setCreateTime(seatOrder.getCreateTime());                v.setFlag(Boolean.TRUE);                v.setId(seatOrder.getId());            } else {                v.setFlag(Boolean.FALSE);            }            childList.add(v);        }        return childList;    }    @Override    public void getSeatOrderInfo(Integer id, Result r) {        if (null == id) {            r.setCode(-1);            r.setMsg("id不能为空");            return;        }        SeatOrder seatOrder = seatOrderMapper.selectById(id);        if (null == seatOrder) {            r.setCode(-1);            r.setMsg("预定不存在");            return;        }        Seat seat = seatMapper.selectById(seatOrder.getSeatId());        if (null == seat) {            r.setCode(-1);            r.setMsg("座位不存在");            return;        }        Classroom classroom = classroomMapper.selectById(seat.getClassroomId());        if (null == classroom) {            r.setCode(-1);            r.setMsg("自习室不存在");            return;        }        Student student = studentMapper.selectById(seatOrder.getSno());        ClazzBo info = clazzMapper.getClazzInfoByClazzId(student.getClazzId());        List reservationMarkVOList = ReservationMarkEnums.getReservationMarkVOList(classroom.getOpenTimeStart().getHour(), classroom.getOpenTimeEnd().getHour());        Map map = CollectionUtils.isEmpty(reservationMarkVOList) ? new HashMap() : reservationMarkVOList.stream().collect(Collectors.toMap(ReservationMarkVO::getMark, Function.identity(), (o1, o2) -> o1));        SeatOrderDetailVO vo = new SeatOrderDetailVO();        BeanUtils.copyProperties(seatOrder, vo);        vo.setName(student.getName());        vo.setPhone(student.getPhone());        vo.setSex(student.getSex());        ReservationMarkVO reservationMarkVO = map.get(seatOrder.getReservationMark());        if (null != reservationMarkVO) {            vo.setTimeRange(reservationMarkVO.getTimeRange());        }        vo.setCollageName(info.getGradeName());        vo.setClazzName(info.getClazzName());        r.setData(vo);    }    @Override    public void reservationSeat(ReservationSeatDTO dto, Integer sno, Result r) {        LocalDate date = dto.getDate();        LocalDate now = LocalDate.now();        if (date.isBefore(now)) {            r.setCode(-1);            r.setMsg("该时间不可预约座位");            return;        }        if (Duration.between(LocalDateTime.of(now, LocalTime.MIN), LocalDateTime.of(date, LocalTime.MIN)).toDays() > 7L) {            r.setCode(-1);            r.setMsg("仅支持预定一周内的座位");            return;        }        LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper();        queryWrapper.eq(SeatOrder::getReservationMark, dto.getMark())                .eq(SeatOrder::getDate, dto.getDate())                .eq(SeatOrder::getSno, sno);        List seatOrders = seatOrderMapper.selectList(queryWrapper);        if (!CollectionUtils.isEmpty(seatOrders)) {            r.setCode(-1);            r.setMsg("预定失败,该时间段内您已进行预定座位,请按时去学习,把座位留给需要的同学,谢谢!");            return;        }        Seat seat = seatMapper.selectById(dto.getSeatId());        if (null == seat) {            r.setCode(-1);            r.setMsg("座位不存在");            return;        }        Classroom classroom = classroomMapper.selectById(seat.getClassroomId());        if (null == classroom) {            r.setCode(-1);            r.setMsg("自习室不存在");            return;        }        Integer openType = classroom.getOpenType();        // 0每天开放，1工作日开放2休息日开放        DayOfWeek dayOfWeek = date.getDayOfWeek();        if (openType == 0) {        } else if (openType == 1) {            if (dayOfWeek.equals(DayOfWeek.SATURDAY) || dayOfWeek.equals(DayOfWeek.SUNDAY)) {                r.setCode(-1);                r.setMsg(classroom.getName() + "自习室" + "仅工作日可定");                return;            }        } else if (openType == 2) {            if (!dayOfWeek.equals(DayOfWeek.SATURDAY) && !dayOfWeek.equals(DayOfWeek.SUNDAY)) {                r.setCode(-1);                r.setMsg(classroom.getName() + "自习室" + "仅休息日可定");                return;            }        } else {            r.setCode(-1);            r.setMsg("自习室开放时间有误");            return;        }        List reservationMarkVOList = ReservationMarkEnums.getReservationMarkVOList(classroom.getOpenTimeStart().getHour(), classroom.getOpenTimeEnd().getHour());        Map map = CollectionUtils.isEmpty(reservationMarkVOList) ? new HashMap() : reservationMarkVOList.stream().collect(Collectors.toMap(ReservationMarkVO::getMark, Function.identity(), (o1, o2) -> o1));        SeatOrder order = new SeatOrder();        order.setSeatId(dto.getSeatId());        order.setCreateTime(LocalDateTime.now());        order.setDate(dto.getDate());        ReservationMarkVO reservationMarkVO = map.get(dto.getMark());        if (reservationMarkVO == null) {            r.setCode(-1);            r.setMsg("预约时间有误");            return;        }        int hour = LocalDateTime.now().getHour();        if (date.equals(now)) {            if (reservationMarkVO.getStartTime()