ToB企服应用市场:ToB评测及商务社交产业平台

标题: 基于 SSM（Spring + Spring MVC + MyBatis）框架构建电器网上订购系统 [打印本页]

---

作者: 民工心事    时间: 2024-11-8 22:57
标题: 基于 SSM（Spring + Spring MVC + MyBatis）框架构建电器网上订购系统
基于 SSM（Spring + Spring MVC + MyBatis）框架构建电器网上订购系统可以为用户提供一个方便快捷的购物平台。以下将详细先容该系统的开发流程，包括需求分析、技术选型、数据库设计、项目结构搭建、主要功能实现以及前端页面设计。

需求分析

电器网上订购系统应具备以下功能：

• 用户注册与登录
  
• 商品展示与搜索
  
• 购物车管理
  
• 订单管理
  
• 支付接口集成
  
• 背景管理系统（商品管理、订单管理、用户管理）
  

技术选型

• 后端：Java、Spring、Spring MVC、MyBatis
  
• 前端：HTML、CSS、JavaScript、JQuery
  
• 数据库：MySQL
  
• 开发工具：IntelliJ IDEA 或 Eclipse
  
• 服务器：Tomcat
  

数据库设计

创建数据库表以存储用户信息、商品信息、购物车信息、订单信息等。
用户表（users）

• id (INT, 主键, 自增)
  
• username (VARCHAR)
  
• password (VARCHAR)
  
• email (VARCHAR)
  
• phone (VARCHAR)
  

商品表（products）

• id (INT, 主键, 自增)
  
• name (VARCHAR)
  
• description (TEXT)
  
• price (DECIMAL)
  
• stock (INT)
  
• category (VARCHAR)
  
• image_url (VARCHAR)
  

购物车表（cart_items）

• id (INT, 主键, 自增)
  
• user_id (INT, 外键)
  
• product_id (INT, 外键)
  
• quantity (INT)
  

订单表（orders）

• id (INT, 主键, 自增)
  
• user_id (INT, 外键)
  
• order_date (DATETIME)
  
• total_price (DECIMAL)
  
• status (VARCHAR)
  

订单详情表（order_details）

• id (INT, 主键, 自增)
  
• order_id (INT, 外键)
  
• product_id (INT, 外键)
  
• quantity (INT)
  
• price (DECIMAL)
  

项目结构搭建

• 创建 Maven 项目
  
  
  
  • 在 IDE 中创建一个新的 Maven 项目。
    
  • 修改 pom.xml 文件，添加必要的依赖项。
    
  
  
• 配置文件
  
  
  
  • application.properties
    1. spring.datasource.url=jdbc:mysql://localhost:3306/electronics_store?useSSL=false&serverTimezone=UTC
    2. spring.datasource.username=root
    3. spring.datasource.password=root
    4. spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    6. mybatis.mapper-locations=classpath:mapper/*.xml

    复制代码
  • spring-mvc.xml
    1. <beans xmlns="http://www.springframework.org/schema/beans"
    2.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    3.        xmlns:context="http://www.springframework.org/schema/context"
    4.        xmlns:mvc="http://www.springframework.org/schema/mvc"
    5.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    6.        http://www.springframework.org/schema/beans/spring-beans.xsd
    7.        http://www.springframework.org/schema/context
    8.        http://www.springframework.org/schema/context/spring-context.xsd
    9.        http://www.springframework.org/schema/mvc
    10.        http://www.springframework.org/schema/mvc/spring-mvc.xsd">
    12.     <context:component-scan base-package="com.electronics"/>
    13.     <mvc:annotation-driven/>
    15.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    16.         <property name="prefix" value="/WEB-INF/views/"/>
    17.         <property name="suffix" value=".jsp"/>
    18.     </bean>
    20. </beans>

    复制代码
  • mybatis-config.xml
    1. <configuration>
    2.     <mappers>
    3.         <mapper resource="mapper/UserMapper.xml"/>
    4.         <mapper resource="mapper/ProductMapper.xml"/>
    5.         <mapper resource="mapper/CartItemMapper.xml"/>
    6.         <mapper resource="mapper/OrderMapper.xml"/>
    7.         <mapper resource="mapper/OrderDetailMapper.xml"/>
    8.     </mappers>
    9. </configuration>

    复制代码
  
  

实体类

User.java

1. package com.electronics.entity;
3. public class User {
4.     private int id;
5.     private String username;
6.     private String password;
7.     private String email;
8.     private String phone;
10.     // Getters and Setters
11. }

复制代码

Product.java

1. package com.electronics.entity;
3. public class Product {
4.     private int id;
5.     private String name;
6.     private String description;
7.     private double price;
8.     private int stock;
9.     private String category;
10.     private String imageUrl;
12.     // Getters and Setters
13. }

复制代码

CartItem.java

1. package com.electronics.entity;
3. public class CartItem {
4.     private int id;
5.     private int userId;
6.     private int productId;
7.     private int quantity;
9.     // Getters and Setters
10. }

复制代码

Order.java

1. package com.electronics.entity;
3. import java.util.Date;
5. public class Order {
6.     private int id;
7.     private int userId;
8.     private Date orderDate;
9.     private double totalPrice;
10.     private String status;
12.     // Getters and Setters
13. }

复制代码

OrderDetail.java

1. package com.electronics.entity;
3. public class OrderDetail {
4.     private int id;
5.     private int orderId;
6.     private int productId;
7.     private int quantity;
8.     private double price;
10.     // Getters and Setters
11. }

复制代码

DAO 层

UserMapper.java

1. package com.electronics.mapper;
3. import com.electronics.entity.User;
4. import org.apache.ibatis.annotations.*;
6. @Mapper
7. public interface UserMapper {
8.     @Select("SELECT * FROM users WHERE username = #{username} AND password = #{password}")
9.     User login(@Param("username") String username, @Param("password") String password);
11.     @Insert("INSERT INTO users(username, password, email, phone) VALUES(#{username}, #{password}, #{email}, #{phone})")
12.     @Options(useGeneratedKeys = true, keyProperty = "id")
13.     void register(User user);
14. }

复制代码

ProductMapper.java

1. package com.electronics.mapper;
3. import com.electronics.entity.Product;
4. import org.apache.ibatis.annotations.*;
6. import java.util.List;
8. @Mapper
9. public interface ProductMapper {
10.     @Select("SELECT * FROM products")
11.     List<Product> getAllProducts();
13.     @Select("SELECT * FROM products WHERE id = #{id}")
14.     Product getProductById(int id);
16.     @Insert("INSERT INTO products(name, description, price, stock, category, image_url) VALUES(#{name}, #{description}, #{price}, #{stock}, #{category}, #{imageUrl})")
17.     @Options(useGeneratedKeys = true, keyProperty = "id")
18.     void addProduct(Product product);
20.     @Update("UPDATE products SET name=#{name}, description=#{description}, price=#{price}, stock=#{stock}, category=#{category}, image_url=#{imageUrl} WHERE id=#{id}")
21.     void updateProduct(Product product);
23.     @Delete("DELETE FROM products WHERE id=#{id}")
24.     void deleteProduct(int id);
25. }

复制代码

CartItemMapper.java

1. package com.electronics.mapper;
3. import com.electronics.entity.CartItem;
4. import org.apache.ibatis.annotations.*;
6. import java.util.List;
8. @Mapper
9. public interface CartItemMapper {
10.     @Select("SELECT * FROM cart_items WHERE user_id = #{userId}")
11.     List<CartItem> getCartItemsByUserId(int userId);
13.     @Insert("INSERT INTO cart_items(user_id, product_id, quantity) VALUES(#{userId}, #{productId}, #{quantity})")
14.     @Options(useGeneratedKeys = true, keyProperty = "id")
15.     void addToCart(CartItem cartItem);
17.     @Update("UPDATE cart_items SET quantity=#{quantity} WHERE id=#{id}")
18.     void updateCartItem(CartItem cartItem);
20.     @Delete("DELETE FROM cart_items WHERE id=#{id}")
21.     void deleteCartItem(int id);
22. }

复制代码

OrderMapper.java

1. package com.electronics.mapper;
3. import com.electronics.entity.Order;
4. import org.apache.ibatis.annotations.*;
6. import java.util.List;
8. @Mapper
9. public interface OrderMapper {
10.     @Select("SELECT * FROM orders WHERE user_id = #{userId}")
11.     List<Order> getOrdersByUserId(int userId);
13.     @Insert("INSERT INTO orders(user_id, order_date, total_price, status) VALUES(#{userId}, #{orderDate}, #{totalPrice}, #{status})")
14.     @Options(useGeneratedKeys = true, keyProperty = "id")
15.     void addOrder(Order order);
17.     @Update("UPDATE orders SET order_date=#{orderDate}, total_price=#{totalPrice}, status=#{status} WHERE id=#{id}")
18.     void updateOrder(Order order);
20.     @Delete("DELETE FROM orders WHERE id=#{id}")
21.     void deleteOrder(int id);
22. }

复制代码

OrderDetailMapper.java

1. package com.electronics.mapper;
3. import com.electronics.entity.OrderDetail;
4. import org.apache.ibatis.annotations.*;
6. import java.util.List;
8. @Mapper
9. public interface OrderDetailMapper {
10.     @Select("SELECT * FROM order_details WHERE order_id = #{orderId}")
11.     List<OrderDetail> getOrderDetailsByOrderId(int orderId);
13.     @Insert("INSERT INTO order_details(order_id, product_id, quantity, price) VALUES(#{orderId}, #{productId}, #{quantity}, #{price})")
14.     @Options(useGeneratedKeys = true, keyProperty = "id")
15.     void addOrderDetail(OrderDetail orderDetail);
16. }

复制代码

Service 层

UserService.java

1. package com.electronics.service;
3. import com.electronics.entity.User;
4. import com.electronics.mapper.UserMapper;
5. import org.springframework.beans.factory.annotation.Autowired;
6. import org.springframework.stereotype.Service;
8. @Service
9. public class UserService {
10.     @Autowired
11.     private UserMapper userMapper;
13.     public User login(String username, String password) {
14.         return userMapper.login(username, password);
15.     }
17.     public void register(User user) {
18.         userMapper.register(user);
19.     }
20. }

复制代码

ProductService.java

1. package com.electronics.service;
3. import com.electronics.entity.Product;
4. import com.electronics.mapper.ProductMapper;
5. import org.springframework.beans.factory.annotation.Autowired;
6. import org.springframework.stereotype.Service;
8. import java.util.List;
10. @Service
11. public class ProductService {
12.     @Autowired
13.     private ProductMapper productMapper;
15.     public List<Product> getAllProducts() {
16.         return productMapper.getAllProducts();
17.     }
19.     public Product getProductById(int id) {
20.         return productMapper.getProductById(id);
21.     }
23.     public void addProduct(Product product) {
24.         productMapper.addProduct(product);
25.     }
27.     public void updateProduct(Product product) {
28.         productMapper.updateProduct(product);
29.     }
31.     public void deleteProduct(int id) {
32.         productMapper.deleteProduct(id);
33.     }
34. }

复制代码

CartService.java

1. package com.electronics.service;
3. import com.electronics.entity.CartItem;
4. import com.electronics.mapper.CartItemMapper;
5. import org.springframework.beans.factory.annotation.Autowired;
6. import org.springframework.stereotype.Service;
8. import java.util.List;
10. @Service
11. public class CartService {
12.     @Autowired
13.     private CartItemMapper cartItemMapper;
15.     public List<CartItem> getCartItemsByUserId(int userId) {
16.         return cartItemMapper.getCartItemsByUserId(userId);
17.     }
19.     public void addToCart(CartItem cartItem) {
20.         cartItemMapper.addToCart(cartItem);
21.     }
23.     public void updateCartItem(CartItem cartItem) {
24.         cartItemMapper.updateCartItem(cartItem);
25.     }
27.     public void deleteCartItem(int id) {
28.         cartItemMapper.deleteCartItem(id);
29.     }
30. }

复制代码

OrderService.java

1. package com.electronics.service;
3. import com.electronics.entity.Order;
4. import com.electronics.entity.OrderDetail;
5. import com.electronics.mapper.OrderDetailMapper;
6. import com.electronics.mapper.OrderMapper;
7. import org.springframework.beans.factory.annotation.Autowired;
8. import org.springframework.stereotype.Service;
10. import java.util.List;
12. @Service
13. public class OrderService {
14.     @Autowired
15.     private OrderMapper orderMapper;
17.     @Autowired
18.     private OrderDetailMapper orderDetailMapper;
20.     public List<Order> getOrdersByUserId(int userId) {
21.         return orderMapper.getOrdersByUserId(userId);
22.     }
24.     public void addOrder(Order order) {
25.         orderMapper.addOrder(order);
26.         for (OrderDetail detail : order.getOrderDetails()) {
27.             orderDetailMapper.addOrderDetail(detail);
28.         }
29.     }
31.     public void updateOrder(Order order) {
32.         orderMapper.updateOrder(order);
33.     }
35.     public void deleteOrder(int id) {
36.         orderMapper.deleteOrder(id);
37.     }
38. }

复制代码

Controller 层

UserController.java

1. package com.electronics.controller;
3. import com.electronics.entity.User;
4. import com.electronics.service.UserService;
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.GetMapping;
9. import org.springframework.web.bind.annotation.PostMapping;
10. import org.springframework.web.bind.annotation.RequestParam;
12. @Controller
13. public class UserController {
14.     @Autowired
15.     private UserService userService;
17.     @GetMapping("/login")
18.     public String showLoginForm() {
19.         return "login";
20.     }
22.     @PostMapping("/login")
23.     public String handleLogin(@RequestParam("username") String username, @RequestParam("password") String password, Model model) {
24.         User user = userService.login(username, password);
25.         if (user != null) {
26.             model.addAttribute("user", user);
27.             return "redirect:/products";
28.         } else {
29.             model.addAttribute("error", "Invalid username or password");
30.             return "login";
31.         }
32.     }
34.     @GetMapping("/register")
35.     public String showRegisterForm() {
36.         return "register";
37.     }
39.     @PostMapping("/register")
40.     public String handleRegister(User user) {
41.         userService.register(user);
42.         return "redirect:/login";
43.     }
44. }

复制代码

ProductController.java

1. package com.electronics.controller;
3. import com.electronics.entity.Product;
4. import com.electronics.service.ProductService;
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.GetMapping;
9. import org.springframework.web.bind.annotation.PostMapping;
10. import org.springframework.web.bind.annotation.RequestParam;
12. import java.util.List;
14. @Controller
15. public class ProductController {
16.     @Autowired
17.     private ProductService productService;
19.     @GetMapping("/products")
20.     public String showProducts(Model model) {
21.         List<Product> products = productService.getAllProducts();
22.         model.addAttribute("products", products);
23.         return "products";
24.     }
26.     @GetMapping("/product/{id}")
27.     public String showProductDetails(@RequestParam("id") int id, Model model) {
28.         Product product = productService.getProductById(id);
29.         model.addAttribute("product", product);
30.         return "productDetails";
31.     }
33.     @GetMapping("/addProduct")
34.     public String showAddProductForm() {
35.         return "addProduct";
36.     }
38.     @PostMapping("/addProduct")
39.     public String handleAddProduct(Product product) {
40.         productService.addProduct(product);
41.         return "redirect:/products";
42.     }
44.     @GetMapping("/editProduct/{id}")
45.     public String showEditProductForm(@RequestParam("id") int id, Model model) {
46.         Product product = productService.getProductById(id);
47.         model.addAttribute("product", product);
48.         return "editProduct";
49.     }
51.     @PostMapping("/editProduct")
52.     public String handleEditProduct(Product product) {
53.         productService.updateProduct(product);
54.         return "redirect:/products";
55.     }
57.     @GetMapping("/deleteProduct/{id}")
58.     public String handleDeleteProduct(@RequestParam("id") int id) {
59.         productService.deleteProduct(id);
60.         return "redirect:/products";
61.     }
62. }

复制代码

CartController.java

1. package com.electronics.controller;
3. import com.electronics.entity.CartItem;
4. import com.electronics.entity.Product;
5. import com.electronics.service.CartService;
6. import com.electronics.service.ProductService;
7. import org.springframework.beans.factory.annotation.Autowired;
8. import org.springframework.stereotype.Controller;
9. import org.springframework.ui.Model;
10. import org.springframework.web.bind.annotation.GetMapping;
11. import org.springframework.web.bind.annotation.PostMapping;
12. import org.springframework.web.bind.annotation.RequestParam;
14. import java.util.List;
16. @Controller
17. public class CartController {
18.     @Autowired
19.     private CartService cartService;
21.     @Autowired
22.     private ProductService productService;
24.     @GetMapping("/cart")
25.     public String showCart(@RequestParam("userId") int userId, Model model) {
26.         List<CartItem> cartItems = cartService.getCartItemsByUserId(userId);
27.         model.addAttribute("cartItems", cartItems);
28.         return "cart";
29.     }
31.     @PostMapping("/addToCart")
32.     public String handleAddToCart(@RequestParam("userId") int userId, @RequestParam("productId") int productId, @RequestParam("quantity") int quantity) {
33.         Product product = productService.getProductById(productId);
34.         CartItem cartItem = new CartItem();
35.         cartItem.setUserId(userId);
36.         cartItem.setProductId(productId);
37.         cartItem.setQuantity(quantity);
38.         cartService.addToCart(cartItem);
39.         return "redirect:/cart?userId=" + userId;
40.     }
42.     @PostMapping("/updateCartItem")
43.     public String handleUpdateCartItem(@RequestParam("id") int id, @RequestParam("quantity") int quantity) {
44.         CartItem cartItem = new CartItem();
45.         cartItem.setId(id);
46.         cartItem.setQuantity(quantity);
47.         cartService.updateCartItem(cartItem);
48.         return "redirect:/cart?userId=" + cartItem.getUserId();
49.     }
51.     @GetMapping("/removeFromCart/{id}")
52.     public String handleRemoveFromCart(@RequestParam("id") int id, @RequestParam("userId") int userId) {
53.         cartService.deleteCartItem(id);
54.         return "redirect:/cart?userId=" + userId;
55.     }
56. }

复制代码

OrderController.java

1. package com.electronics.controller;
3. import com.electronics.entity.Order;
4. import com.electronics.entity.OrderDetail;
5. import com.electronics.entity.Product;
6. import com.electronics.service.OrderService;
7. import com.electronics.service.ProductService;
8. import org.springframework.beans.factory.annotation.Autowired;
9. import org.springframework.stereotype.Controller;
10. import org.springframework.ui.Model;
11. import org.springframework.web.bind.annotation.GetMapping;
12. import org.springframework.web.bind.annotation.PostMapping;
13. import org.springframework.web.bind.annotation.RequestParam;
15. import java.util.ArrayList;
16. import java.util.Date;
17. import java.util.List;
19. @Controller
20. public class OrderController {
21.     @Autowired
22.     private OrderService orderService;
24.     @Autowired
25.     private ProductService productService;
27.     @GetMapping("/orders")
28.     public String showOrders(@RequestParam("userId") int userId, Model model) {
29.         List<Order> orders = orderService.getOrdersByUserId(userId);
30.         model.addAttribute("orders", orders);
31.         return "orders";
32.     }
34.     @PostMapping("/placeOrder")
35.     public String handlePlaceOrder(@RequestParam("userId") int userId, @RequestParam("cartItemIds") String cartItemIds) {
36.         Order order = new Order();
37.         order.setUserId(userId);
38.         order.setOrderDate(new Date());
39.         order.setTotalPrice(0.0);
40.         order.setStatus("Pending");
42.         List<OrderDetail> orderDetails = new ArrayList<>();
43.         String[] ids = cartItemIds.split(",");
44.         for (String id : ids) {
45.             int cartItemId = Integer.parseInt(id);
46.             CartItem cartItem = cartService.getCartItemById(cartItemId);
47.             Product product = productService.getProductById(cartItem.getProductId());
49.             OrderDetail orderDetail = new OrderDetail();
50.             orderDetail.setProductId(cartItem.getProductId());
51.             orderDetail.setQuantity(cartItem.getQuantity());
52.             orderDetail.setPrice(product.getPrice());
54.             orderDetails.add(orderDetail);
55.             order.setTotalPrice(order.getTotalPrice() + product.getPrice() * cartItem.getQuantity());
56.         }
58.         order.setOrderDetails(orderDetails);
59.         orderService.addOrder(order);
61.         // 清空购物车
62.         for (OrderDetail detail : orderDetails) {
63.             cartService.deleteCartItem(detail.getId());
64.         }
66.         return "redirect:/orders?userId=" + userId;
67.     }
68. }

复制代码

前端页面

使用 JSP 创建前端页面。以下是简朴的 JSP 示例：
login.jsp

1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
2. <html>
3. <head>
4.     <title>Login</title>
5. </head>
6. <body>
7. <h2>Login</h2>
8. <form action="${pageContext.request.contextPath}/login" method="post">
9.     Username: <input type="text" name="username"><br>
10.     Password: <input type="password" name="password"><br>
11.     <input type="submit" value="Login">
12. </form>
13. <c:if test="${not empty error}">
14.     <p style="color: red">${error}</p>
15. </c:if>
16. </body>
17. </html>

复制代码

products.jsp

1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
2. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
3. <html>
4. <head>
5.     <title>Products</title>
6. </head>
7. <body>
8. <h2>Products</h2>
9. <table>
10.     <tr>
11.         <th>Name</th>
12.         <th>Description</th>
13.         <th>Price</th>
14.         <th>Stock</th>
15.         <th>Category</th>
16.         <th>Action</th>
17.     </tr>
18.     <c:forEach items="${products}" var="product">
19.         <tr>
20.             <td>${product.name}</td>
21.             <td>${product.description}</td>
22.             <td>${product.price}</td>
23.             <td>${product.stock}</td>
24.             <td>${product.category}</td>
25.             <td>
26.                 <a href="${pageContext.request.contextPath}/product/${product.id}">View</a>
27.                 <a href="${pageContext.request.contextPath}/addToCart?userId=${user.id}&productId=${product.id}&quantity=1">Add to Cart</a>
28.             </td>
29.         </tr>
30.     </c:forEach>
31. </table>
32. <a href="${pageContext.request.contextPath}/addProduct">Add New Product</a>
33. </body>
34. </html>

复制代码

cart.jsp

1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
2. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
3. <html>
4. <head>
5.     <title>Cart</title>
6. </head>
7. <body>
8. <h2>Cart</h2>
9. <table>
10.     <tr>
11.         <th>Product Name</th>
12.         <th>Quantity</th>
13.         <th>Price</th>
14.         <th>Action</th>
15.     </tr>
16.     <c:forEach items="${cartItems}" var="cartItem">
17.         <tr>
18.             <td>${cartItem.product.name}</td>
19.             <td>${cartItem.quantity}</td>
20.             <td>${cartItem.product.price}</td>
21.             <td>
22.                 <a href="${pageContext.request.contextPath}/removeFromCart?id=${cartItem.id}&userId=${user.id}">Remove</a>
23.             </td>
24.         </tr>
25.     </c:forEach>
26. </table>
27. <a href="${pageContext.request.contextPath}/placeOrder?userId=${user.id}&cartItemIds=${cartItemIds}">Place Order</a>
28. </body>
29. </html>

复制代码

测试与调试

对每个功能举行详细测试，确保全部功能都能正常工作。
部署与发布

编译最终版本的应用程序，并准备好 WAR 文件供 Tomcat 或其他应用服务器部署。

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。

---

欢迎光临 ToB企服应用市场:ToB评测及商务社交产业平台 (https://dis.qidao123.com/)

Powered by Discuz! X3.4