基于javaweb+mysql的jsp+servlet酒店客房管理系统(java+jsp+html+bootstrap+jquery+servlet+mysql)

最新推荐文章于 2024-11-11 16:57:31 发布
最新推荐文章于 2024-11-11 16:57:31 发布
阅读量130 收藏
点赞数
文章标签： java mysql spring boot
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_71000466/article/details/132028958
版权

基于javaweb+mysql的jsp+servlet酒店客房管理系统(java+jsp+html+bootstrap+jquery+servlet+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的JSP+Servlet酒店客房管理系统(java+jsp+html+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. 将项目中jdbc.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入localhost:8080/SLH 登录 注：tomcat中配置项目路径必须为/SLH，否则会报错； 客房经理用户名密码：admin/admin 前台管理员用户名密码：test/123456 客户用户名密码：jack/123456
		
		if(result.indexOf("error")!=-1){
			state = 0;
			value = result.substring(6,result.length());
		}else{
			state = 1;
			value =result;
		}
		System.out.println(value.replace("\"", "'"));
		out.println("{\"state\":\""+state+"\",\"value\":\""+value.replace("\"", "'")+"\",\"cause\":\""+cause+"\"}");
		out.flush();
		out.close();
		
		
	}

	private String messages(HttpServletRequest request,
			HttpServletResponse response) {
		String sql = "select m.id,m.title,m.content,u.name as user,m.time from message m,users u  where m.messageuser = u.id";
		List<Map<String, String>>list = new DBHelper().queryObjects(sql, null, new String[]{"id","title","content","user","time"});
		if(list!=null && list.size()>0){
			return JSONArray.fromObject(list).toString();
		}else  return "error:未获取到留言信息";
	}

	private String findRoom(HttpServletRequest request,
			HttpServletResponse response) {
		String id = request.getParameter("id")==null?"":request.getParameter("id");
		if(id.equals("")) return "error:ID不能为空！";
		String sql = "select * from rooms where id = ?";
		String params[]={id};
		String fields[]={"id","roomno","type","price","isempty","des","pic"};
		Map<String, String> map = new DBHelper().queryObject(sql, params, fields);
		if(map!=null && !map.isEmpty()){
			if(map.containsKey("pic") &&( map.get("pic")==null || map.get("pic").equals(""))){
				map.put("pic", "");
			}else{
				map.put("pic",request.getRequestURL().toString().split("SLH")[0]+"SLH"+"/"+ImageUtil.PATH+"/"+map.get("pic"));
			}
			return JSONObject.fromObject(map).toString();
		}else
			return "error:房间信息未查到！";
	}

	private String findManager(HttpServletRequest request,
			HttpServletResponse response) {
		String uid = request.getParameter("uid")==null?"":request.getParameter("uid");
		if(uid.equals("")){

		if(map!=null && !map.isEmpty()){
			return JSONObject.fromObject(map).toString();
		}else
			return "error:用户信息未获取到！";
	}

	private String  addDiscount(HttpServletRequest request,
			HttpServletResponse response) {
		String id = Keys.createKey("D");
		String name = request.getParameter("name")==null?"":request.getParameter("name");
		String desc = request.getParameter("desc")==null?"":request.getParameter("desc");
		String userID = ((Users)request.getSession().getAttribute("user")).getId();
		String time = DateUtil.dateFormat();
		if(name.equals("")){
			return "error:名称不能为空！";
		}
		if(desc.equals("")){
			return "error:请填写描述....";
		}
		
		String sql="insert into discount values(?,?,?,?,?)";
		String params[]={id,name,desc,userID,time};
		int rows = new DBHelper().alertData(sql, params);
		if(rows>0){
			return "成功！";
		}else
			return "error:添加失败！";
		
	}

	private String discounts(HttpServletRequest request,
			HttpServletResponse response) {
		String sql="select d.id,d.name,d.desc,u.name  as username,d.time from discount as d inner join users as u where d.releaseuser = u.id";
		String fields[]={"id","name","desc","username","time"};
		List<Map<String,String>> list = new DBHelper().queryObjects(sql, null, fields);
		if(list!=null && list.size()>0){
			return JSONArray.fromObject(list).toString();
		}else
			return "error:没有获取到优惠信息！";
	}

	private String editRoom(HttpServletRequest request,
			HttpServletResponse response) {
		String id = request.getParameter("id")==null?"":request.getParameter("id");
		String roomno = request.getParameter("roomno")==null?"":request.getParameter("roomno");
		String type = request.getParameter("type")==null?"":request.getParameter("type");
		String price = request.getParameter("price")==null?"":request.getParameter("price");
		String isempty = request.getParameter("isempty")==null?"":request.getParameter("isempty");
		String desc = request.getParameter("des")==null?"":request.getParameter("des");

			u.setIdcard(map.get("idcard"));
			request.getSession().setAttribute("user", u);
			return "登陆成功";
		}else{
			return "error:用户密码错误！";
		}
	}
	public String register(HttpServletRequest request, HttpServletResponse response){
		
		String name = request.getParameter("name")==null?"":request.getParameter("name");
		String password = request.getParameter("password")==null?"":request.getParameter("password");
		String realname = request.getParameter("realname")==null?"":request.getParameter("realname");
		String idcard = request.getParameter("idcard")==null?"":request.getParameter("idcard");
		String phone = request.getParameter("phone")==null?"":request.getParameter("phone");
		
		String cname = "select name from users where name = ?";
		String cnname = new DBHelper().queryField(cname, new String[]{name}, "name");
		if(cnname!=null && !cnname.equals("")) return "error:用户名重复，请修改";
		
		if(name.equals(""))return "error:用户名为空！";
		if(password.equals("")) return "error:密码为空！";
		if(realname.equals("")) return "error:真实姓名为空！";
		if(idcard.equals("")) return "error:身份证号码为空！";
		if(phone.equals("")) return "error:手机号码为空！";
		
		String id = Keys.createKey("U");
		
		String sql = "insert into users(id,name,password,realname,idcard,phone,role,isdelete) values(?,?,?,?,?,?,?,?)";
		String params[]={id,name,password,realname,idcard,phone,"3","0"};
		int rows = new DBHelper().alertData(sql, params);
		if(rows>0){
			return "注册成功";
		}else{
			return "error:注册失败！";
		}
	}

	public void init() throws ServletException {

	}
	public static void main(String[] args) {

		int state = 1;
		String value = "";
		String cause = "";
		String result = "";
		response.setContentType("text/html,charset=utf-8");
		PrintWriter out = response.getWriter();
		
		String flag = request.getParameter("flag")==null?"":request.getParameter("flag");
		if(flag.equals("")){
			result = "error:参数错误！";
		}else if (flag.equals("managers")){
			//前台管理员列表
			result = managers(request, response);
		}else if(flag.equals("addManager")){
			//添加
			result = addManager(request,response);
		}else if(flag.equals("deleteManager")){
			//删除
			result = deleteManager(request,response);
		}else if(flag.equals("editManager")){
			//编辑
			result = editManager(request,response);
		}else if (flag.equals("rooms")){
			//客房列表
			result = rooms(request,response);
		}else if (flag.equals("addRoom")){
			//添加客房
			result = addRoom(request,response);
		}else if(flag.equals("deleteRoom")){
			//删除客房
			result = deleteRoom(request,response);
		}else if (flag.equals("editRoom")){
			//编辑客房
			result = editRoom(request,response);
		}else if (flag.equals("discounts")){
			//优惠折扣列表
			result = discounts(request,response);
		}else if(flag.equals("addDiscount")){
			//添加折扣
			result = addDiscount(request,response);
		}else if(flag.equals("findManager")){
			result = findManager(request,response);
		}else if(flag.equals("findRoom")){
			result = findRoom(request,response);
		}else if(flag.equals("messages")){
			//留言查看
			result = messages(request,response);
		}
		
		if(result.indexOf("error")!=-1){
			state = 0;

}
package com.slh.code.servlet;

public class CustomerServlet extends HttpServlet {

	private static final long serialVersionUID = 1L;

	public void destroy() {
		super.destroy(); 
	}
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
			this.doPost(request, response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		
		int state = 0;
		String value = "";
		String cause = "";
		String result = "";
		
		String flag = request.getParameter("flag")==null?"":request.getParameter("flag");
		if(flag.equals("")){
			state = 0;
			result = "error:参数错误！";
		}else if(flag.equals("customerInfo")){

			String name = request.getParameter("name")==null?"":request.getParameter("name");
			String password = request.getParameter("password")==null?"":request.getParameter("password");
			String realname = request.getParameter("realname")==null?"":request.getParameter("realname");
			String idcard = request.getParameter("idcard")==null?"":request.getParameter("idcard");
			String phone = request.getParameter("phone")==null?"":request.getParameter("phone");
			
			String cname = "select name from users where name = ?";
			String cnname = new DBHelper().queryField(cname, new String[]{name}, "name");
			if(cnname!=null && !cnname.equals("")) return "error:用户名重复，请修改";
			
			if(name.equals(""))return "error:用户名为空！";
			if(password.equals("")) return "error:密码为空！";
			if(realname.equals("")) return "error:真实姓名为空！";
			if(idcard.equals("")) return "error:身份证号码为空！";
			if(phone.equals("")) return "error:手机号码为空！";
			
			id = Keys.createKey("U");
			
			String sql = "insert into users(id,name,password,realname,idcard,phone,role,isdelete) values(?,?,?,?,?,?,?,?)";
			String params[]={id,name,password,realname,idcard,phone,"3","0"};
			int rows = new DBHelper().alertData(sql, params);
			if(rows <= 0) return "error:添加用户失败！";
		}else{
			//用户注册过
			id = uid;
		}
		String oid = Keys.createKey("O");
		String orderno = Keys.createKey("SLH");
		String orderuser = id;
		String handleuser = ((Users)request.getSession().getAttribute("user")).getId();
		String ordertime = DateUtil.dateFormat();
		String ordermoney = request.getParameter("ordermoney")==null?"":request.getParameter("ordermoney");
		String ordertype =  request.getParameter("ordertype")==null?"":request.getParameter("ordertype");
		String roomno = request.getParameter("roomno")==null?"":request.getParameter("roomno");
		String occupancytime = request.getParameter("occupancytime")==null?"":request.getParameter("occupancytime");
		String day = request.getParameter("day")==null?"1":request.getParameter("day");
		String isoccupancy = request.getParameter("isoccupancy")==null?"1":request.getParameter("isoccupancy");
		String prepay = request.getParameter("prepay")==null?"1":request.getParameter("prepay");
		if(roomno.equals("")) return "error:房间号不能为空！";
		if(ordermoney.equals("")) return "error:订单价格不能为空";
		if(occupancytime.equals("")) return "error:入住时间不能为空！";
		if(isoccupancy.equals("")) isoccupancy="1";
		if(ordertype.equals("3") && prepay.equals("")) return "error:前台订房需要预交定金！";
		
		String rsql = "update rooms set isempty = ? where roomno = ?";
		String isempty = "1";

		super.destroy(); 
	}

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

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		    PrintWriter out =  response.getWriter();
			int state = 0;
			String value = "";
			String cause = "";
			String flag = request.getParameter("flag")==null?"":request.getParameter("flag").replaceAll("[\t\n\r]", "");
			
			if(flag.equals("login")){
				//登陆
				String result = this.login(request, response);
				if(result.indexOf("error")!=-1){
					state = 0;
					value = result.substring(6, result.length());
				}else{
					state = 1;
					value = result;
				}
			}else if(flag.equals("register")){
				//注册
				String result = this.register(request, response);
				if(result.indexOf("error")!=-1){
					state = 0;
					value = result.substring(6, result.length());
				}else{
					state = 1;
					value = result;
				}
			} else if(flag.equals("exit")){
				//退出系统
					request.getSession().removeAttribute("user");
					if(request.getSession().getAttribute("user")!=null && !request.getSession().getAttribute("user").equals("") ){
						state = 0;
						value = "退出系统失败！";
					}else{
						state = 1;
						value = "成功！";
					}
			}else{
				state = 0;
				value = "参数错误！";
			}
			System.out.println("{'state':'"+state+"','value':'"+value+"','cause':'"+cause+"'}");
			out.println("{\"state\":\""+state+"\",\"value\":\""+value+"\",\"cause\":\""+cause+"\"}");
			out.close();

		}
		if(!name.equals("")){
			sql+="  and u.name=  '"+ name+"'";
			csql+="  and u.name= '"+ name+"'";
		}
		if(!idcard.equals("")){
			sql+=" and u.idcard = '"+idcard+"'";
			csql+=" and u.idcard = '"+idcard+"'";
		}
		if(!isoccupancy.equals("")){
			sql+=" and o.isoccupancy = "+isoccupancy;
			csql+=" and o.isoccupancy = "+isoccupancy;
		}
		
		sql+=" order by u.id limit "+(page-1)*pagesize+"," +pagesize;
		String total = new DBHelper().queryField(csql, null, "total");
		Map<String ,String>map = null;
		if(total!=null && !total.equals("")){
			int totalCount = Integer.parseInt(total);
			map = new HashMap<String, String>();
			map.put("total", totalCount+"");
			map.put("prepage", page+"");
			map.put("totalPage", (totalCount%pagesize==0?totalCount/pagesize:totalCount/pagesize+1)+"");
			String fields[]={"id","orderno","name","roomno","day","handleuser","ordertime","ordermoney","prepay","ordertype","occupancytime","outtime" ,"isoccupancy","iscompensation","compensationmoney","compensationgoods"};
			List<Map<String, String>> list = new DBHelper().queryObjects(sql, null, fields);
			if(list!=null && list.size()>0){
				list.add(map);
				return JSONArray.fromObject(list).toString();
			}else
				return "error:没有用户的入住信息！";
		}else{
			return "error:没有用户的入住信息！";
		}
	}
	
	
	private String StayCount(HttpServletRequest request,
			HttpServletResponse response) {
		String isoccupancy = request.getParameter("isoccupancy")==null?"":request.getParameter("isoccupancy");
		int page =0;
		String prepage = request.getParameter("page")==null?"":request.getParameter("page");
		if(prepage.equals("")){
			page = 1;
		}else page = Integer.parseInt(prepage);
		int pagesize = 5;
		
		String sql = "select u.id, o.orderno,o.roomno,u.name,u.realname,o.isoccupancy,o.occupancytime,o.outtime,u.idcard,u.phone from orders o,users u where o.orderuser = u.id and 1=1 ";
		String csql = "select count(*) total from orders o,users u where o.orderuser = u.id and 1=1 ";
		if(isoccupancy!=null && !isoccupancy.equals("")){
			sql += "and isoccupancy = "+isoccupancy;

	private String delOrder(HttpServletRequest request,
			HttpServletResponse response) {
		String id = request.getParameter("id")==null?"":request.getParameter("id");
		if(id==null || id.equals("")) return "订单编号不能为空！";
		String sql = "delete from orders where id = ?";
		//获取删除订单的所对应房间的ID
		String csql ="select r.id from rooms r, orders o where o.roomno = r.roomno and o.id=?";
		String rid = new DBHelper().queryField(csql, new String[]{id}, "id");
		if(rid!=null && !rid.equals("")){
			//修改房间状态
			String rsql = "update rooms set isempty = ? where id = ?";
			String rparams[]={"1",rid};
			int rrows = new DBHelper().alertData(rsql, rparams);
			if(rrows <= 0) return "error:修改房间状态失败";
			else {
				//删除订单
				int rows = new DBHelper().alertData(sql, new String[]{id});
				if(rows > 0) return "订单删除成功！";
				else return "error:订单删除失败！";
			}
		}else return "error:获取房间ID失败！";
		
	}
	private String findOrderStatus(HttpServletRequest request,
			HttpServletResponse response){
		String sql="select isoccupancy from orders where id = ?";
		String id = request.getParameter("id")==null?"":request.getParameter("id");
		if(id==null || id.equals("")) return "error:订单编号不能为空！";
		String isoccupancy = new DBHelper().queryField(sql, new String[]{id}, "isoccupancy");
		if(isoccupancy!=null && !isoccupancy.equals("")){
			return isoccupancy;
		}else
			return "error:获取订单状态失败";
	}

	public String findExitUser(HttpServletRequest request,
			HttpServletResponse response){
		String name = request.getParameter("name")==null?"":request.getParameter("name");
		if(name.equals("")) return "error:用户名为空";
		String sql = "select id, name,password,realname,idcard,phone,role from users where name = ?";
		Map<String, String>map = new DBHelper().queryObject(sql, new String[]{name}, new String[]{"id","name","password","realname","idcard","phone","role"});
		if(map!=null && !map.isEmpty()){
			if(!map.get("role").equals("3")) return "error:@@@@该用户为内部人员，不可订房！";
			return JSONObject.fromObject(map).toString();

		}
	}

	public void init() throws ServletException {
		 
	}

}
package com.slh.code.servlet;

public class CustomerServlet extends HttpServlet {

	private static final long serialVersionUID = 1L;

	public void destroy() {
		super.destroy(); 
	}
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
			this.doPost(request, response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		

					if(map2.containsKey("pic") &&( map2.get("pic")==null || map2.get("pic").equals(""))){
						map2.put("pic", "");
					}else{
						map2.put("pic",request.getRequestURL().toString().split("SLH")[0]+"SLH"+"/"+ImageUtil.PATH+"/"+map2.get("pic"));
					}
				}
				list.add(map);
				return JSONArray.fromObject(list).toString();
			}else
				return "error:未获取到房间的信息";
		}else return "error:未获取到房间的信息";
		
		
	}

	private String editManager(HttpServletRequest request,
			HttpServletResponse response) {
		String id = request.getParameter("id")==null?"":request.getParameter("id");
		String name = request.getParameter("name")==null?"":request.getParameter("name");
		String age = request.getParameter("age")==null?"":request.getParameter("age");
		String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
		String realname = request.getParameter("realname")==null?"":request.getParameter("realname");
		String phone = request.getParameter("phone")==null?"":request.getParameter("phone");
		String idcard = request.getParameter("idcard")==null?"":request.getParameter("idcard");
		String isdelete = request.getParameter("isdelete")==null?"":request.getParameter("isdelete");
		
		if(id.equals("")){
			return "error:用户id不能为空！";
		}
		if(name.equals("")){
			return "error:用户名不能为空！";
		}
		String sql = "update users set name = ?,age=?,sex=?,realname=?,phone=?,idcard=? ,isdelete=?where id = ?";
		String params[]={name,age,sex,realname,phone,idcard,isdelete,id};
		
		int rows = new DBHelper().alertData(sql, params);
		if(rows>0){
			return "修改成功！";
		}else
			return "error:修改失败！";
	}


				}else{
					state = 1;
					value = result;
				}
			}else if(flag.equals("register")){
				//注册
				String result = this.register(request, response);
				if(result.indexOf("error")!=-1){
					state = 0;
					value = result.substring(6, result.length());
				}else{
					state = 1;
					value = result;
				}
			} else if(flag.equals("exit")){
				//退出系统
					request.getSession().removeAttribute("user");
					if(request.getSession().getAttribute("user")!=null && !request.getSession().getAttribute("user").equals("") ){
						state = 0;
						value = "退出系统失败！";
					}else{
						state = 1;
						value = "成功！";
					}
			}else{
				state = 0;
				value = "参数错误！";
			}
			System.out.println("{'state':'"+state+"','value':'"+value+"','cause':'"+cause+"'}");
			out.println("{\"state\":\""+state+"\",\"value\":\""+value+"\",\"cause\":\""+cause+"\"}");
			out.close();
	}
	
	public String login(HttpServletRequest request, HttpServletResponse response){
		String username = request.getParameter("username")==null?"":request.getParameter("username").replaceAll("[\t\r\n]", "");
		if(username.equals("")){
			return "error:用户名不能为空";
		}
		String sql_name = "select name from users where name =?";
		String name = new DBHelper().queryField(sql_name, new String []{username}, "name");
		if(name == null || name.equals("")){
			return "error:用户名不存在！";

		
		if(result.indexOf("error")!=-1){
			state = 0;
			value = result.substring(6,result.length());
		}else{
			state = 1;
			value =result;
		}
		System.out.println(value.replaceAll("\"", "'"));
		out.println("{\"state\":\""+state+"\",\"value\":\""+value.replaceAll("\"", "'")+"\",\"cause\":\""+cause+"\"}");
		out.flush();
		out.close();
	}
	private String continu(HttpServletRequest request,
			HttpServletResponse response) {
		int day =0;
		double money = 0;
		String id = request.getParameter("id")==null?"":request.getParameter("id");
		String conday = request.getParameter("conday")==null?"":request.getParameter("conday");
		String conmoney = request.getParameter("conmoney")==null?"":request.getParameter("conmoney");
		if(id.equals("")) return "error:id不能为空";
		if(conday.equals("")) return "error:续费天数不能为空";else day = Integer.parseInt(conday);
		if(conmoney.equals("")) return "error:续费金额不能为空";else money = Double.parseDouble(conmoney);
		String sql = "update orders set day = day+"+day+" , prepay=prepay+"+money +" where id = '"+id+"'";
		int rows = new DBHelper().alertData(sql, null);
		if(rows>0) return "成功！";
		else return "error:失败";
	}

	private String change(HttpServletRequest request,
			HttpServletResponse response) {
		String id = request.getParameter("orderId")==null?"":request.getParameter("orderId");
		String roomno = request.getParameter("roomno")==null?"":request.getParameter("roomno");
		String handleuser = ((Users)request.getSession().getAttribute("user")).getId();
		String oldroomno = request.getParameter("oldroomno")==null?"":request.getParameter("oldroomno");
		if(id.equals("")) return "error:订单Id为空！";
		if(roomno.equals("")) return "error:房间号不能为空！";
		
		String rsql = "update rooms set isempty = ? where roomno = ?";
		String isempty = "3";
		String rparams[]={isempty,roomno};
		int rrows = new DBHelper().alertData(rsql, rparams);
		if(rrows <= 0) return "error:修改房间状态失败";
		
		rsql = "update rooms set isempty = ? where roomno = ?";
		isempty="1";
		String oparams[]={isempty,oldroomno};
		rrows = new DBHelper().alertData(rsql, oparams);
		if(rrows <= 0) return "error:修改房间状态失败";
		
		String sql = "update orders set roomno = ?,handleuser=?  where id = ?";

		}else if(flag.equals("orderRoom")){
			result = orderRoom(request,response);
		}else if(flag.equals("orderLook")){
			result = orderLook(request,response);
		}else if(flag.equals("findOrderById")){
			//获取单个订单信息
			result = findOrderById(request,response);
		}else if(flag.equals("editOrder")){
			result = editOrder(request,response);
		}else if(flag.equals("deleteOrder")){
			result = deleteOrder(request,response);
		}else if(flag.equals("message")){
			//留言
			result = message(request,response);
		}
		if(result.indexOf("error")!=-1){
			state = 0;
			value = result.substring(6,result.length());
		}else{
			state = 1;
			value =result;
		}
		System.out.println(value);
		out.println("{\"state\":\""+state+"\",\"value\":\""+value.replaceAll("\"", "'")+"\",\"cause\":\""+cause+"\"}");
		out.flush();
		out.close();
	}

	private String findOrderById(HttpServletRequest request,
			HttpServletResponse response) {
		String id = request.getParameter("id")==null?"":request.getParameter("id");
		String uid = ((Users)request.getSession().getAttribute("user")).getId();
		
		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 = ?";
		String fields[]={"id","orderno","name","occupancytime","ordertime","ordermoney","prepay","ordertype","roomno","day","isoccupancy"};
		Map<String,String> map = new DBHelper().queryObject(sql, new String[]{id,uid}, fields);
		if(map!=null && !map.isEmpty()){
			return JSONObject.fromObject(map).toString();
		}else return "error:获取您的订单信息失败！";
		
	}
	private String motifyuser(HttpServletRequest request,
			HttpServletResponse response) {
		String id = request.getParameter("id")==null?"":request.getParameter("id");
		String age = request.getParameter("age")==null?"":request.getParameter("age");
		String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
		String realname = request.getParameter("realname")==null?"":request.getParameter("realname");
		String phone = request.getParameter("phone")==null?"":request.getParameter("phone");
		
		String reg = "^[1-9]+$";

		} 
		else return "error:修改信息失败！";
	}
	private String message(HttpServletRequest request,
			HttpServletResponse response) {
		String id = Keys.createKey("M");
		String title = request.getParameter("title")==null?"":request.getParameter("title");
		String content = request.getParameter("content")==null?"":request.getParameter("content");
		String messageuser = ((Users)request.getSession().getAttribute("user")).getId();
		String time = DateUtil.dateFormat();
		if(title.equals("")) return "error:标题不能为空！";
		if(content.equals("")) return "error:内容不能为空！";
		
		String sql = "insert into message(id,title,content,messageuser,time)values(?,?,?,?,?)";
		
		String params[]={id,title,content,messageuser,time};
		
		int rows = new DBHelper().alertData(sql, params);
		if(rows >0) return "成功！";
		else return "error:留言失败！";
	}
	private String deleteOrder(HttpServletRequest request,
			HttpServletResponse response) {
		String id= request.getParameter("id")==null?"":request.getParameter("id");
		if(id.equals("")) return "error:订单ID不能为空！";
		
		String sql = "delete from orders where id = ?";
		String params[]={id};
		int rows = new DBHelper().alertData(sql, params);
		if(rows > 0) return "成功";
		else return "error:删除订单失败！";
	}
	private String editOrder(HttpServletRequest request,
			HttpServletResponse response) {
		String id = request.getParameter("id")==null?"":request.getParameter("id");
		String occupancytime = request.getParameter("occupancytime")==null?"":request.getParameter("occupancytime");
		String day = request.getParameter("day")==null?"":request.getParameter("day");
		if(id.equals("")) return "error:订单ID不能为空！";
		if(occupancytime.equals("")) return "error:入住时间不能为空！";
		if(day.equals("")) return "error:入住天数不能为空！";

					state = 1;
					value = result;
				}
			} else if(flag.equals("exit")){
				//退出系统
					request.getSession().removeAttribute("user");
					if(request.getSession().getAttribute("user")!=null && !request.getSession().getAttribute("user").equals("") ){
						state = 0;
						value = "退出系统失败！";
					}else{
						state = 1;
						value = "成功！";
					}
			}else{
				state = 0;
				value = "参数错误！";
			}
			System.out.println("{'state':'"+state+"','value':'"+value+"','cause':'"+cause+"'}");
			out.println("{\"state\":\""+state+"\",\"value\":\""+value+"\",\"cause\":\""+cause+"\"}");
			out.close();
	}
	
	public String login(HttpServletRequest request, HttpServletResponse response){
		String username = request.getParameter("username")==null?"":request.getParameter("username").replaceAll("[\t\r\n]", "");
		if(username.equals("")){
			return "error:用户名不能为空";
		}
		String sql_name = "select name from users where name =?";
		String name = new DBHelper().queryField(sql_name, new String []{username}, "name");
		if(name == null || name.equals("")){
			return "error:用户名不存在！";
		}
		String password = request.getParameter("password")==null?"":request.getParameter("password").replaceAll("[\r\t\n]", "");
		if(password.equals("")){
			return "error:密码不能为空！";
		}
		String sql = "select * from users where name = ? and password = ?";
		String fields[] = new String[]{"id","name","age","sex","realname","role","phone","idcard"};
		Map<String, String>map = new DBHelper().queryObject(sql, new String[]{username,password}, fields);
		if(map!=null && !map.isEmpty()){
			Users u = new Users();
			u.setId(map.get("id"));
			u.setName(map.get("name"));

			map.put("prepage", page+"");
			map.put("totalPage", (totalCount%pagesize==0?totalCount/pagesize:totalCount/pagesize+1)+"");
			List<Map<String, String>>list =  new DBHelper().queryObjects(sql, null, new String[]{"id","roomno","type","price","isempty","des","pic"});
			if(list!=null && list.size()>0){
				for (Map<String, String> map2 : list) {
					//System.out.println(map2.get("pic").equals(""));
					if(map2.containsKey("pic") &&( map2.get("pic")==null || map2.get("pic").equals(""))){
						map2.put("pic", "");
					}else{
						map2.put("pic",request.getRequestURL().toString().split("SLH")[0]+"SLH"+"/"+ImageUtil.PATH+"/"+map2.get("pic"));
					}
				}
				list.add(map);
				return JSONArray.fromObject(list).toString();
			}else
				return "error:未获取到房间的信息";
		}else return "error:未获取到房间的信息";
		
		
	}

	private String editManager(HttpServletRequest request,
			HttpServletResponse response) {
		String id = request.getParameter("id")==null?"":request.getParameter("id");
		String name = request.getParameter("name")==null?"":request.getParameter("name");
		String age = request.getParameter("age")==null?"":request.getParameter("age");
		String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
		String realname = request.getParameter("realname")==null?"":request.getParameter("realname");
		String phone = request.getParameter("phone")==null?"":request.getParameter("phone");
		String idcard = request.getParameter("idcard")==null?"":request.getParameter("idcard");
		String isdelete = request.getParameter("isdelete")==null?"":request.getParameter("isdelete");
		
		if(id.equals("")){
			return "error:用户id不能为空！";
		}
		if(name.equals("")){
			return "error:用户名不能为空！";
		}
		String sql = "update users set name = ?,age=?,sex=?,realname=?,phone=?,idcard=? ,isdelete=?where id = ?";
		String params[]={name,age,sex,realname,phone,idcard,isdelete,id};
		
		int rows = new DBHelper().alertData(sql, params);
		if(rows>0){

			map.put("totalPage", (totalCount%pagesize==0?totalCount/pagesize:totalCount/pagesize+1)+"");
			String fields[]={"id","orderno","name","roomno","day","handleuser","ordertime","ordermoney","prepay","ordertype","occupancytime","outtime" ,"isoccupancy","iscompensation","compensationmoney","compensationgoods"};
			List<Map<String, String>> list = new DBHelper().queryObjects(sql, null, fields);
			if(list!=null && list.size()>0){
				list.add(map);
				return JSONArray.fromObject(list).toString();
			}else
				return "error:没有用户的入住信息！";
		}else{
			return "error:没有用户的入住信息！";
		}
	}
	
	
	private String StayCount(HttpServletRequest request,
			HttpServletResponse response) {
		String isoccupancy = request.getParameter("isoccupancy")==null?"":request.getParameter("isoccupancy");
		int page =0;
		String prepage = request.getParameter("page")==null?"":request.getParameter("page");
		if(prepage.equals("")){
			page = 1;
		}else page = Integer.parseInt(prepage);
		int pagesize = 5;
		
		String sql = "select u.id, o.orderno,o.roomno,u.name,u.realname,o.isoccupancy,o.occupancytime,o.outtime,u.idcard,u.phone from orders o,users u where o.orderuser = u.id and 1=1 ";
		String csql = "select count(*) total from orders o,users u where o.orderuser = u.id and 1=1 ";
		if(isoccupancy!=null && !isoccupancy.equals("")){
			sql += "and isoccupancy = "+isoccupancy;
			csql += "and isoccupancy = "+isoccupancy;
		}
		sql += " order by u.id limit "+(page-1)*pagesize+","+pagesize;
		String total = new DBHelper().queryField(csql, null, "total");
		Map<String, String>map = null;
		if(total!=null && !total.equals("")){
			int totalCount = Integer.parseInt(total);
			map = new HashMap<String, String>();
			map.put("total", totalCount+"");
			map.put("prepage", page+"");
			map.put("totalPage", (totalCount%pagesize==0?totalCount/pagesize:totalCount/pagesize+1)+"");
			String fields []= {"id", "orderno","roomno","name","realname","isoccupancy","occupancytime","outtime","idcard","phone"};
			List<Map<String,String>> list = new DBHelper().queryObjects(sql, null, fields);
			if(list!=null && list.size() > 0){
				list.add(map);
				return JSONArray.fromObject(list).toString();
			}else return "error:没有入住信息!";
		}
		else return "error:获取信息失败！";
	}

	private String cancleOrder(HttpServletRequest request,

请添加图片描述

请添加图片描述
请添加图片描述
请添加图片描述

m0_71000466
关注
基于jsp+servlet+mysql的酒店管理系统(附源码)
vx1271487114的博客
10-25 4480
本系统是基于jsp+servlet+mysql的前后端分离的酒店管理系统，前后端分离是指前端和后端分别是两个独立存在的项目，能独立运行。没有前端项目，后端也能运行且进行数据管理，没有后端项目，前端也能运行且能注册登录以及下订单。 本系统集中数据管理、分布式应用，实现信息的全面共享，为决策者提供最新的人力资源数据。 完全基于浏览器的操作模式，安装简单、操作方便，具有良好的系统扩充能力。 灵活的模块需求设计，可根据实训项目周期灵活裁剪。
jsp+servlet+mysql实现的酒店预定管理系统源码+运行教程+参考论文+开题报告
所有项目源码实战教程均可在【猿来入此】下载
12-31 273
主要实现的功能有：管理员登录、楼层管理、房型管理、房间管理、预定管理、入住管理、查看账单、日志管理、用户管理等，所有管理列表页面都提供了导出到excel的功能。本项目资料目前包含有完整项目源码和视频导入运行教程，关于修改页面文字版权信息的视频里也会讲。PS：目前该项目已经配套了完整的开发文档（开发文档包含了需求分析、系统架构、流程图、E-R图、用例图、实体图、数据库设计、代码实现等论文的所有要求点，可作为参考论文），帮您快速掌握整个系统哦！，总之重要的事说三遍：包运行、包运行、包运行！
基于Java web的酒店管理系统（源码+数据库）.zip
06-06
酒店管理系统 课程设计大二下 MySQL数据库，tomcat服务器。 界面好看，课程设计拿到了优。你值得拥有
基于JSP+Servlet+MySQL简单的酒店后台管理系统
code51博客
07-17 1367
登陆图表添加房间房间管理房间信息编辑用户列表用户管理管理员管理管理员添加技术描述开发工具数据库mysqlJar包仓库普通jar包前段框架后端框架。
基于javaweb+mysql的jsp+servlet酒店管理系统(java+jsp+bootstrap+jquery+servlet+mysql)
欢迎私信
01-04 890
3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；酒店管理员角色包含以下功能： 管理员登录,用户管理、住客信息管理、客房管理、房间管理、会员等级折扣管理、订单管理等功能。基于javaweb+mysql的jsp+servlet酒店管理系统(java+jsp+bootstrap+jquery+servlet+mysql)操作员角色包含以下功能： 用户登录,用户管理、住客信息管理、房型管理、房间管理、订单管理等功能。
Java项目:酒店客房管理系统(java+JSP+bootstrap+jQuery+Servlet+Mysql)
常年被追砍的博客
06-17 451
酒店管理系统共分为三个角色，客房经理、前台管理员、客户，各个角色的权限各不相同； 客房经理功能包括：登录、注册、前台用户管理、客房管理、优惠活动、查看留言、更换客房、房费续交、订单查看、报修统计、入驻统计、退房等功能；前台管理员主要功能： 前台管理：包括客房查询、更换客房、房费续交、订单查看、报修统计、入住统计、退房、查看留言；客户主要功能： 主要查看用户信息：个人信息、优惠活动、客房信息、订单管理、留言等；1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.I
基于JAVA+Servlet+JSP+MYSQL的酒店管理系统
程序猿编程
11-08 397
项目功能： 页面效果：
基于Servlet+jsp+mysql开发javaWeb学生成绩管理系统
10-19
系统采用技术：Servlet+jsp+mysql+jQuery+bootstrap+面向接口编程 系统管理员： 个人信息管理，课程管理，成绩管理，学生信息管理，教师管理，所有账号管理等。 教师： 个人信息管理，课程管理，成绩管理，...
基于javaweb+mysql的jsp+servlet酒店管理系统(java+jsp+mysql)
欢迎私信，一直在线
03-01 373
基于javaweb+mysql的jsp+servlet酒店管理系统(java+jsp+mysql)基于javaweb的JSP+Servlet酒店管理系统(java+jsp+mysql)eclipse/idea/myeclipse/sts等均可配置运行。课程设计，大作业，毕业设计，项目练习，学习演示等。
javaweb(servlet)+jsp+Mysql实现的酒店客房管理系统（功能包含登录、用户管理、住客信息管理、房型管理、房间管理、会员星级管理、订单管理等）
anmu4200的博客
12-07 1079
javaweb(servlet)+jsp+Mysql实现的酒店客房管理系统（功能包含登录、用户管理、住客信息管理、房型管理、房间管理、会员星级管理、订单管理等）
java-使用Servlet+JSP+Mysql+JDBC制作简易的商品管理系统
喃灬疯的博客
11-06 3679
目录 一、前言 二、环境搭建 三、前端页面   1. index.jsp 登陆首页   2. shopping.jsp 商品管理页面   3. addGoods.jsp 添加商品页面   4. updateGoods.jsp 修改商品信息页面 四、后端   1. 登录用户检验   2. 商品管理处理     2.1 GoodsServlet 代码     2.2 BasicDao 代码     2.3 GoodsDao 代码     2.4 GoodsService 代码     2.5 JdbcUtil
酒店管理系统(JSP+java+springmvc+mysql+MyBatis)
回明毕设项目
12-13 68
酒店作为旅游业的重要组成部分，在现代社会中扮演着越来越重要的角色。同时，它也可以提高酒店的信息化水平，为酒店提供更好的数据支持和管理决策。+ Maven +mysql5.7或8.0+html+css+js等等组成，B/S模式 + Maven管理等等。JSP技术生成动态的Web页面，将页面展示给用户。用户发送请求：用户通过浏览器或其他客户端向系统发送请求，请求访问特定的页面或执行特定的操作。前端展示结果：前端接收到后端返回的数据，根据需要进行展示。后端程序接收到请求后，根据请求的类型和参数进行相应的处理。
java mysql实现_Java实现数据库
weixin_29164497的博客
02-04 842
一、【建立数据库】在mysql中新建一个名为kecheng的数据库，并在其中新建一个kecheng数据表，包含三个字段，classname,classroom,teacher二、【新建web项目】1. eclipse新建一个名为Course的Dynamic Web Project2. 将连接mysql的驱动jar包(mysql-connector-java-5.1.7-bin.jar)copy到W...
Java项目:酒店管理系统(java+JSP+bootstrap+jQuery+Servlet+Mysql)
常年被追砍的博客
06-17 998
该项目主要分为酒店管理员与操作员两种角色； 酒店管理员角色包含以下功能： 管理员登录,用户管理、住客信息管理、客房管理、房间管理、会员等级折扣管理、订单管理等功能。操作员角色包含以下功能： 用户登录,用户管理、住客信息管理、房型管理、房间管理、订单管理等功能。1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬
Java项目:旅游管理系统(java+JSP+HTML5+Bootstrap+servlet+Mysql)
12-18
HTML5+Ajax+CSS+JavaScript+BootStrap+jQuery+servlet+mysql 使用说明 1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyE
基于javaweb+mysql的jsp+servlet旅游管理系统(java+jsp+html+bootstrap+servlet+mysql)
毕业javaweb，一直在线，欢迎私信
12-25 852
其他版本理论上也可以。3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；基于javaweb+mysql的jsp+servlet旅游管理系统(java+jsp+html+bootstrap+servlet+mysql)管理员角色包含以下功能： 管理员登录,管留言信息修改,景点管理,资讯管理,图片库管理,留言管理,管理员管理等功能。"alert('删除成功!"alert('删除成功!"alert('删除成功!"alert('留言成功!
JavaWeb：实现酒店管理系统（课程设计完整版）
热门推荐
m0_63512120的博客
05-20 1万+
该web写的相对简单一点，写的大概思路就是：先写前端页面，然后将信息传递给后端，后端在对数据进行处理，处理之后再将数据转发给前端。项目全部源代码和图片素材在文章末尾展示。
日常bug记录，easyexcel导入报错convert data ... to class java.math.BigDecimal error
最新发布
mm
11-11 191
排查发现实体类中有BigDecimal属性，然而数据中这个属性为null，进行转换时报错。在实体类上加上自定义转换器。解决方法：自定义转换器类。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值