基于javaweb+mysql的ssm+maven民宿管理系统(java+ssm+jsp+bootstrap+jquery+mysql)

最新推荐文章于 2024-06-20 19:01:05 发布

m0_71480420

最新推荐文章于 2024-06-20 19:01:05 发布

阅读量33

点赞数

文章标签： java mysql maven

本文链接：https://blog.csdn.net/m0_71480420/article/details/132121645

版权

基于javaweb+mysql的ssm+maven民宿管理系统(java+ssm+jsp+bootstrap+jquery+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的SSM+Maven民宿管理系统(java+ssm+jsp+bootstrap+jquery+mysql)

项目介绍

游客功能:用户注册、登录、登录权限拦截、按名称搜索房间、支付流程、查看订单信息和状态、评论预定过的房间，并自动修改订单状态、查看统计剩余房间数量，数量为0时不可预定管理员功能：房间分类管理、房间管理、订单管理

高级功能：各种列表清单的导出和打印功能、订单组合条件查询

功能清单

游客功能

用户注册、登录 + 登录权限拦截 + 按名称搜索房间 + 支付流程 + 查看订单信息和状态 + 评论预定过的房间，并自动修改订单状态
查看统计剩余房间数量，数量为0时不可预定

管理员功能

房间分类管理 + 类型的删除、修改、查询（准备添加增添功能，即图片上传功能） + 类型所含属性的增删改查 + 房间分类图片上传 > 房间管理 + 房间增删改导印统 + 查询已上传房间的所有照片 + 房间的配套设施属性设置 + 房间价格（原价、活动价）、名称、描述等属性设置 + 房间存量统计 > 订单管理 + 订单信息修改、删除 + 订单组合条件查询

筛选出超时未评论的订单

高级功能 + 各种列表清单的导出和打印功能

订单组合条件查询

环境需要

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 5.7版本；

技术栈

后端：Spring SpringMVC MyBatis
前端：JSP+bootstrap+jQuery

使用说明

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

    }
}

@Controller
@RequestMapping("/user")
public class UserController {
    private static Logger logger = Logger.getLogger(OrderController.class);
    ModelAndView mav = new ModelAndView();
    @Autowired
    UserService userService;

    @RequestMapping(value = "/foreregister",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView register(HttpServletRequest request, HttpServletResponse response,User user) throws Exception{
        GeneralController generalController = new GeneralController();
        try{
            userService.insert(user);
            request.getSession().setAttribute("user",user);

        modelAndView.setViewName("bought");
        User user = (User) request.getSession().getAttribute("user");
        modelAndView.addObject("os", orderService.getOrders(user));
        return modelAndView;
    }

    @RequestMapping(value = "/deleteorder", produces = "text/html; charset=UTF-8")
    @ResponseBody
    public void deleteorder(HttpServletRequest request,HttpServletResponse response, Integer oid) throws Exception{
        orderService.deleteOrder(oid);
        response.sendRedirect("forebought");
    }

    @RequestMapping(value = "/forestory", produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView story()throws Exception{
        modelAndView.setViewName("story");
        return modelAndView;
    }

    /**
     * 跳转到确认支付
     * @return
     * @throws Exception
     */
    @RequestMapping(value = "/foreconfirmPay",produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView confirmPay(int oid) throws Exception{
        Order order = orderService.getOrder(oid);
        order.setOrderItems(orderItemService.getOrderItem(order.getId()));
        modelAndView.addObject("o",order);
        modelAndView.setViewName("confirmPay");
        return modelAndView;
    }

    /**
     * 跳转到支付页面
     * @return
     * @throws Exception
     */
    @RequestMapping(value = "/forealipay",produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView alipay() throws Exception{
        modelAndView.setViewName("alipay");
        return modelAndView;
    }

    /**
     * 跳转到评价页面
     * @param oid：订单id
     * @param request

            FileUtils.copyFile(new File(path1),new File(path4));
            FileUtils.copyFile(new File(path1),new File(path5));
            FileUtils.copyFile(new File(path1),new File(path6));
        }

        return admin_productImage_list(pid,request);
    }

    //更改房间属性选项
    @RequestMapping(value = "/admin_product_editPropertyValue",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_product_editPropertyValue(Integer id, HttpServletRequest request){
        Product product = productService.getProduct(id);
        List<Propertyvalue> values = productService.listProprotyValue(id);
        for(Propertyvalue p: values){
            p.setProperty(productService.getProperty(p.getPtid()));
        }
        mav.addObject("p",product);
        mav.addObject("pvs",values);
        mav.setViewName("/admin/editProductValue");
        return mav;
    }

    //提交更新房间属性值
    @RequestMapping(value = "/admin_product_updatePropertyValue",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public String admin_product_updatePropertyValue(Integer id, Integer pvid, String value){
        productService.updatePropertyValue(pvid, value);
        return "success";
    }

    //提交房间修改信息
    @RequestMapping(value = "/admin_product_update",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_product_update(Product product){
        productService.update(product);
        return admin_product_list(product.getCid());
    }

    //编辑房间信息页面
    @RequestMapping(value = "/admin_product_edit",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_product_edit(Integer id, HttpServletRequest request){
        Product product = productService.getProduct(id);
        mav.addObject("p",product);

        // 遍历集合数据，产生数据行  
        Iterator<Object[]> it = dataset.iterator();
        int index = 0;
        while (it.hasNext()) {
            index++;
            row = sheet.createRow(index);//从第1行开始创建  
            Object[] obj = (Object[]) it.next();
            for (short i = 0; i < obj.length; i++) {
                HSSFCell cell = row.createCell(i);
                cell.setCellStyle(style2);
                Object value = obj[i];
                String textValue = null;
                if (!"".equals(value) && value != null) {
                    if (value instanceof Integer) {
                        int intValue = (Integer) value;
                        cell.setCellValue(intValue);
                    } else if (value instanceof Float) {
                        float fValue = (Float) value;
                        cell.setCellValue(fValue);
                    } else if (value instanceof Double) {
                        double dValue = (Double) value;
                        cell.setCellValue(dValue);
                    } else if (value instanceof Long) {
                        long longValue = (Long) value;
                        cell.setCellValue(longValue);
                    } else if (value instanceof Date) {
                        Date date = (Date) value;
                        if(null==pattern||pattern.equals("")){
                            pattern="yyyy-MM-dd";
                        }
                        SimpleDateFormat sdf = new SimpleDateFormat(pattern);
                        textValue = sdf.format(date);
                        cell.setCellValue(textValue);
                    } else {
                        // 其它数据类型都当作字符串简单处理  
                        textValue = value.toString();
                        cell.setCellValue(textValue); // 设置单元格的值  
                    }
                } else {
                    cell.setCellValue("");
                }
            }
        }

        //让列宽随着导出的列长自动适应    
        for (int colNum = 0; colNum < headers.length; colNum++) {
            int columnWidth = sheet.getColumnWidth(colNum) / 256;

        }
        orderService.update(origin_order);
        modelAndView.addObject("o",origin_order);
        modelAndView.setViewName("/confirmPay");
        return modelAndView;
    }

    /**
     * 确认支付，订单状态：waitReview
     * @param oid
     * @return
     * @throws Exception
     */
    @RequestMapping(value = "/foreorderConfirmed", produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView confirm(Integer oid) throws Exception{
        Order order = orderService.getOrder(oid);
        order.setStatus("waitReview");
        orderService.update(order);
        modelAndView.setViewName("orderConfirmed");
        return modelAndView;
    }

    @RequestMapping(value = "/forebought", produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView bought(HttpServletRequest request) throws Exception{
        modelAndView.setViewName("bought");
        User user = (User) request.getSession().getAttribute("user");
        modelAndView.addObject("os", orderService.getOrders(user));
        return modelAndView;
    }

    @RequestMapping(value = "/deleteorder", produces = "text/html; charset=UTF-8")
    @ResponseBody
    public void deleteorder(HttpServletRequest request,HttpServletResponse response, Integer oid) throws Exception{
        orderService.deleteOrder(oid);
        response.sendRedirect("forebought");
    }

    @RequestMapping(value = "/forestory", produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView story()throws Exception{
        modelAndView.setViewName("story");
        return modelAndView;
    }

    /**
     * 跳转到确认支付
     * @return
     * @throws Exception

    public ModelAndView reviewed(Review review, HttpServletRequest request)throws Exception{
        Date date = new Date();
        review.setCreateDate(date);
        reviewService.insert(review);
        Product product = productService.getProduct(review.getPid());
        product.setReviewCount(product.getReviewCount()+1);
        productService.update(product);
        Order order = orderService.getOrder(review.getOid());
        order.setStatus("reviewed");
        orderService.update(order);
        return review(review.getOid(),request);
    }
}

@Controller
@RequestMapping("/order")
class OrderController {

    private static Logger logger = Logger.getLogger(OrderController.class);
    //获取所有订单
    @RequestMapping(value = "/list",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public List<Order> listOrder(/* @RequestParam(value = "addressId") int addressId */) throws Exception{
        SqlSession sqlSession = MybatisSessionFactory.getSession();
        OrderMapper orderMapper = sqlSession.getMapper(OrderMapper.class);
        return orderMapper.selectAll();
    }

    @RequestMapping(value = "/deleteOne",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public String deleteById(@RequestParam(value = "orderId") Integer orderId) throws Exception{
        SqlSession sqlSession = MybatisSessionFactory.getSession();
        OrderMapper orderMapper = sqlSession.getMapper(OrderMapper.class);
        try{
            orderMapper.deleteByPrimaryKey(orderId);

     * 跳转到评价页面
     * @param oid：订单id
     * @param request
     * @return
     * @throws Exception
     */
    @RequestMapping(value = "/forereview", produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView review(int oid, HttpServletRequest request)throws Exception{
        Order order = orderService.getOrder(oid);
        Product product = productService.getProduct(orderItemService.getOrderItem(oid).get(0).getPid());
        List<Review> reviews = reviewService.listReview(product.getId());
        modelAndView.addObject("re", reviewService.getReviews(reviews));
        modelAndView.addObject("p",product);
        modelAndView.addObject("o",order);
        modelAndView.addObject("u",request.getSession().getAttribute("user"));
        modelAndView.setViewName("review");
        return modelAndView;
    }

    /**
     * 评价；订单状态：reviewed
     * @param review
     * @param request
     * @return
     * @throws Exception
     */
    @RequestMapping(value = "/foredoreviewed", produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView reviewed(Review review, HttpServletRequest request)throws Exception{
        Date date = new Date();
        review.setCreateDate(date);
        reviewService.insert(review);
        Product product = productService.getProduct(review.getPid());
        product.setReviewCount(product.getReviewCount()+1);
        productService.update(product);
        Order order = orderService.getOrder(review.getOid());
        order.setStatus("reviewed");
        orderService.update(order);
        return review(review.getOid(),request);
    }
}

    @ResponseBody
    public ModelAndView story()throws Exception{
        modelAndView.setViewName("story");
        return modelAndView;
    }

    /**
     * 跳转到确认支付
     * @return
     * @throws Exception
     */
    @RequestMapping(value = "/foreconfirmPay",produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView confirmPay(int oid) throws Exception{
        Order order = orderService.getOrder(oid);
        order.setOrderItems(orderItemService.getOrderItem(order.getId()));
        modelAndView.addObject("o",order);
        modelAndView.setViewName("confirmPay");
        return modelAndView;
    }

    /**
     * 跳转到支付页面
     * @return
     * @throws Exception
     */
    @RequestMapping(value = "/forealipay",produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView alipay() throws Exception{
        modelAndView.setViewName("alipay");
        return modelAndView;
    }

    /**
     * 跳转到评价页面
     * @param oid：订单id
     * @param request
     * @return
     * @throws Exception
     */

            path2 = imgPath+"target\\project-1.0-SNAPSHOT\\img\\productDetail\\"+imageId.toString()+".jpg";
            filepath.transferTo(new File(path1));
            FileUtils.copyFile(new File(path1),new File(path2));
        }
        if (type.equals("type_single")){
            // windows系统参考路径
            path1 = imgPath+"src\\main\\webapp\\img\\productSingle\\"+imageId.toString()+".jpg";
            path2 = imgPath+"target\\project-1.0-SNAPSHOT\\img\\productSingle\\"+imageId.toString()+".jpg";
            String path3 = imgPath+"src\\main\\/webapp\\img\\productSingle_middle\\"+imageId.toString()+".jpg";;
            String path4 = imgPath+"target\\project-1.0-SNAPSHOT\\img\\productSingle_middle\\"+imageId.toString()+".jpg";
            String path5 = imgPath+"src\\main\\webapp\\img\\productSingle_small\\"+imageId.toString()+".jpg";;
            String path6 = imgPath+"target\\project-1.0-SNAPSHOT\\img\\productSingle_small\\"+imageId.toString()+".jpg";
            filepath.transferTo(new File(path1));
            FileUtils.copyFile(new File(path1),new File(path2));
            FileUtils.copyFile(new File(path1),new File(path3));
            FileUtils.copyFile(new File(path1),new File(path4));
            FileUtils.copyFile(new File(path1),new File(path5));
            FileUtils.copyFile(new File(path1),new File(path6));
        }

        return admin_productImage_list(pid,request);
    }

    //更改房间属性选项
    @RequestMapping(value = "/admin_product_editPropertyValue",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_product_editPropertyValue(Integer id, HttpServletRequest request){
        Product product = productService.getProduct(id);
        List<Propertyvalue> values = productService.listProprotyValue(id);
        for(Propertyvalue p: values){
            p.setProperty(productService.getProperty(p.getPtid()));
        }
        mav.addObject("p",product);
        mav.addObject("pvs",values);
        mav.setViewName("/admin/editProductValue");
        return mav;
    }

    //提交更新房间属性值
    @RequestMapping(value = "/admin_product_updatePropertyValue",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public String admin_product_updatePropertyValue(Integer id, Integer pvid, String value){
        productService.updatePropertyValue(pvid, value);
        return "success";
    }


@Controller
@RequestMapping("/user")
public class UserController {
    private static Logger logger = Logger.getLogger(OrderController.class);
    ModelAndView mav = new ModelAndView();
    @Autowired
    UserService userService;

    @RequestMapping(value = "/foreregister",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView register(HttpServletRequest request, HttpServletResponse response,User user) throws Exception{
        GeneralController generalController = new GeneralController();
        try{
            userService.insert(user);
            request.getSession().setAttribute("user",user);
        }catch (Exception e){
            logger.info("用户名已存在");
            return generalController.home(request);
        }
        mav.setViewName("registerSuccess");
        return mav;
    }
}

        return mav;
    }

    //编辑属性名称页面
    @RequestMapping(value = "/admin_property_edit",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_property_edit(@RequestParam(value = "id") Integer id){
        Property property = productService.getProperty(id);
        mav.addObject("p",property);
        mav.setViewName("/admin/editProperty");
        return mav;
    }

    //提交编辑的属性名称
    @RequestMapping(value = "/admin_property_update",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_property_update(Property record){
        productService.updateProperty(record);
        List<Property> properties = productService.listProproty(record.getCid());
        mav.addObject("ps",properties);
        mav.setViewName("/admin/listProperty");
        return mav;
    }

    //删除属性名称
    @RequestMapping(value = "/admin_property_delete",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_property_delete(Integer id,HttpServletRequest request){
        try{
            productService.deleteProperty(id);
        }catch (Exception e){
            e.printStackTrace();
        }
        List<Property> properties = productService.listProproty((Integer)request.getSession().getAttribute("cid"));
        mav.addObject("ps",properties);
        mav.setViewName("/admin/listProperty");
        return mav;
    }

    //房间管理
    @RequestMapping(value = "/admin_product_list",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_product_list(Integer cid){
        return listProduct(cid);
    }

    //添加房间
    @RequestMapping(value = "/admin_product_add",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_product_add(Product product,HttpServletRequest request){
        productService.insert(product);

public class UserController {
    private static Logger logger = Logger.getLogger(OrderController.class);
    ModelAndView mav = new ModelAndView();
    @Autowired
    UserService userService;

    @RequestMapping(value = "/foreregister",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView register(HttpServletRequest request, HttpServletResponse response,User user) throws Exception{
        GeneralController generalController = new GeneralController();
        try{
            userService.insert(user);
            request.getSession().setAttribute("user",user);
        }catch (Exception e){
            logger.info("用户名已存在");
            return generalController.home(request);
        }
        mav.setViewName("registerSuccess");
        return mav;
    }
}

public class AdminInterceptor implements HandlerInterceptor {
    private static Logger logger = Logger.getLogger(AdminController.class);

    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws IOException {
        logger.info("执行spring拦截器");
        //检查当前sessions是否有登录用户
        User user = (User) request.getSession().getAttribute("user");
        if(user != null)
            return true;
        else
            response.sendRedirect(request.getContextPath()+"/login.jsp");

        for (short i = 0; i < headers.length; i++) {
            HSSFCell cell = row.createCell(i);
            cell.setCellStyle(style);
            HSSFRichTextString text = new HSSFRichTextString(headers[i]);
            cell.setCellValue(text);
        }
        // 遍历集合数据，产生数据行  
        Iterator<Object[]> it = dataset.iterator();
        int index = 0;
        while (it.hasNext()) {
            index++;
            row = sheet.createRow(index);//从第1行开始创建  
            Object[] obj = (Object[]) it.next();
            for (short i = 0; i < obj.length; i++) {
                HSSFCell cell = row.createCell(i);
                cell.setCellStyle(style2);
                Object value = obj[i];
                String textValue = null;
                if (!"".equals(value) && value != null) {
                    if (value instanceof Integer) {
                        int intValue = (Integer) value;
                        cell.setCellValue(intValue);
                    } else if (value instanceof Float) {
                        float fValue = (Float) value;
                        cell.setCellValue(fValue);
                    } else if (value instanceof Double) {
                        double dValue = (Double) value;
                        cell.setCellValue(dValue);
                    } else if (value instanceof Long) {
                        long longValue = (Long) value;
                        cell.setCellValue(longValue);
                    } else if (value instanceof Date) {
                        Date date = (Date) value;
                        if(null==pattern||pattern.equals("")){
                            pattern="yyyy-MM-dd";
                        }
                        SimpleDateFormat sdf = new SimpleDateFormat(pattern);
                        textValue = sdf.format(date);
                        cell.setCellValue(textValue);
                    } else {
                        // 其它数据类型都当作字符串简单处理  
                        textValue = value.toString();
                        cell.setCellValue(textValue); // 设置单元格的值  
                    }
                } else {
                    cell.setCellValue("");
                }
            }
        }

        //让列宽随着导出的列长自动适应    
        for (int colNum = 0; colNum < headers.length; colNum++) {
            int columnWidth = sheet.getColumnWidth(colNum) / 256;

     * @throws Exception
     */
    @RequestMapping(value = "/forereview", produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView review(int oid, HttpServletRequest request)throws Exception{
        Order order = orderService.getOrder(oid);
        Product product = productService.getProduct(orderItemService.getOrderItem(oid).get(0).getPid());
        List<Review> reviews = reviewService.listReview(product.getId());
        modelAndView.addObject("re", reviewService.getReviews(reviews));
        modelAndView.addObject("p",product);
        modelAndView.addObject("o",order);
        modelAndView.addObject("u",request.getSession().getAttribute("user"));
        modelAndView.setViewName("review");
        return modelAndView;
    }

    /**
     * 评价；订单状态：reviewed
     * @param review
     * @param request
     * @return
     * @throws Exception
     */
    @RequestMapping(value = "/foredoreviewed", produces = "text/html; charset=UTF-8")
    @ResponseBody
    public ModelAndView reviewed(Review review, HttpServletRequest request)throws Exception{
        Date date = new Date();
        review.setCreateDate(date);
        reviewService.insert(review);
        Product product = productService.getProduct(review.getPid());
        product.setReviewCount(product.getReviewCount()+1);
        productService.update(product);
        Order order = orderService.getOrder(review.getOid());
        order.setStatus("reviewed");
        orderService.update(order);
        return review(review.getOid(),request);
    }
}

            }
        }
        try {
            if (createDir(docsPath)) {
                OutputStream out = new FileOutputStream(filePath);
                workbook.write(out);
                out.close();
                download(filePath, response);// 执行下载  
                cleanFile(filePath);// 删除已完成下载的文件  
            }
        }  catch (FileNotFoundException e) {
            e.printStackTrace();
        }catch (IOException e) {
            e.printStackTrace();
        }
        return workbook;
    }

    /**
     * 导出下载,弹出下载框 
     * @param path  文件下载路径 
     * @param response
     */
    public static void download(String path, HttpServletResponse response) {
        try {
            // path是指欲下载的文件的路径。  
            File file = new File(path);
            // 取得文件名。  
            String filename = file.getName();
            // 以流的形式下载文件。  
            InputStream fis = new BufferedInputStream(new FileInputStream(path));
            byte[] buffer = new byte[fis.available()];
            fis.read(buffer);
            fis.close();
            // 清空response  
            response.reset();
            // 设置response的Header  
            response.addHeader("Content-Disposition", "attachment;filename="+ URLEncoder.encode(filename, "UTF-8"));
            response.addHeader("Content-Length", "" + file.length());
            OutputStream toClient = new BufferedOutputStream(response.getOutputStream());
            response.setContentType("application/vnd.ms-excel;charset=gb2312");

        mav.setViewName("/admin/printListUser");
        return mav;
    }

    //导出用户信息
    @RequestMapping(value = "/admin_export_user_list",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public void exportUserList(HttpServletRequest request, HttpServletResponse response) throws Exception{
        List<User> users = userService.listAll();
        String []rowsName = new String[]{"id","name","password"};
        List<Object[]> dataList = new ArrayList<Object[]>();
        for(int i = 0;i < users.size();i++){
            Object[] objs = new Object[rowsName.length];
            User user = users.get(i);
            objs[0] = user.getId();
            objs[1] = user.getName();
            objs[2] = user.getPassword();
            dataList.add(objs);
        }
        String fileName = "exportUserExcel";
        //执行导出
        ExportExcel.exportExcel(request,response,fileName, rowsName, dataList, "yyyy-MM-dd HH:mm:ss");
    }

    //删除用户
    @RequestMapping(value = "/admin_user_delete",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_user_delete(Integer id, HttpServletRequest request){
        try{
            userService.deleteByPrimaryKey(id);
        }catch (Exception e){
            e.getMessage();
        }
        List<User> users = userService.listAll();
        mav.addObject("us",users);
        mav.setViewName("/admin/listUser");
        return mav;
    }

    //编辑用户信息页面
    @RequestMapping(value = "/admin_user_edit",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_user_edit(Integer id, HttpServletRequest request){
        User user = userService.getUser(id);
        mav.addObject("u",user);
        mav.setViewName("/admin/editUser");
        return mav;

            // windows系统参考路径 注：此处必须为本地src及target下productDetail的路径
            path1 = imgPath+"src\\main\\webapp\\img\\productDetail\\"+imageId.toString()+".jpg";
            path2 = imgPath+"target\\project-1.0-SNAPSHOT\\img\\productDetail\\"+imageId.toString()+".jpg";
            filepath.transferTo(new File(path1));
            FileUtils.copyFile(new File(path1),new File(path2));
        }
        if (type.equals("type_single")){
            // windows系统参考路径
            path1 = imgPath+"src\\main\\webapp\\img\\productSingle\\"+imageId.toString()+".jpg";
            path2 = imgPath+"target\\project-1.0-SNAPSHOT\\img\\productSingle\\"+imageId.toString()+".jpg";
            String path3 = imgPath+"src\\main\\/webapp\\img\\productSingle_middle\\"+imageId.toString()+".jpg";;
            String path4 = imgPath+"target\\project-1.0-SNAPSHOT\\img\\productSingle_middle\\"+imageId.toString()+".jpg";
            String path5 = imgPath+"src\\main\\webapp\\img\\productSingle_small\\"+imageId.toString()+".jpg";;
            String path6 = imgPath+"target\\project-1.0-SNAPSHOT\\img\\productSingle_small\\"+imageId.toString()+".jpg";
            filepath.transferTo(new File(path1));
            FileUtils.copyFile(new File(path1),new File(path2));
            FileUtils.copyFile(new File(path1),new File(path3));
            FileUtils.copyFile(new File(path1),new File(path4));
            FileUtils.copyFile(new File(path1),new File(path5));
            FileUtils.copyFile(new File(path1),new File(path6));
        }

        return admin_productImage_list(pid,request);
    }

    //更改房间属性选项
    @RequestMapping(value = "/admin_product_editPropertyValue",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public ModelAndView admin_product_editPropertyValue(Integer id, HttpServletRequest request){
        Product product = productService.getProduct(id);
        List<Propertyvalue> values = productService.listProprotyValue(id);
        for(Propertyvalue p: values){
            p.setProperty(productService.getProperty(p.getPtid()));
        }
        mav.addObject("p",product);
        mav.addObject("pvs",values);
        mav.setViewName("/admin/editProductValue");
        return mav;
    }

    //提交更新房间属性值
    @RequestMapping(value = "/admin_product_updatePropertyValue",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public String admin_product_updatePropertyValue(Integer id, Integer pvid, String value){
        productService.updatePropertyValue(pvid, value);
        return "success";
    }

    //提交房间修改信息
    @RequestMapping(value = "/admin_product_update",produces = "text/html;charset=UTF-8")
    @ResponseBody

请添加图片描述

m0_71480420

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
基于javaweb+mysql的ssm+maven民宿管理系统(java+ssm+jsp+bootstrap+jquery+mysql)

其他版本理论上也可以。房间分类管理 + 类型的删除、修改、查询（准备添加增添功能，即图片上传功能） + 类型所含属性的增删改查 + 房间分类图片上传 > 房间管理 + 房间增删改导印统 + 查询已上传房间的所有照片 + 房间的配套设施属性设置 + 房间价格（原价、活动价）、名称、描述等属性设置 + 房间存量统计 > 订单管理 + 订单信息修改、删除 + 订单组合条件查询。用户注册、登录 + 登录权限拦截 + 按名称搜索房间 + 支付流程 + 查看订单信息和状态 + 评论预定过的房间，并自动修改订单状态。
复制链接

扫一扫

基于javaweb+mysql的ssm+maven民宿管理系统(java+ssm+jsp+bootstrap+jquery+mysql)

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