Java提交HsqlDB

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

Class.forName("org.hsqldb.jdbc.JDBCDriver");

String url = "jdbc:hsqldb:file:/path/to/database";
Connection connection = DriverManager.getConnection(url, "username", "password");

Statement statement = connection.createStatement();
String createTableQuery = "CREATE TABLE IF NOT EXISTS my_table (id INT PRIMARY KEY, name VARCHAR(50))";
statement.executeUpdate(createTableQuery);

String insertQuery = "INSERT INTO my_table (id, name) VALUES (1, 'John')";
statement.executeUpdate(insertQuery);

String selectQuery = "SELECT * FROM my_table";
ResultSet resultSet = statement.executeQuery(selectQuery);
while (resultSet.next()) {
    int id = resultSet.getInt("id");
    String name = resultSet.getString("name");
    System.out.println("id: " + id + ", name: " + name);
}

resultSet.close();
statement.close();
connection.close();