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

    作者主页：源码空间站2022

     简介：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. 将项目中jdbc.properties配置文件中的数据库配置改为自己的配置;
    4. 运行项目，输入localhost:8080/SLH 登录 注：tomcat中配置项目路径必须为/SLH，否则会报错；
    客房经理用户名密码：admin/admin
    前台管理员用户名密码：test/123456

    客户用户名密码：jack/123456

    运行截图

    相关代码 

    CustomerServlet

    1. package com.slh.code.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.util.HashMap;
    6. import java.util.List;
    7. import java.util.Map;
    8. import java.util.regex.Pattern;
    9.  
    10. import javax.servlet.ServletException;
    11. import javax.servlet.http.HttpServlet;
    12. import javax.servlet.http.HttpServletRequest;
    13. import javax.servlet.http.HttpServletResponse;
    14.  
    15. import net.sf.json.JSONArray;
    16. import net.sf.json.JSONObject;
    17.  
    18. import com.slh.code.Users;
    19. import com.slh.code.db.DBHelper;
    20. import com.slh.util.DateUtil;
    21. import com.slh.util.Keys;
    22.  
    23. public class CustomerServlet extends HttpServlet {
    24.  
    25. 	private static final long serialVersionUID = 1L;
    26.  
    27. 	public void destroy() {
    28. 		super.destroy(); 
    29. 	}
    30. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    31. 			throws ServletException, IOException {
    32. 			this.doPost(request, response);
    33. 	}
    34.  
    35. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    36. 			throws ServletException, IOException {
    37.  
    38. 		response.setContentType("text/html");
    39. 		PrintWriter out = response.getWriter();
    40. 		
    41. 		int state = 0;
    42. 		String value = "";
    43. 		String cause = "";
    44. 		String result = "";
    45. 		
    46. 		String flag = request.getParameter("flag")==null?"":request.getParameter("flag");
    47. 		if(flag.equals("")){
    48. 			state = 0;
    49. 			result = "error:参数错误！";
    50. 		}else if(flag.equals("customerInfo")){
    51. 			result = customerInfo(request,response);
    52. 		}else if(flag.equals("motifyuser")){
    53. 			//修改用户信息
    54. 			result = motifyuser(request,response);
    55. 		}else if(flag.equals("orderRoom")){
    56. 			result = orderRoom(request,response);
    57. 		}else if(flag.equals("orderLook")){
    58. 			result = orderLook(request,response);
    59. 		}else if(flag.equals("findOrderById")){
    60. 			//获取单个订单信息
    61. 			result = findOrderById(request,response);
    62. 		}else if(flag.equals("editOrder")){
    63. 			result = editOrder(request,response);
    64. 		}else if(flag.equals("deleteOrder")){
    65. 			result = deleteOrder(request,response);
    66. 		}else if(flag.equals("message")){
    67. 			//留言
    68. 			result = message(request,response);
    69. 		}
    70. 		if(result.indexOf("error")!=-1){
    71. 			state = 0;
    72. 			value = result.substring(6,result.length());
    73. 		}else{
    74. 			state = 1;
    75. 			value =result;
    76. 		}
    77. 		System.out.println(value);
    78. 		out.println("{\"state\":\""+state+"\",\"value\":\""+value.replaceAll("\"", "'")+"\",\"cause\":\""+cause+"\"}");
    79. 		out.flush();
    80. 		out.close();
    81. 	}
    82.  
    83. 	private String findOrderById(HttpServletRequest request,
    84. 			HttpServletResponse response) {
    85. 		String id = request.getParameter("id")==null?"":request.getParameter("id");
    86. 		String uid = ((Users)request.getSession().getAttribute("user")).getId();
    87. 		
    88. 		String sql = "select o.id,o.orderno,u.name,o.occupancytime,o.ordertime,o.ordermoney,o.prepay,o.ordertype,o.roomno,o.day,o.isoccupancy from orders o,users u where u.id = o.orderuser and o.id = ? and u.id = ?";
    89. 		String fields[]={"id","orderno","name","occupancytime","ordertime","ordermoney","prepay","ordertype","roomno","day","isoccupancy"};
    90. 		Map map = new DBHelper().queryObject(sql, new String[]{id,uid}, fields);
    91. 		if(map!=null && !map.isEmpty()){
    92. 			return JSONObject.fromObject(map).toString();
    93. 		}else return "error:获取您的订单信息失败！";
    94. 		
    95. 	}
    96. 	private String motifyuser(HttpServletRequest request,
    97. 			HttpServletResponse response) {
    98. 		String id = request.getParameter("id")==null?"":request.getParameter("id");
    99. 		String age = request.getParameter("age")==null?"":request.getParameter("age");
    100. 		String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
    101. 		String realname = request.getParameter("realname")==null?"":request.getParameter("realname");
    102. 		String phone = request.getParameter("phone")==null?"":request.getParameter("phone");
    103. 		
    104. 		String reg = "^[1-9]+$";
    105. 		Pattern p = Pattern.compile(reg);
    106. 		
    107. 		
    108. 		if(id.equals("")) return "error:用户ID为空！";
    109. 		if(age.equals("")) return "error:年龄为空";
    110. 		if(!p.matcher(age).matches()) return "error:请输入正确的年龄";
    111. 		if(Integer.parseInt(age)>150) return "error:请输入真实的年龄";
    112. 		if(sex.equals("")) return "error:请选择性别！";
    113. 		if(realname.equals("")) return "error:真实姓名为空！";
    114. 		if(phone.equals("")) return "error:联系方式为空";
    115. 		
    116. 		String sql = "update users set age =?,sex=?,realname=?,phone=? where id= ?";
    117. 		String params[]={age,sex,realname,phone,id};
    118. 		int rows = new DBHelper().alertData(sql, params);
    119. 		if(rows > 0){
    120. 			Users u = (Users)request.getSession().getAttribute("user");
    121. 			u.setAge(age);
    122. 			u.setSex(sex);
    123. 			u.setRealname(realname);
    124. 			u.setPhone(phone);
    125. 			return "修改信息成功！";
    126. 		} 
    127. 		else return "error:修改信息失败！";
    128. 	}
    129. 	private String message(HttpServletRequest request,
    130. 			HttpServletResponse response) {
    131. 		String id = Keys.createKey("M");
    132. 		String title = request.getParameter("title")==null?"":request.getParameter("title");
    133. 		String content = request.getParameter("content")==null?"":request.getParameter("content");
    134. 		String messageuser = ((Users)request.getSession().getAttribute("user")).getId();
    135. 		String time = DateUtil.dateFormat();
    136. 		if(title.equals("")) return "error:标题不能为空！";
    137. 		if(content.equals("")) return "error:内容不能为空！";
    138. 		
    139. 		String sql = "insert into message(id,title,content,messageuser,time)values(?,?,?,?,?)";
    140. 		
    141. 		String params[]={id,title,content,messageuser,time};
    142. 		
    143. 		int rows = new DBHelper().alertData(sql, params);
    144. 		if(rows >0) return "成功！";
    145. 		else return "error:留言失败！";
    146. 	}
    147. 	private String deleteOrder(HttpServletRequest request,
    148. 			HttpServletResponse response) {
    149. 		String id= request.getParameter("id")==null?"":request.getParameter("id");
    150. 		if(id.equals("")) return "error:订单ID不能为空！";
    151. 		
    152. 		String sql = "delete from orders where id = ?";
    153. 		String params[]={id};
    154. 		int rows = new DBHelper().alertData(sql, params);
    155. 		if(rows > 0) return "成功";
    156. 		else return "error:删除订单失败！";
    157. 	}
    158. 	private String editOrder(HttpServletRequest request,
    159. 			HttpServletResponse response) {
    160. 		String id = request.getParameter("id")==null?"":request.getParameter("id");
    161. 		String occupancytime = request.getParameter("occupancytime")==null?"":request.getParameter("occupancytime");
    162. 		String day = request.getParameter("day")==null?"":request.getParameter("day");
    163. 		if(id.equals("")) return "error:订单ID不能为空！";
    164. 		if(occupancytime.equals("")) return "error:入住时间不能为空！";
    165. 		if(day.equals("")) return "error:入住天数不能为空！";
    166. 		String sql = "update orders set occupancytime=? ,day =? where id =?";
    167. 		String params[]={occupancytime,day ,id};
    168. 		
    169. 		int rows = new DBHelper().alertData(sql, params);
    170. 		if(rows>0) return "订单修改成功";
    171. 		else return "修改订单失败！";
    172. 	}
    173. 	private String orderLook(HttpServletRequest request,
    174. 			HttpServletResponse response) {
    175. 		int page = 0;
    176. 		int pagesize = 5;
    177. 		String uid = ((Users)request.getSession().getAttribute("user")).getId();
    178. 		String prepage = request.getParameter("page")==null?"":request.getParameter("page");
    179. 		boolean p = Pattern.compile("^[0-9]+$").matcher(prepage).matches();
    180. 		if(!p) page =1;
    181. 		else if(prepage.equals("")) page =1;
    182. 		else if(p && Integer.parseInt(prepage)>0) page = Integer.parseInt(prepage);
    183. 		String sql = "select o.id,o.orderno,o.occupancytime,u.name,o.ordertime ,o.ordermoney ,o.prepay,o.ordertype,o.roomno,o.day,o.isoccupancy from orders o inner join users u where o.orderuser = u.id and u.id = ? limit "+(page-1)*pagesize+","+pagesize;
    184. 		String csql = "select count(*) count from orders o inner join users u where o.orderuser = u.id and u.id = ? ";
    185. 		String params[]={uid};
    186. 		String total = new DBHelper().queryField(csql, params, "count");
    187. 		Mapmap = null;
    188. 		if(total!=null && !total.equals("")){
    189. 			map = new HashMap();
    190. 			int totalCount = Integer.parseInt(total);
    191. 			map.put("total", total);
    192. 			map.put("prepage", page+"");
    193. 			map.put("totalPage", (totalCount%pagesize==0?totalCount/pagesize:totalCount/pagesize+1)+"");
    194. 			
    195. 			String fields[]={"id","orderno","name","occupancytime","ordertime","ordermoney","prepay","ordertype","roomno","day","isoccupancy"};
    196. 			System.out.println("sql:"+sql);
    197. 			List>list = new DBHelper().queryObjects(sql, params, fields);
    198. 			if(list!=null && list.size()>0){
    199. 				list.add(map);
    200. 				return JSONArray.fromObject(list).toString();
    201. 			}else
    202. 				return "error:没有获取到订单的信息！";
    203. 		}else return "error:没有获取到相关的订单信息！";
    204. 		
    205. 	}
    206. 	private String orderRoom(HttpServletRequest request,
    207. 			HttpServletResponse response) {
    208. 		String id = Keys.createKey("O");
    209. 		String orderno = Keys.createKey("SLH");
    210. 		String orderuser = ((Users)request.getSession().getAttribute("user")).getId();
    211. 		String ordertime = DateUtil.dateFormat();
    212. 		String ordermoney = request.getParameter("ordermoney")==null?"":request.getParameter("ordermoney");
    213. 		String ordertype = "1";
    214. 		String roomno = request.getParameter("roomno")==null?"":request.getParameter("roomno");
    215. 		String isoccupancy = "2";
    216. 		String occupancytime = request.getParameter("occupancytime")==null?"":request.getParameter("occupancytime");
    217. 		String day = request.getParameter("day")==null?"1":request.getParameter("day");
    218. 		if(roomno.equals("")) return "error:房间号不能为空！";
    219. 		if(ordermoney.equals("")) return "error:订单价格不能为空";
    220. 		if(occupancytime.equals("")) return "error:入住时间不能为空！";
    221. 		
    222. 		
    223. 		String rsql = "update rooms set isempty = 2 where roomno = ?";
    224. 		int room = new DBHelper().alertData(rsql, new String[]{roomno});
    225. 		if(room <= 0) return "error:房间的状态修改失败！";
    226. 		
    227. 		
    228. 		String sql = "insert into orders(id,orderno,orderuser,ordertime,ordermoney,ordertype,roomno,isoccupancy,occupancytime,day)values(?,?,?,?,?,?,?,?,?,?)";
    229. 		String params[]={id,orderno,orderuser,ordertime,ordermoney,ordertype,roomno,isoccupancy,occupancytime,day};
    230. 		int rows = new DBHelper().alertData(sql, params);
    231. 		if(rows > 0) return "下单成功";
    232. 		else return "error:下单失败";
    233. 	}
    234. 	private String customerInfo(HttpServletRequest request,
    235. 			HttpServletResponse response) {
    236. 		if(request.getSession().getAttribute("user")!=null)
    237. 			return JSONObject.fromObject((Users)request.getSession().getAttribute("user")).toString();
    238. 		else return "error:获取用户信息失败，session失效！";
    239. 	}
    240. 	public void init() throws ServletException {
    241.  
    242. 	}
    243.  
    244. }

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

  • 相关阅读:
    IO（输入/输出）
    Salesforce使用的数据库是什么
    30天Python入门（第十三天：深入了解Python中的列表推导式）
    echarts 容器自适应
    二维码怎么做列表？点击可跳转其他内容
    云计算-JavaAPI与Hadoop的互联的实现
    【密码加密原则三】
    10.7- 的报错整理（与linux、python相关）
    数据结构与算法概述
    （刘二大人）PyTorch深度学习实践-卷积网络（Advance）
  • 原文地址：https://blog.csdn.net/m0_74967853/article/details/128066769