基于javaweb+mysql的ssm+maven在线社区药品销售商城(java+ssm+jsp+bootstrap+mysql)

于 2023-08-15 19:17:41 发布
阅读量64 收藏
点赞数
文章标签： java mysql maven
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/m0_71098312/article/details/132305407
版权

基于javaweb+mysql的ssm+maven在线社区药品销售商城(java+ssm+jsp+bootstrap+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的SSM+Maven在线社区药品销售商城(java+ssm+jsp+bootstrap+mysql)

项目介绍

本项目为前后台项目，前台为普通用户登录，后台为管理员登录； 管理员角色包含以下功能： 管理员登录,分类管理,用户管理,订单管理等功能。

用户角色包含以下功能： 按分类查看药品,用户登录,查看商品详情,加入购物车,提交订单,查看订单等功能。

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 5.数据库：MySql 5.7版本； 6.是否Maven项目：是；

技术栈

  1. 后端：Spring+SpringMVC+Mybatis 2. 前端：JSP+CSS+JavaScript+jQuery+Bootstrap

使用说明

  1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目，在浏览器中输入http://localhost:8080/ssm_sqyp_shop/ 登录 注：Tomcat中配置项目路径必须为ssm_sqyp_shop 用户账号/密码： user/123456 管理员账号/密码：admin/admin
        int product_id = propertyValue.getProduct_id();
        int category_id = productService.get(product_id).getCategory_id();
        propertyValueService.add(propertyValue);
        return "redirect:listPropertyValue?product_id=" + product_id + "&category_id=" + category_id;
    }

    @RequestMapping("/deletePropertyValue")
    public String delete(Integer id)  {
        int product_id = propertyValueService.get(id).getProduct_id();
        int category_id = productService.get(product_id).getCategory_id();
        propertyValueService.delete(id);
        return "redirect:listPropertyValue?product_id=" + product_id + "&category_id=" + category_id;
    }

    @RequestMapping("/editPropertyValue")
    public String edit(Integer id ,Model model) {
        PropertyValue propertyValue = propertyValueService.get(id);
        model.addAttribute("propertyValue",propertyValue);
        Product product = productService.get(propertyValue.getProperty_id());
        model.addAttribute("product",product);
        return "admin/editPropertyValue";
    }

    @RequestMapping("/updatePropertyValue")
    public String update(PropertyValue propertyValue) {
        Integer product_id = propertyValue.getProduct_id();
        Integer category_id = productService.get(product_id).getCategory_id();
        propertyValueService.update(propertyValue);
        return "redirect:listPropertyValue?product_id=" + product_id + "&category_id=" + category_id;
    }
}


//----------------------------------------------登录、注册-------------------------------------------------

    @RequestMapping("/login")
    public String login(Model model, @RequestParam("name") String name,
                        @RequestParam("password") String password,
                        HttpSession session) {
        User user = userService.get(name, password);
        if (null == user) {
            model.addAttribute("msg", "用户名或密码错误");
            return "loginPage";
        }
        session.setAttribute("user", user);
        return "redirect:home";
    }

    @RequestMapping("/logout")
    public String logout(HttpSession session) {
        session.removeAttribute("user");
        return "redirect:home";
    }

    @RequestMapping("/register")
    public String register(Model model, User user) {
        String name = user.getName();
        boolean exist = userService.isExist(name);
        if (exist) {
            String msg = "用户名已存在";
            model.addAttribute("msg", msg);
            model.addAttribute("username", user.getName());
            return "registerPage";
        }
        userService.add(user);
        return "redirect:registerSuccess";
    }

    //----------------------------------------------立即购买-------------------------------------------------

    @RequestMapping("/buyOne")
    public String buyOne(Integer product_id, Integer number, HttpSession session) {
        Product product = productService.get(product_id);
        int orderItemId = 0;

        User user = (User) session.getAttribute("user");
        boolean found = false;
        List<OrderItem> orderItems = orderItemService.findByUserId(user.getId());

        session2.removeAttribute("admin");
        return "redirect:admin";
    }
}

@Controller
@RequestMapping("/admin")
public class UserController {
    @Autowired
    private UserService userService;

    @RequestMapping("/listUser")
    public String findAll(Model model) {
        List<User> users = userService.findAll();
        model.addAttribute("users",users);
        return "admin/listUser";
    }
    @RequestMapping("/editUser")
    public String edit(Model model ,Integer id) {
        User user = userService.get(id);
        model.addAttribute("user",user);
        return "admin/editUser";
    }

    @RequestMapping("/updateUser")
    public String update(Integer id,String password) {
        userService.updatePassword(id,password);
        return "redirect:listUser";
    }

}


        session.setAttribute("cartTotalItemNumber",cartTotalItemNumber);
    }

    @Override
    public void afterCompletion(HttpServletRequest request, HttpServletResponse response, Object handler, Exception ex) throws Exception {
    }
}

@Controller
public class AdminController {

    @Autowired
    private AdminService adminService;

    @RequestMapping("/aLogin")
    public String login(Model model, @RequestParam("name") String name,
                        @RequestParam("password") String password,
                        HttpSession session2) {
        Admin admin = adminService.get(name, password);
        if (null == admin) {
            model.addAttribute("msg", "用户名或密码错误");
            return "admin/adminLogin";
        }
        session2.setAttribute("admin", admin);
        return "redirect:admin/listCategory";
    }

    @RequestMapping("/adminLogout")
    public String logout(HttpSession session2) {
        session2.removeAttribute("admin");

    private OrderItemService orderItemService;

    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        return true;
    }

    @Override
    public void postHandle(HttpServletRequest request, HttpServletResponse response, Object handler, ModelAndView modelAndView) throws Exception {
        HttpSession session = request.getSession();
        User user = (User) session.getAttribute("user");
        int cartTotalItemNumber = 0;
        if(null != user) {
            List<OrderItem> ois = orderItemService.findForCart(user.getId());
            for(OrderItem oi : ois) {
                cartTotalItemNumber += oi.getNumber();
            }
        }
        session.setAttribute("cartTotalItemNumber",cartTotalItemNumber);
    }

    @Override
    public void afterCompletion(HttpServletRequest request, HttpServletResponse response, Object handler, Exception ex) throws Exception {
    }
}

@Controller
public class AdminController {

            }
        }
        return dir.delete();
    }*/
    @RequestMapping("/editProduct")
    public String edit(Integer id, Model model) {
        Product product = productService.get(id);
        model.addAttribute("product",product);
        Category category = categoryService.get(product.getCategory_id());
        model.addAttribute("category",category);
        return "admin/editProduct";
    }

    @RequestMapping("/updateProduct")
    public String update(Product product) {
        productService.update(product);
        return "redirect:listProduct?category_id=" + product.getCategory_id();
    }
}

@Controller
@RequestMapping("/admin")
public class ProductImageController {

    @Autowired
    private ProductImageService productImageService;

    @Autowired
    private ProductService productService;

    @RequestMapping("/editProductImage")

    }

    @RequestMapping("/changeOrderItem")
    @ResponseBody
    public String changeOrderItem(Model model,HttpSession session,int product_id,int number) {
        User user = (User)session.getAttribute("user");
        if(null == user)
            return "fail";

        List<OrderItem> ois = orderItemService.findByUserId(user.getId());
        for(OrderItem oi : ois) {
            if(oi.getProduct().getId().intValue() == product_id) {
                oi.setNumber(number);
                orderItemService.update(oi);
                break;
            }
        }
        return "success";
    }

    @RequestMapping("deleteOrderItem")
    @ResponseBody
    public String deleteOrderItem(Model model,HttpSession session,Integer orderItemId) {
        User user = (User) session.getAttribute("user");
        if(null == user)
            return "fail";
        orderItemService.delete(orderItemId);
        return "success";
    }

    @RequestMapping("bought")
    public String bought(Model model,HttpSession session) {
        User user =(User) session.getAttribute("user");
        List<Order> orders = orderService.list(user.getId(),OrderService.delete);
        orderItemService.fill(orders);
        model.addAttribute("orders",orders);
        return "bought";
    }

    @RequestMapping("confirmPay")
    public String confirmPay(Model model,Integer order_id) {
        Order order = orderService.get(order_id);
        orderItemService.fill(order);
        model.addAttribute("order",order);
        return "confirmPay";
    }

    @RequestMapping("/orderConfirmed")
    public String orderConfirmed(Model model,Integer order_id) {
        Order order = orderService.get(order_id);
        order.setStatus(OrderService.waitReview);
        order.setConfirm_date(new Date());
        orderService.update(order);
        return "orderConfirmedPage";

    }

    @RequestMapping("/updateProduct")
    public String update(Product product) {
        productService.update(product);
        return "redirect:listProduct?category_id=" + product.getCategory_id();
    }
}

@Controller
@RequestMapping("/admin")
public class ProductImageController {

    @Autowired
    private ProductImageService productImageService;

    @Autowired
    private ProductService productService;

    @RequestMapping("/editProductImage")
    public String edit(Model model,Integer product_id) {
        List<ProductImage> productImages = productImageService.findAll(product_id);
        model.addAttribute("productImages",productImages);
        Product product = productService.get(product_id);
        model.addAttribute("product",product);
        return "admin/editProductImage";
    }

    @RequestMapping(value = "/updateProductImage",method = RequestMethod.POST)
    public String update(HttpServletRequest request, Integer product_id , Integer id, @RequestParam("picture") MultipartFile picture) {

    private PropertyValueService propertyValueService;

    @Autowired
    private ReviewService reviewService;

    @Autowired
    private UserService userService;

    @Autowired
    private OrderItemService orderItemService;

    @Autowired
    private OrderService orderService;

    @RequestMapping("/home")
    public String home(Model model) {
        List<Category> categories = categoryService.findAll();
        productService.fillAll(categories);
        model.addAttribute("categories", categories);
        return "index";
    }

    @RequestMapping("/showProduct")
    public String showProduct(Model model, Integer product_id) {
        List<Category> categories = categoryService.findAll();
        model.addAttribute("categories", categories);
        Product product = productService.get(product_id);
        productService.setReviewCount(product);
        model.addAttribute("product", product);
        List<PropertyValue> propertyValues = propertyValueService.findByProductId(product_id);
        model.addAttribute("propertyValues", propertyValues);
        List<Review> reviews = reviewService.findByProductId(product_id);
        model.addAttribute("reviews", reviews);
        return "detail";
    }

    @RequestMapping("/searchProduct")
    public String searchProduct(Model model, String keyword) {
        PageHelper.offsetPage(0, 20);
        List<Product> products = productService.search(keyword);
        for (Product product: products) {
            product.setReviewCount(reviewService.getCount(product.getId()));
        }
        model.addAttribute("products", products);
        return "searchPage";
    }


@Controller
public class ForeController {

    @Autowired
    private CategoryService categoryService;

    @Autowired
    private ProductService productService;

    @Autowired
    private PropertyValueService propertyValueService;

    @Autowired
    private ReviewService reviewService;

    @Autowired
    private UserService userService;

    @Autowired
    private OrderItemService orderItemService;

    @Autowired
    private OrderService orderService;

    @RequestMapping("/home")
    public String home(Model model) {
        List<Category> categories = categoryService.findAll();
        productService.fillAll(categories);
        model.addAttribute("categories", categories);
        return "index";
    }

    @RequestMapping("/showProduct")
    public String showProduct(Model model, Integer product_id) {
        List<Category> categories = categoryService.findAll();


@Controller
@RequestMapping("/admin")
public class PropertyController {

    @Autowired
    private PropertyService propertyService;

    @Autowired
    private CategoryService categoryService;

    @RequestMapping("/listProperty")
    public String findAll(Model model , Integer category_id) {
        List<Property> properties = propertyService.findAll(category_id);
        model.addAttribute("properties",properties);
        Category category = categoryService.get(category_id);
        model.addAttribute("category",category);
        return "admin/listProperty";
    }

    @RequestMapping("/addPropertyView")
    public String addPropertyView(Model model,Integer category_id) {
        Category category = categoryService.get(category_id);
        model.addAttribute("category" , category);
        return "admin/addPropertyView";
    }
    @RequestMapping("/addProperty")
    public String add(Property property) {
        propertyService.add(property);
        return "redirect:listProperty?category_id=" + property.getCategory_id();
    }

    @RequestMapping("/deleteProperty")
    public String delete(Integer id) {
        Integer category_id = propertyService.get(id).getCategory_id();
        propertyService.delete(id);
        return "redirect:listProperty?category_id=" + category_id;
    }


    @RequestMapping("/listPropertyValue")
    public String findAll(Model model ,Integer product_id ,Integer category_id) {
        List<PropertyValue> propertyValues = propertyValueService.findByProductId(product_id);
        model.addAttribute("propertyValues",propertyValues);
        Product product = productService.get(product_id);
        model.addAttribute("product",product);
        List<Property> properties = propertyService.findAll(category_id);
        model.addAttribute("properties",properties);
        return "admin/listPropertyValue";
    }

    @RequestMapping("/addPropertyValueView")
    public String addPropertyValueView(Model model ,Integer product_id,Integer category_id) {
        List<PropertyValue> propertyValues = propertyValueService.findByProductId(product_id);
        model.addAttribute("propertiesValue",propertyValues);
        List<Property> properties = propertyService.findAll(category_id);
        model.addAttribute("properties",properties);
        Product product = productService.get(product_id);
        model.addAttribute("product",product);
        return "admin/addPropertyValueView";
    }

    @RequestMapping("/addPropertyValue")
    public String add(PropertyValue propertyValue ){
        int product_id = propertyValue.getProduct_id();
        int category_id = productService.get(product_id).getCategory_id();
        propertyValueService.add(propertyValue);
        return "redirect:listPropertyValue?product_id=" + product_id + "&category_id=" + category_id;
    }

    @RequestMapping("/deletePropertyValue")
    public String delete(Integer id)  {
        int product_id = propertyValueService.get(id).getProduct_id();
        int category_id = productService.get(product_id).getCategory_id();
        propertyValueService.delete(id);
        return "redirect:listPropertyValue?product_id=" + product_id + "&category_id=" + category_id;
    }

    @RequestMapping("/editPropertyValue")
    public String edit(Integer id ,Model model) {
        PropertyValue propertyValue = propertyValueService.get(id);
        model.addAttribute("propertyValue",propertyValue);
        Product product = productService.get(propertyValue.getProperty_id());
        model.addAttribute("product",product);
        return "admin/editPropertyValue";
    }

    @RequestMapping("/updatePropertyValue")


public class LoginInterceptor extends HandlerInterceptorAdapter {
    public boolean preHandle(HttpServletRequest request , HttpServletResponse response ,Object handler) throws Exception {
        HttpSession session = request.getSession();
        String[] noNeedAuthPage = new String[] {
                "/ssm_sqyp_shop/home",
                "/ssm_sqyp_shop/searchProduct",
                "/ssm_sqyp_shop/sortProduct",
                "/ssm_sqyp_shop/showProduct",
                "/ssm_sqyp_shop/login",
                "/ssm_sqyp_shop/loginPage",
                "/ssm_sqyp_shop/registerPage",
                "/ssm_sqyp_shop/register",
                "/ssm_sqyp_shop/registerSuccess",
                "/ssm_sqyp_shop/checkLogin",
                "/ssm_sqyp_shop/admin",
                "/ssm_sqyp_shop/aLogin",
                "/ssm_sqyp_shop/adminLogout",
                "/ssm_sqyp_shop/knowledge",
                "/ssm_sqyp_shop/advert"
        };
        String uri = request.getRequestURI();
        if(!Arrays.asList(noNeedAuthPage).contains(uri)) {
            User user = (User) session.getAttribute("user");
            if(null == user) {
                response.sendRedirect("/ssm_sqyp_shop/loginPage");
                return false;
            }
        }
        return true;
    }

    public void postHandle(HttpServletRequest request, HttpServletResponse response, Object handler, ModelAndView modelAndView) throws Exception {
    }

    public void afterCompletion(HttpServletRequest request, HttpServletResponse response, Object handler, Exception ex) throws Exception {
        super.afterCompletion(request, response, handler, ex);
    }

        propertyValueService.delete(id);
        return "redirect:listPropertyValue?product_id=" + product_id + "&category_id=" + category_id;
    }

    @RequestMapping("/editPropertyValue")
    public String edit(Integer id ,Model model) {
        PropertyValue propertyValue = propertyValueService.get(id);
        model.addAttribute("propertyValue",propertyValue);
        Product product = productService.get(propertyValue.getProperty_id());
        model.addAttribute("product",product);
        return "admin/editPropertyValue";
    }

    @RequestMapping("/updatePropertyValue")
    public String update(PropertyValue propertyValue) {
        Integer product_id = propertyValue.getProduct_id();
        Integer category_id = productService.get(product_id).getCategory_id();
        propertyValueService.update(propertyValue);
        return "redirect:listPropertyValue?product_id=" + product_id + "&category_id=" + category_id;
    }
}

@Controller
@RequestMapping("/admin")
public class ProductController {

    @Autowired
    private ProductService productService;

        String name = user.getName();
        boolean exist = userService.isExist(name);
        if (exist) {
            String msg = "用户名已存在";
            model.addAttribute("msg", msg);
            model.addAttribute("username", user.getName());
            return "registerPage";
        }
        userService.add(user);
        return "redirect:registerSuccess";
    }

    //----------------------------------------------立即购买-------------------------------------------------

    @RequestMapping("/buyOne")
    public String buyOne(Integer product_id, Integer number, HttpSession session) {
        Product product = productService.get(product_id);
        int orderItemId = 0;

        User user = (User) session.getAttribute("user");
        boolean found = false;
        List<OrderItem> orderItems = orderItemService.findByUserId(user.getId());
        for (OrderItem orderItem : orderItems) {
            if (orderItem.getProduct_id().intValue() == product.getId().intValue()) {
                orderItem.setNumber(orderItem.getNumber() + number);
                orderItemService.update(orderItem);
                orderItemId = orderItem.getId();
                break;
            }
        }

        if (!found) {
            OrderItem orderItem = new OrderItem();
            orderItem.setUser_id(user.getId());
            orderItem.setNumber(number);
            orderItem.setProduct_id(product_id);
            orderItemService.add(orderItem);
            orderItemId = orderItem.getId();
        }
        return "redirect:buy?orderItemId=" + orderItemId;
    }

    @RequestMapping("/buy")
    public String buy(Model model, String[] orderItemId, HttpSession session) {
        List<OrderItem> orderItems = new ArrayList<>();
        float total = 0;
        for (String strId : orderItemId) {
            int id = Integer.parseInt(strId);
            OrderItem orderItem = orderItemService.get(id);

        order.setStatus(OrderService.waitReview);
        order.setConfirm_date(new Date());
        orderService.update(order);
        return "orderConfirmedPage";
    }

    @RequestMapping("deleteOrder")
    public String deleteOrder(Model model,Integer order_id) {
        Order order = orderService.get(order_id);
        order.setStatus(OrderService.delete);
        orderService.update(order);
        return "success";
    }

    @RequestMapping("review")
    public String review(Model model,Integer order_id) {
        Order order = orderService.get(order_id);
        orderItemService.fill(order);
        Product product = order.getOrderItems().get(0).getProduct();
        List<Review> reviews = reviewService.findByProductId(product.getId());
        productService.setReviewCount(product);
        model.addAttribute("product",product);
        model.addAttribute("order",order);
        model.addAttribute("reviews",reviews);
        return "reviewPage";
    }

    @RequestMapping("doReview")
    public String deReview(Model model,HttpSession session,
                           @RequestParam("order_id") Integer order_id,
                           @RequestParam("product_id") Integer product_id,
                           String content) {
        Order order = orderService.get(order_id);
        order.setStatus(OrderService.finish);
        orderService.update(order);

        User user = (User) session.getAttribute("user");
        Review review = new Review();
        review.setContent(content);
        review.setProduct_id(product_id);
        review.setCreateDate(new Date());

        Category category = categoryService.get(category_id);
        model.addAttribute("category",category);
        return "admin/listProperty";
    }

    @RequestMapping("/addPropertyView")
    public String addPropertyView(Model model,Integer category_id) {
        Category category = categoryService.get(category_id);
        model.addAttribute("category" , category);
        return "admin/addPropertyView";
    }
    @RequestMapping("/addProperty")
    public String add(Property property) {
        propertyService.add(property);
        return "redirect:listProperty?category_id=" + property.getCategory_id();
    }

    @RequestMapping("/deleteProperty")
    public String delete(Integer id) {
        Integer category_id = propertyService.get(id).getCategory_id();
        propertyService.delete(id);
        return "redirect:listProperty?category_id=" + category_id;
    }

    @RequestMapping("/editProperty")
    public String edit(Integer id,Model model) {
        Property property = propertyService.get(id);
        model.addAttribute("property",property);
        Category category = categoryService.get(property.getCategory_id());
        model.addAttribute("category",category);
        return "admin/editProperty";
    }

    @RequestMapping("/updateProperty")
    public String update(Property property) {
        propertyService.update(property);
        return "redirect:listProperty?category_id=" + property.getCategory_id();
    }
}


        return "bought";
    }

    @RequestMapping("confirmPay")
    public String confirmPay(Model model,Integer order_id) {
        Order order = orderService.get(order_id);
        orderItemService.fill(order);
        model.addAttribute("order",order);
        return "confirmPay";
    }

    @RequestMapping("/orderConfirmed")
    public String orderConfirmed(Model model,Integer order_id) {
        Order order = orderService.get(order_id);
        order.setStatus(OrderService.waitReview);
        order.setConfirm_date(new Date());
        orderService.update(order);
        return "orderConfirmedPage";
    }

    @RequestMapping("deleteOrder")
    public String deleteOrder(Model model,Integer order_id) {
        Order order = orderService.get(order_id);
        order.setStatus(OrderService.delete);
        orderService.update(order);
        return "success";
    }

    @RequestMapping("review")
    public String review(Model model,Integer order_id) {
        Order order = orderService.get(order_id);
        orderItemService.fill(order);
        Product product = order.getOrderItems().get(0).getProduct();
        List<Review> reviews = reviewService.findByProductId(product.getId());
        productService.setReviewCount(product);
        model.addAttribute("product",product);
        model.addAttribute("order",order);
        model.addAttribute("reviews",reviews);
        return "reviewPage";
    }

    @RequestMapping("doReview")
    public String deReview(Model model,HttpSession session,
                           @RequestParam("order_id") Integer order_id,

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

m0_71098312
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值