基于javaweb+mysql的ssmyy酒店管理系统(java+jsp+easyui+echars+ssm+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSMyy酒店管理系统(java+jsp+easyui+echars+ssm+mysql)
基础环境
搭建环境
Tomcat 8.5
Java 1.8+
Mysql 5.7
涉及技术
Spring、Mybatis、MySql、easyui、h-ui、Jsp、echars
项目介绍
酒店管理系统的目标是为用户提供高效的服务,减少手工处理的繁琐与误差,及时准确地反映酒店工作情况、经营信息,从而提高酒店工作质量,获得更好的经济效益,实现客房管理的规范化、自动化。具体目标包括:
高效的客房预订及订单处理。
准确无误地记录客人每笔消费信息。
实时、快速、准确提供客房动态。
酒店收益的最终统计。
系统运行稳定可靠、各项维护功能齐全、易于维护。
简单、友好的操作界面
前台页面:
模块
主要功能
酒店信息展示
客房信息展示、房间状态查询、房间预定、客房信息检索、
会员用户预订
会员注册登录、用户中心、订单查询、用户信息修改、用户密码修改
后台页面:
模块
主要功能
系统设置
菜单管理、角色管理、修改密码
用户管理
用户列表管理
系统日志
日志列表
酒店管理
楼层管理、房型管理、房间管理、客户管理、预订管理、入住管理
营业统计
统计图标
Map<String,String> retMap = new HashMap<String, String>();
if(account == null){
retMap.put("type", "error");
retMap.put("msg", "请填写正确的用户信息!");
return retMap;
}
if(StringUtils.isEmpty(account.getName())){
retMap.put("type", "error");
retMap.put("msg", "用户名不能为空!");
return retMap;
}
if(StringUtils.isEmpty(account.getPassword())){
retMap.put("type", "error");
retMap.put("msg", "密码不能为空!");
return retMap;
}
if(StringUtils.isEmpty(vcode)){
retMap.put("type", "error");
retMap.put("msg", "验证码不能为空!");
return retMap;
}
Object attribute = request.getSession().getAttribute("accountLoginCpacha");
if(attribute == null){
retMap.put("type", "error");
retMap.put("msg", "验证码过期,请刷新!");
return retMap;
}
if(!vcode.equalsIgnoreCase(attribute.toString())){
retMap.put("type", "error");
retMap.put("msg", "验证码错误!");
return retMap;
}
Account findByName = accountService.findByName(account.getName());
if(findByName == null){
retMap.put("type", "error");
retMap.put("msg", "用户名不存在!");
return retMap;
}
if(!account.getPassword().equals(findByName.getPassword())){
retMap.put("type", "error");
retMap.put("msg", "密码错误!");
return retMap;
}
if(findByName.getStatus() == -1){
retMap.put("type", "error");
retMap.put("msg", "该用户已被禁用,请联系管理员!");
return retMap;
}
request.getSession().setAttribute("account", findByName);
/**
* 预定房间页面
* @param model
* @return
*/
@RequestMapping(value="/book_order",method=RequestMethod.GET)
public ModelAndView bookOrder(ModelAndView model,Long roomTypeId
){
model.addObject("roomType", roomTypeService.find(roomTypeId));
model.setViewName("home/account/book_order");
return model;
}
/**
* 预定信息提交
* @param account
* @return
*/
@RequestMapping(value="/book_order",method=RequestMethod.POST)
@ResponseBody
public Map<String,String> bookOrderAct(BookOrder bookOrder,HttpServletRequest request){
Map<String, String> ret = new HashMap<String, String>();
if(bookOrder == null){
ret.put("type", "error");
ret.put("msg", "请填写正确的预定订单信息!");
return ret;
}
Account account = (Account)request.getSession().getAttribute("account");
if(account == null){
ret.put("type", "error");
ret.put("msg", "客户不能为空!");
return ret;
}
bookOrder.setAccountId(account.getId());
if(bookOrder.getRoomTypeId() == null){
ret.put("type", "error");
ret.put("msg", "房型不能为空!");
return ret;
}
if(StringUtils.isEmpty(bookOrder.getName())){
ret.put("type", "error");
ret.put("msg", "预定订单联系人名称不能为空!");
return ret;
}
if(StringUtils.isEmpty(bookOrder.getMobile())){
ret.put("type", "error");
ret.put("msg", "预定订单联系人手机号不能为空!");
return ret;
}
if(StringUtils.isEmpty(bookOrder.getIdCard())){
ret.put("type", "error");
ret.put("msg", "联系人身份证号不能为空!");
}
if(roomService.add(room) <= 0){
ret.put("type", "error");
ret.put("msg", "添加失败,请联系管理员!");
return ret;
}
ret.put("type", "success");
ret.put("msg", "添加成功!");
return ret;
}
/**
* 房间信息编辑操作
* @param roomType
* @return
*/
@RequestMapping(value="/edit",method=RequestMethod.POST)
@ResponseBody
public Map<String, String> edit(Room room){
Map<String, String> ret = new HashMap<String, String>();
if(room == null){
ret.put("type", "error");
ret.put("msg", "请填写正确的房间信息!");
return ret;
}
if(StringUtils.isEmpty(room.getSn())){
ret.put("type", "error");
ret.put("msg", "房间编号不能为空!");
return ret;
}
if(room.getRoomTypeId() == null){
ret.put("type", "error");
ret.put("msg", "请选择房间类型!");
return ret;
}
if(room.getFloorId() == null){
ret.put("type", "error");
ret.put("msg", "请选择房间所属楼层!");
return ret;
}
if(isExist(room.getSn(), room.getId())){
ret.put("type", "error");
ret.put("msg", "该房间编号已经存在!");
return ret;
}
if(roomService.edit(room) <= 0){
ret.put("type", "error");
ret.put("msg", "修改失败,请联系管理员!");
return ret;
}
return ret;
}
ret.put("type", "success");
ret.put("msg", "用户删除成功!");
return ret;
}
/**
* 上传图片
* @param photo
* @param request
* @return
*/
@RequestMapping(value="/upload_photo",method=RequestMethod.POST)
@ResponseBody
public Map<String, String> uploadPhoto(MultipartFile photo,HttpServletRequest request){
Map<String, String> ret = new HashMap<String, String>();
if(photo == null){
ret.put("type", "error");
ret.put("msg", "选择要上传的文件!");
return ret;
}
if(photo.getSize() > 1024*1024*1024){
ret.put("type", "error");
ret.put("msg", "文件大小不能超过10M!");
return ret;
}
//获取文件后缀
String suffix = photo.getOriginalFilename().substring(photo.getOriginalFilename().lastIndexOf(".")+1,photo.getOriginalFilename().length());
if(!"jpg,jpeg,gif,png".toUpperCase().contains(suffix.toUpperCase())){
ret.put("type", "error");
ret.put("msg", "请选择jpg,jpeg,gif,png格式的图片!");
return ret;
}
String savePath = request.getServletContext().getRealPath("/") + "/resources/upload/";
File savePathFile = new File(savePath);
if(!savePathFile.exists()){
//若不存在改目录,则创建目录
savePathFile.mkdir();
}
String filename = new Date().getTime()+"."+suffix;
try {
//将文件保存至指定目录
photo.transferTo(new File(savePath+filename));
}catch (Exception e) {
// TODO Auto-generated catch block
}
/**
* 本系统所有的验证码均采用此方法
* @param vcodeLen
* @param width
* @param height
* @param cpachaType:用来区别验证码的类型,传入字符串
* @param request
* @param response
*/
@RequestMapping(value="/get_cpacha",method=RequestMethod.GET)
public void generateCpacha(
@RequestParam(name="vl",required=false,defaultValue="4") Integer vcodeLen,
@RequestParam(name="w",required=false,defaultValue="100") Integer width,
@RequestParam(name="h",required=false,defaultValue="30") Integer height,
@RequestParam(name="type",required=true,defaultValue="loginCpacha") String cpachaType,
HttpServletRequest request,
HttpServletResponse response){
CpachaUtil cpachaUtil = new CpachaUtil(vcodeLen, width, height);
String generatorVCode = cpachaUtil.generatorVCode();
request.getSession().setAttribute(cpachaType, generatorVCode);
BufferedImage generatorRotateVCodeImage = cpachaUtil.generatorRotateVCodeImage(generatorVCode, true);
try {
ImageIO.write(generatorRotateVCodeImage, "gif", response.getOutputStream());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/**
* 房间管理后台控制器
*
*/
@RequestMapping("/admin/room")
@Controller
public class RoomController {
@Autowired
private RoomTypeService roomTypeService;
@Autowired
private RoomService roomService;
@Autowired
private FloorService floorService;
/**
* 房间管理列表页面
* @param model
* @return
*/
}
/**
* 房间管理后台控制器
*
*/
@RequestMapping("/admin/room")
@Controller
public class RoomController {
@Autowired
private RoomTypeService roomTypeService;
@Autowired
private RoomService roomService;
@Autowired
private FloorService floorService;
/**
public class MenuController {
@Autowired
private MenuService menuService;
/**
* 菜单管理列表页
* @param model
* @return
*/
@RequestMapping(value="/list",method=RequestMethod.GET)
public ModelAndView list(ModelAndView model){
model.addObject("topList", menuService.findTopList());
model.setViewName("menu/list");
return model;
}
/**
* 获取菜单列表
* @param page
* @param name
* @return
*/
@RequestMapping(value="/list",method=RequestMethod.POST)
@ResponseBody
public Map<String, Object> getMenuList(Page page,
@RequestParam(name="name",required=false,defaultValue="") String name
){
Map<String, Object> ret = new HashMap<String, Object>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("offset", page.getOffset());
queryMap.put("pageSize", page.getRows());
queryMap.put("name", name);
List<Menu> findList = menuService.findList(queryMap);
ret.put("rows", findList);
ret.put("total", menuService.getTotal(queryMap));
return ret;
}
/**
* 获取指定目录下的系统icon集合
* @param request
* @return
*/
@RequestMapping(value="/get_icons",method=RequestMethod.POST)
@ResponseBody
public Map<String, Object> getIconList(HttpServletRequest request){
Map<String, Object> ret = new HashMap<String, Object>();
String realPath = request.getServletContext().getRealPath("/");
File file = new File(realPath + "\\resources\\admin\\easyui\\css\\icons");
List<String> icons = new ArrayList<String>();
if(!file.exists()){
if(room != null){
//要把房间状态设置为已入住
room.setStatus(1);
roomService.edit(room);
}
ret.put("type", "success");
ret.put("msg", "添加成功!");
return ret;
}
/**
* 入住信息编辑操作
* @param account
* @return
*/
@RequestMapping(value="/edit",method=RequestMethod.POST)
@ResponseBody
public Map<String, String> edit(Checkin checkin,
@RequestParam(name="bookOrderId",required=false) Long bookOrderId
){
Map<String, String> ret = new HashMap<String, String>();
if(checkin == null){
ret.put("type", "error");
ret.put("msg", "请填写正确的入住信息!");
return ret;
}
if(checkin.getRoomId() == null){
ret.put("type", "error");
ret.put("msg", "房间不能为空!");
return ret;
}
if(checkin.getRoomTypeId() == null){
ret.put("type", "error");
ret.put("msg", "房型不能为空!");
return ret;
}
if(StringUtils.isEmpty(checkin.getName())){
ret.put("type", "error");
ret.put("msg", "入住联系人名称不能为空!");
return ret;
}
@Controller
public class HomeController {
@Autowired
private RoomTypeService roomTypeService;
@Autowired
private AccountService accountService;
/**
* 前台首页
* @param model
* @param name
* @return
*/
@RequestMapping(value="/index",method=RequestMethod.GET)
public ModelAndView list(ModelAndView model,
@RequestParam(name="name",defaultValue="") String name
){
Map<String,Object> queryMap = new HashMap<String, Object>();
queryMap.put("name", name);
queryMap.put("offset", 0);
queryMap.put("pageSize", 999);
model.addObject("roomTypeList", roomTypeService.findList(queryMap));
model.setViewName("home/index/index");
model.addObject("kw", name);
return model;
}
/**
* 登录页面
* @param model
* @return
*/
@RequestMapping(value="/login",method=RequestMethod.GET)
public ModelAndView login(ModelAndView model
){
model.setViewName("home/index/login");
return model;
}
/**
* 注册页面
return ret;
}
//首先操作房间状态
Room room = roomService.find(checkin.getRoomId());
if(room != null){
room.setStatus(2);
roomService.edit(room);
}
//其次修改房型可用数、入住数、状态
RoomType roomType = roomTypeService.find(checkin.getRoomTypeId());
if(roomType != null){
roomType.setAvilableNum(roomType.getAvilableNum() + 1);
if(roomType.getAvilableNum() > roomType.getRoomNum()){
roomType.setAvilableNum(roomType.getRoomNum());
}
roomType.setLivedNum(roomType.getLivedNum() - 1);
if(roomType.getStatus() == 0){
roomType.setStatus(1);
}
if(checkin.getBookOrderId() != null){
roomType.setBookNum(roomType.getBookNum() - 1);
}
roomTypeService.updateNum(roomType);
roomTypeService.edit(roomType);
}
//判断是否来自预定
if(checkin.getBookOrderId() != null){
BookOrder bookOrder = bookOrderService.find(checkin.getBookOrderId());
bookOrder.setStatus(2);
bookOrderService.edit(bookOrder);
}
ret.put("type", "success");
ret.put("msg", "退房成功!");
return ret;
}
/**
* 根据房间类型获取房间
* @param roomTypeId
* @return
*/
@RequestMapping(value="/load_room_list",method=RequestMethod.POST)
@ResponseBody
public List<Map<String, Object>> load_room_list(Long roomTypeId){
List<Map<String, Object>> retList = new ArrayList<Map<String,Object>>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("roomTypeId", roomTypeId);
queryMap.put("status", 0);
queryMap.put("offset", 0);
queryMap.put("pageSize", 999);
/**
* 用户管理控制器
*
*/
@RequestMapping("/admin/user")
@Controller
public class UserController {
@Autowired
private UserService userService;
@Autowired
private RoleService roleService;
/**
* 用户列表页面
* @param model
* @return
*/
@RequestMapping(value="/list",method=RequestMethod.GET)
public ModelAndView list(ModelAndView model){
Map<String, Object> queryMap = new HashMap<String, Object>();
model.addObject("roleList", roleService.findList(queryMap));
model.setViewName("user/list");
return model;
}
/**
* 获取用户列表
* @param page
* @param username
* @param roleId
* @param sex
* @return
*/
@RequestMapping(value="/list",method=RequestMethod.POST)
@ResponseBody
public Map<String, Object> getList(Page page,
@RequestParam(name="username",required=false,defaultValue="") String username,
@Autowired
private BookOrderService bookOrderService;
/**
* 预定订单管理列表页面
* @param model
* @return
*/
@RequestMapping(value="/list",method=RequestMethod.GET)
public ModelAndView list(ModelAndView model){
model.addObject("roomTypeList", roomTypeService.findAll());
model.addObject("accountList", accountService.findAll());
model.setViewName("book_order/list");
return model;
}
/**
* 预定订单信息添加操作
* @param bookOrder
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.POST)
@ResponseBody
public Map<String, String> add(BookOrder bookOrder){
Map<String, String> ret = new HashMap<String, String>();
if(bookOrder == null){
ret.put("type", "error");
ret.put("msg", "请填写正确的预定订单信息!");
return ret;
}
if(bookOrder.getAccountId() == null){
ret.put("type", "error");
ret.put("msg", "客户不能为空!");
return ret;
}
if(bookOrder.getRoomTypeId() == null){
ret.put("type", "error");
ret.put("msg", "房型不能为空!");
return ret;
}
if(StringUtils.isEmpty(bookOrder.getName())){
ret.put("type", "error");
ret.put("msg", "预定订单联系人名称不能为空!");
return ret;
@ResponseBody
public Map<String,Object> list(
@RequestParam(name="name",defaultValue="") String name,
Page page
){
Map<String,Object> ret = new HashMap<String, Object>();
Map<String,Object> queryMap = new HashMap<String, Object>();
queryMap.put("name", name);
queryMap.put("offset", page.getOffset());
queryMap.put("pageSize", page.getRows());
ret.put("rows", floorService.findList(queryMap));
ret.put("total", floorService.getTotal(queryMap));
return ret;
}
/**
* 楼层信息删除操作
* @param id
* @return
*/
@RequestMapping(value="/delete",method=RequestMethod.POST)
@ResponseBody
public Map<String, String> delete(Long id){
Map<String, String> ret = new HashMap<String, String>();
if(id == null){
ret.put("type", "error");
ret.put("msg", "请选择要删除的信息!");
return ret;
}
try {
if(floorService.delete(id) <= 0){
ret.put("type", "error");
ret.put("msg", "删除失败,请联系管理员!");
return ret;
}
} catch (Exception e) {
// TODO: handle exception
ret.put("type", "error");
ret.put("msg", "该楼层下存在房间信息,请先删除该楼层下的所有房间信息!");
return ret;
}
ret.put("type", "success");
ret.put("msg", "删除成功!");
return ret;
}
return ret;
}
ret.put("type", "success");
ret.put("msg", "角色删除成功!");
return ret;
}
/**
* 获取所有的菜单信息
* @return
*/
@RequestMapping(value="/get_all_menu",method=RequestMethod.POST)
@ResponseBody
public List<Menu> getAllMenu(){
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("offset", 0);
queryMap.put("pageSize", 99999);
return menuService.findList(queryMap);
}
/**
* 添加权限
* @param ids
* @return
*/
@RequestMapping(value="/add_authority",method=RequestMethod.POST)
@ResponseBody
public Map<String, String> addAuthority(
@RequestParam(name="ids",required=true) String ids,
@RequestParam(name="roleId",required=true) Long roleId
){
Map<String,String> ret = new HashMap<String, String>();
if(StringUtils.isEmpty(ids)){
ret.put("type", "error");
ret.put("msg", "请选择相应的权限!");
return ret;
}
if(roleId == null){
ret.put("type", "error");
ret.put("msg", "请选择相应的角色!");
return ret;
}
if(ids.contains(",")){
ids = ids.substring(0,ids.length()-1);
}
String[] idArr = ids.split(",");
if(idArr.length > 0){
authorityService.deleteByRoleId(roleId);
}
switch (type) {
case "month":{
ret.put("type", "success");
ret.put("content", getStatsValue(checkinService.getStatsByMonth()));
return ret;
}
case "day":{
ret.put("type", "success");
ret.put("content", getStatsValue(checkinService.getStatsByDay()));
return ret;
}
default:{
ret.put("type", "error");
ret.put("msg", "请选择正确的统计类型!");
return ret;
}
}
}
/**
* 把数据的键和值分开保存
* @param statsValue
* @return
*/
private Map<String, Object> getStatsValue(List<Map> statsValue){
Map<String, Object> ret = new HashMap<String, Object>();
List<String> keyList = new ArrayList<String>();
List<Float> valueList = new ArrayList<Float>();
for(Map m:statsValue){
keyList.add(m.get("stats_date").toString());
valueList.add(Float.valueOf(m.get("money").toString()));
}
ret.put("keyList", keyList);
ret.put("valueList", valueList);
return ret;
}
}
if(bookOrder.getAccountId() == null){
ret.put("type", "error");
ret.put("msg", "客户不能为空!");
return ret;
}
if(bookOrder.getRoomTypeId() == null){
ret.put("type", "error");
ret.put("msg", "房型不能为空!");
return ret;
}
if(StringUtils.isEmpty(bookOrder.getName())){
ret.put("type", "error");
ret.put("msg", "预定订单联系人名称不能为空!");
return ret;
}
if(StringUtils.isEmpty(bookOrder.getMobile())){
ret.put("type", "error");
ret.put("msg", "预定订单联系人手机号不能为空!");
return ret;
}
if(StringUtils.isEmpty(bookOrder.getIdCard())){
ret.put("type", "error");
ret.put("msg", "联系人身份证号不能为空!");
return ret;
}
if(StringUtils.isEmpty(bookOrder.getArriveDate())){
ret.put("type", "error");
ret.put("msg", "到达时间不能为空!");
return ret;
}
if(StringUtils.isEmpty(bookOrder.getLeaveDate())){
ret.put("type", "error");
ret.put("msg", "离店时间不能为空!");
return ret;
}
BookOrder existBookOrder = bookOrderService.find(bookOrder.getId());
if(existBookOrder == null){
ret.put("type", "error");
ret.put("msg", "请选择正确的数据进行编辑!");
return ret;
}
if(bookOrderService.edit(bookOrder) <= 0){
ret.put("type", "error");
ret.put("msg", "编辑失败,请联系管理员!");
return ret;
}
//判断房型是否发生变化
if(existBookOrder.getRoomTypeId().longValue() != bookOrder.getRoomTypeId().longValue()){
//房型发生了变化
//首先恢复原来房型的预定数及可用数
RoomType oldRoomType = roomTypeService.find(existBookOrder.getRoomTypeId());
oldRoomType.setAvilableNum(oldRoomType.getAvilableNum() + 1);
oldRoomType.setBookNum(oldRoomType.getBookNum() - 1);
roomTypeService.updateNum(oldRoomType);