如何在JavaFX中执行异步数据库 [英] How can I do asynchrous database in JavaFX

问题描述

我有一个问题。如何在JavaFX中执行异步数据库。我知道存在SwingWoker，但我读到我不能在JavaFX中使用它。我读到了关于Task但我可以将结果转换为ObservableList但我需要普通的LinkedList。
我正在尝试使用mysql数据库

I have a question. How can I do asynchrous database in JavaFX. I know that exist SwingWoker but I read that I can't use this in JavaFX. I read about Task but I can do convert the result to ObservableList but I need normal LinkedList. I'm trying conntect to mysql database

我知道这个论坛在javafx中有很多关于数据库的回答，但所有结果都转换为ObservableList

I know that this forum has a lot of answering about database in javafx but all results are converted to ObservableList

感谢您的所有答案。

FlightControllerTask.java

FlightControllerTask.java

public class FlightControllerTask extends Task<LinkedList<Flight>>{
private final static int MAX=10000;
ArrayList<Airport> airportList=new ArrayList<>()
@Override
protected LinkedList<Flight> call() throws Exception {
    for (int i = 0; i < MAX; i++) {  
        updateProgress(i, MAX);  
        Thread.sleep(5);  
   }  

    LinkedList<Flight> flightList = new LinkedList<>();
    Connection c ;
    c = DBConnector.connect(); 
    String SQL = "SELECT flight.idflight, airport.nameAirport, airport.nameAirport, flight.departureTime FROM flight INNER JOIN airport";
    ResultSet rs = c.createStatement().executeQuery(SQL);  
    while(rs.next()){  
        flightList.add(new Flight(rs.getInt("idflight"), rs.getString("flightFrom"), rs.getString("flightTo"), rs.getTime("departureTime")));       
   }  

    return flightList;
}

FlightControllerService

FlightControllerService

public class FlightControllerService extends Service<LinkedList<Flight>>{
@Override  
protected Task<LinkedList<Flight>> createTask() {  
     return new FlightControllerTask();  
}  

}

MainController.java

MainController.java

final FlightControllerService service= new FlightControllerService();
    ReadOnlyObjectProperty<LinkedList<Flight>> flightList =service.valueProperty();
    flightList.get();

推荐答案

public class FlightControllerTask extends Task<LinkedList<Flight>>{
  @Override
  protected LinkedList<Flight> call() throws Exception { 
    // load data
    return data;
  }
}

// usage:
FlightControllerTask task = new FlightControllerTask();
task.setOnSucceeded(ev -> task.getValue());
new Thread(task).start();

现在部件 task.getValue（）是关键部分，使用此方法，您可以在准备好后立即检索使用任务计算的值（因此成功挂钩）。

Now the part with task.getValue() is the crucial part, with this method you can retrieve the value that was computed with the task as soon as is is ready (thus the succeeded hook).

这篇关于如何在JavaFX中执行异步数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！