用于从javafx tableView和SQLite表行中删除选定行的删除按钮功能

import javafx.application.Application;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.scene.layout.VBox;
import javafx.stage.Stage;

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

public class DeleteButtonExample extends Application {

    private TableView<Person> tableView;
    private ObservableList<Person> data;

    public static void main(String[] args) {
        launch(args);
    }

    @Override
    public void start(Stage primaryStage) {
        primaryStage.setTitle("Delete Button Example");

        // 创建TableView和数据
        tableView = new TableView<>();
        data = FXCollections.observableArrayList(
                new Person("John", "Doe"),
                new Person("Jane", "Smith"),
                new Person("Bob", "Johnson")
        );

        // 创建列和删除按钮
        TableColumn<Person, String> firstNameCol = new TableColumn<>("First Name");
        firstNameCol.setCellValueFactory(new PropertyValueFactory<>("firstName"));

        TableColumn<Person, String> lastNameCol = new TableColumn<>("Last Name");
        lastNameCol.setCellValueFactory(new PropertyValueFactory<>("lastName"));

        TableColumn<Person, Void> deleteCol = new TableColumn<>("Delete");
        deleteCol.setCellFactory(param -> new DeleteButtonCell());

        tableView.getColumns().addAll(firstNameCol, lastNameCol, deleteCol);
        tableView.setItems(data);

        // 创建布局并显示场景
        VBox vbox = new VBox(tableView);
        Scene scene = new Scene(vbox);
        primaryStage.setScene(scene);
        primaryStage.show();
    }

    // 自定义单元格，添加删除按钮
    private class DeleteButtonCell extends TableCell<Person, Void> {
        private final Button deleteButton;

        public DeleteButtonCell() {
            deleteButton = new Button("Delete");
            deleteButton.setOnAction(event -> {
                Person person = getTableRow().getItem();
                deletePerson(person);
            });
        }

        @Override
        protected void updateItem(Void item, boolean empty) {
            super.updateItem(item, empty);
            if (!empty) {
                setGraphic(deleteButton);
            } else {
                setGraphic(null);
            }
        }
    }

    // 从SQLite表中删除选定的行
    private void deletePerson(Person person) {
        try {
            Connection conn = DriverManager.getConnection("jdbc:sqlite:path/to/database.db");
            String sql = "DELETE FROM Person WHERE firstName = ? AND lastName = ?";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, person.getFirstName());
            pstmt.setString(2, person.getLastName());
            pstmt.executeUpdate();
            data.remove(person);
            pstmt.close();
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    // Person类，用于存储数据
    private static class Person {
        private final String firstName;
        private final String lastName;

        public Person(String firstName, String lastName) {
            this.firstName = firstName;
            this.lastName = lastName;
        }

        public String getFirstName() {
            return firstName;
        }

        public String getLastName() {
            return lastName;
        }
    }
}