如何在swing中连接到h2数据库

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

public class H2DatabaseConnection {
    private static final String DB_DRIVER = "org.h2.Driver";
    private static final String DB_CONNECTION = "jdbc:h2:~/test"; // H2数据库的连接URL
    private static final String DB_USER = "sa";
    private static final String DB_PASSWORD = "";

    public static Connection getDBConnection() {
        Connection connection = null;
        try {
            Class.forName(DB_DRIVER);
            connection = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD);
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return connection;
    }
}

import javax.swing.*;
import java.awt.*;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SwingH2DatabaseExample {
    public static void main(String[] args) {
        JFrame frame = new JFrame("Swing H2 Database Example");
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.setSize(400, 300);

        // 创建一个面板
        JPanel panel = new JPanel();
        panel.setLayout(new FlowLayout());

        // 创建一个标签
        JLabel label = new JLabel("查询结果:");
        panel.add(label);

        // 创建一个文本区域
        JTextArea textArea = new JTextArea(10, 30);
        panel.add(textArea);

        // 获取数据库连接
        Connection connection = H2DatabaseConnection.getDBConnection();

        if (connection != null) {
            try {
                Statement statement = connection.createStatement();
                String query = "SELECT * FROM your_table"; // 替换为你的表名
                ResultSet resultSet = statement.executeQuery(query);

                while (resultSet.next()) {
                    // 处理查询结果
                    String result = resultSet.getString("column_name"); // 替换为你的列名
                    textArea.append(result + "\n");
                }

                resultSet.close();
                statement.close();
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        frame.getContentPane().add(panel);
        frame.setVisible(true);
    }
}