Spring MVC电商项目：如何实现客户订单及订单历史展示？

看起来你已经搭建了电商项目的基础框架，现在卡在多表关联的订单数据展示上——这其实是Hibernate关联查询的典型场景，我帮你一步步梳理解决方案：

一、先完善实体类的关联映射 #

首先你没贴出Orders实体类，这是关联的核心，我先帮你补全并配置好与Product、Customer的关联：

1. 补全Orders实体类 #

package com.site.model;

import javax.persistence.*;
import java.io.Serializable;

@Entity
@Table(name = "orders") // MySQL避免用关键字做表名，这里小写更规范
public class Orders implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int orderId;

    // 多对一关联Product：一个订单对应一个产品（如果是多产品订单建议关联CartItem，这里按你的表结构来）
    @ManyToOne(fetch = FetchType.EAGER) // 直接加载关联产品，避免页面懒加载异常
    @JoinColumn(name = "productId") // 与数据库Orders表的productId字段对应
    private Product product;

    // 多对一关联Customer：多个订单属于一个客户
    @ManyToOne(fetch = FetchType.EAGER)
    @JoinColumn(name = "customerId") // 你的Orders表需要添加customerId字段，否则没法关联客户
    private Customer customer;

    private int quantity;
    private double totalPrice;

    // Getters & Setters
    public int getOrderId() { return orderId; }
    public void setOrderId(int orderId) { this.orderId = orderId; }
    public Product getProduct() { return product; }
    public void setProduct(Product product) { this.product = product; }
    public Customer getCustomer() { return customer; }
    public void setCustomer(Customer customer) { this.customer = customer; }
    public int getQuantity() { return quantity; }
    public void setQuantity(int quantity) { this.quantity = quantity; }
    public double getTotalPrice() { return totalPrice; }
    public void setTotalPrice(double totalPrice) { this.totalPrice = totalPrice; }
}

2. 确保Product实体的基础字段（你没贴，补必要部分） #

package com.site.model;

import javax.persistence.*;
import java.io.Serializable;

@Entity
public class Product implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int productId;
    private String productName;
    private String productManufacturer;
    // 其他字段如price、description等自行补充

    // Getters & Setters
    public int getProductId() { return productId; }
    public void setProductId(int productId) { this.productId = productId; }
    public String getProductName() { return productName; }
    public void setProductName(String productName) { this.productName = productName; }
    public String getProductManufacturer() { return productManufacturer; }
    public void setProductManufacturer(String productManufacturer) { this.productManufacturer = productManufacturer; }
}

二、DAO层实现多表关联查询 #

用HQL的JOIN FETCH一次性拉取所有关联数据，避免N+1查询问题：

1. OrdersDAO接口 #

package com.site.dao;

import com.site.model.Orders;
import com.site.model.Customer;
import java.util.List;

public interface OrdersDAO {
    // 查询指定客户的所有订单（带产品、客户地址信息）
    List<Orders> getOrdersByCustomer(Customer customer);
}

2. OrdersDAOImpl实现类 #

package com.site.dao.impl;

import com.site.dao.OrdersDAO;
import com.site.model.Orders;
import com.site.model.Customer;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.query.Query;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public class OrdersDAOImpl implements OrdersDAO {

    @Autowired
    private SessionFactory sessionFactory;

    @Override
    public List<Orders> getOrdersByCustomer(Customer customer) {
        Session session = sessionFactory.getCurrentSession();
        // JOIN FETCH 一次性加载关联的product和customer数据
        Query<Orders> query = session.createQuery(
                "FROM Orders o JOIN FETCH o.product JOIN FETCH o.customer WHERE o.customer.customerId = :customerId",
                Orders.class
        );
        query.setParameter("customerId", customer.getCustomerId());
        return query.getResultList();
    }
}

三、Service层封装业务逻辑 #

package com.site.service.impl;

import com.site.dao.OrdersDAO;
import com.site.model.Orders;
import com.site.model.Customer;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@Service
@Transactional
public class OrdersServiceImpl {

    @Autowired
    private OrdersDAO ordersDAO;

    public List<Orders> getCustomerOrderHistory(Customer customer) {
        return ordersDAO.getOrdersByCustomer(customer);
    }
}

四、Controller层传递数据到页面 #

假设用Spring Security做登录验证，获取当前登录用户的订单历史：

package com.site.controller;

import com.site.model.Customer;
import com.site.model.Orders;
import com.site.service.OrdersServiceImpl;
import com.site.service.CustomerService; // 你需要实现根据用户名查客户的Service
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.core.context.SecurityContextHolder;
import org.springframework.security.core.userdetails.UserDetails;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;

import java.util.List;

@Controller
public class OrderHistoryController {

    @Autowired
    private OrdersServiceImpl ordersService;
    @Autowired
    private CustomerService customerService;

    // 获取当前登录的客户
    private Customer getCurrentCustomer() {
        UserDetails userDetails = (UserDetails) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
        return customerService.getCustomerByUsername(userDetails.getUsername());
    }

    @GetMapping("/customer/order-history")
    public String showOrderHistory(Model model) {
        Customer currentCustomer = getCurrentCustomer();
        List<Orders> orderHistory = ordersService.getCustomerOrderHistory(currentCustomer);
        model.addAttribute("orderHistory", orderHistory);
        return "customer/order-history"; // 对应你的JSP页面路径
    }
}

五、JSP页面用JSTL展示多表数据 #

在order-history.jsp里，直接通过关联对象的属性获取跨表数据：

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>我的订单历史</title>
</head>
<body>
    <h2>我的订单</h2>
    <table border="1" cellpadding="8">
        <tr>
            <th>订单ID</th>
            <th>产品名称</th>
            <th>厂商</th>
            <th>购买数量</th>
            <th>订单总价</th>
            <th>收货地址</th>
        </tr>
        <c:forEach items="${orderHistory}" var="order">
            <tr>
                <td>${order.orderId}</td>
                <td>${order.product.productName}</td>
                <td>${order.product.productManufacturer}</td>
                <td>${order.quantity}</td>
                <td>${order.totalPrice}</td>
                <td>
                    ${order.customer.shippingAddress.addressLine1} ${order.customer.shippingAddress.addressLine2}<br>
                    ${order.customer.shippingAddress.city}, ${order.customer.shippingAddress.state} ${order.customer.shippingAddress.zipCode}
                </td>
            </tr>
        </c:forEach>
    </table>
</body>
</html>

关键注意事项 #

• 确保数据库Orders表存在customerId字段，否则没法关联Customer获取收货地址；
• 实体类的@JoinColumn名称必须和数据库字段完全一致；
• 用FETCH关键字一次性加载关联数据，避免页面渲染时触发懒加载异常；
• 如果是多产品订单，建议调整数据模型：让Orders关联Cart，Cart关联多个CartItem，这样更符合电商逻辑。

内容的提问来源于stack exchange，提问作者Harsh Patel