Java源码社

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

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

350023442402

360023442402

370023442402

380023442402

390023442402

400023442402

基于javaweb的JSP+Servlet酒店管理系统(java+jsp+bootstrap+jquery+servlet+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版本； 6.是否Maven项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目

技术栈

  1. 后端：Servlet 2. 前端：JSP+bootstrap+jQuery

使用说明

  1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中link/DBUtil.java配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入localhost:8080/ 登录 酒店管理员账号/密码：admin/admin 操作员账号/密码：aa/aa

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



public class updatetufang extends HttpServlet {
    public void init(ServletConfig config) throws ServletException {

        super.init(config);
        try {
            Class.forName(DBUtil.driverClass);
        } catch (Exception e) {
        }
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        PrintWriter out = response.getWriter();
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;setchar=UTF-8");
        String a = URLEncoder.encode("退房成功！", "UTF-8");
        String b = URLEncoder.encode("退房失败！", "UTF-8");
        int i = 0;
        String bno = request.getParameter("bno");

        try {
            request.setCharacterEncoding("UTF-8");

            Connection con = DBUtil.getConnection();
            Statement stmt = con.createStatement();
            String sql = "update dorder set oid='" + request.getParameter("bno") + "',omoney='" + request.getParameter("omoney") + "',youttime='" + request.getParameter("youttime") + "',yintime='" + request.getParameter("yintime") + "',souttime='" + request.getParameter("souttime") + "',sintime='" + request.getParameter("sintime") + "',oname='" + request.getParameter("oname") + "',ophone='" + request.getParameter("ophone") + "',oidcard='" + request.getParameter("oidcard") + "',ovip='" + request.getParameter("ovip") + "',ostate='" + request.getParameter("ostate") + "',oday='" + request.getParameter("oday") + "',ortname='" + request.getParameter("ortname") + "',roomid='" + request.getParameter("roomid") + "' where oid='" + request.getParameter("bno") + "'";
            System.out.println(sql);
            AddOrder reg = new AddOrder();
            request.setAttribute("register", reg);
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
                i = stmt.executeUpdate("delete from auser where aname='" + bno + "'");
                if (i == 1) {
                    out.println("<script language='javascript'>");
                    out.println("alert(decodeURIComponent('" + a + "') )");
                    out.println("location.href='adminlist.jsp'");
                    out.println("</script>");
                } else {
                    out.println("<script language='javascript'>");
                    out.println("alert(decodeURIComponent('" + b + "') )");
                    out.println("location.href='adminlist.jsp'");
                    out.println("</script>");
                }
                con.close();
                stmt.close();
            } else {
                out.println("<script language='javascript'>");
                out.println("alert(decodeURIComponent('" + b + "') )");
                out.println("location.href='adminlist.jsp'");
                out.println("</script>");
            }
        } catch (Exception e) {
            // TODO: handle exception
        }
    }

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }
}
package com.servlet;





public class DelRoomType extends HttpServlet {

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
        }

        RequestDispatcher dispatcher =
                request.getRequestDispatcher("showadduser.jsp");
        dispatcher.forward(request, response);
    }

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }
}
package com.servlet;



public class Handleaddroom extends HttpServlet {
    public int t = 0;

    public void init(ServletConfig config) throws ServletException {
        super.init(config);
        try {
            Class.forName(DBUtil.driverClass);
        } catch (Exception e) {
        }
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        Connection con;
        Statement sql;
        AddRoom reg = new AddRoom();
        request.setAttribute("register", reg);
        String rid = request.getParameter("rid").trim(),
                rdescribe = request.getParameter("rdescribe").trim(),
                rtname = request.getParameter("rtname").trim(), rstate = request.getParameter("rstate").trim();
        System.out.print(rid);
        System.out.print(rdescribe);
        System.out.print(rtname);
        System.out.print(rstate);
        int la = 0;

        if (rid == null)
            rid = "";
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

    super.init(config);
    try {
        Class.forName(DBUtil.driverClass);
    } catch (Exception e) {
    }
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    PrintWriter out = response.getWriter();
    request.setCharacterEncoding("UTF-8");
    response.setCharacterEncoding("UTF-8");
    response.setContentType("text/html;setchar=UTF-8");
    String a = URLEncoder.encode("退房成功！", "UTF-8");
    String b = URLEncoder.encode("退房失败！", "UTF-8");
    int i = 0;
    String bno = request.getParameter("bno");

    try {
        request.setCharacterEncoding("UTF-8");

        Connection con = DBUtil.getConnection();
        Statement stmt = con.createStatement();
        String sql = "update dorder set oid='" + request.getParameter("bno") + "',omoney='" + request.getParameter("omoney") + "',youttime='" + request.getParameter("youttime") + "',yintime='" + request.getParameter("yintime") + "',souttime='" + request.getParameter("souttime") + "',sintime='" + request.getParameter("sintime") + "',oname='" + request.getParameter("oname") + "',ophone='" + request.getParameter("ophone") + "',oidcard='" + request.getParameter("oidcard") + "',ovip='" + request.getParameter("ovip") + "',ostate='" + request.getParameter("ostate") + "',oday='" + request.getParameter("oday") + "',ortname='" + request.getParameter("ortname") + "',roomid='" + request.getParameter("roomid") + "' where oid='" + request.getParameter("bno") + "'";
        System.out.println(sql);
        AddOrder reg = new AddOrder();
        request.setAttribute("register", reg);
        String oname = request.getParameter("oname").trim(), ophone = request.getParameter("ophone").trim(),
                oidcard = request.getParameter("oidcard").trim(), yintime = request.getParameter("yintime").trim(),
                ortname = request.getParameter("ortname").trim(), youttime = request.getParameter("youttime").trim(),

        String sql3 = "update room set rstate='" + request.getParameter("ostate") + "' where rid='" + request.getParameter("roomid") + "'";
        int w = stmt.executeUpdate(sql3);
        int q = stmt.executeUpdate(sql);
        if (q == 1) {
            response.setHeader("refresh", "1;url=searchorder.jsp");
        } else {
            response.setHeader("refresh", "1;url=searchorder.jsp");
        }
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 b = URLEncoder.encode("修改失败！", "UTF-8");
        int i = 0;
        String bno = request.getParameter("bno");

        try {
            request.setCharacterEncoding("utf-8");

            Connection con = DBUtil.getConnection();
            Statement stmt = con.createStatement();
            String sql = "update dorder set oid='" + bno + "',omoney='" + request.getParameter("omoney") + "',youttime='" + request.getParameter("youttime") + "',yintime='" + request.getParameter("yintime") + "',souttime='" + request.getParameter("souttime") + "',sintime='" + request.getParameter("sintime") + "',oname='" + request.getParameter("oname") + "',ophone='" + request.getParameter("ophone") + "',oidcard='" + request.getParameter("oidcard") + "',ovip='" + request.getParameter("ovip") + "',ostate='" + request.getParameter("ostate") + "',oday='" + request.getParameter("oday") + "',ortname='" + request.getParameter("ortname") + "',roomid='" + request.getParameter("roomid") + "' where oid='" + request.getParameter("bno") + "'";
            System.out.println(sql);
            AddOrder reg = new AddOrder();
            request.setAttribute("register", reg);
            String oname = request.getParameter("oname").trim(), ophone = request.getParameter("ophone").trim(),
                    oidcard = request.getParameter("oidcard").trim(), yintime = request.getParameter("yintime").trim(),
                    ortname = request.getParameter("ortname").trim(), youttime = request.getParameter("youttime").trim(),
                    oday = request.getParameter("oday").trim(), ostate = request.getParameter("ostate").trim();

            String sql2 = "insert into user (name,phone,idcard,vip) values ('" + oname + "','" + ophone + "','" + oidcard + "','0')";
            String sql3 = "update room set rstate='" + request.getParameter("ostate") + "' where rid='" + request.getParameter("roomid") + "'";
            int w = stmt.executeUpdate(sql3);
//            int z = stmt.executeUpdate(sql2);
            int q = stmt.executeUpdate(sql);
            if (q == 1) {
                response.setHeader("refresh", "1;url=searchorder.jsp");
            } else {
                response.setHeader("refresh", "1;url=searchorder.jsp");
            }
            stmt.close();
            con.close();
        } catch (Exception e) {
            out.println(e);
        }
    }

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }
}
package com.servlet;

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 b = URLEncoder.encode("修改失败！", "UTF-8");
        int i = 0;
        String bno = request.getParameter("bno");

        try {
            request.setCharacterEncoding("utf-8");

            Connection con = DBUtil.getConnection();
            Statement stmt = con.createStatement();
            String sql = "update dorder set oid='" + request.getParameter("bno") + "',omoney='" + request.getParameter("omoney") + "',youttime='" + request.getParameter("youttime") + "',yintime='" + request.getParameter("yintime") + "',souttime='" + request.getParameter("souttime") + "',sintime='" + request.getParameter("sintime") + "',oname='" + request.getParameter("oname") + "',ophone='" + request.getParameter("ophone") + "',oidcard='" + request.getParameter("oidcard") + "',ovip='" + request.getParameter("ovip") + "',ostate='" + request.getParameter("ostate") + "',oday='" + request.getParameter("oday") + "',ortname='" + request.getParameter("ortname") + "',roomid='" + request.getParameter("roomid") + "' where oid='" + request.getParameter("bno") + "'";
            System.out.println(sql);
            AddOrder reg = new AddOrder();
            request.setAttribute("register", reg);
            String oname = request.getParameter("oname").trim(), ophone = request.getParameter("ophone").trim(),
                    oidcard = request.getParameter("oidcard").trim(), yintime = request.getParameter("yintime").trim(),
                    ortname = request.getParameter("ortname").trim(), youttime = request.getParameter("youttime").trim(),

            String sql2 = "insert into user (name,phone,idcard,vip) values ('" + oname + "','" + ophone + "','" + oidcard + "','0')";
            String sql3 = "update room set rstate='" + request.getParameter("ostate") + "' where rid='" + request.getParameter("roomid") + "'";
            int w = stmt.executeUpdate(sql3);
            int z = stmt.executeUpdate(sql2);
            int q = stmt.executeUpdate(sql);
            if (q == 1) {
                response.setHeader("refresh", "1;url=searchorder.jsp");
            } else {
                response.setHeader("refresh", "1;url=searchorder.jsp");
            }
            stmt.close();
            con.close();

        } catch (Exception e) {
            // TODO: handle exception
        }
    }

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }
}
package com.servlet;

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