package fxmltableview;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.scene.control.TableView;
import javafx.scene.control.TextField;


public class FXMLTableViewController {

    @FXML
    private TableView<Person> tableView;
    @FXML
    private TextField namaBarangField;
    @FXML
    private TextField jumlahBarangField;
    @FXML
    private TextField hargaBarangField;
    @FXML
    private TextField tanggalMasukField;

    @FXML
    protected void addPerson(ActionEvent event) {
        Connection conn2 = null;
        try {

            // connect way #2
            String url2 = "jdbc:mysql://localhost/test?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
            conn2 = DriverManager.getConnection(url2);
            if (conn2 != null) {
                System.out.println("Connected to the database test2");
            }

            String sql = "INSERT INTO View ( Nama_Barang, jumlah_Barang, Harga_Barang,Tanggal_Masuk ) VALUES (?, ?, ?, ?)";

            PreparedStatement statement = conn2.prepareStatement(sql);
            statement.setString(1, namaBarangField.getText());
            statement.setString(2, jumlahBarangField.getText());
            statement.setString(3, hargaBarangField.getText());
            statement.setString(4, tanggalMasukField.getText());

            int rowsInserted = statement.executeUpdate();
            if (rowsInserted > 0) {
                System.out.println("A new user was inserted successfully!");
            }

            String sqll = "SELECT * FROM View";

            Statement statementt = conn2.createStatement();
            ResultSet result = statementt.executeQuery(sqll);

            int count = 0;

            while (result.next()) {
                String Nama_Barang = result.getString("Nama_Barang");
                String jumlah_Barang = result.getString("jumlah_Barang");
                String Harga_Barang = result.getString("Harga_Barang");
                String Tanggal_Masuk = result.getString("Tanggal_Masuk");

                String output = "User #%d: %s - %s - %s - %s";
                System.out.println(String.format(output, ++count, Nama_Barang, jumlah_Barang, Harga_Barang, Tanggal_Masuk));
            }

        } catch (SQLException ex) {
            ex.printStackTrace();
        }

        ObservableList<Person> data = tableView.getItems();

        String namaBarang = namaBarangField.getText();
        int jumlahBarang = Integer.parseInt(jumlahBarangField.getText());
        int hargaBarang = Integer.parseInt(hargaBarangField.getText().replace(".", ""));
        String tanggalMasuk = tanggalMasukField.getText();

        data.add(new Person(namaBarang, jumlahBarang, hargaBarang, tanggalMasuk));

        namaBarangField.setText("");
        jumlahBarangField.setText("");
        hargaBarangField.setText("");
        tanggalMasukField.setText("");

    }

}