从Java代码生成SQLite数据库方案

<dependency>
    <groupId>org.xerial</groupId>
    <artifactId>sqlite-jdbc</artifactId>
    <version>3.36.0.3</version>
</dependency>

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class SQLiteConnection {
    public static void main(String[] args) {
        Connection connection = null;
        try {
            // 连接到SQLite数据库
            connection = DriverManager.getConnection("jdbc:sqlite:/path/to/database.db");
            System.out.println("成功连接到数据库！");
        } catch (SQLException e) {
            System.out.println("连接数据库时发生错误：" + e.getMessage());
        } finally {
            try {
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                System.out.println("关闭数据库连接时发生错误：" + e.getMessage());
            }
        }
    }
}

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class SQLiteCreateTable {
    public static void main(String[] args) {
        Connection connection = null;
        Statement statement = null;
        try {
            // 连接到SQLite数据库
            connection = DriverManager.getConnection("jdbc:sqlite:/path/to/database.db");
            System.out.println("成功连接到数据库！");

            // 创建表
            statement = connection.createStatement();
            String createTableSQL = "CREATE TABLE IF NOT EXISTS employees (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)";
            statement.executeUpdate(createTableSQL);
            System.out.println("成功创建表！");

            // 插入数据
            String insertDataSQL = "INSERT INTO employees (id, name, age) VALUES (1, 'John Doe', 30)";
            statement.executeUpdate(insertDataSQL);
            System.out.println("成功插入数据！");
        } catch (SQLException e) {
            System.out.println("操作数据库时发生错误：" + e.getMessage());
        } finally {
            try {
                if (statement != null) {
                    statement.close();
                }
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                System.out.println("关闭数据库连接时发生错误：" + e.getMessage());
            }
        }
    }
}