Java项目：30 基于SpringBoot自习室座位预定系统
温馨提示：这篇文章已超过385天没有更新，请注意相关的内容是否还可用！
作者主页：舒克日记
简介：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 */ @Service public 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()
免责声明：我们致力于保护作者版权，注重分享，被刊用文章因无法核实真实出处，未能及时与作者取得联系，或有版权异议的，请联系管理员，我们会立即处理! 部分文章是来自自研大数据AI进行生成,内容摘自(百度百科,百度知道,头条百科,中国民法典,刑法,牛津词典,新华词典,汉语词典,国家院校,科普平台)等数据,内容仅供学习参考,不准确地方联系删除处理! 图片声明：本站部分配图来自人工智能系统AI生成,觅知网授权图片,PxHere摄影无版权图库和百度，360，搜狗等多加搜索引擎自动关键词搜索配图，如有侵权的图片，请第一时间联系我们，邮箱：ciyunidc@ciyunshuju.com。本站只作为美观性配图使用,无任何非法侵犯第三方意图,一切解释权归图片著作权方,本站不承担任何责任。如有恶意碰瓷者,必当奉陪到底严惩不贷!
