在Java中如何开发在线票务管理系统_票务管理系统项目实战解析

@Data
@TableName("t_show")
public class Show {
    private Long id;
    private String title;
    private String location;
    private LocalDateTime showTime;
    private Integer status; // 0:未开始, 1:已结束
}

@PostMapping("/createOrder")
public String createOrder(@RequestParam Long ticketTypeId,
                          @RequestParam Integer quantity,
                          HttpSession session,
                          Model model) {
    User user = (User) session.getAttribute("user");
    TicketType ticket = ticketTypeService.getById(ticketTypeId);
<pre class="brush:php;toolbar:false;"><pre class="brush:php;toolbar:false;">if (ticket.getStock() < quantity) {
    model.addAttribute("error", "库存不足！");
    return "error";
}

// 扣减库存
ticket.setStock(ticket.getStock() - quantity);
ticketTypeService.updateById(ticket);

// 创建订单
Order order = new Order();
order.setOrderId(System.currentTimeMillis() + "-" + user.getId());
order.setUserId(user.getId());
order.setTicketTypeId(ticketTypeId);
order.setQuantity(quantity);
order.setTotalPrice(ticket.getPrice().multiply(BigDecimal.valueOf(quantity)));
order.setStatus(0); // 待支付
orderService.save(order);

return "redirect:/order/detail/" + order.getOrderId();

<pre class="brush:php;toolbar:false;">-- 用户表
CREATE TABLE t_user (
  id BIGINT PRIMARY KEY AUTO_INCREMENT,
  username VARCHAR(50) UNIQUE,
  password VARCHAR(100),
  role ENUM('USER','ADMIN')
);
<p>-- 演出表
CREATE TABLE t_show (
id BIGINT PRIMARY KEY AUTO_INCREMENT,
title VARCHAR(100),
location VARCHAR(100),
show_time DATETIME,
status INT
);</p><p>-- 票种表
CREATE TABLE t_ticket_type (
id BIGINT PRIMARY KEY AUTO_INCREMENT,
show_id BIGINT,
type_name VARCHAR(50),
price DECIMAL(10,2),
stock INT
);</p><p>-- 订单表
CREATE TABLE t_order (
id BIGINT PRIMARY KEY AUTO_INCREMENT,
order_id VARCHAR(50) UNIQUE,
user_id BIGINT,
ticket_type_id BIGINT,
quantity INT,
total_price DECIMAL(10,2),
status INT,
create_time DATETIME DEFAULT CURRENT_TIMESTAMP
);