Javafx Mysql CRUD Step by Step

This Javafx Mysql crud will teach you how to do basic database functions that are CREATE RETIEVE UPDATE and DELETE. using Mysql Database. The INSERT, SELECT, UPDATE and DELETE statements can be used in any database system, because this is support by all relational database systems.

The tutorial you learn javafx mysql crud operation step by step. Crud operations are must when you developing a javafx mini projects. learn how to INSERT, SELECT, UPDATE and DELETE in database by writing code to manage the registation table in the database named studcruds. records table consist of following columns name,mobile,course.

we will do the java best practice for understand java programming clearly and easily.

First Step

Install Scence Builder in your computer follow this link to download the scene builder which will offers all visual layout components which will easy to drag and drop and make the attractive look. After installed the Scence Builder in your computer successfully.open the netbeans and select new project ->JavaFx- you can select here JavaFx FXML Application and click next it will automatically configure the scene builder path. i attached the
screen shot image below.

Double click and open the FXMLDocument.fxml your Scence Builder will be loaded and open. then your make your design as you like.

after done the design you must name textfields and tables and tables coloums. after that copy code. go to view->Sample Skeleton

Copy the code

And paste into FXMLDocumentController inside the class. remove the default design and keep as it is a initialize method. this code which will manage the Add Records and View Records from the database.

package javafxcrudd;

import java.net.URL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ResourceBundle;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.fxml.Initializable;
import javafx.scene.control.Label;
import javafx.fxml.FXML;
import javafx.scene.control.Button;
import javafx.scene.control.Label;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.TextField;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.scene.control.Alert;
import javafx.scene.control.TableRow;
/**
 *
 * @author kobinath
 */public class FXMLDocumentController implements Initializable {
    
   
     @FXML
    private Label label;

    @FXML
    private TextField txtName;

    @FXML
    private TextField txtMobile;

    @FXML
    private TextField txtCourse;

    @FXML
    private TableView<Student> table;

    @FXML
    private TableColumn<Student, String> IDColmn;

    @FXML
    private TableColumn<Student, String> NameColmn;

    @FXML
    private TableColumn<Student, String> MobileColmn;

    @FXML
    private TableColumn<Student, String> CourseColmn;

    @FXML
    private Button btnAdd;

    @FXML
    private Button btnUpdate;

    @FXML
    private Button btnDelete;

    @FXML
    void Add(ActionEvent event) {
        
            String stname,mobile,course;
            stname = txtName.getText();
            mobile = txtMobile.getText();
            course = txtCourse.getText();
        try 
        {
            pst = con.prepareStatement("insert into registation(name,mobile,course)values(?,?,?)");
            pst.setString(1, stname);
            pst.setString(2, mobile);
            pst.setString(3, course);
            pst.executeUpdate();
          
             Alert alert = new Alert(Alert.AlertType.INFORMATION);
        alert.setTitle("Student Registation");

        
        alert.setHeaderText("Student Registation");
        alert.setContentText("Record Addedddd!");

        alert.showAndWait();

            table();
            
            txtName.setText("");
            txtMobile.setText("");
            txtCourse.setText("");
            txtName.requestFocus();
        } 
        catch (SQLException ex)
        {
            Logger.getLogger(FXMLDocumentController.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    
    public void table()
      {
          Connect();
          ObservableList<Student> students = FXCollections.observableArrayList();
       try 
       {
           pst = con.prepareStatement("select id,name,mobile,course from registation");  
           ResultSet rs = pst.executeQuery();
      {
        while (rs.next())
        {
            Student st = new Student();
            st.setId(rs.getString("id"));
            st.setName(rs.getString("name"));
            st.setMobile(rs.getString("mobile"));
            st.setCourse(rs.getString("course"));
            students.add(st);
       }
    } 
                table.setItems(students);
                IDColmn.setCellValueFactory(f -> f.getValue().idProperty());
                NameColmn.setCellValueFactory(f -> f.getValue().nameProperty());
                MobileColmn.setCellValueFactory(f -> f.getValue().mobileProperty());
                CourseColmn.setCellValueFactory(f -> f.getValue().courseProperty());
                
               

       }
       
       catch (SQLException ex) 
       {
           Logger.getLogger(FXMLDocumentController.class.getName()).log(Level.SEVERE, null, ex);
       }

                table.setRowFactory( tv -> {
             TableRow<Student> myRow = new TableRow<>();
             myRow.setOnMouseClicked (event -> 
             {
                if (event.getClickCount() == 1 && (!myRow.isEmpty()))
                {
                    myIndex =  table.getSelectionModel().getSelectedIndex();
         
                   id = Integer.parseInt(String.valueOf(table.getItems().get(myIndex).getId()));
                   txtName.setText(table.getItems().get(myIndex).getName());
                   txtMobile.setText(table.getItems().get(myIndex).getMobile());
                            txtCourse.setText(table.getItems().get(myIndex).getCourse());
                           
                         
                           
                }
             });
                return myRow;
                   });
    
    
      }

    @FXML
    void Delete(ActionEvent event) {
        myIndex = table.getSelectionModel().getSelectedIndex();
         
        id = Integer.parseInt(String.valueOf(table.getItems().get(myIndex).getId()));
                     

        try 
        {
            pst = con.prepareStatement("delete from registation where id = ? ");
            pst.setInt(1, id);
            pst.executeUpdate();
            
            Alert alert = new Alert(Alert.AlertType.INFORMATION);
            alert.setTitle("Student Registationn");

        
        alert.setHeaderText("Student Registation");
        alert.setContentText("Deletedd!");

        alert.showAndWait();
                  table();
        } 
        catch (SQLException ex)
        {
            Logger.getLogger(FXMLDocumentController.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    @FXML
    void Update(ActionEvent event) {
       
        String stname,mobile,course;
        
         myIndex = table.getSelectionModel().getSelectedIndex();
         
        id = Integer.parseInt(String.valueOf(table.getItems().get(myIndex).getId()));
           
            stname = txtName.getText();
            mobile = txtMobile.getText();
            course = txtCourse.getText();
        try 
        {
            pst = con.prepareStatement("update registation set name = ?,mobile = ? ,course = ? where id = ? ");
            pst.setString(1, stname);
            pst.setString(2, mobile);
            pst.setString(3, course);
             pst.setInt(4, id);
            pst.executeUpdate();
            Alert alert = new Alert(Alert.AlertType.INFORMATION);
        alert.setTitle("Student Registationn");

        
        alert.setHeaderText("Student Registation");
        alert.setContentText("Updateddd!");

        alert.showAndWait();
                table();
        } 
        catch (SQLException ex)
        {
            Logger.getLogger(FXMLDocumentController.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    
    
    
    Connection con;
    PreparedStatement pst;
    int myIndex;
    int id;
    
    
    
     public void Connect()
    {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost/studcruds","root","");
        } catch (ClassNotFoundException ex) {
          
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
    

    
    @Override
    public void initialize(URL url, ResourceBundle rb) {
        Connect();
        table();
    }    
    
}

Student.java

package javafxcrudd;

import javafx.beans.property.SimpleStringProperty;
import javafx.beans.property.StringProperty;

/**
 *
 * @author kobinath
 */public class Student 
{
    private final StringProperty id;
    private final StringProperty name;
    private final StringProperty mobile;
    private final StringProperty  course;
     
    public Student()
    {
        id = new SimpleStringProperty(this, "id");
        name = new SimpleStringProperty(this, "name");
        mobile = new SimpleStringProperty(this, "mobile");
        course = new SimpleStringProperty(this, "course");
    }

    public StringProperty idProperty() { return id; }
    public String getId() { return id.get(); }
    public void setId(String newId) { id.set(newId); }

    public StringProperty nameProperty() { return name; }
    public String getName() { return name.get(); }
    public void setName(String newName) { name.set(newName); }

    public StringProperty mobileProperty() { return mobile; }
    public String getMobile() { return mobile.get(); }
    public void setMobile(String newMobile) { mobile.set(newMobile); }
    
    public StringProperty courseProperty() { return course; }
    public String getCourse() { return course.get(); }
    public void setCourse(String newCourse) { course.set(newCourse); }
}