controller

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package phonebookapp1;

import java.net.URL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.fxml.Initializable;
import javafx.scene.control.Label;
import java.sql.*;
import javafx.scene.control.Alert;
import javafx.scene.control.Alert.AlertType;
import javafx.scene.control.ListView;
import javafx.scene.control.TextField;

/**
 *
 * @author ucenik
 */
public class FXMLDocumentController implements Initializable {

         private String dbUrl = "jdbc:mysql://localhost:3306/PhoneBook?useSSL=false";
     private String username = "root";
     private String password ="root";
    @FXML
    private Label label;
    @FXML
    private ListView contactsListView;
    @FXML
    private TextField tf1;
     @FXML
    private TextField tf2;
      @FXML
    private TextField tf3;
    @FXML
    private void handleInsertButtonAction(ActionEvent event) {
        try(
           Connection conn = DriverManager.getConnection(dbUrl, username, password);
                Statement stmt = conn.createStatement();
        )
        {

           String name = tf2.getText();
           String phoneNumber= tf3.getText();
            String strInsert =String.format("insert into Contacts(Name,PhoneNumber) values ('%s','%s')",name,phoneNumber);
       int rowCount =  stmt.executeUpdate(strInsert);
       if(rowCount > 0)
       {
           Alert message = new Alert(AlertType.INFORMATION);
           message.setTitle("Uspesno ste dodali novi kontakt");
           message.showAndWait();
           LoadAllContacts();
       }
           }


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

    }
    @FXML
     private void handleDeleteButtonAction(ActionEvent event) {
     try(
           Connection conn = DriverManager.getConnection(dbUrl, username, password);
                Statement stmt = conn.createStatement();
        )
     {
                String ID = tf1.getText();

            String strDelete =String.format("delete from Contacts where id=%s",ID);
       int rowCount =  stmt.executeUpdate(strDelete);
       if(rowCount > 0)
       {
           Alert message = new Alert(AlertType.INFORMATION);
           message.setTitle("Uspesno ste izbrisali kontakt");
           message.showAndWait();
           LoadAllContacts();
     }
     }
       catch(SQLException ex)
        {
            ex.printStackTrace();
        }
     }
     @FXML
      private void handleUpdateButtonAction(ActionEvent event) {

              try(
           Connection conn = DriverManager.getConnection(dbUrl, username, password);
                Statement stmt = conn.createStatement();
        )
     {

                String ID = tf1.getText();
                String name= tf2.getText();
                String phoneNumber= tf3.getText();

            String strUpdate =String.format("update Contacts set Name='%s', PhoneNumber='%s' where Id=%s",name,phoneNumber ,ID);
       int rowCount =  stmt.executeUpdate(strUpdate);
       if(rowCount > 0)
       {
           Alert message = new Alert(AlertType.INFORMATION);
           message.setTitle("Uspesno ste izmenili kontakt");
           message.showAndWait();
           LoadAllContacts();
     }
     }
       catch(SQLException ex)
        {
            ex.printStackTrace();
        }
    }

    @Override
    public void initialize(URL url, ResourceBundle rb) {
LoadAllContacts();    }
    private void LoadAllContacts()
    {
        contactsListView.getItems().clear();
         try(
           Connection conn = DriverManager.getConnection(dbUrl, username, password);
                Statement stmt = conn.createStatement();
        )
        {
            String strSelect = "select * from Contacts";
            ResultSet rs = stmt.executeQuery(strSelect);


            while(rs.next()) {
            int id = rs.getInt("Id");
            String name = rs.getString("Name");
            String phoneNumber = rs.getString("PhoneNumber");
            System.out.println(String.format("%s %s %s",id , name, phoneNumber));
            Contact c = new Contact(id,name, phoneNumber);
            contactsListView.getItems().add(c);
           }


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

    }

}