Java源码社

基于javaweb的JSP+Servlet酒店预定管理系统(java+jsp+bootstrap+servlet+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

471623332808

481623332808

491623332808

511623332808

521623332808

531623332808

541623332808

551623332808

561623332808

基于javaweb的JSP+Servlet酒店预定管理系统(java+jsp+bootstrap+servlet+mysql)

管理员：
admin 123456

注意：前台预定后，需要后台管理员审核通过，前台才能查询到预定信息

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
            if(roomId!=null){//不是空是评论信息
                queryListByRoomId(req,resp);
            }else{
                resp.setContentType("application/json;chartset=utf-8");
                resp.getWriter().print(JSON.toJSONString(R.ok()));
            }
            break;
        default:
            query(req,resp);
            break;
    }
}


/**
 * 查询评论信息根据房间id
 */
public void queryListByRoomId(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    String roomID=req.getParameter("roomId");
    try {
        List<CommentInfo> list=   commentInfoService.queryListByRoomID(Integer.parseInt(roomID));
        resp.setContentType("application/json;chartset=utf-8");
        Map map=new HashMap();
        map.put("list",list);
        String jsons= JSON.toJSONString(map);
        resp.getWriter().print(jsons);
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    }
}

/**
 * 查询主页中的房间列表信息
 * @param req
 * @param resp
 * @throws ServletException
 * @throws IOException
 */
public void query(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    List<RoomInfo> list=roomInfoService.queryRoomListByStatus(0);
    req.setAttribute("list",list);
    req.getRequestDispatcher("room.jsp").forward(req,resp);
}



/**
 * 根据前端传值获取对应的值信息，并把值信息封装到RoomInfo 对象中
 * @param req
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
     */
    public void query(HttpServletRequest req,
                      HttpServletResponse resp) throws ServletException, IOException {

        //接收前端的传值  当前页 每页显示记录数
        String currPage=req.getParameter("page");
        String limit=req.getParameter("limit");
        String content=req.getParameter("content")==null?null:req.getParameter("content");
        //判断
        if(currPage==null || "".equals(currPage.trim())){
            currPage="1";
        }

        if(limit==null || "".equals(limit.trim())){
            limit="10";
        }

        //通过service层接口拿到分页对象
        PageBean<RoomInfo> pageBean=null;
        try {
            pageBean = service.getPage(currPage,limit,content);
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

        //转到前端
        JsonObject object=new JsonObject();
        object.setCode(0);
        object.setMsg("");
        object.setCount(pageBean.getTotalCount());
        object.setData(pageBean.getPageData());

        resp.setContentType("application/json;chartset=utf-8");
        String jsons= JSON.toJSONString(object);
        resp.getWriter().print(jsons);
    }
}


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
            String password=req.getParameter("password");
            service.updatePasswordByUserId(password,Integer.parseInt(id2));
            resp.setContentType("application/json;chartset=utf-8");
            resp.getWriter().print(JSON.toJSONString(R.ok()));
            break;
        case "delete":
            String ids=req.getParameter("ids");
            //把接收到的字符串转成集合
            List<String> idList= Arrays.asList(ids.split(","));
            for(String id:idList){
                service.deleteById(Integer.parseInt(id));
            }
            resp.setContentType("application/json;chartset=utf-8");
            resp.getWriter().print(JSON.toJSONString(R.ok()));
            break;
        case "queryId":
            String id=req.getParameter("id");
            UserInfo info1= null;
            try {
                info1 = service.queryByID(Integer.parseInt(id));
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            req.setAttribute("info",info1);
            resp.setContentType("text/html;chartset=utf-8");
            req.getRequestDispatcher("admin/user/update.jsp").forward(req,resp);
            break;
        case "update":
            UserInfo roomInfo=getValues(req);
            boolean bs=service.updateInfo(roomInfo);
            resp.setContentType("application/json;chartset=utf-8");
            String jsons2=JSON.toJSONString(R.fail("修改失败了..."));
            if(bs){
                jsons2=JSON.toJSONString(R.ok());
            }
            resp.getWriter().print(jsons2);
            break;
        default:
            query(req,resp);
            break;
    }

}


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


@WebServlet("/commentServlet")
public class CommentServlet extends HttpServlet {

    CommentInfoService service=new CommentInfoServiceImpl();
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String flag=req.getParameter("flag")==null?"":req.getParameter("flag");
        switch (flag){
            case "delete":
                String ids=req.getParameter("ids");
                //把接收到的字符串转成集合
                List<String> idList= Arrays.asList(ids.split(","));
                for(String id:idList){
                    service.deleteById(Integer.parseInt(id));
                }
                resp.setContentType("application/json;chartset=utf-8");
                resp.getWriter().print(JSON.toJSONString(R.ok()));
                break;
            default:
                query(req,resp);
                break;
        }

    }


    /**
     * 查询
     */
    public void query(HttpServletRequest req,
                      HttpServletResponse resp) throws ServletException, IOException {

        //接收前端的传值  当前页 每页显示记录数
        String currPage=req.getParameter("page");
        String limit=req.getParameter("limit");
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
                //存放类型名称
                List <String> listName=new ArrayList<>();
                List <Integer> listData=new ArrayList<>();
                for(DataCount dataCount:dataCountList){
                    listName.add("'"+dataCount.getName()+"'");
                    listData.add(dataCount.getCounts());
                }
                req.setAttribute("listName",listName);
                req.setAttribute("listData",listData);
                req.getRequestDispatcher("admin/tongji/index.jsp").forward(req,resp);
            } catch (Exception throwables) {
                throwables.printStackTrace();
            }
            break;
        default:
            query(req,resp);
            break;
    }

}

/**
 * 上传图片接口
 */
public void uploadFile(HttpServletRequest req,
                       HttpServletResponse resp) throws Exception {
    //文件上传处理器
    FileItemFactory factory=new DiskFileItemFactory();
    ServletFileUpload upload=new ServletFileUpload(factory);
    //解析请求信息
    List items=upload.parseRequest(req);
    Iterator it=items.iterator();
    String fileName="";
    if(it.hasNext()){
       FileItem item= (FileItem) it.next();
        fileName=item.getName();
       //获取文件的后缀名
       String suffName= fileName.substring(fileName.lastIndexOf("."));
       //随机生成文件名称
       fileName= UUID.randomUUID()+suffName;
       req.setAttribute("fileName",fileName);
       //真实上传到的文件地址  注意文件夹存在
       String basePath="D:\\images";
       File f=new File(basePath);

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