基于javaweb+mysql的springboot酒店宾馆管理系统(java+springboot+html+layui+jquery+maven+mysql)

基于javaweb+mysql的springboot酒店宾馆管理系统(java+springboot+html+layui+jquery+maven+mysql)

运行环境

Java≥8、MySQL≥5.7

开发工具

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

适用

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

功能说明

基于javaweb+mysql的SpringBoot酒店宾馆管理系统(java+springboot+html+layui+jquery+maven+mysql)

功能介绍

springboot酒店宾馆管理系统。该系统为后管系统,无前台。主要分三种角色:管理者/工作人员/前台人员。

主要功能有: 客房:客房标准、房间信息; 订单:入住订单; 员工:员工信息; 事务:事务信息; 停车:车位信息; 财务:财务信息; 历史:订单历史、车库历史; 会员:会员信息;

环境需要

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.是否Maven项目: 是;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目

6.数据库:MySql 8.0版本;

技术栈

  1. 后端:SpringBoot

  2. 前端:html+layui+jQuery

使用说明

  1. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,下载所需jar包;

  2. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置 4. 配置tomcat,然后运行项目,输入localhost:8888 登录 5. 数据库中的employ中有密码,密码是加密过的,三种权限,管理者/工作人员/前台人员 管理账号:admin 密码:worker1 工作人员账号:worker1 密码:worker1

前台人员:sever1 密码:worker1

		}while (--number>0);

		return ResultReturn.success(garageList);
	}
}
package com.hotel.controller;

@RestController
public class OrderHistoryController
{

	private final OrderHistoryService orderHistoryService;

	private final FinanceService financeService;

	@Autowired
	public OrderHistoryController(OrderHistoryService orderHistoryService,FinanceService financeService)
	{
		this.orderHistoryService=orderHistoryService;
		this.financeService=financeService;
	}

	/**
	 * @return 返回订单历史集合
	 */
	@RequestMapping("/orderhistory/getall")
	public Result<List<OrderHistory>> getAll()
	{
		return ResultReturn.success(orderHistoryService.findAll());
	}

	/**
	 * @param year  年份
	 * @param month 月份
	 * @param day   天数
	 * @return 返回对应的日订单历史
	 */
	@RequestMapping("/orderhistory/getallbyday")
	@RequestMapping("/garagehistory/getall")
	public Result<List<GarageHistory>> garageHistoryList()
	{
		return ResultReturn.success(garageHistoryService.findAll());
	}

	/**
	 * @param garageId 车库(位)编号
	 * @return 返回根据车库(位)编号查询到的车库历史纪录列表
	 */
	@RequestMapping("/garagehistory/getallbyid/{garageno}")
	public Result<List<GarageHistory>> garageHistoryListById(@PathVariable("garageno") int garageId)
	{
		return ResultReturn.success(garageHistoryService.findAllById(garageId));
	}

	/**
	 * @param brand 车牌
	 * @return 返回根据车牌查询到的车库历史纪录列表
	 */
	@RequestMapping("/garagehistory/getallbybrand/{brand}")
	public Result<List<GarageHistory>> garageHistoryListByBrand(@PathVariable("brand") String brand)
	{
		return ResultReturn.success(garageHistoryService.findAllByBrand(brand));
	}

	/**
	 * @param year  年份
	 * @param month 月份
	 * @param day   天数
	 * @return 返回日车库历史
	 */
	@RequestMapping("/garagehistory/getallbyday")
	public Result<List<GarageHistory>> getAllByDay(@RequestParam("year") int year,@RequestParam("month") int month,
												   @RequestParam("day") int day)
	{
		return ResultReturn.success(garageHistoryService.findAllByDay(year,month,day));
	}

	/**
	 * @param year  年份
                            @RequestParam("employposition")int employposition,
                            @RequestParam("employauthority") int employauthority,
                            @RequestParam("employpaymentpermonth")int employpaymentpermonth,
                            @RequestParam("employworktime") int employworktime,
                            @RequestParam("username") String username,
                            @RequestParam("password") String password) {
        Employ e = employservice.findByEmployno(employno);
        if(e!=null)
            return ResultReturn.error(2,"that employno arleady exist");
        else{
            e = saveEmploy(employno,employname,employsex,employage,employposition,employauthority,
                    employpaymentpermonth,employworktime,username,password);
            return ResultReturn.success(employservice.save(e));
        }
    }

    @RequestMapping("/employ/update/{employno}")
    public Result employUpdate(@PathVariable("employno")int employno,@RequestParam("employname") String employname,
                               @RequestParam("employsex")int employsex,@RequestParam("employage") int employage,
                               @RequestParam("employposition")int employposition,
                               @RequestParam("employauthority") int employauthority,
                               @RequestParam("employpaymentpermonth")int employpaymentpermonth,
                               @RequestParam("employworktime") int employworktime,
                               @RequestParam("username") String username,
                               @RequestParam("password") String password) {
        Employ e = employservice.findByEmployno(employno);
            if(e==null) {
            return ResultReturn.error(1,"that employno did not exist");
        }
        else{
            e = saveEmploy(employno,employname,employsex,employage,employposition,employauthority,
                    employpaymentpermonth,  employworktime,username,password);
            return ResultReturn.success(employservice.save(e));
        }

    }

    @RequestMapping("/employ/delete/{employno}")
    public Result employDelete(@PathVariable("employno")int employno) {
        Employ e = employservice.findByEmployno(employno);
        if (e==null)
            return ResultReturn.error(1,"can't find this employno");
        employservice.delete(e);
        return ResultReturn.success(e);

class LoginSuccessHandle implements AuthenticationSuccessHandler {
    public void onAuthenticationSuccess(HttpServletRequest request, HttpServletResponse response,
                                        Authentication authentication) throws IOException,ServletException {
        Set<String> roles = AuthorityUtils.authorityListToSet(authentication.getAuthorities());
        String path = request.getContextPath() ;
        String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
        if (roles.contains("ROLE_ADMIN")){
            response.sendRedirect(basePath+"adminHotel");
            return;
        }
        else if (roles.contains("ROLE_WORKER")){
            response.sendRedirect(basePath+"workerHotel");
            return;
        }
        else if (roles.contains("ROLE_SERVER")){
            response.sendRedirect(basePath+"serverHotel");
            return;
        }
        else {
            response.sendRedirect(basePath+"/403");
        }
    }

    }
package com.hotel.handle;

@ControllerAdvice
public class ExceptionHandle
	{
		Member member=new Member();

		member.setPhone(phone);
		member.setName(name);
		member.setId(id);
		member.setEntertime(new Timestamp(System.currentTimeMillis()));

		return ResultReturn.success(memberService.save(member));
	}

	/**
	 *
	 * @param phone 电话号码
	 * @return 返回成功
	 */
	@RequestMapping("/member/deletebyphone")
	public Result deleteByPhone(@RequestParam("phone") String phone)
	{
		memberService.delete(memberService.findByPhone(phone));
		return ResultReturn.success();
	}

	/**
	 *
	 * @param id 身份证
	 * @return 返回成功
	 */
	@RequestMapping("/member/deletebyid")
	public Result deleteByID(@RequestParam("id") String id)
	{
		memberService.delete(memberService.findByID(id));
		return ResultReturn.success();
	}
}
package com.hotel.login;

		}
		else
		{
			e.setEmployno(em.getEmployno());
			return ResultReturn.success(eventservice.save(e));
		}
	}

	//更新事务
	@RequestMapping("/event/update/{eventno}")
	public Result eventUpdate(@PathVariable("eventno") int eventno,@RequestParam("type") int type,
							  @RequestParam("roomno") int roomno,@RequestParam("comment") String comment)
	{
		Event E=eventservice.findAllByEventno(eventno);
		if(E==null)
			return ResultReturn.error(1,"can't find this eventno");
		//更新时房间号确认
		E.setType(type);
		Room r=roomservice.findByRoom(roomno);
		if(r==null)
			return ResultReturn.error(1,"roomno is not exist");
		E.setRoomno(roomno);
		E.setComment(comment);
		Employ em=employservice.eventMatch(type,E.getStarttime());
		if(em.getEmployno()==0)
		{
			return ResultReturn.error(1,"can't match worker in that time");
		}
		else
		{
			E.setEmployno(em.getEmployno());
			return ResultReturn.success(eventservice.save(E));
		}
	}

	//根据eventno删除事务
	@RequestMapping("/event/delete/{eventno}")
	public Result eventDelete(@PathVariable("eventno") int eventno)
	{
		Event E=eventservice.findAllByEventno(eventno);
	@RequestMapping("/event/delete/{eventno}")
	public Result eventDelete(@PathVariable("eventno") int eventno)
	{
		Event E=eventservice.findAllByEventno(eventno);
		if(E==null)
			return ResultReturn.error(1,"can't find this eventno");
		eventservice.delete(E);
		return ResultReturn.success(E);
	}

	@RequestMapping("/event/searchOne/{eventno}")
	public Result evenSerchOne(@PathVariable("eventno") int eventno)
	{
		Event e=eventservice.findById(eventno);
		if(e==null)
		{
			return ResultReturn.error(1,"it's not exist, you can't delete!");
		}
		else
		{
			return ResultReturn.success(e);
		}
	}

}
package com.hotel.controller;

@RestController
public class FinanceController
{
	private final FinanceService financeService;

	@Autowired
	public FinanceController(FinanceService financeService)
	{
		this.financeService=financeService;
	}

	@Autowired
	public GarageHistoryController(GarageHistoryService garageHistoryService,FinanceService financeService)
	{
		this.garageHistoryService=garageHistoryService;
		this.financeService=financeService;
	}

	/**
	 * @return 返回车库历史纪录列表
	 */
	@RequestMapping("/garagehistory/getall")
	public Result<List<GarageHistory>> garageHistoryList()
	{
		return ResultReturn.success(garageHistoryService.findAll());
	}

	/**
	 * @param garageId 车库(位)编号
	 * @return 返回根据车库(位)编号查询到的车库历史纪录列表
	 */
	@RequestMapping("/garagehistory/getallbyid/{garageno}")
	public Result<List<GarageHistory>> garageHistoryListById(@PathVariable("garageno") int garageId)
	{
		return ResultReturn.success(garageHistoryService.findAllById(garageId));
	}

	/**
	 * @param brand 车牌
	 * @return 返回根据车牌查询到的车库历史纪录列表
	 */
	@RequestMapping("/garagehistory/getallbybrand/{brand}")
	public Result<List<GarageHistory>> garageHistoryListByBrand(@PathVariable("brand") String brand)
	{
		return ResultReturn.success(garageHistoryService.findAllByBrand(brand));
	}

	/**
	 * @param year  年份
	 * @param month 月份
	 * @param day   天数
	 * @return 返回日车库历史
	 */
	@RequestMapping("/garagehistory/getallbyday")
	public Result<List<GarageHistory>> getAllByDay(@RequestParam("year") int year,@RequestParam("month") int month,
												   @RequestParam("day") int day)
	{
		return ResultReturn.success(garageHistoryService.findAllByDay(year,month,day));
		if(E==null)
			return ResultReturn.error(1,"can't find this eventno");
		//更新时房间号确认
		E.setType(type);
		Room r=roomservice.findByRoom(roomno);
		if(r==null)
			return ResultReturn.error(1,"roomno is not exist");
		E.setRoomno(roomno);
		E.setComment(comment);
		Employ em=employservice.eventMatch(type,E.getStarttime());
		if(em.getEmployno()==0)
		{
			return ResultReturn.error(1,"can't match worker in that time");
		}
		else
		{
			E.setEmployno(em.getEmployno());
			return ResultReturn.success(eventservice.save(E));
		}
	}

	//根据eventno删除事务
	@RequestMapping("/event/delete/{eventno}")
	public Result eventDelete(@PathVariable("eventno") int eventno)
	{
		Event E=eventservice.findAllByEventno(eventno);
		if(E==null)
			return ResultReturn.error(1,"can't find this eventno");
		eventservice.delete(E);
		return ResultReturn.success(E);
	}

	@RequestMapping("/event/searchOne/{eventno}")
	public Result evenSerchOne(@PathVariable("eventno") int eventno)
	{
		Event e=eventservice.findById(eventno);
		if(e==null)
		{
			return ResultReturn.error(1,"it's not exist, you can't delete!");
		}
		else
		{
			return ResultReturn.success(e);
		}
	}

}
package com.hotel.controller;

        }
    }

    @RequestMapping("/room/searchOne/{roomno}")
    public Result roomSerchOne(@PathVariable("roomno") int roomno) {
        Room r = roomservice.findByRoom(roomno);
        if(r == null) {
            return ResultReturn.error(1,"it's not exist!");
        }
        else {
            return ResultReturn.success(r);
        }
    }

    @RequestMapping("/room/delete/{roomno}")
    public Result roomDelete(@PathVariable("roomno") int roomno) {
        //需要先查询是否存在
        Room r = roomservice.findByRoom(roomno);
        if(r == null) {
            return ResultReturn.error(1,"it's not exist, you can't delete!");
        }
        else {
            roomservice.delete(r);
            return ResultReturn.success(r);
        }
    }

    public Room saveRoom(int roomno,int type,int price,int ifwindow,String comment) {
        Room r = new Room();
        r.setRoomno(roomno);
        r.setType(type);
        r.setPrice(price);
        r.setIfwindow(ifwindow);
        r.setComment(comment);
        return r;
    }

    public Standard saveStandard(String stdname,int roomarea,int bedno,String equip1,String equip2){
        Standard s = new Standard();
        s.setStdname(stdname);
        s.setRoomerea(roomarea);
        s.setBedno(bedno);
        s.setEquip1(equip1);
        s.setEquip2(equip2);
        return s;
    }
}
package com.hotel.controller;


@RestController
public class GarageHistoryController
{
	private final GarageHistoryService garageHistoryService;

	private final FinanceService financeService;

	@Autowired
	public GarageHistoryController(GarageHistoryService garageHistoryService,FinanceService financeService)
	{
		this.garageHistoryService=garageHistoryService;
		this.financeService=financeService;
	}

	/**
	 * @return 返回车库历史纪录列表
	 */
	@RequestMapping("/garagehistory/getall")
	public Result<List<GarageHistory>> garageHistoryList()
	{
		return ResultReturn.success(garageHistoryService.findAll());
	}

	/**
	 * @param garageId 车库(位)编号
	 * @return 返回根据车库(位)编号查询到的车库历史纪录列表
	 */
	@RequestMapping("/garagehistory/getallbyid/{garageno}")
	public Result<List<GarageHistory>> garageHistoryListById(@PathVariable("garageno") int garageId)
	{
		return ResultReturn.success(garageHistoryService.findAllById(garageId));
	}

	/**
	 * @param brand 车牌
	 * @return 返回根据车牌查询到的车库历史纪录列表
	 */
	@RequestMapping("/garagehistory/getallbybrand/{brand}")
	public Result<List<GarageHistory>> garageHistoryListByBrand(@PathVariable("brand") String brand)
	{
		return ResultReturn.success(garageHistoryService.findAllByBrand(brand));
			return ResultReturn.success(eventservice.save(E));
		}
	}

	//根据eventno删除事务
	@RequestMapping("/event/delete/{eventno}")
	public Result eventDelete(@PathVariable("eventno") int eventno)
	{
		Event E=eventservice.findAllByEventno(eventno);
		if(E==null)
			return ResultReturn.error(1,"can't find this eventno");
		eventservice.delete(E);
		return ResultReturn.success(E);
	}

	@RequestMapping("/event/searchOne/{eventno}")
	public Result evenSerchOne(@PathVariable("eventno") int eventno)
	{
		Event e=eventservice.findById(eventno);
		if(e==null)
		{
			return ResultReturn.error(1,"it's not exist, you can't delete!");
		}
		else
		{
			return ResultReturn.success(e);
		}
	}

}
package com.hotel.controller;

@RestController
public class FinanceController
{
	private final FinanceService financeService;
	public Result<Member> insert(@RequestParam("phone") String phone,
								 @RequestParam("name") String name,
								 @RequestParam("id") String id)
	{
		Member member=new Member();

		member.setPhone(phone);
		member.setName(name);
		member.setId(id);
		member.setEntertime(new Timestamp(System.currentTimeMillis()));

		return ResultReturn.success(memberService.save(member));
	}

	/**
	 *
	 * @param phone 电话号码
	 * @return 返回成功
	 */
	@RequestMapping("/member/deletebyphone")
	public Result deleteByPhone(@RequestParam("phone") String phone)
	{
		memberService.delete(memberService.findByPhone(phone));
		return ResultReturn.success();
	}

	/**
	 *
	 * @param id 身份证
	 * @return 返回成功
	 */
	@RequestMapping("/member/deletebyid")
	public Result deleteByID(@RequestParam("id") String id)
	{
		memberService.delete(memberService.findByID(id));
		return ResultReturn.success();
	}
}
package com.hotel.login;


@RestController
public class EmployController
{
    private final EmployService employservice;

    @Autowired
    public EmployController(EmployService employservice)
    {
        this.employservice=employservice;
    }

    @Autowired
    EventService eventService;

    @RequestMapping("/employ/list")
    public Result<Employ> employList() {
        return ResultReturn.success(employservice.findAll());
    }

    @RequestMapping("/employ/searchOne/{employno}")
    public Result employSearchOne(@PathVariable("employno") int employno) {
        Employ r = employservice.findByEmployno(employno);
        if(r == null) {
            return ResultReturn.error(1,"it's not exist, you can't delete!");
        }
        else {
            return ResultReturn.success(r);
        }
    }

    @RequestMapping("/employ/add")
    public Result employAdd(@RequestParam("employno")int employno,@RequestParam("employname") String employname,
                            @RequestParam("employsex")int employsex,@RequestParam("employage") int employage,
                            @RequestParam("employposition")int employposition,
                            @RequestParam("employauthority") int employauthority,
                            @RequestParam("employpaymentpermonth")int employpaymentpermonth,
                            @RequestParam("employworktime") int employworktime,
                            @RequestParam("username") String username,
                            @RequestParam("password") String password) {
						  @RequestParam("comment") String comment)
	{
		Event e=new Event();
		e.setType(type);
		e.setRoomno(roomno);
		e.setComment(comment);
		//检测房间号是否存在
		java.sql.Timestamp timestamp=new java.sql.Timestamp(System.currentTimeMillis());
		e.setStarttime(timestamp);

		Room r=roomservice.findByRoom(roomno);
		if(r==null)
			return ResultReturn.error(1,"roomno is not exist");
		//需要做employno
		Employ em=employservice.eventMatch(type,timestamp);
		if(em.getEmployno()==0)
		{
			return ResultReturn.error(1,"can't match worker in that time");
		}
		else
		{
			e.setEmployno(em.getEmployno());
			return ResultReturn.success(eventservice.save(e));
		}
	}

	//更新事务
	@RequestMapping("/event/update/{eventno}")
	public Result eventUpdate(@PathVariable("eventno") int eventno,@RequestParam("type") int type,
							  @RequestParam("roomno") int roomno,@RequestParam("comment") String comment)
	{
		Event E=eventservice.findAllByEventno(eventno);
		if(E==null)
			return ResultReturn.error(1,"can't find this eventno");
		//更新时房间号确认
		E.setType(type);
		Room r=roomservice.findByRoom(roomno);
		if(r==null)
			return ResultReturn.error(1,"roomno is not exist");
		E.setRoomno(roomno);
		E.setComment(comment);
		Employ em=employservice.eventMatch(type,E.getStarttime());
		if(em.getEmployno()==0)
		{
			return ResultReturn.error(1,"can't match worker in that time");
		}
		else
		{
    }

    public Standard saveStandard(String stdname,int roomarea,int bedno,String equip1,String equip2){
        Standard s = new Standard();
        s.setStdname(stdname);
        s.setRoomerea(roomarea);
        s.setBedno(bedno);
        s.setEquip1(equip1);
        s.setEquip2(equip2);
        return s;
    }
}
package com.hotel.controller;

@RestController
public class GarageController
{
	private final GarageService garageService;

	private final GarageHistoryService garageHistoryService;

	private final FinanceService financeService;

	@Autowired
	public GarageController(GarageService garageService,GarageHistoryService garageHistoryService,
	public Result<GarageHistory> garageDriveOut(@RequestParam("garageno") int garageNo)
	{
		Garage garage=garageService.findById(garageNo);
		Timestamp endTime=new Timestamp(System.currentTimeMillis());

		Garage garageTemp=new Garage(garage);

		garageUpdate(garage.getGarageno(),0,null,null,null);

		return new GarageHistoryController(garageHistoryService,financeService).garageHistoryInsertLog(garageTemp,endTime);
	}

	/**
	 * @param number 想要增加车位的数量
	 * @return 返回车库扩增结果(增加车位的具体信息)
	 */
	@RequestMapping("/garage/insertnullgarage/{number}")
	public Result<List<Garage>> garageInsertNullGarage(@PathVariable("number") int number)
	{
		List<Garage> garageList=new ArrayList<>();
		int temp=number;
		do
		{
			Garage newGarage=new Garage();

			if(temp==number)
			{
				newGarage.setGarageno(1);
			}
			newGarage.setBrand(null);
			newGarage.setStarttime(null);
			newGarage.setEndtime(null);
			newGarage.setType(0);
			garageList.add(garageService.save(newGarage));
			garageService.save(newGarage);
		}while (--number>0);

		return ResultReturn.success(garageList);
	}
}
package com.hotel.controller;

	@RequestMapping("/garage/insertnullgarage/{number}")
	public Result<List<Garage>> garageInsertNullGarage(@PathVariable("number") int number)
	{
		List<Garage> garageList=new ArrayList<>();
		int temp=number;
		do
		{
			Garage newGarage=new Garage();

			if(temp==number)
			{
				newGarage.setGarageno(1);
			}
			newGarage.setBrand(null);
			newGarage.setStarttime(null);
			newGarage.setEndtime(null);
			newGarage.setType(0);
			garageList.add(garageService.save(newGarage));
			garageService.save(newGarage);
		}while (--number>0);

		return ResultReturn.success(garageList);
	}
}
package com.hotel.controller;

@RestController
public class OrderHistoryController
{

	private final OrderHistoryService orderHistoryService;

	private final FinanceService financeService;

	@Autowired
	public OrderHistoryController(OrderHistoryService orderHistoryService,FinanceService financeService)
	{
		this.orderHistoryService=orderHistoryService;
		this.financeService=financeService;
	}

	@RequestMapping("/order/orderroom/{orderno}")
	public Result<List<OrderRoom>> orderroomList(@PathVariable("orderno") int orderno)
	{
		return ResultReturn.success(orderroomservice.findAll(orderno));
	}

	/**
	 * 根据订单-房间序号查找对应记录
	 *
	 * @param orno 订单-房间表的序号
	 * @return 返回对应的订单-房间信息
	 */
	@RequestMapping("/order/orderroom/orderroomSearchOne/{orno}")
	public Result<OrderRoom> orderroomSearchOne(@PathVariable("orno") int orno)
	{
		return ResultReturn.success(orderroomservice.findOne(orno));
	}

	/**
	 * OrderRoom表更新
	 *
	 * @param orno         编号
	 * @param brand        车牌号
	 * @param roomnoAfter  之前的房间号
	 * @param roomnoBefore 现在重新设定的房间号(计算价格需要)
	 * @param orderno      订单号(保存当前订单的价格需要)
	 * @return 返回保存的orderroom对象
	 */
	@RequestMapping("/order/orderroom/update/{orno}")
	public Result orderroomUpdate(@PathVariable("orno") int orno,@RequestParam("brand") String brand,
								  @RequestParam("roomnoAfter") int roomnoAfter,
								  @RequestParam("roomnoBefore") int roomnoBefore,@RequestParam("orderno") int orderno)
	{
		OrderRoom or=orderroomservice.findOne(orno);
		or.setBrand(brand);
		or.setRoomno(roomnoAfter);

		List<Roomid> ri=roomidservice.findAll(roomnoBefore);
		for (Roomid aRi : ri)
		{
			aRi.setRoomno(roomnoAfter);
		}

			return new OrderHistoryController(orderHistoryService,financeService).orderHistoryInsert(orderTemp);
		}
		else
		{
			throw new HotelException(ExceptionType.ORDER_ISENTER_ERROR.getCode(),
					ExceptionType.ORDER_ISENTER_ERROR.getMsg());
		}

	}
}
package com.hotel.controller;

@RestController
public class EmployController
{
    private final EmployService employservice;

    @Autowired
    public EmployController(EmployService employservice)
    {
        this.employservice=employservice;
    }

    @Autowired

@RestController
public class OrderHistoryController
{

	private final OrderHistoryService orderHistoryService;

	private final FinanceService financeService;

	@Autowired
	public OrderHistoryController(OrderHistoryService orderHistoryService,FinanceService financeService)
	{
		this.orderHistoryService=orderHistoryService;
		this.financeService=financeService;
	}

	/**
	 * @return 返回订单历史集合
	 */
	@RequestMapping("/orderhistory/getall")
	public Result<List<OrderHistory>> getAll()
	{
		return ResultReturn.success(orderHistoryService.findAll());
	}

	/**
	 * @param year  年份
	 * @param month 月份
	 * @param day   天数
	 * @return 返回对应的日订单历史
	 */
	@RequestMapping("/orderhistory/getallbyday")
	public Result<List<OrderHistory>> getAllByDay(@RequestParam("year") int year,@RequestParam("month") int month,
												  @RequestParam("day") int day)
	{
		return ResultReturn.success(orderHistoryService.findByDay(year,month,day));
	}

	/**
	 * @param year  年份
	 * @param month 月份
        else {
            response.sendRedirect(basePath+"/403");
        }
    }

    }
package com.hotel.handle;

@ControllerAdvice
public class ExceptionHandle
{
	@ExceptionHandler(value=Exception.class)
	@ResponseBody
	public Result handel(Exception e)
	{
		if(e instanceof HotelException)
		{
			HotelException hotelException=(HotelException)e;
			return ResultReturn.error(
					hotelException.getCode(),
					hotelException.getMessage()
			);
		}
		else
		{
			e.printStackTrace();
			
			return ResultReturn.error(
					ExceptionType.UNKNOWN_ERROR.getCode(),
					ExceptionType.UNKNOWN_ERROR.getMsg()
			);
		}

	}
}
package com.hotel.controller;

	}

}
package com.hotel.controller;

@RestController
public class FinanceController
{
	private final FinanceService financeService;

	@Autowired
	public FinanceController(FinanceService financeService)
	{
		this.financeService=financeService;
	}

	/**
	 * @return 返回全部财务报表
	 */
	@RequestMapping("/finance/getall")
	public Result<Finance> getAll()
	{
		return ResultReturn.success(financeService.findAll());
	}

	/**
	 * @param year  欲查询日财务报表的年份
	 * @param month 欲查询日财务报表的月份
	{
		OrderHistory orderHistory=saveOrderHistory(order);
		orderHistory.setOrderno(new TimeStampUtil().getString(new Timestamp(System.currentTimeMillis())));

		new FinanceController(financeService).insert(orderHistory);
		return ResultReturn.success(orderHistoryService.save(orderHistory));
	}
}
package com.hotel.controller;

@RestController
public class GarageHistoryController
{
	private final GarageHistoryService garageHistoryService;

	private final FinanceService financeService;

	@Autowired
	public GarageHistoryController(GarageHistoryService garageHistoryService,FinanceService financeService)
	{
		this.garageHistoryService=garageHistoryService;
		this.financeService=financeService;
	}

	/**
	 * @return 返回车库历史纪录列表
	 */
	@RequestMapping("/garagehistory/getall")
	public Result<List<GarageHistory>> garageHistoryList()
								  @RequestParam("roomnoBefore") int roomnoBefore,@RequestParam("orderno") int orderno)
	{
		OrderRoom or=orderroomservice.findOne(orno);
		or.setBrand(brand);
		or.setRoomno(roomnoAfter);

		List<Roomid> ri=roomidservice.findAll(roomnoBefore);
		for (Roomid aRi : ri)
		{
			aRi.setRoomno(roomnoAfter);
		}
		roomidservice.saveAll(ri);

		Order order=orderservice.findByOrderNo(orderno);
		Room roomAfter=roomservice.findByRoom(roomnoAfter);
		Room roomBefore=roomservice.findByRoom(roomnoBefore);
		order.setPrice(order.getPrice()+roomAfter.getPrice()-roomBefore.getPrice());
		orderservice.save(order);

		return ResultReturn.success(orderroomservice.save(or));
	}

	//roomid表查看
	@RequestMapping("/order/orderroom/roomid/list/{roomno}")
	public Result<List<Roomid>> roomidList(@PathVariable("roomno") int roomno)
	{
		return ResultReturn.success(roomidservice.findAll(roomno));
	}

	/**
	 * 根据房间-身份证表的序号查找对应信息
	 *
	 * @param rino 房间-身份证表的序号
	 * @return 返回对应信息
	 */
	@RequestMapping("/order/orderroom/roomid/roomidSearchOne/{rino}")
	public Result<Roomid> roomidSearchOne(@PathVariable("rino") int rino)
	{
		return ResultReturn.success(roomidservice.findByRino(rino));
	}

	/**
	 * 房间-身份证表更新
	 *
	 * @param rino 房间-身份证表的序号
	 * @param name 姓名
	 * @param id   身份证
	 * @return 返回更改后的信息

@RestController
public class EmployController
{
    private final EmployService employservice;

    @Autowired
    public EmployController(EmployService employservice)
    {
        this.employservice=employservice;
    }

    @Autowired
    EventService eventService;

    @RequestMapping("/employ/list")
    public Result<Employ> employList() {
        return ResultReturn.success(employservice.findAll());
    }

    @RequestMapping("/employ/searchOne/{employno}")
    public Result employSearchOne(@PathVariable("employno") int employno) {
        Employ r = employservice.findByEmployno(employno);
        if(r == null) {
            return ResultReturn.error(1,"it's not exist, you can't delete!");
        }
        else {
            return ResultReturn.success(r);
        }
    }

    @RequestMapping("/employ/add")
    public Result employAdd(@RequestParam("employno")int employno,@RequestParam("employname") String employname,
                            @RequestParam("employsex")int employsex,@RequestParam("employage") int employage,
                            @RequestParam("employposition")int employposition,
                            @RequestParam("employauthority") int employauthority,
                            @RequestParam("employpaymentpermonth")int employpaymentpermonth,
                            @RequestParam("employworktime") int employworktime,
                            @RequestParam("username") String username,
                            @RequestParam("password") String password) {
        Employ e = employservice.findByEmployno(employno);
        if(e!=null)
            return ResultReturn.error(2,"that employno arleady exist");
        else{
            e = saveEmploy(employno,employname,employsex,employage,employposition,employauthority,
                    employpaymentpermonth,employworktime,username,password);
            return ResultReturn.success(employservice.save(e));
        }
    }

请添加图片描述

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

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
宾馆管理系统数据库文件 -- -- Server version 5.0.45-community-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Create schema neohotel -- -- CREATE DATABASE IF NOT EXISTS neohotel; USE neohotel; -- -- Definition of table `nhbalancement` -- DROP TABLE IF EXISTS `nhbalancement`; CREATE TABLE `nhbalancement` ( `BMID` varchar(32) NOT NULL, `BMCHECKINORDERID` varchar(32) NOT NULL, `BMGUESTID` varchar(32) default NULL, `BMTYPE` varchar(16) NOT NULL, `BMTOTALRATE` decimal(14,2) NOT NULL, `BMPAIDMONEY` decimal(14,2) NOT NULL, `BMRECEIVMONEY` decimal(14,2) NOT NULL, `BMCREATETIME` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `BMOPERATOR` varchar(20) NOT NULL, `BMPAYMENTMODEL` varchar(16) NOT NULL, `BMREMARK` varchar(100) default NULL, PRIMARY KEY (`BMID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `nhbalancement` -- /*!40000 ALTER TABLE `nhbalancement` DISABLE KEYS */; INSERT INTO `nhbalancement` (`BMID`,`BMCHECKINORDERID`,`BMGUESTID`,`BMTYPE`,`BMTOTALRATE`,`BMPAIDMONEY`,`BMRECEIVMONEY`,`BMCREATETIME`,`BMOPERATOR`,`BMPAYMENTMODEL`,`BMREMARK`) VALUES ('402881e51a448696011a4489783f0003','402881e51a448696011a4489373e0001','402881e51a39c232011a39da4d3e0005','结单','320.00','1000.00','200.00','2008-06-01 22:30:37','admin','现金','remark'), ('402881e51a53efae011a53f874550004','402881e51a53efae011a53f77fc40001','402881e51a39c232011a39da4d3e0005','结单','350.00','0.00','0.00','2008-06-04 22:26:09','admin','现金','fdsafdsa'); /*!40000 ALTER TABLE `nhbalancement` ENABLE KEYS */; -- -- Definition of table `nhbaseinfo` --

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值