在NetBeans中使用java连接SQLite数据库

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

public class SQLiteConnection {
    public static Connection connect() {
        Connection conn = null;
        try {
            // 注册SQLite JDBC驱动
            Class.forName("org.sqlite.JDBC");
            
            // 创建数据库连接
            String url = "jdbc:sqlite:/path/to/your/database.db";
            conn = DriverManager.getConnection(url);
            
            System.out.println("SQLite数据库连接成功！");
        } catch (ClassNotFoundException | SQLException e) {
            System.out.println(e.getMessage());
        }
        return conn;
    }
}

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

public class Main {
    public static void main(String[] args) {
        Connection conn = SQLiteConnection.connect();
        if (conn != null) {
            try {
                Statement stmt = conn.createStatement();
                String sql = "SELECT * FROM table_name";
                ResultSet rs = stmt.executeQuery(sql);
                
                while (rs.next()) {
                    // 处理查询结果
                    String column1 = rs.getString("column1");
                    int column2 = rs.getInt("column2");
                    // ...
                }
                
                rs.close();
                stmt.close();
                conn.close();
            } catch (SQLException e) {
                System.out.println(e.getMessage());
            }
        }
    }
}