基于javaweb+mysql的ssm+maven会议室预约系统(java+ssm+js+jsp+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven会议室预约系统(java+ssm+js+jsp+mysql)
项目介绍
管理员角色包含以下功能: 管理员登陆,会议室管理,预约审核管理,用户注册等功能。
用户角色包含以下功能: 用户登录,会议室查询,预约记录查询,会议室预约申请,取消预约等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:HTML+CSS+JavaScript+jsp
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/ 登录
List<Room> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
pagingVO.setTotalCount(roomService.roomCount());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = roomService.findByPaging(1);
} else {
pagingVO.setToPageNo(page);
list = roomService.findByPaging(page);
}
model.addAttribute("roomList", list);
model.addAttribute("pagingVO", pagingVO);
return "/admin/showRoom";
}
//搜索会议室
@RequestMapping(value = "/queryRoom", method = {RequestMethod.POST})
private String queryRoom(String findByName, Model model) throws Exception {
List<Room> list = roomService.findByName(findByName);
model.addAttribute("roomList", list);
return "/admin/showRoom";
}
//添加会议室页面跳转
@RequestMapping(value = "/addRoom", method = {RequestMethod.GET})
public String addRoom(Model model) throws Exception {
return "/admin/addRoom";
}
//添加会议室业务实现
@RequestMapping(value = "/addRoom", method = {RequestMethod.POST})
public String addRoom(Room room, Model model) throws Exception {
roomService.add(room);
return "redirect:/admin/showRoom";
}
// 修改会议室信息页面显示
@RequestMapping(value = "/editRoom", method = {RequestMethod.GET})
public String editRoomUI(Integer id, Model model) throws Exception {
if (id == null) {
List<Room> list = roomService.nameList();
model.addAttribute("nameList", list);
return "/ordinary/reserveRoom";
}
//预约会议室功能实现
@RequestMapping(value = "/reserveRoom", method = RequestMethod.POST)
public String reserveRoom(ReservationCustom reservationCustom) throws Exception {
reservationService.addReservation(reservationCustom);
return "redirect:/ordinary/showRecord";
}
//取消预约申请页面跳转
@RequestMapping(value = "/cancelApplication",method = RequestMethod.GET)
public String cancelApplicationUI(String user,Model model) throws Exception{
List<ReservationCustom> list=reservationService.findByUser(user);
model.addAttribute("reserveList",list);
return "/ordinary/cancelApplication";
}
//取消预约申请业务实现
@RequestMapping("/cancelApply")
public String cancelApplication(Integer id) throws Exception{
reservationService.cancelApplication(id);
return "redirect:/ordinary/showRecord";
}
}
/**
*/
@Controller
public class LoginController {
@RequestMapping("/showRecord")
public String findRecord(Model model, Integer page) throws Exception {
List<ReservationVo> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
pagingVO.setTotalCount(reservationService.reservationPassCount());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = reservationService.findRecord(1);
} else {
pagingVO.setToPageNo(page);
list = reservationService.findRecord(page);
}
model.addAttribute("recordList", list);
model.addAttribute("pagingVo", pagingVO);
return "/admin/showRecord";
}
/*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<用户信息管理>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
//添加新用户
@RequestMapping(value = "/userRegister", method = {RequestMethod.GET})
public String userRegister(Model model) throws Exception {
return "/admin/userRegister";
}
@RequestMapping(value = "/userRegister", method = RequestMethod.POST)
public String userRegister(User user) throws Exception {
if (user.getId() != null && user.getId() != "" && user.getPassword() != null && user.getPassword() != "") {
userService.addNewUser(user);
}
return "redirect:/admin/userRegister";
}
}
@RequestMapping(value = "/userRegister", method = RequestMethod.POST)
public String userRegister(User user) throws Exception {
if (user.getId() != null && user.getId() != "" && user.getPassword() != null && user.getPassword() != "") {
userService.addNewUser(user);
}
return "redirect:/admin/userRegister";
}
}
/**
*/
@Controller
@RequestMapping("/ordinary")
public class OrdinaryController {
@Resource(name = "roomServiceImpl")
private RoomService roomService;
@Resource(name = "reservationServiceImpl")
private ReservationService reservationService;
@Resource(name = "userServiceImpl")
private UserService userService;
/*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<会议室信息管理>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
// 会议室信息显示
@RequestMapping("/showRoom")
public String showRoom(Model model, Integer page) throws Exception {
List<Room> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
model.addAttribute("roomList", list);
return "/admin/showRoom";
}
//添加会议室页面跳转
@RequestMapping(value = "/addRoom", method = {RequestMethod.GET})
public String addRoom(Model model) throws Exception {
return "/admin/addRoom";
}
//添加会议室业务实现
@RequestMapping(value = "/addRoom", method = {RequestMethod.POST})
public String addRoom(Room room, Model model) throws Exception {
roomService.add(room);
return "redirect:/admin/showRoom";
}
// 修改会议室信息页面显示
@RequestMapping(value = "/editRoom", method = {RequestMethod.GET})
public String editRoomUI(Integer id, Model model) throws Exception {
if (id == null) {
return "redirect:/admin/showRoom";
}
Room room = roomService.findById(id);
model.addAttribute("roomList", room);
return "/admin/editRoom";
}
// 修改会议室信息页面处理
@RequestMapping(value = "/editRoom", method = {RequestMethod.POST})
public String editRoom(Room room) throws Exception {
roomService.updateById(room);
//重定向
return "redirect:/admin/showRoom";
}
// 删除会议室信息
@RequestMapping("/removeRoom")
public String removeRoom(Integer id) throws Exception {
if (id == null) {
//加入没有带教师id就进来的话就返回教师显示页面
return "/admin/showRoom";
}
roomService.removeById(id);
return "redirect:/admin/showRoom";
}
Room room = roomService.findById(id);
model.addAttribute("roomList", room);
return "/admin/editRoom";
}
// 修改会议室信息页面处理
@RequestMapping(value = "/editRoom", method = {RequestMethod.POST})
public String editRoom(Room room) throws Exception {
roomService.updateById(room);
//重定向
return "redirect:/admin/showRoom";
}
// 删除会议室信息
@RequestMapping("/removeRoom")
public String removeRoom(Integer id) throws Exception {
if (id == null) {
//加入没有带教师id就进来的话就返回教师显示页面
return "/admin/showRoom";
}
roomService.removeById(id);
return "redirect:/admin/showRoom";
}
/*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<会议室预约管理>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
//查询所有待审核预约记录
@RequestMapping("/showReservation")
public String findAllReservation(Model model, Integer page) throws Exception {
List<ReservationVo> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
pagingVO.setTotalCount(reservationService.reservationCount());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = reservationService.findByPaging(1);
} else {
pagingVO.setToPageNo(page);
list = reservationService.findByPaging(page);
}
model.addAttribute("reservationList", list);
model.addAttribute("pagingVO", pagingVO);
return "/admin/showReservation";
}
//搜索借用人
@RequestMapping(value = "queryUser", method = {RequestMethod.POST})
/**
*/
@Controller
@RequestMapping("/ordinary")
public class OrdinaryController {
@Resource(name = "roomServiceImpl")
private RoomService roomService;
@Resource(name = "reservationServiceImpl")
private ReservationService reservationService;
@Resource(name = "userServiceImpl")
private UserService userService;
/*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<会议室信息管理>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
// 会议室信息显示
@RequestMapping("/showRoom")
public String showRoom(Model model, Integer page) throws Exception {
List<Room> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
pagingVO.setTotalCount(roomService.roomCount());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = roomService.findByPaging(1);
} else {
pagingVO.setToPageNo(page);
list = roomService.findByPaging(page);
}
model.addAttribute("roomList", list);
model.addAttribute("pagingVO", pagingVO);
// 修改会议室信息页面处理
@RequestMapping(value = "/editRoom", method = {RequestMethod.POST})
public String editRoom(Room room) throws Exception {
roomService.updateById(room);
//重定向
return "redirect:/admin/showRoom";
}
// 删除会议室信息
@RequestMapping("/removeRoom")
public String removeRoom(Integer id) throws Exception {
if (id == null) {
//加入没有带教师id就进来的话就返回教师显示页面
return "/admin/showRoom";
}
roomService.removeById(id);
return "redirect:/admin/showRoom";
}
/*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<会议室预约管理>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
//查询所有待审核预约记录
@RequestMapping("/showReservation")
public String findAllReservation(Model model, Integer page) throws Exception {
List<ReservationVo> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
pagingVO.setTotalCount(reservationService.reservationCount());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = reservationService.findByPaging(1);
} else {
pagingVO.setToPageNo(page);
list = reservationService.findByPaging(page);
}
model.addAttribute("reservationList", list);
model.addAttribute("pagingVO", pagingVO);
return "/admin/showReservation";
}
//搜索借用人
@RequestMapping(value = "queryUser", method = {RequestMethod.POST})
private String queryUser(String findByName, Model model) throws Exception {
List<Reservation> list = reservationService.findByName(findByName);
// 会议室信息显示
@RequestMapping("/showRoom")
public String showRoom(Model model, Integer page) throws Exception {
List<Room> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
pagingVO.setTotalCount(roomService.roomCount());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = roomService.findByPaging(1);
} else {
pagingVO.setToPageNo(page);
list = roomService.findByPaging(page);
}
model.addAttribute("roomList", list);
model.addAttribute("pagingVO", pagingVO);
return "/ordinary/showRoom";
}
//搜索会议室
@RequestMapping(value = "/queryRoom", method = {RequestMethod.POST})
private String queryRoom(String findByName, Model model) throws Exception {
List<Room> list = roomService.findByName(findByName);
model.addAttribute("roomList", list);
return "/ordinary/showRoom";
}
//查询接下来的15天内所有已被预约的会议室记录
@RequestMapping("/showRecord")
public String findAllReservation(Model model, Integer page) throws Exception {
List<ReservationVo> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
pagingVO.setTotalCount(reservationService.reserveCount());
@RequestMapping("/showRecord")
public String findAllReservation(Model model, Integer page) throws Exception {
List<ReservationVo> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
pagingVO.setTotalCount(reservationService.reserveCount());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = reservationService.findAllByPaging(1);
} else {
pagingVO.setToPageNo(page);
list = reservationService.findAllByPaging(page);
}
model.addAttribute("recordList", list);
model.addAttribute("pagingVo", pagingVO);
return "/ordinary/showRecord";
}
//搜索借用人
@RequestMapping(value = "/queryByUser", method = {RequestMethod.POST})
private String queryUser(String findByName, Model model) throws Exception {
List<ReservationVo> list = reservationService.queryByUser(findByName);
model.addAttribute("recordList", list);
return "/ordinary/showRecord";
}
//预约会议室页面跳转
@RequestMapping(value = "/reserveRoom", method = RequestMethod.GET)
public String reserveRoomUI(Model model) throws Exception {
//从数据库查询出所有会议室信息回显到页面
List<Room> list = roomService.nameList();
model.addAttribute("nameList", list);
return "/ordinary/reserveRoom";
}
//预约会议室功能实现
@RequestMapping(value = "/reserveRoom", method = RequestMethod.POST)
public String reserveRoom(ReservationCustom reservationCustom) throws Exception {
reservationService.addReservation(reservationCustom);
return "redirect:/ordinary/showRecord";
}
model.addAttribute("reservationList", list);
model.addAttribute("pagingVO", pagingVO);
return "/admin/showReservation";
}
//搜索借用人
@RequestMapping(value = "queryUser", method = {RequestMethod.POST})
private String queryUser(String findByName, Model model) throws Exception {
List<Reservation> list = reservationService.findByName(findByName);
model.addAttribute("reservationList", list);
return "/admin/showReservation";
}
//同意会议室申请
@RequestMapping("/reviewReservation")
public String reviewReservation(Integer id) throws Exception {
reservationService.reviewReservation(id);
return "redirect:/admin/showReservation";
}
//查询所有审核通过预约记录
@RequestMapping("/showRecord")
public String findRecord(Model model, Integer page) throws Exception {
List<ReservationVo> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
pagingVO.setTotalCount(reservationService.reservationPassCount());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = reservationService.findRecord(1);
} else {
pagingVO.setToPageNo(page);
list = reservationService.findRecord(page);
}
model.addAttribute("recordList", list);
model.addAttribute("pagingVo", pagingVO);
return "/admin/showRecord";
}
/*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<用户信息管理>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
//添加新用户
return "redirect:/admin/showRoom";
}
// 删除会议室信息
@RequestMapping("/removeRoom")
public String removeRoom(Integer id) throws Exception {
if (id == null) {
//加入没有带教师id就进来的话就返回教师显示页面
return "/admin/showRoom";
}
roomService.removeById(id);
return "redirect:/admin/showRoom";
}
/*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<会议室预约管理>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
//查询所有待审核预约记录
@RequestMapping("/showReservation")
public String findAllReservation(Model model, Integer page) throws Exception {
List<ReservationVo> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
pagingVO.setTotalCount(reservationService.reservationCount());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = reservationService.findByPaging(1);
} else {
pagingVO.setToPageNo(page);
list = reservationService.findByPaging(page);
}
model.addAttribute("reservationList", list);
model.addAttribute("pagingVO", pagingVO);
return "/admin/showReservation";
}
//搜索借用人
@RequestMapping(value = "queryUser", method = {RequestMethod.POST})
private String queryUser(String findByName, Model model) throws Exception {
List<Reservation> list = reservationService.findByName(findByName);
model.addAttribute("reservationList", list);
return "/admin/showReservation";
}
//同意会议室申请
/**
*/
@Controller
@RequestMapping("/ordinary")
public class OrdinaryController {
@Resource(name = "roomServiceImpl")
private RoomService roomService;
@Resource(name = "reservationServiceImpl")
private ReservationService reservationService;
@Resource(name = "userServiceImpl")
private UserService userService;
/*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<会议室信息管理>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
// 会议室信息显示
@RequestMapping("/showRoom")
public String showRoom(Model model, Integer page) throws Exception {
List<Room> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
}
//搜索会议室
@RequestMapping(value = "/queryRoom", method = {RequestMethod.POST})
private String queryRoom(String findByName, Model model) throws Exception {
List<Room> list = roomService.findByName(findByName);
model.addAttribute("roomList", list);
return "/admin/showRoom";
}
//添加会议室页面跳转
@RequestMapping(value = "/addRoom", method = {RequestMethod.GET})
public String addRoom(Model model) throws Exception {
return "/admin/addRoom";
}
//添加会议室业务实现
@RequestMapping(value = "/addRoom", method = {RequestMethod.POST})
public String addRoom(Room room, Model model) throws Exception {
roomService.add(room);
return "redirect:/admin/showRoom";
}
// 修改会议室信息页面显示
@RequestMapping(value = "/editRoom", method = {RequestMethod.GET})
public String editRoomUI(Integer id, Model model) throws Exception {
if (id == null) {
return "redirect:/admin/showRoom";
}
Room room = roomService.findById(id);
model.addAttribute("roomList", room);
return "/admin/editRoom";
}
// 修改会议室信息页面处理
@RequestMapping(value = "/editRoom", method = {RequestMethod.POST})
public String editRoom(Room room) throws Exception {
roomService.updateById(room);
//重定向
return "redirect:/admin/showRoom";
}
// 删除会议室信息
@RequestMapping("/removeRoom")
public String removeRoom(Integer id) throws Exception {
if (id == null) {
return "/admin/showRoom";
}
//搜索会议室
@RequestMapping(value = "/queryRoom", method = {RequestMethod.POST})
private String queryRoom(String findByName, Model model) throws Exception {
List<Room> list = roomService.findByName(findByName);
model.addAttribute("roomList", list);
return "/admin/showRoom";
}
//添加会议室页面跳转
@RequestMapping(value = "/addRoom", method = {RequestMethod.GET})
public String addRoom(Model model) throws Exception {
return "/admin/addRoom";
}
//添加会议室业务实现
@RequestMapping(value = "/addRoom", method = {RequestMethod.POST})
public String addRoom(Room room, Model model) throws Exception {
roomService.add(room);
return "redirect:/admin/showRoom";
}
// 修改会议室信息页面显示
@RequestMapping(value = "/editRoom", method = {RequestMethod.GET})
public String editRoomUI(Integer id, Model model) throws Exception {
if (id == null) {
return "redirect:/admin/showRoom";
}
Room room = roomService.findById(id);
model.addAttribute("roomList", room);
return "/admin/editRoom";
}
// 修改会议室信息页面处理
//取消预约申请页面跳转
@RequestMapping(value = "/cancelApplication",method = RequestMethod.GET)
public String cancelApplicationUI(String user,Model model) throws Exception{
List<ReservationCustom> list=reservationService.findByUser(user);
model.addAttribute("reserveList",list);
return "/ordinary/cancelApplication";
}
//取消预约申请业务实现
@RequestMapping("/cancelApply")
public String cancelApplication(Integer id) throws Exception{
reservationService.cancelApplication(id);
return "redirect:/ordinary/showRecord";
}
}
/**
*/
@Controller
public class LoginController {
//登录跳转
@RequestMapping(value = "/login", method = {RequestMethod.GET})
public String loginUI() throws Exception {
return "../../login";
}
//登录表单处理
@RequestMapping(value = "/login", method = {RequestMethod.POST})
public String login(User user) throws Exception {
//Shiro实现登录
UsernamePasswordToken token = new UsernamePasswordToken(user.getId(),user.getPassword());
/**
*/
@Controller
@RequestMapping("/ordinary")
public class OrdinaryController {
@Resource(name = "roomServiceImpl")
private RoomService roomService;
@Resource(name = "reservationServiceImpl")
private ReservationService reservationService;
@Resource(name = "userServiceImpl")
private UserService userService;
/*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<会议室信息管理>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
// 会议室信息显示
@RequestMapping("/showRoom")
public String showRoom(Model model, Integer page) throws Exception {
List<Room> list = null;
//页码对象
PagingVO pagingVO = new PagingVO();
//设置总页数
pagingVO.setTotalCount(roomService.roomCount());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = roomService.findByPaging(1);
} else {
pagingVO.setToPageNo(page);
list = roomService.findByPaging(page);
}
model.addAttribute("roomList", list);
model.addAttribute("pagingVO", pagingVO);
return "/ordinary/showRoom";
}
//搜索会议室