Java实现订单历史查询方法详解

• order_id：订单唯一标识（主键）
• user_id：用户ID，用于关联查询
• product_name：商品名称
• quantity：数量
• total_price：总价
• order_date：下单时间
• status：订单状态（如已完成、已取消）

public class Order {
    private Long orderId;
    private Long userId;
    private String productName;
    private Integer quantity;
    private Double totalPrice;
    private Date orderDate;
    private String status;
// 构造函数、getter和setter省略
}

public class OrderDao {
    private Connection getConnection() throws SQLException {
        return DriverManager.getConnection(
            "jdbc:mysql://localhost:3306/your_db", "username", "password");
    }
public List<Order> getOrdersByUserId(Long userId) {
    List<Order> orders = new ArrayList<>();
    String sql = "SELECT * FROM orders WHERE user_id = ? ORDER BY order_date DESC";

    try (Connection conn = getConnection();
         PreparedStatement stmt = conn.prepareStatement(sql)) {

        stmt.setLong(1, userId);
        ResultSet rs = stmt.executeQuery();

        while (rs.next()) {
            Order order = new Order();
            order.setOrderId(rs.getLong("order_id"));
            order.setUserId(rs.getLong("user_id"));
            order.setProductName(rs.getString("product_name"));
            order.setQuantity(rs.getInt("quantity"));
            order.setTotalPrice(rs.getDouble("total_price"));
            order.setOrderDate(rs.getTimestamp("order_date"));
            order.setStatus(rs.getString("status"));
            orders.add(order);
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return orders;
}
}

public class OrderService {
    private OrderDao orderDao = new OrderDao();
public List<Order> getOrderHistory(Long userId) {
    if (userId == null || userId <= 0) {
        throw new IllegalArgumentException("无效的用户ID");
    }
    return orderDao.getOrdersByUserId(userId);
}
}

@RestController
@RequestMapping("/api/orders")
public class OrderController {
    private OrderService orderService = new OrderService();
@GetMapping("/history/{userId}")
public ResponseEntity<List<Order>> getOrderHistory(@PathVariable Long userId) {
    List<Order> orders = orderService.getOrderHistory(userId);
    return ResponseEntity.ok(orders);
}
}