如何将HSQL DB与java应用程序集成

   <groupId>org.hsqldb</groupId>
   <artifactId>hsqldb</artifactId>
   <version>2.5.1</version>
</dependency>

implementation 'org.hsqldb:hsqldb:2.5.1'

import org.hsqldb.jdbc.JDBCDataSource;

public class Database {
    private JDBCDataSource dataSource;

    public Database() {
        dataSource = new JDBCDataSource();
        dataSource.setDatabase("jdbc:hsqldb:file:mydb");
        dataSource.setUser("sa");
        dataSource.setPassword("");
    }

    public Connection getConnection() throws SQLException {
        return dataSource.getConnection();
    }
}

import java.sql.Connection;
import java.sql.Statement;

public class TableCreator {
    private Database database;

    public TableCreator(Database database) {
        this.database = database;
    }

    public void createTable() throws SQLException {
        try (Connection connection = database.getConnection();
             Statement statement = connection.createStatement()) {
            statement.execute("CREATE TABLE IF NOT EXISTS users (id INT PRIMARY KEY, name VARCHAR(255))");
        }
    }
}

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class UserDao {
    private Database database;

    public UserDao(Database database) {
        this.database = database;
    }

    public void insertUser(int id, String name) throws SQLException {
        String sql = "INSERT INTO users (id, name) VALUES (?, ?)";
        try (Connection connection = database.getConnection();
             PreparedStatement statement = connection.prepareStatement(sql)) {
            statement.setInt(1, id);
            statement.setString(2, name);
            statement.executeUpdate();
        }
    }

    public User getUserById(int id) throws SQLException {
        String sql = "SELECT * FROM users WHERE id = ?";
        try (Connection connection = database.getConnection();
             PreparedStatement statement = connection.prepareStatement(sql)) {
            statement.setInt(1, id);
            try (ResultSet resultSet = statement.executeQuery()) {
                if (resultSet.next()) {
                    return new User(resultSet.getInt("id"), resultSet.getString("name"));
                }
            }
        }
        return null;
    }
}

public class Main {
    public static void main(String[] args) {
        Database database = new Database();
        TableCreator tableCreator = new TableCreator(database);
        UserDao userDao = new UserDao(database);

        try {
            tableCreator.createTable();
            userDao.insertUser(1, "John Doe");
            User user = userDao.getUserById(1);
            System.out.println("User: " + user.getName());
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}