javamysql异步查询

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.concurrent.CompletableFuture;

public class AsyncMySQLQuery {

    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String user = "username";
        String password = "password";

        CompletableFuture.runAsync(() -> {
            try (Connection conn = DriverManager.getConnection(url, user, password);
                 Statement stmt = conn.createStatement();
                 ResultSet rs = stmt.executeQuery("SELECT * FROM mytable")) {

                while (rs.next()) {
                    System.out.println(rs.getString("columnName"));
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }).thenRun(() -> {
            System.out.println("Query completed asynchronously.");
        });

        // 主线程继续执行其他任务
        System.out.println("Main thread continues to execute other tasks.");
    }
}