package sample;

import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Parent;
import javafx.scene.Scene;
import javafx.stage.Stage;


import java.io.*;
import java.sql.*;
import java.util.Locale;

public class Main extends Application {

    @Override
    public void start(Stage primaryStage) throws Exception{
        Parent root = FXMLLoader.load(getClass().getResource("sample.fxml"));
        primaryStage.setTitle("Блюда");
        primaryStage.setScene(new Scene(root, primaryStage.getWidth(), primaryStage.getHeight()));
        primaryStage.show();
    }


    public static void main(String[] args) {
        launch(args);
        Locale.setDefault(Locale.ENGLISH);
        Connection connection = null;
        Statement statement = null;
        Statement statement1 = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try {
            connection = DriverManager.getConnection("jdbc:oracle:thin:@DESKTOP-7297M66:1521:XE", "KATKOVP_6307", "12345");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            statement = connection.createStatement();
        } catch (SQLException e) {
            e.printStackTrace();
        }


        try(FileWriter writer = new FileWriter("E:\\test.txt", false))
        {
            try {
                ResultSet resultSet = statement.executeQuery("select * from menu");
                while(resultSet.next()){
                    writer.write(resultSet.getNString(2) + ":" + "\n");
                    statement1 = connection.createStatement();
                    ResultSet resultSet1 = statement1.executeQuery("select component from composition where id = " + resultSet.getNString(1));
                    int i = 0;
                    while (resultSet1.next()) {
                        i++;
                        writer.write(resultSet1.getNString(1) + " ");
                    }
                    if (i == 0)
                        writer.write("нет ингридиентов " );
                    writer.write("\r\n");


                }
            }
            catch (SQLException e) {
                e.printStackTrace();
            }
            writer.flush();
        }
        catch(IOException ex){

            System.out.println(ex.getMessage());
        }

    }

}