Ébauche Assignement Everflow

import java.io.IOException;
import java.io.InputStream;
import java.net.URL;
import java.sql.*;

import org.glassfish.json.JsonProviderImpl;
import javax.json.*;
import javax.json.stream.JsonParser;
import javax.json.stream.JsonParser.Event;

public class Main {

    public static void main(String[] args) {



        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/everflow","root","benben");
            Statement stmt = con.createStatement();
            String query = "INSERT INTO test VALUES (";

            URL url = new URL("https://newsapi.org/v2/top-headlines?country=us&category=business&apiKey=57f4696d8c28484f849bc09108670849");
            InputStream is = url.openStream();
            JsonReader reader = Json.createReader(is);

            JsonObject obj = reader.readObject();
            JsonArray results = obj.getJsonArray("data");


            for(JsonObject result : results.getValuesAs(JsonObject.class)) {
                //Pour tester que les objets sont biens reçus
                System.out.print(result.getJsonObject("from").getString("name"));
                System.out.print(": ");
                System.out.println(result.getString("message", ""));
                System.out.println("-----------");
            }



        } catch (IOException | ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }

    }

}