Java源码社

基于javaweb的SSM+Maven会议室预约系统(java+ssm+js+jsp+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

030023172402

040023172402

050023172402

060023172402

070023172402

080023172402

基于javaweb的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版本；

技术栈

  1. 后端：Spring+SpringMVC+Mybatis 2. 前端：HTML+CSS+JavaScript+jsp

使用说明

  1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入localhost:8080/ 登录

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
    }

    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) {
        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";
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
/**
 */
@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";
    }

    //搜索会议室
    @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);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

/**
 */
@Controller
@RequestMapping("/admin")
public class AdminController {

    @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 "/admin/showRoom";
    }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
    }

    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";
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
    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";
}

//同意会议室申请
@RequestMapping("/reviewReservation")
public String reviewReservation(Integer id) throws Exception {
    reservationService.reviewReservation(id);
    return "redirect:/admin/showReservation";
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40


/**
 */
@Controller
@RequestMapping("/admin")
public class AdminController {

    @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 "/admin/showRoom";
    }

项目链接：
https://javayms.github.io?id=232322092805200mb
https://javayms.pages.dev?id=232322092805200mb