Java源码社

基于javaweb的SSM+Mavenktv管理系统KTV(java+ssm+jsp+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

460023322402

470023322402

490023322402

500023322402

510023322402

520023322402

530023322402

540023322402

550023322402

基于javaweb的SSM+Mavenktv管理系统KTV(java+ssm+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
        model.addAttribute("allfood", allFood);
        model.addAttribute("rows", Math.ceil(allFood.size() / 6.0));
        model.addAttribute("succeed", true);
        model.addAttribute("msg", result.getMessage());
        return "consume";
    }

}
package cn.edu.sysu.Web;



/**
 * Project name: KTV-System
 * Package name: cn.edu.sysu.Web
 * Description: VIP相关页面的Controller
 */

@Controller
@RequestMapping("/vip")
public class VIPController {

    @Autowired
    private VIPService vipService;

    @RequestMapping(method = RequestMethod.GET)
    public String VIPManagement() {
        return "vipManagement";
    }

    @RequestMapping(value = "/all", method = RequestMethod.GET)
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
    if (name != null) {
        result.add(name);
    }
    if (phone != null) {
        result.add(phone);
    }
    if (result.size() == 0) {
        model.addAttribute("msg", "未查询到相关会员信息！");
        return "vipQuery";
    }
    model.addAttribute("list", result);
    model.addAttribute("rows", Math.ceil(result.size() / 6.0));
    model.addAttribute("title", "查询结果");
    return "vipList";
}

@RequestMapping(value = "/add", method = RequestMethod.GET)
public String addVIP() {
    return "vipAdd";
}

@RequestMapping(value = "/add")
public String doVIPAdd(HttpServletRequest request, Model model) throws UnsupportedEncodingException {
    request.setCharacterEncoding("UTF-8");
    String cname = request.getParameter("cname");
    String phone = request.getParameter("phone");
    VIP vip = new VIP();
    vip.setCname(cname);
    vip.setPhone(phone);
    OperationStatus result;
    try {
        result = vipService.addVIP(vip);
    } catch (KTVException e) {
        model.addAttribute("succeed", false);
        model.addAttribute("msg", e.getMessage());
        return "vipAdd";
    }
    model.addAttribute("succeed", true);
    model.addAttribute("msg", result.getMessage());
    return "vipAdd";
}

@RequestMapping(value = "/delete")
public String doVIPDelete(HttpServletRequest request, Model model) throws UnsupportedEncodingException {
    request.setCharacterEncoding("UTF-8");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20



/**
 * Project name: KTV-System
 * Package name: cn.edu.sysu.Web
 * Description: Room相关页面的Controller
 */

@Controller
@RequestMapping("/room")
public class RoomController {

    @Autowired
    private RoomService roomService;

    @Autowired
    private OrderService orderService;

    @Autowired
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

/**
 * Project name: KTV-System
 * Package name: cn.edu.sysu.Web
 * Description: VIP相关页面的Controller
 */

@Controller
@RequestMapping("/vip")
public class VIPController {

    @Autowired
    private VIPService vipService;

    @RequestMapping(method = RequestMethod.GET)
    public String VIPManagement() {
        return "vipManagement";
    }

    @RequestMapping(value = "/all", method = RequestMethod.GET)
    public String allVIP(Model model) {
        List<VIP> allVIP = vipService.queryAllVIP();
        model.addAttribute("list", allVIP);
        model.addAttribute("rows", Math.ceil(allVIP.size() / 6.0));
        model.addAttribute("title", "所有会员");
        return "vipList";
    }

    @RequestMapping(value = "/query", method = RequestMethod.GET)
    public String queryVIP() {
        return "vipQuery";
    }

    @RequestMapping(value = "/query")
    public String doVIPQuery(HttpServletRequest request, Model model) throws UnsupportedEncodingException {
        request.setCharacterEncoding("UTF-8");
        String keyWord = request.getParameter("key");
        if (keyWord.equals("")) {
            model.addAttribute("msg", "请输入有效字符！");
            return "vipQuery";
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
}

@RequestMapping(value = "/query", method = RequestMethod.GET)
public String queryRoom() {
    return "roomQuery";
}

@RequestMapping(value = "/query")
public String doRoomQuery(HttpServletRequest request, Model model) throws UnsupportedEncodingException {
    request.setCharacterEncoding("UTF-8");
    String keyWord = request.getParameter("key");

    if (keyWord.length() == 1 && String.valueOf(keyWord.charAt(0)).equals("空")) {
        List<Room> result = roomService.queryEmptyRoom();
        if (result == null) {
            model.addAttribute("msg", "未查询到空房间！");
            return "roomQuery";
        }
        model.addAttribute("list", result);
        model.addAttribute("rows", Math.ceil(result.size() / 6.0));
        model.addAttribute("title", "查询结果");
        return "roomList";
    } else if (keyWord.length() == 2 && String.valueOf(keyWord.charAt(0)).equals("空")) {
        List<Room> result = roomService.queryEmptyRoomByType(String.valueOf(keyWord.charAt(1)));
        if (result == null) {
            model.addAttribute("msg", "未查询到类型为" + String.valueOf(keyWord.charAt(1)) + "空房间！");
            return "roomQuery";
        }
        model.addAttribute("list", result);
        model.addAttribute("rows", Math.ceil(result.size() / 6.0));
        model.addAttribute("title", "查询结果");
        return "roomList";
    } else if (keyWord.length() == 2 && !String.valueOf(keyWord.charAt(0)).equals("空")) {
        Room room = roomService.queryRoom(Integer.parseInt(keyWord.substring(1)), keyWord.substring(0, 1));
        if (room == null) {
            model.addAttribute("msg", "未查询到相关房间信息！");
            return "roomQuery";
        }
        model.addAttribute("room", room);
        model.addAttribute("title", "房间详情");
        return "roomDetail";
    } else {
        model.addAttribute("msg", "请输入有效字符！");
        return "roomQuery";
    }

}

@RequestMapping(value = "/add", method = RequestMethod.GET)
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
    String roomType = request.getParameter("roomType");
    String roomNum = request.getParameter("roomNum");
    Room room = new Room();
    room.setType(roomType);
    room.setPrice(roomType.equals("L") ? 200.0 : roomType.equals("M") ? 130.0 : 80.0);
    room.setId(Integer.parseInt(roomNum));
    OperationStatus result;
    try {
        result = roomService.addRoom(room);
    } catch (KTVException e) {
        model.addAttribute("succeed", false);
        model.addAttribute("msg", e.getMessage());
        return "roomAdd";
    }
    model.addAttribute("succeed", true);
    model.addAttribute("msg", result.getMessage());
    return "roomAdd";
}

@RequestMapping(value = "/{type}-{id}/detail", method = RequestMethod.GET)
public String detail(@PathVariable("id") Integer id,
                     @PathVariable("type") String type, Model model) {
    if (id == null) {
        return "redirect:room/all";
    }
    Room room = roomService.queryRoom(id, type);
    if (room == null) {
        return "redirect:room/all";
    }
    model.addAttribute("room", room);
    model.addAttribute("title", "房间详情");
    return "roomDetail";
}

@RequestMapping(value = "/booking")
public String bookingRoom(HttpServletRequest request, Model model) throws UnsupportedEncodingException, JsonProcessingException {
    request.setCharacterEncoding("UTF-8");
    String roomType = request.getParameter("roomType");
    String roomNum = request.getParameter("roomNum");
    String hours = request.getParameter("hours");
    String cname = request.getParameter("cname");
    Room room = roomService.queryRoom(Integer.parseInt(roomNum), roomType);

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