How to develop a simple online travel booking system using MySQL and Java

How to use MySQL and Java to develop a simple online travel booking system

In today's digital era, more and more people choose to book travel and vacation products online , so developing a simple online travel booking system has become a new opportunity. In this article, we will introduce how to develop a simple online travel booking system using MySQL and Java, and provide some specific code examples.

First, we need to install and configure the MySQL database, and create corresponding tables to store travel products, user information and order information. The following are examples of SQL statements to create these tables:

CREATE TABLE products (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    description VARCHAR(255),
    price DECIMAL(8, 2) NOT NULL
);

CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50) NOT NULL,
    password VARCHAR(50) NOT NULL,
    email VARCHAR(50) NOT NULL
);

CREATE TABLE orders (
    id INT PRIMARY KEY AUTO_INCREMENT,
    product_id INT NOT NULL,
    user_id INT NOT NULL,
    quantity INT NOT NULL,
    total_price DECIMAL(8, 2) NOT NULL,
    order_date DATE NOT NULL,
    FOREIGN KEY (product_id) REFERENCES products(id),
    FOREIGN KEY (user_id) REFERENCES users(id)
);

Next, we can use Java to write the corresponding code to connect to the MySQL database and perform related additions, deletions, modifications and queries. The following is an example of a simple Java class used to connect to the database and query travel product information:

import java.sql.*;

public class TravelBookingSystem {
    private static final String JDBC_URL = "jdbc:mysql://localhost/travel_booking_system";
    private static final String USERNAME = "root";
    private static final String PASSWORD = "password";

    public static void main(String[] args) {
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;

        try {
            connection = DriverManager.getConnection(JDBC_URL, USERNAME, PASSWORD);
            statement = connection.createStatement();
            resultSet = statement.executeQuery("SELECT * FROM products");

            while (resultSet.next()) {
                int id = resultSet.getInt("id");
                String name = resultSet.getString("name");
                String description = resultSet.getString("description");
                double price = resultSet.getDouble("price");

                System.out.println("Product ID: " + id);
                System.out.println("Name: " + name);
                System.out.println("Description: " + description);
                System.out.println("Price: $" + price);
                System.out.println();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (resultSet != null) resultSet.close();
                if (statement != null) statement.close();
                if (connection != null) connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

In this sample code, we first define the URL, username and password required to connect to the database. Then, we establish a connection with the database through the DriverManager.getConnection() method and create a Statement object to execute the SQL query statement. Finally, we print out the travel product information by traversing the result set in the ResultSet object.

In addition to querying travel product information, we can also write corresponding code to handle operations such as user registration and order creation. The following is an example of a simple Java class for user registration and order creation:

import java.sql.*;

public class TravelBookingSystem {
    // ...

    public static void registerUser(String username, String password, String email) {
        Connection connection = null;
        PreparedStatement preparedStatement = null;

        try {
            connection = DriverManager.getConnection(JDBC_URL, USERNAME, PASSWORD);
            preparedStatement = connection.prepareStatement("INSERT INTO users (username, password, email) VALUES (?, ?, ?)");
            preparedStatement.setString(1, username);
            preparedStatement.setString(2, password);
            preparedStatement.setString(3, email);

            preparedStatement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (preparedStatement != null) preparedStatement.close();
                if (connection != null) connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public static void createOrder(int productId, int userId, int quantity) {
        Connection connection = null;
        PreparedStatement preparedStatement = null;

        try {
            connection = DriverManager.getConnection(JDBC_URL, USERNAME, PASSWORD);
            preparedStatement = connection.prepareStatement("INSERT INTO orders (product_id, user_id, quantity, order_date) VALUES (?, ?, ?, CURDATE())");
            preparedStatement.setInt(1, productId);
            preparedStatement.setInt(2, userId);
            preparedStatement.setInt(3, quantity);

            preparedStatement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (preparedStatement != null) preparedStatement.close();
                if (connection != null) connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

In this sample code, we have written the registerUser() method for registering users in the user form Insert new user information, and write the createOrder() method to insert new order information into the order form.

Through the above code example, we can see how to use MySQL and Java to develop a simple online travel booking system. Of course, this is just a basic version, and you can further expand and improve the system's functions according to actual needs. I hope this article can help you develop a travel reservation system!

The above is the detailed content of How to develop a simple online travel booking system using MySQL and Java. For more information, please follow other related articles on the PHP Chinese website!