用Java从SQLIte数据库中检索特定数据

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

Connection connection = null;
try {
    Class.forName("org.sqlite.JDBC");
    connection = DriverManager.getConnection("jdbc:sqlite:/path/to/database.db");
} catch (ClassNotFoundException | SQLException e) {
    e.printStackTrace();
}

Statement statement = null;
try {
    statement = connection.createStatement();
} catch (SQLException e) {
    e.printStackTrace();
}

String query = "SELECT * FROM table_name WHERE column_name = 'specific_value'";
ResultSet resultSet = null;
try {
    resultSet = statement.executeQuery(query);
} catch (SQLException e) {
    e.printStackTrace();
}

try {
    while (resultSet.next()) {
        // 从结果集中获取数据
        String column1 = resultSet.getString("column1");
        int column2 = resultSet.getInt("column2");
        // 处理数据
        // ...
    }
} catch (SQLException e) {
    e.printStackTrace();
}

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