//this is the button action im working on
public void lisaMenyyNupp() {

    try{
        String query = "Select * from Toiduinfo where Toidu = ?";
        prep = con.prepareStatement(query);
        prep.setString(1, (String)cbToiduaine.getSelectionModel().getSelectedItem());
        rs = prep.executeQuery();
        String food = rs.getString("Toidu");
        int kalor = rs.getInt("Kalorid");
        int valk = rs.getInt("Valgud");
        int sys = rs.getInt("Süsivesikud");
        int rasv = rs.getInt("Rasvad");

        con = DriverManager.getConnection("jdbc:sqlite:Menyy.sqlite");
        stat = con.createStatement();
        stat.executeUpdate(
                    "CREATE TABLE IF NOT EXISTS Menuu (Toidunimi TEXT, Calories INTEGER, Proteins INTEGER, Carbs INTEGER, Fats INTEGER)");

        String queryone = "INSERT OR IGNORE INTO Menuu (Toidunimi, Calories, Proteins, Carbs, Fats) VALUES(?, ?, ?, ?, ?)";
        prep = con.prepareStatement(queryone);
        while(rs.next()){
        prep.setString(1, food);
        prep.setInt(2, kalor);
        prep.setInt(3, valk);
        prep.setInt(4, sys);
        prep.setInt(5, rasv);
        prep.close();
        }

    }catch(Exception e) {
        System.out.println(e);
    }

}

package packet;

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.FXCollections;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.fxml.FXMLLoader;
import javafx.scene.Parent;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.ComboBox;
import javafx.scene.control.Label;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.TextField;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.stage.Stage;

public class Paevikcontroll {
    @FXML
    private Label summaKcal;

    @FXML
    private Label summaValk;

    @FXML
    private Label summaSysi;

    @FXML
    private Label summaRasv;

    @FXML
    private Button lisaMenyy;

    @FXML
    private TableView tbTabel;

    @FXML
    private TableColumn tbToit;

    @FXML
    private TableColumn tbValk;

    @FXML
    private TableColumn tbRasv;

    @FXML
    private TableColumn tbKcal;

    @FXML
    private TableColumn tbSysi;

    @FXML
    private ComboBox cbToiduaine;

    @FXML
    private TextField txtKogus;

    private static Connection con;
    private static Statement stat;
    private PreparedStatement prep;
    ResultSet rs = null;
    ObservableList menuData;
    ObservableList options = FXCollections.observableArrayList();

    @FXML
    private void initialize() {

        menuData = FXCollections.observableArrayList();

        tbKcal.setCellValueFactory(new PropertyValueFactory<Toidubaas, Integer>("rbCal"));
        tbValk.setCellValueFactory(new PropertyValueFactory<Toidubaas, Integer>("rbProt"));
        tbSysi.setCellValueFactory(new PropertyValueFactory<Toidubaas, Integer>("rbCarb"));
        tbRasv.setCellValueFactory(new PropertyValueFactory<Toidubaas, Integer>("rbFat"));
        tbToit.setCellValueFactory(new PropertyValueFactory<Toidubaas, String>("rbMeal"));

        try {

            con = DriverManager.getConnection("jdbc:sqlite:Fooditabel.sqlite");
            stat = con.createStatement();
            stat.executeUpdate(
                    "CREATE TABLE IF NOT EXISTS Menuu (Toidunimi TEXT, Calories INTEGER, Proteins INTEGER, Carbs INTEGER, Fats INTEGER)");

            ResultSet rs = con.createStatement()
                    .executeQuery("SELECT Toidunimi, Calories, Proteins, Carbs, Fats FROM Menuu");
            while (rs.next()) {
                Toidubaas nrt = new Toidubaas();

                nrt.rbMeal.set(rs.getString("Toidunimi"));
                nrt.rbCal.set(rs.getInt("Calories"));
                nrt.rbProt.set(rs.getInt("Proteins"));
                nrt.rbCarb.set(rs.getInt("Carbs"));
                nrt.rbFat.set(rs.getInt("Fats"));
                menuData.add(nrt);
            }

            tbTabel.setItems(menuData);

        } catch (SQLException ex) {
            System.out.println(ex.getMessage());
            ;
        }

        cbToiduaine.setItems(options);
        fillComboBox();

    }


    public void fillComboBox() {
        String query = "select Toidu from Toiduinfo";
        try {
            con = DriverManager.getConnection("jdbc:sqlite:Fooditabel.sqlite");

            prep = con.prepareStatement(query);
            rs = prep.executeQuery();
            while (rs.next()) {
                options.add(rs.getString("Toidu"));
            }
            prep.close();
            rs.close();
        } catch (SQLException e) {

            e.printStackTrace();
        }
    }

    public void DataNupp(ActionEvent event) throws Exception {
        try {
            Parent root1 = (Parent) FXMLLoader.load(getClass().getResource("Databaas.fxml"));
            Stage stage = new Stage();
            stage.setScene(new Scene(root1));
            stage.show();
        } catch (Exception e) {

        }
    }

    public void lisaMenyyNupp() {

        try{
            String query = "Select * from Toiduinfo where Toidu = ?";
            prep = con.prepareStatement(query);
            prep.setString(1, (String)cbToiduaine.getSelectionModel().getSelectedItem());
            rs = prep.executeQuery();
            String food = rs.getString("Toidu");
            int kalor = rs.getInt("Kalorid");
            int valk = rs.getInt("Valgud");
            int sys = rs.getInt("Süsivesikud");
            int rasv = rs.getInt("Rasvad");

            con = DriverManager.getConnection("jdbc:sqlite:Fooditabel.sqlite");
            stat = con.createStatement();
            stat.executeUpdate(
                    "CREATE TABLE IF NOT EXISTS Menuu (Toidunimi TEXT, Calories INTEGER, Proteins INTEGER, Carbs INTEGER, Fats INTEGER)");

            String queryone = "INSERT OR IGNORE INTO Menuu (Toidunimi, Calories, Proteins, Carbs, Fats) VALUES(?, ?, ?, ?, ?)";
            prep = con.prepareStatement(queryone);
            while(rs.next()){
            prep.setString(1, food);
            prep.setInt(2, kalor);
            prep.setInt(3, valk);
            prep.setInt(4, sys);
            prep.setInt(5, rasv);
            prep.close();
            }

            /*while(rs.next()){
                Toidubaas nst = new Toidubaas();
                nst.rbMeal.set(rs.getString("Toidu"));
                nst.rbCal.set(rs.getInt("Kalorid"));
                nst.rbProt.set(rs.getInt("Valgud"));
                nst.rbCarb.set(rs.getInt("Süsivesikud"));
                nst.rbFat.set(rs.getInt("Rasvad"));
                menuData.add(nst);
            }*/
        }catch(Exception e) {
            System.out.println(e);
        }

        /*try{
            String query = "Insert or Ignore into Menuu(Toidunimi, Calories, Proteins, Carbs, Fats)";
            prep = con.prepareStatement(query);
            prep.setObject(1, cbToiduaine.getSelectionModel().getSelectedItem());
        }catch(Exception e){
            System.out.println(e);
        }*/
        summad();

    }

    public void valiNupp() {

        refreshCB();
    }

    public void refreshCB() {
        options.clear();
        try {
            String query = "Select * FROM Toiduinfo";
            prep = con.prepareStatement(query);
            rs = prep.executeQuery();

            while (rs.next()) {

                options.add(rs.getString("Toidu"));
                cbToiduaine.setItems(options);
            }
            prep.close();
            rs.close();
        } catch (Exception e2) {
            System.out.println(e2);
        }
    }
    public void summad(){

        int sumCal = 0;
        int sumProt = 0;
        int sumCarb = 0;
        int sumFat = 0;
        try {
        con = DriverManager.getConnection("jdbc:sqlite:Fooditabel.sqlite");
        stat = con.createStatement();

        rs = stat.executeQuery("SELECT SUM(Calories), SUM(Proteins), SUM(Carbs), SUM(Fats) FROM Menuu");
        while (rs.next()) {
            int c = rs.getInt(1);
            int d = rs.getInt(2);
            int e = rs.getInt(3);
            int f = rs.getInt(4);
            sumCal = sumCal + c;
            sumProt = sumProt + d;
            sumCarb = sumCarb + e;
            sumFat = sumFat + f;
            fillComboBox();
            refreshCB();
        }


        rs.close();

        } catch (Exception e) {
            System.out.println(e);
        }
            String sC = Integer.toString(sumCal);
            String sP = Integer.toString(sumProt);
            String sS = Integer.toString(sumCarb);
            String sF = Integer.toString(sumFat);
            summaKcal.setText(sC + " kcal");
            summaValk.setText(sP + " g");
            summaSysi.setText(sS + " g");
            summaRasv.setText(sF + " g");


    }

            public void removeBtn(){

            }


        }

package packet;

import javafx.beans.property.SimpleIntegerProperty;
import javafx.beans.property.SimpleStringProperty;

public class Toidubaas {

    public SimpleIntegerProperty rbCal = new SimpleIntegerProperty();
    public SimpleIntegerProperty rbProt = new SimpleIntegerProperty();
    public SimpleIntegerProperty rbCarb = new SimpleIntegerProperty();
    public SimpleIntegerProperty rbFat = new SimpleIntegerProperty();
    public SimpleStringProperty rbMeal = new SimpleStringProperty();

    public Toidubaas() {
    }
    public Toidubaas(String sbMeal) {
        this.rbMeal = new SimpleStringProperty(sbMeal);
        ;
    }

    public Toidubaas(String sbMeal, Integer sbCal, Integer sbProt, Integer sbCarb, Integer sbFat) {

        this.rbMeal = new SimpleStringProperty(sbMeal);
        this.rbCal = new SimpleIntegerProperty(sbCal);
        this.rbProt = new SimpleIntegerProperty(sbProt);
        this.rbCarb = new SimpleIntegerProperty(sbCarb);
        this.rbFat = new SimpleIntegerProperty(sbFat);

    }

    public String getRbMeal() {
        return rbMeal.get();
    }

    public void setRbMeal(String v) {
        rbMeal.set(v);
    }

    public Integer getRbCal() {
        return rbCal.get();
    }

    public void setRbCal(Integer v) {
        rbCal.set(v);
    }

    public Integer getRbProt() {
        return rbProt.get();
    }

    public void setRbProt(Integer v) {
        rbProt.set(v);
    }

    public Integer getRbCarb() {
        return rbCarb.get();
    }

    public void setRbCarb(Integer v) {
        rbCarb.set(v);
    }

    public Integer getRbFat() {
        return rbFat.get();
    }

    public void setRbFat(Integer v) {
        rbFat.set(v);
    }

}