当前位置：首页 > Java

java如何买票

2026-03-19 11:39:45Java

使用Java实现购票功能

在Java中实现购票功能通常涉及数据库操作、用户界面交互和业务逻辑处理。以下是实现购票功能的关键步骤和代码示例。

数据库设计

创建数据库表存储票务信息，例如：

CREATE TABLE tickets (
    id INT PRIMARY KEY AUTO_INCREMENT,
    event_name VARCHAR(100) NOT NULL,
    price DECIMAL(10,2) NOT NULL,
    quantity INT NOT NULL,
    available BOOLEAN DEFAULT true
);

创建Java实体类

public class Ticket {
    private int id;
    private String eventName;
    private double price;
    private int quantity;
    private boolean available;

    // 构造函数、getter和setter方法
}

数据库连接和操作

使用JDBC进行数据库连接和操作：

public class TicketDAO {
    private Connection connection;

    public TicketDAO() {
        try {
            connection = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/ticket_db", 
                "username", 
                "password");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public boolean purchaseTicket(int ticketId, int quantity) {
        String sql = "UPDATE tickets SET quantity = quantity - ? WHERE id = ? AND quantity >= ?";
        try (PreparedStatement stmt = connection.prepareStatement(sql)) {
            stmt.setInt(1, quantity);
            stmt.setInt(2, ticketId);
            stmt.setInt(3, quantity);
            return stmt.executeUpdate() > 0;
        } catch (SQLException e) {
            e.printStackTrace();
            return false;
        }
    }
}

用户界面实现

使用Swing或JavaFX创建简单的购票界面：

public class TicketApp extends JFrame {
    private JTextField ticketIdField;
    private JTextField quantityField;
    private JButton purchaseButton;

    public TicketApp() {
        // 初始化UI组件
        purchaseButton.addActionListener(e -> {
            int ticketId = Integer.parseInt(ticketIdField.getText());
            int quantity = Integer.parseInt(quantityField.getText());

            TicketDAO dao = new TicketDAO();
            if (dao.purchaseTicket(ticketId, quantity)) {
                JOptionPane.showMessageDialog(this, "购票成功");
            } else {
                JOptionPane.showMessageDialog(this, "购票失败");
            }
        });
    }
}

事务处理

为确保数据一致性，应使用事务处理：

public boolean purchaseTicketWithTransaction(int ticketId, int quantity) {
    try {
        connection.setAutoCommit(false);

        // 检查票余量
        String checkSql = "SELECT quantity FROM tickets WHERE id = ?";
        PreparedStatement checkStmt = connection.prepareStatement(checkSql);
        checkStmt.setInt(1, ticketId);
        ResultSet rs = checkStmt.executeQuery();

        if (rs.next() && rs.getInt("quantity") >= quantity) {
            // 更新票余量
            String updateSql = "UPDATE tickets SET quantity = quantity - ? WHERE id = ?";
            PreparedStatement updateStmt = connection.prepareStatement(updateSql);
            updateStmt.setInt(1, quantity);
            updateStmt.setInt(2, ticketId);
            updateStmt.executeUpdate();

            connection.commit();
            return true;
        }

        connection.rollback();
        return false;
    } catch (SQLException e) {
        try {
            connection.rollback();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        e.printStackTrace();
        return false;
    }
}