基于javaweb+mysql的ssm在线蛋糕商城系统(java+ssm+jsp+bootstrap+jquery+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM在线蛋糕商城系统(java+ssm+jsp+bootstrap+jquery+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项目:是;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:JSP+CSS+JavaScript+jQuery+Bootstrap
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入http://localhost:8080/ssm_dangao_shop/ 登录 注:Tomcat中配置项目路径必须为ssm_dangao_shop 用户账号/密码: user/123456 管理员账号/密码:admin/admin
break;
case "price":
Collections.sort(products, Comparator.comparing(Product::getPrice));
}
}
model.addAttribute("products", products);
return "searchPage";
}
//----------------------------------------------登录、注册-------------------------------------------------
@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);
}
@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();
}
}
public class LoginInterceptor extends HandlerInterceptorAdapter {
"/ssm_dangao_shop/searchProduct",
"/ssm_dangao_shop/sortProduct",
"/ssm_dangao_shop/showProduct",
"/ssm_dangao_shop/login",
"/ssm_dangao_shop/loginPage",
"/ssm_dangao_shop/registerPage",
"/ssm_dangao_shop/register",
"/ssm_dangao_shop/registerSuccess",
"/ssm_dangao_shop/checkLogin",
"/ssm_dangao_shop/admin",
"/ssm_dangao_shop/aLogin",
"/ssm_dangao_shop/adminLogout",
"/ssm_dangao_shop/knowledge",
"/ssm_dangao_shop/advert"
};
String uri = request.getRequestURI();
if(!Arrays.asList(noNeedAuthPage).contains(uri)) {
User user = (User) session.getAttribute("user");
if(null == user) {
response.sendRedirect("/ssm_dangao_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);
}
}
@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";
}
@RequestMapping("sortProduct")
public String sortProduct(Model model, String sort, String keyword) {
List<Product> products = productService.search(keyword);
for (Product product : products) {
product.setReviewCount(reviewService.getCount(product.getId()));
}
if (sort != null) {
switch (sort) {
case "all":
Collections.sort(products, Comparator.comparing(Product::getId));
break;
case "sale":
Collections.sort(products, Comparator.comparing(Product::getSale));
break;
case "price":
Collections.sort(products, Comparator.comparing(Product::getPrice));
}
}
model.addAttribute("products", products);
return "searchPage";
}
//----------------------------------------------登录、注册-------------------------------------------------
@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");
@RequestMapping("/registerSuccess")
public String registerSuccess() {
return "registerSuccess";
}
@RequestMapping("/payPage")
public String payPage() {
return "payPage";
}
@RequestMapping("/admin")
public String admin() {
return "admin/adminLogin";
}
@RequestMapping("/adminLogin")
public String adminLogin() {
return "admin/adminLogin";
}
@RequestMapping("/back")
public String back() {
return "back";
}
@RequestMapping("/knowledge")
public String knowledge() {
return "knowledge";
}
@RequestMapping("/advert")
public String advert() {
return "advert";
}
@RequestMapping("/touch")
public String touch() {
return "touch";
}
}
return "redirect:listPropertyValue?product_id=" + product_id + "&category_id=" + category_id;
}
}
@Controller
@RequestMapping("/admin")
public class ProductController {
@Autowired
private ProductService productService;
@Autowired
private CategoryService categoryService;
@Autowired
private ProductImageService productImageService;
@Autowired
private PropertyValueService propertyValueService;
@RequestMapping("/listProduct")
public String findAll(Model model,Integer category_id) {
List<Product> products = productService.findAll(category_id);
model.addAttribute("products",products);
Category category = categoryService.get(category_id);
model.addAttribute("category",category);
return "admin/listProduct";
}
@RequestMapping("/addProductView")
public String addView(Model model,Integer category_id) {
Category category = categoryService.get(category_id);
model.addAttribute("category",category);
return "admin/addProductView";
}
@RequestMapping("/addProduct")
public String add(Product product) {
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";
}
}
@Controller
public class PageController {
@RequestMapping("/loginPage")
public String loginPage() {
return "loginPage";
}
@RequestMapping("/registerPage")
public String registerPage() {
return "registerPage";
}
@RequestMapping("/registerSuccess")
public String registerSuccess() {
return "registerSuccess";
}
@RequestMapping("/payPage")
public String payPage() {
return "payPage";
}
@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";
}
}
@Controller
public class PageController {
@RequestMapping("/loginPage")
public String loginPage() {
}
@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");
return "redirect:admin";
}
}
@RequestMapping("/listProduct")
public String findAll(Model model,Integer category_id) {
List<Product> products = productService.findAll(category_id);
model.addAttribute("products",products);
Category category = categoryService.get(category_id);
model.addAttribute("category",category);
return "admin/listProduct";
}
@RequestMapping("/addProductView")
public String addView(Model model,Integer category_id) {
Category category = categoryService.get(category_id);
model.addAttribute("category",category);
return "admin/addProductView";
}
@RequestMapping("/addProduct")
public String add(Product product) {
productService.add(product);
ProductImage productImage = new ProductImage();
productImage.setProduct_id(product.getId());
for(int i = 1;i <= 5 ;i++) {
productImageService.add(productImage);
}
return "redirect:listProduct?category_id=" + product.getCategory_id();
}
/* @RequestMapping("/deleteProduct")
public String delete(Integer id,HttpServletRequest request) {
productImageService.deleteByProductId(id);
String path = request.getSession().getServletContext().getRealPath("" + id);
deleteDir(new File(path));
propertyValueService.deleteByProductId(id);
int category_id = productService.get(id).getCategory_id();
productService.delete(id);
return "redirect:listProduct?category_id=" + category_id;
}*/
/* public static boolean deleteDir(File dir) {
if(dir.isDirectory()){
String[] children = dir.list();
for(int i = 0 ;i < children.length;i++ ) {
boolean success = deleteDir(new File(dir, children[i]));
if(!success) {
}*/
/* public static boolean deleteDir(File dir) {
if(dir.isDirectory()){
String[] children = dir.list();
for(int i = 0 ;i < children.length;i++ ) {
boolean success = deleteDir(new File(dir, children[i]));
if(!success) {
return false;
}
}
}
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")
@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");
return "redirect:admin";
}
}
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";
}
}
@Controller
public class PageController {
@RequestMapping("/loginPage")
public String loginPage() {
return "loginPage";
}
@RequestMapping("/registerPage")
public String registerPage() {
return "registerPage";
}
@RequestMapping("/registerSuccess")
public String registerSuccess() {
return "registerSuccess";
}
@RequestMapping("/payPage")
public String payPage() {
return "payPage";
}
@RequestMapping("/admin")
public String admin() {
return "admin/adminLogin";
}
@RequestMapping("/adminLogin")
public String adminLogin() {
@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);
total += orderItem.getProduct().getPrice() * orderItem.getNumber();
orderItems.add(orderItem);
}
session.setAttribute("orderItems", orderItems);
model.addAttribute("total", total);
return "buyPage";
@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());
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) {
}
}
@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");
return "redirect:admin";
}
}
@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("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";