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

    作者主页：夜未央5788

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

    文末获取源码

    酒店管理系统-温情小筑后台管理系统

    系统概要

    项目主要功能包括：
    住客管理：住客入住、住客列表；
    房间管理：房间列表、添加房间、修改房间状态；
    会员管理：新增会员、会员列表；
    系统设置：网站信息、修改密码、清除缓存；
    数据表：生成Excel并导出等功能，适合java新手学习；

    由于本程序规模不大，可供课程设计，毕业设计学习演示之用

    更多项目源码，请到“源码空间站”，地址：http://www.shuyue.fun/

    技术选型

    1.后台技术选型：SSM（Spring SpringMVC Mybatis）

    2.前端技术选型：LayUI

    开发环境

    1.编程语言：Java
    2.开发工具：IDEA/Eclipse、Navicat
    3.项目构建：Maven 3.5.2
    4.服务器：Tomcat 8.0及以上

    5.数据库：MySQL5.7

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 将项目中jdbc.properties配置文件中的数据库配置改为自己的配置;
    3. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，配置tomcat，然后运行；
    4. 运行项目，输入localhost:8080/ 登录

    运行

    导入项目并运行成功后，在tomcat路径中设置为/,注意路径中不要带有项目名，否则会导致项目运行异常；

    运行截图

     

     

     

     

     

     

     

     

    相关代码 

    AdminController

    1. package com.hotel.controller;
    2.  
    3. import com.hotel.pojo.Admin;
    4. import com.hotel.service.AdminServiceImpl;
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.stereotype.Controller;
    7. import org.springframework.web.bind.annotation.RequestMapping;
    8.  
    9. @Controller
    10. @RequestMapping("/admin")
    11.  
    12. public class AdminController {
    13.  
    14.     @Autowired
    15.             AdminServiceImpl adminService;
    16.  
    17.     @RequestMapping("/login")
    18.     public String login(String username, int password){
    19.  
    20.         Admin admin=adminService.findAdmin(username,password );
    21.        if(admin!=null){
    22.            if(admin.getPassword()==password){
    23.                return "index";
    24.            }else {
    25.                 return "error";
    26.            }
    27.        }
    28.         return "error";
    29.     }
    30.  
    31.     @RequestMapping("/updatePwd")
    32.     public String update(Admin admin){
    33.         adminService.updatePwd(admin);
    34.         System.out.println(admin);
    35.         return "suc_a";
    36.     }
    37. }

    ExcelController

    1. package com.hotel.controller;
    2.  
    3. import com.hotel.pojo.Home;
    4. import com.hotel.pojo.Vip;
    5. import com.hotel.service.HomeServiceImpl;
    6. import com.hotel.service.VipServiceImpl;
    7. import org.apache.poi.hssf.usermodel.HSSFRow;
    8. import org.apache.poi.hssf.usermodel.HSSFSheet;
    9. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
    10. import org.springframework.beans.factory.annotation.Autowired;
    11. import org.springframework.stereotype.Controller;
    12. import org.springframework.web.bind.annotation.RequestMapping;
    13.  
    14. import javax.servlet.http.HttpServletResponse;
    15. import java.io.IOException;
    16. import java.io.OutputStream;
    17. import java.util.List;
    18.  
    19. @Controller
    20. @RequestMapping("/excel")
    21. public class ExcelController {
    22.  
    23.     @Autowired
    24.     HomeServiceImpl homeService;
    25.     @Autowired
    26.     VipServiceImpl vipService;
    27.  
    28.     @RequestMapping("/home")
    29.     public void excel_home(HttpServletResponse response )throws IOException {
    30.  
    31.         response.setCharacterEncoding("UTF-8");
    32.         List homeList=homeService.queryAllHome();
    33.         //创建excel文件
    34.         HSSFWorkbook wb = new HSSFWorkbook();
    35.         //创建sheet页
    36.         HSSFSheet sheet = wb.createSheet("房间信息");
    37.         //创建标题行
    38.         HSSFRow titleRow = sheet.createRow(0);
    39.         titleRow.createCell(0).setCellValue("编号");
    40.         titleRow.createCell(1).setCellValue("房间号");
    41.         titleRow.createCell(2).setCellValue("房间类型");
    42.         titleRow.createCell(3).setCellValue("价格");
    43.         titleRow.createCell(4).setCellValue("状态");
    44.         titleRow.createCell(5).setCellValue("描述");
    45.  
    46.         //获取需要下载表对应的pojo类
    47.         for(Home home:homeList){
    48.             HSSFRow dataRow = sheet.createRow(sheet.getLastRowNum()+1);
    49.             dataRow.createCell(0).setCellValue(home.getId());
    50.             dataRow.createCell(1).setCellValue(home.getNum());
    51.             dataRow.createCell(2).setCellValue(home.getH_Type());
    52.             dataRow.createCell(3).setCellValue(home.getPrice());
    53.             dataRow.createCell(4).setCellValue(home.getState());
    54.             dataRow.createCell(5).setCellValue(home.getText());
    55.         }
    56.  
    57.         // 设置下载时客户端Excel的名称
    58.         response.setContentType("application/octet-stream;charset=utf-8");
    59.         response.setHeader("Content-Disposition", "attachment;filename="
    60.                 + new String("房间信息表".getBytes(),"iso-8859-1") + ".xls");
    61.  
    62.         OutputStream ouputStream = response.getOutputStream();
    63.         wb.write(ouputStream);
    64.         ouputStream.flush();
    65.         ouputStream.close();
    66.  
    67.     }
    68.  
    69.     @RequestMapping("/vip")
    70.     public void excel_vip(HttpServletResponse response )throws IOException {
    71.  
    72.         response.setCharacterEncoding("UTF-8");
    73.         List vipList=vipService.queryAllVip();
    74.         //创建excel文件
    75.         HSSFWorkbook wb = new HSSFWorkbook();
    76.         //创建sheet页
    77.         HSSFSheet sheet = wb.createSheet("会员信息");
    78.         //创建标题行
    79.         HSSFRow titleRow = sheet.createRow(0);
    80.         titleRow.createCell(0).setCellValue("编号");
    81.         titleRow.createCell(1).setCellValue("姓名");
    82.         titleRow.createCell(2).setCellValue("性别");
    83.         titleRow.createCell(3).setCellValue("身份证号");
    84.         titleRow.createCell(4).setCellValue("手机号");
    85.         titleRow.createCell(5).setCellValue("会员类型");
    86.         titleRow.createCell(6).setCellValue("开通时间");
    87.         titleRow.createCell(7).setCellValue("到期时间");
    88.  
    89.         for(Vip vip:vipList){
    90.             HSSFRow dataRow = sheet.createRow(sheet.getLastRowNum()+1);
    91.             dataRow.createCell(0).setCellValue(vip.getId());
    92.             dataRow.createCell(1).setCellValue(vip.getName());
    93.             dataRow.createCell(2).setCellValue(vip.getSex());
    94.             dataRow.createCell(3).setCellValue(vip.getCard());
    95.             dataRow.createCell(4).setCellValue(vip.getPhone());
    96.             dataRow.createCell(5).setCellValue(vip.getV_Type());
    97.             dataRow.createCell(6).setCellValue(vip.getStartTime());
    98.             dataRow.createCell(7).setCellValue(vip.getEndTime());
    99.         }
    100.  
    101.         // 设置下载时客户端Excel的名称
    102.         response.setContentType("application/octet-stream;charset=utf-8");
    103.         response.setHeader("Content-Disposition", "attachment;filename="
    104.                 + new String("客户会员名单".getBytes(),"iso-8859-1") + ".xls");
    105.  
    106.         OutputStream ouputStream = response.getOutputStream();
    107.         wb.write(ouputStream);
    108.         ouputStream.flush();
    109.         ouputStream.close();
    110.  
    111.     }
    112.  
    113. }

    GuestsController

    1. package com.hotel.controller;
    2.  
    3. import com.hotel.pojo.Guests;
    4. import com.hotel.service.GuestsServiceImpl;
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.stereotype.Controller;
    7. import org.springframework.web.bind.annotation.RequestMapping;
    8. import org.springframework.web.servlet.ModelAndView;
    9.  
    10. import java.util.ArrayList;
    11. import java.util.List;
    12.  
    13. @Controller
    14. @RequestMapping("/guests")
    15. public class GuestsController {
    16.  
    17.     @Autowired
    18.             GuestsServiceImpl guestsService;
    19.  
    20.     @RequestMapping("/add")
    21.     public ModelAndView add(Guests guests){
    22.         ModelAndView mv = new ModelAndView();
    23.         guestsService.addGuests(guests);
    24.         mv.setViewName("suc_g");
    25.         return mv;
    26.     }
    27.  
    28.     @RequestMapping("/delete")
    29.     public String delete(int id){
    30.         guestsService.deleteGuestsById(id);
    31.         return "redirect:/guests/list";
    32.     }
    33.  
    34.     @RequestMapping("/list")
    35.     public ModelAndView list(){
    36.         ModelAndView mv = new ModelAndView();
    37.         List guestsList=guestsService.queryAllGuests();
    38.         mv.addObject("list",guestsList);
    39.         mv.setViewName("guests_list");
    40.         return mv;
    41.     }
    42.  
    43.     @RequestMapping("/update1")
    44.     public ModelAndView update1(int id){
    45.         ModelAndView mv = new ModelAndView();
    46.         Guests guests = guestsService.queryGuestsById(id);
    47.         mv.addObject("g",guests);
    48.         mv.setViewName("guests_update");
    49.         return mv;
    50.     }
    51.  
    52.     @RequestMapping("/update2")
    53.     public String update2(Guests g ){
    54.         guestsService.updateGuestsById(g);
    55.         return ("redirect:/guests/list");
    56.     }
    57.  
    58.     @RequestMapping("/find")
    59.     public ModelAndView find(String findByPhone){
    60.         ModelAndView mv = new ModelAndView();
    61.         Guests guests = guestsService.queryGuestsByPhone(findByPhone);
    62.         List guestsList=new ArrayList();
    63.         guestsList.add(guests);
    64.         if (guests==null){
    65.             guestsList=guestsService.queryAllGuests();
    66.            mv.addObject("error","未查询出结果");
    67.         }
    68.         mv.addObject("list",guestsList);
    69.         mv.setViewName("guests_list");
    70.         return mv;
    71.     }
    72. }

    HomeController

    1. package com.hotel.controller;
    2.  
    3. import com.hotel.pojo.Home;
    4. import com.hotel.service.HomeServiceImpl;
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.stereotype.Controller;
    7. import org.springframework.ui.Model;
    8. import org.springframework.web.bind.annotation.RequestMapping;
    9. import org.springframework.web.servlet.ModelAndView;
    10.  
    11. import java.io.*;
    12. import java.util.ArrayList;
    13. import java.util.List;
    14. import java.util.UUID;
    15.  
    16. @Controller
    17. @RequestMapping("/home")
    18.  
    19. public class HomeController {
    20.  
    21.     @Autowired
    22.             HomeServiceImpl homeService;
    23.  
    24.     @RequestMapping("/add")
    25.     public String add(Home home, Model model) throws IOException{
    26.  
    27.         String sqlPath = null;
    28.         //定义文件保存的本地路径
    29. //        String localPath="/DownLoad/";
    30.         String localPath="/Users/admin/Desktop/log/";
    31.         //定义 文件名
    32.         String filename=null;
    33.         if(!home.getFile().isEmpty()){
    34.             //生成uuid作为文件名称
    35.             String uuid = UUID.randomUUID().toString().replaceAll("-","");
    36.             //获得文件类型（可以判断如果不是图片，禁止上传）
    37.             String contentType=home.getFile().getContentType();
    38.             //获得文件后缀名
    39.             String suffixName=contentType.substring(contentType.indexOf("/")+1);
    40.             //得到 文件名
    41.             filename=uuid+"."+suffixName;
    42.             System.out.println(filename);
    43.             //文件保存路径
    44.             home.getFile().transferTo(new File(localPath+filename));
    45.         }
    46.         //把图片的相对路径保存至数据库
    47.         sqlPath = "/upload/"+filename;
    48.         System.out.println(sqlPath);
    49.         home.setImg(sqlPath);
    50.  
    51.         homeService.addHome(home);
    52.         model.addAttribute("home",home);
    53.         return "home_show";
    54.     }
    55.  
    56.     @RequestMapping("/delete")
    57.     public String delete(Integer  id){
    58.         homeService.deleteHomeById(id);
    59.         return "redirect:/home/list";
    60.     }
    61.  
    62.     @RequestMapping("/list")
    63.     public ModelAndView list(){
    64.         ModelAndView mv = new ModelAndView();
    65.         List homeList=homeService.queryAllHome();
    66.         mv.addObject("list",homeList);
    67.         mv.setViewName("home_list");
    68.         return mv;
    69.     }
    70.  
    71.     @RequestMapping("/update1")
    72.     public ModelAndView update1(Integer  id){
    73.         ModelAndView mv = new ModelAndView();
    74.         Home home = homeService.queryHomeById(id);
    75.         mv.addObject("h",home);
    76.         mv.setViewName("home_update");
    77.         return mv;
    78.     }
    79.  
    80.     @RequestMapping("/update2")
    81.     public String update2(Home h)throws IOException{
    82.         String sqlPath = null;
    83.         //定义文件保存的本地路径
    84. //        String localPath="/Download/";
    85.         String localPath="/Users/admin/Desktop/log/";
    86.         //定义 文件名
    87.         String filename=null;
    88.         if(!h.getFile().isEmpty()){
    89.             //生成uuid作为文件名称
    90.             String uuid = UUID.randomUUID().toString().replaceAll("-","");
    91.             //获得文件类型（可以判断如果不是图片，禁止上传）
    92.             String contentType=h.getFile().getContentType();
    93.             //获得文件后缀名
    94.             String suffixName=contentType.substring(contentType.indexOf("/")+1);
    95.             //得到 文件名
    96.             filename=uuid+"."+suffixName;
    97.             System.out.println(filename);
    98.             //文件保存路径
    99.             h.getFile().transferTo(new File(localPath+filename));
    100.         }
    101.         //把图片的相对路径保存至数据库
    102.         sqlPath = "/upload/"+filename;
    103.         System.out.println(sqlPath);
    104.         h.setImg(sqlPath);
    105.  
    106.         homeService.updateHomeById(h);
    107.         return ("redirect:/home/list");
    108.     }
    109.  
    110.     @RequestMapping("/show")
    111.     public ModelAndView show(Integer  id){
    112.         ModelAndView mv = new ModelAndView();
    113.         Home home=homeService.queryHomeById(id);
    114.         mv.addObject("home",home);
    115.         mv.setViewName("home_show");
    116.         return mv;
    117.     }
    118.  
    119.     @RequestMapping("/find")
    120.     public ModelAndView find(int findByNum ){
    121.         ModelAndView mv = new ModelAndView();
    122.         Home home = homeService.queryHomeByNum(findByNum);
    123.         List homeList=new ArrayList();
    124.         homeList.add(home);
    125.         if (home==null){
    126.             homeList=homeService.queryAllHome();
    127.             mv.addObject("error","未查询出结果");
    128.         }
    129.         mv.addObject("list",homeList);
    130.         mv.setViewName("home_list");
    131.         return mv;
    132.     }
    133.  
    134.     @RequestMapping("/type1")
    135.     public String type1(Integer id,Model model){
    136.         Home home = homeService.queryHomeById(id);
    137.         model.addAttribute("h",home);
    138.         return "H_Type_update";
    139.     }
    140.  
    141.     @RequestMapping("/type2")
    142.     public String type2(Home home){
    143.         homeService.updateH_TypeById(home);
    144.         return "redirect:/home/list";
    145.     }
    146. }

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

  • 相关阅读:
    Springboot集成redis
    自定义类型：结构体，枚举，联合
    代码Bug太多？给新人Code Review头都大了？快来试试SpotBugs
    Linux——（第五章）用户管理
    AIGC Midjourney 机器人绘画案例演示
    golang设计模式——享元模式
    Vue3中watch用法
    温馨浪漫HTML表白爱情源码大气简洁单页源码(html生日快乐网站制作)
    查看网卡速率脚本
    lwip_网卡
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/126798147