• Java项目：JSP酒店管理系统

    作者主页：夜未央5788

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    该项目主要分为酒店管理员与操作员两种角色；
    酒店管理员角色包含以下功能：
    管理员登录,用户管理、住客信息管理、客房管理、房间管理、会员等级折扣管理、订单管理等功能。

    操作员角色包含以下功能：
    用户登录,用户管理、住客信息管理、房型管理、房间管理、订单管理等功能。

    环境需要

    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

    运行截图

     

     

     

     

     

     

     

     

    相关代码 

    Handleaddadmin1

    1. package com.servlet;
    2.  
    3. import java.sql.*;
    4. import java.io.*;
    5.  
    6. import javax.servlet.*;
    7. import javax.servlet.http.*;
    8.  
    9. import com.bean.AddAdmin;
    10. import com.link.DBUtil;
    11.  
    12. public class Handleaddadmin1 extends HttpServlet {
    13.     public int t = 0;
    14.  
    15.     public void init(ServletConfig config) throws ServletException {
    16.         super.init(config);
    17.         try {
    18.             Class.forName(DBUtil.driverClass);
    19.         } catch (Exception e) {
    20.         }
    21.     }
    22.  
    23.     public void doPost(HttpServletRequest request, HttpServletResponse response)
    24.             throws ServletException, IOException {
    25.         Connection con;
    26.         Statement sql;
    27.         AddAdmin reg = new AddAdmin();
    28.         request.setAttribute("register", reg);
    29.         String aname = request.getParameter("aname").trim(),
    30.                 apwd = request.getParameter("apwd").trim(),
    31.                 atype = request.getParameter("atype").trim();
    32.         int la = 0;
    33.  
    34.         if (aname == null)
    35.             aname = "";
    36.         if (apwd == null)
    37.             apwd = "";
    38.         boolean isLD = true;
    39.         boolean boo = aname.length() > 0 && apwd.length() > 0 && isLD;
    40.         String backNews = "";
    41.  
    42.         try {
    43.             con = DBUtil.getConnection();
    44.             String insertCondition = "INSERT INTO auser (aname, apwd,atype) VALUES ('" + aname + "','" + apwd + "','" + atype + "')";
    45.  
    46.             sql = con.createStatement();
    47.             if (boo) {
    48.                 int m = sql.executeUpdate(insertCondition);
    49.                 if (m != 0) {
    50.                     backNews = "注册成功";
    51.                     reg.setAname(aname);
    52.                     reg.setApwd(apwd);
    53.                     reg.setAtype(atype);
    54.                     reg.setLa(la);
    55.                     reg.setBackNews(backNews);
    56.                 }
    57.             } else {
    58.                 backNews = "用户信息不完整请重试！";
    59.                 reg.setBackNews(backNews);
    60.             }
    61.             con.close();
    62.         } catch (SQLException exp) {
    63.  
    64.             backNews = "该用户名已使用！";
    65.             reg.setBackNews(backNews);
    66.         }
    67.  
    68.         RequestDispatcher dispatcher =
    69.                 request.getRequestDispatcher("showaddadmin1.jsp");//转发
    70.         dispatcher.forward(request, response);
    71.     }
    72.  
    73.     public void doGet(HttpServletRequest request, HttpServletResponse response)
    74.             throws ServletException, IOException {
    75.         doPost(request, response);
    76.     }
    77. }

    HandleLogin

    1. package com.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.sql.Connection;
    5. import java.sql.DriverManager;
    6. import java.sql.ResultSet;
    7. import java.sql.SQLException;
    8. import java.sql.Statement;
    9.  
    10. import javax.servlet.RequestDispatcher;
    11. import javax.servlet.ServletConfig;
    12. import javax.servlet.ServletException;
    13. import javax.servlet.http.HttpServlet;
    14. import javax.servlet.http.HttpServletRequest;
    15. import javax.servlet.http.HttpServletResponse;
    16. import javax.servlet.http.HttpSession;
    17.  
    18. import com.bean.Login;
    19. import com.link.DBUtil;
    20.  
    21. public class HandleLogin extends HttpServlet {
    22.     private RequestDispatcher dispatcher;
    23.  
    24.     public void init(ServletConfig config) throws ServletException {
    25.         super.init(config);
    26.         try {
    27.             Class.forName(DBUtil.driverClass);
    28.         }
    29.         catch (Exception e) {
    30.         }
    31.     }
    32.  
    33.     public void doPost(HttpServletRequest request, HttpServletResponse response)
    34.             throws ServletException, IOException {
    35.         Connection con;
    36.         Statement sql;
    37.         Login loginBean = null;
    38.         String backNews = "欢迎进入登陆界面！";
    39.         HttpSession session = request.getSession(true);
    40.         try {
    41.             loginBean = (Login) session.getAttribute("login");
    42.             if (loginBean == null) {
    43.                 loginBean = new Login();
    44.                 session.setAttribute("login", loginBean);
    45.             }
    46.         } catch (Exception ee) {
    47.             loginBean = new Login();
    48.             session.setAttribute("login", loginBean);
    49.         }
    50.         String aname = request.getParameter("aname").trim(), apwd = request
    51.                 .getParameter("apwd").trim(), atype = request.getParameter(
    52.                 "atype").trim();
    53.         boolean ok = loginBean.getSuccess();
    54.  
    55.         System.out.print(aname);
    56.         System.out.print(apwd);
    57.         System.out.print(atype);
    58.         if (ok == true && aname.equals(loginBean.getAname())) {
    59.             backNews = aname + "已经登录了";
    60.             loginBean.setBackNews(backNews);
    61.         } else {
    62.             boolean boo = (aname.length() > 0) && (apwd.length() > 0);
    63.             try {
    64.                 con = DBUtil.getConnection();
    65.                 String condition = "select * from auser where aname = '"
    66.                         + aname + "' and apwd = '" + apwd + "' and atype = '"
    67.                         + atype + "' ";
    68.                 sql = con.createStatement();
    69.                 if (boo) {
    70.                     ResultSet rs = sql.executeQuery(condition);
    71.                     boolean m = (rs.next());
    72.                     if (m == true && atype.equals("0")) {
    73.                         backNews = "酒店管理员登录成功！";
    74.                         loginBean.setBackNews(backNews);
    75.                         loginBean.setSuccess(true);
    76.                         loginBean.setAname(aname);
    77.                         dispatcher = request
    78.                                 .getRequestDispatcher("admin/adminMain.jsp");
    79.                     } else if (m == true && atype.equals("1")) {
    80.                         backNews = "第三方管理员登录成功！";
    81.                         loginBean.setBackNews(backNews);
    82.                         loginBean.setSuccess(true);
    83.                         loginBean.setAname(aname);
    84.                         dispatcher = request
    85.                                 .getRequestDispatcher("operator/adminMain2.jsp");
    86.                     }
    87.                     else {
    88.                         backNews = "您输入的用户名不存在，或密码不匹配";
    89.                         loginBean.setBackNews(backNews);
    90.                         loginBean.setSuccess(false);
    91.                         loginBean.setAname(aname);
    92.                         loginBean.setApwd(apwd);
    93.                         dispatcher = request
    94.                                 .getRequestDispatcher("validatelogon.jsp");
    95.                     }
    96.                 } else {
    97.                     backNews = "请输入用户名密码！";
    98.                     loginBean.setBackNews(backNews);
    99.                     loginBean.setSuccess(false);
    100.                     loginBean.setAname(aname);
    101.                     loginBean.setApwd(apwd);
    102.                     dispatcher = request
    103.                             .getRequestDispatcher("validatelogon.jsp");
    104.                 }
    105.                 con.close();
    106.             } catch (SQLException exp) {
    107.                 backNews = "" + exp;
    108.                 loginBean.setBackNews(backNews);
    109.                 dispatcher = request.getRequestDispatcher("validatelogon.jsp");
    110.             }
    111.         }
    112.  
    113.         dispatcher.forward(request, response);
    114.     }
    115.  
    116.     public void doGet(HttpServletRequest request, HttpServletResponse response)
    117.             throws ServletException, IOException {
    118.         doPost(request, response);
    119.     }
    120. }

    Handleorder

    1. package com.servlet;
    2.  
    3. import java.sql.*;
    4. import java.io.*;
    5. import javax.servlet.*;
    6. import javax.servlet.http.*;
    7.  
    8. import com.bean.*;
    9. import com.link.DBUtil;
    10.  
    11. public class Handleorder extends HttpServlet {
    12.     public int t = 0;
    13.  
    14.     public void init(ServletConfig config) throws ServletException {
    15.         super.init(config);
    16.         try {
    17.             Class.forName(DBUtil.driverClass);
    18.         } catch (Exception e) {
    19.         }
    20.     }
    21.  
    22.     public void doPost(HttpServletRequest request, HttpServletResponse response)
    23.             throws ServletException, IOException {
    24.         Connection con;
    25.         Statement sql;
    26.         AddOrder reg = new AddOrder();
    27.         request.setAttribute("register", reg);
    28.         String oname = request.getParameter("oname").trim(), ophone = request.getParameter("ophone").trim(),
    29.                 oidcard = request.getParameter("oidcard").trim(), yintime = request.getParameter("yintime").trim(),
    30.                 ortname = request.getParameter("ortname").trim(), youttime = request.getParameter("youttime").trim(),
    31.                 oday = request.getParameter("oday").trim(), ostate = request.getParameter("ostate").trim();//����
    32.         System.out.print(oname);
    33.         System.out.print(oidcard);
    34.         System.out.print(ophone);
    35.         System.out.print(yintime);
    36.         System.out.print(ortname);
    37.         System.out.print(youttime);
    38.         System.out.print(oday);
    39.         System.out.print(ostate);
    40.         int la = 0;
    41.  
    42.         if (oname == null)
    43.             oname = "";
    44.         boolean boo = oname.length() > 0;
    45.         String backNews = "";
    46.         try {
    47.             con = DBUtil.getConnection();
    48.             String insertCondition = "insert into dorder (oname,ophone,oidcard,yintime,ortname,youttime,oday,ostate) VALUES ('" + oname + "','" + ophone + "','" + oidcard + "','" + yintime + "','" + ortname + "','" + youttime + "','" + oday + "','" + ostate + "')";
    49.             System.out.println(insertCondition);
    50.             sql = con.createStatement();
    51.             if (boo) {
    52.                 int m = sql.executeUpdate(insertCondition);
    53.                 if (m != 0) {
    54.  
    55.                     backNews = "添加成功";
    56.                     reg.setBackNews(backNews);
    57.                     reg.setOname(oname);
    58.                     reg.setOidcard(oidcard);
    59.                     reg.setYintime(yintime);
    60.                     reg.setOrtname(ortname);
    61.                     reg.setYouttime(youttime);
    62.                     reg.setOday(oday);
    63.                     reg.setOstate(ostate);
    64.                     reg.setLa(la);
    65.                 }
    66.             } else {
    67.  
    68.                 backNews = "下单失败请重试！";
    69.                 reg.setBackNews(backNews);
    70.             }
    71.             con.close();
    72.         } catch (SQLException exp) {
    73.  
    74.             backNews = "下单失败！";
    75.             reg.setBackNews(backNews);
    76.         }
    77.  
    78.         RequestDispatcher dispatcher =
    79.                 request.getRequestDispatcher("showaddorder.jsp");//转发
    80.         dispatcher.forward(request, response);
    81.     }
    82.  
    83.     public void doGet(HttpServletRequest request, HttpServletResponse response)
    84.             throws ServletException, IOException {
    85.         doPost(request, response);
    86.     }
    87. }
    88.  
    89.

    Handleorder2

    1. package com.servlet;
    2.  
    3. import java.sql.*;
    4. import java.io.*;
    5. import javax.servlet.*;
    6. import javax.servlet.http.*;
    7.  
    8. import com.bean.*;
    9. import com.link.DBUtil;
    10.  
    11. public class Handleorder2 extends HttpServlet {
    12.     public int t = 0;
    13.  
    14.     public void init(ServletConfig config) throws ServletException {
    15.         super.init(config);
    16.         try {
    17.             Class.forName(DBUtil.driverClass);
    18.         } catch (Exception e) {
    19.         }
    20.     }
    21.  
    22.     public void doPost(HttpServletRequest request, HttpServletResponse response)
    23.             throws ServletException, IOException {
    24.         Connection con;
    25.         Statement sql;
    26.         AddOrder reg = new AddOrder();
    27.         request.setAttribute("register", reg);
    28.         String oname = request.getParameter("oname").trim(), ophone = request.getParameter("ophone").trim(),
    29.                 oidcard = request.getParameter("oidcard").trim(), yintime = request.getParameter("yintime").trim(),
    30.                 ortname = request.getParameter("ortname").trim(), youttime = request.getParameter("youttime").trim(),
    31.                 oday = request.getParameter("oday").trim(), ostate = request.getParameter("ostate").trim();//����
    32.         System.out.print(oname);
    33.         System.out.print(oidcard);
    34.         System.out.print(ophone);
    35.         System.out.print(yintime);
    36.         System.out.print(ortname);
    37.         System.out.print(youttime);
    38.         System.out.print(oday);
    39.         System.out.print(ostate);
    40.         int la = 0;
    41.  
    42.         if (oname == null)
    43.             oname = "";
    44.         boolean boo = oname.length() > 0;
    45.         String backNews = "";
    46.         try {
    47.             con = DBUtil.getConnection();
    48.             String insertCondition = "insert into dorder (oname,ophone,oidcard,yintime,ortname,youttime,oday,ostate) VALUES ('" + oname + "','" + ophone + "','" + oidcard + "','" + yintime + "','" + ortname + "','" + youttime + "','" + oday + "','" + ostate + "')";
    49.             System.out.println(insertCondition);
    50.             sql = con.createStatement();
    51.             if (boo) {
    52.                 int m = sql.executeUpdate(insertCondition);
    53.                 if (m != 0) {
    54.  
    55.                     backNews = "添加成功";
    56.                     reg.setBackNews(backNews);
    57.                     reg.setOname(oname);
    58.                     reg.setOidcard(oidcard);
    59.                     reg.setYintime(yintime);
    60.                     reg.setOrtname(ortname);
    61.                     reg.setYouttime(youttime);
    62.                     reg.setOday(oday);
    63.                     reg.setOstate(ostate);
    64.                     reg.setLa(la);
    65.                 }
    66.             } else {
    67.                 backNews = "下单失败请重试！";
    68.                 reg.setBackNews(backNews);
    69.             }
    70.             con.close();
    71.         } catch (SQLException exp) {
    72.  
    73.             backNews = "下单失败！";
    74.             reg.setBackNews(backNews);
    75.         }
    76.  
    77.         RequestDispatcher dispatcher =
    78.                 request.getRequestDispatcher("showaddorder2.jsp");//转发
    79.         dispatcher.forward(request, response);
    80.     }
    81.  
    82.     public void doGet(HttpServletRequest request, HttpServletResponse response)
    83.             throws ServletException, IOException {
    84.         doPost(request, response);
    85.     }
    86. }
    87.  
    88.

    updatetufang

    1. package com.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.net.URLEncoder;
    6. import java.sql.Connection;
    7. import java.sql.DriverManager;
    8. import java.sql.Statement;
    9.  
    10. import javax.servlet.ServletConfig;
    11. import javax.servlet.ServletException;
    12. import javax.servlet.http.HttpServlet;
    13. import javax.servlet.http.HttpServletRequest;
    14. import javax.servlet.http.HttpServletResponse;
    15.  
    16. import com.bean.*;
    17. import com.link.DBUtil;
    18.  
    19. public class updatetufang extends HttpServlet {
    20.     public void init(ServletConfig config) throws ServletException {
    21.  
    22.         super.init(config);
    23.         try {
    24.             Class.forName(DBUtil.driverClass);
    25.         } catch (Exception e) {
    26.         }
    27.     }
    28.  
    29.     public void doPost(HttpServletRequest request, HttpServletResponse response)
    30.             throws ServletException, IOException {
    31.         PrintWriter out = response.getWriter();
    32.         request.setCharacterEncoding("UTF-8");
    33.         response.setCharacterEncoding("UTF-8");
    34.         response.setContentType("text/html;setchar=UTF-8");
    35.         String a = URLEncoder.encode("退房成功！", "UTF-8");
    36.         String b = URLEncoder.encode("退房失败！", "UTF-8");
    37.         int i = 0;
    38.         String bno = request.getParameter("bno");
    39.  
    40.         try {
    41.             request.setCharacterEncoding("UTF-8");
    42.  
    43.             Connection con = DBUtil.getConnection();
    44.             Statement stmt = con.createStatement();
    45.             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") + "'";
    46.             System.out.println(sql);
    47.             AddOrder reg = new AddOrder();
    48.             request.setAttribute("register", reg);
    49.             String oname = request.getParameter("oname").trim(), ophone = request.getParameter("ophone").trim(),
    50.                     oidcard = request.getParameter("oidcard").trim(), yintime = request.getParameter("yintime").trim(),
    51.                     ortname = request.getParameter("ortname").trim(), youttime = request.getParameter("youttime").trim(),
    52.                     oday = request.getParameter("oday").trim(), ostate = request.getParameter("ostate").trim();//����
    53.  
    54.             String sql3 = "update room set rstate='" + request.getParameter("ostate") + "' where rid='" + request.getParameter("roomid") + "'";
    55.             int w = stmt.executeUpdate(sql3);
    56.             int q = stmt.executeUpdate(sql);
    57.             if (q == 1) {
    58.                 out.println("");
    59.                 response.setHeader("refresh", "1;url=searchorder.jsp");
    60.             } else {
    61.                 out.println("");
    62.                 response.setHeader("refresh", "1;url=searchorder.jsp");
    63.             }
    64.             stmt.close();
    65.             con.close();
    66.  
    67.         } catch (Exception e) {
    68.             out.println(e);
    69.         }
    70.     }
    71.  
    72.     public void doGet(HttpServletRequest request, HttpServletResponse response)
    73.             throws ServletException, IOException {
    74.         doPost(request, response);
    75.     }
    76. }

    如果也想学习本系统，下面领取。关注并回复：108jsp

  • 相关阅读:
    【c++每天一题】 字符串压缩
    算法 数据结构 斐波那契数列 递归实现斐波那契数列 斐波那契递归的优化 斐波那契数列递归求解 多路递归实现 斐波那契算法系列 数据结构（十一）
    Flink中Table API和SQL（一）
    linux网络编程之socket,bind，listen，connect,accept
    数组专题总结
    pycharm更改远程服务器地址
    CMakeLists中Set编译器要放在project设定之前
    用DIV+CSS技术设计的公益主题网站——防止电信诈骗（web前端网页制作课作业）
    POJ 3481、HDU 1908、AcWing 5125：双端队列 ← STL map
    Cmake小总结
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/126917112