Home Java Java GUI CRUD for Beginners

Java GUI CRUD for Beginners

3 min read
0
0
146

Introduction to Java GUI CRUD

Java is a powerful programming language widely used for building desktop applications. One fundamental aspect of many applications is the ability to manage data through Create, Read, Update, and Delete (CRUD) operations. In this tutorial, we will walk through creating a simple Java GUI application that performs basic CRUD operations, making it suitable for beginners.

First Step import the Sql namespace at the top : import java.sql.*;

After that implement the sql class 

Connection con;
PreparedStatement pst;
ResultSet rs;    
DefaultTableModel df;

After that use the connect method connet the databases

public void connect()
   {
  
       try {
           //Register the driver
           Class.forName("com.mysql.cj.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql:/phonebook","root","");
            System.out.println("Connected");
       } catch (ClassNotFoundException ex) {
           Logger.getLogger(Phone.class.getName()).log(Level.SEVERE, null, ex);
       } catch (SQLException ex) {
           Logger.getLogger(Phone.class.getName()).log(Level.SEVERE, null, ex);
       }
   }

Paste the code into the Save Button

String name,address;
int phone;

name = txtName.getText();
address = txtAddress.getText();
phone = Integer.parseInt(txtPhone.getText());


try {
    //query
    pst = con.prepareStatement("insert into contact(name,address,phone) values(?,?,?)");
     pst.setString(1, name);
     pst.setString(2, address);
     pst.setInt(3, phone);
     pst.executeUpdate();
     JOptionPane.showMessageDialog(null, "Record Saveddd!!!!!!");
     Phonetable();
     
} catch (SQLException ex) {
    Logger.getLogger(Phone.class.getName()).log(Level.SEVERE, null, ex);
}

Load the Table

public void Phonetable() 
   {
       try {
           pst = con.prepareStatement("SELECT * FROM contact");
           rs = pst.executeQuery();
           
           //pass into the respective table 
           df = (DefaultTableModel) tblbook.getModel();
           df.setRowCount(0);

            //contribute the table columns
            while (rs.next()) {
           df.addRow(new Object[]{
            
               rs.getString("name"),
               rs.getString("address"),
               rs.getInt("phone")
           });
       }   
       } catch (SQLException ex) {
           Logger.getLogger(Phone.class.getName()).log(Level.SEVERE, null, ex);
       }
       
   }

I attached the video below How to make this System

 

Load More Related Articles
  • Conditional Statements in Python

    Conditional statements in Python allow us to control the flow of execution based on condit…
  • Java Beans

    A Java Bean is a reusable software component that follows a specific set of conventions. J…
  • Java String Methods

    Java provides a rich set of built-in methods for handling String operations efficiently. S…
Load More By admin
  • Java Beans

    A Java Bean is a reusable software component that follows a specific set of conventions. J…
  • Java String Methods

    Java provides a rich set of built-in methods for handling String operations efficiently. S…
  • Java Developer Jobs

    Java remains one of the most in-demand programming languages worldwide, powering everythin…
Load More In Java

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Conditional Statements in Python

Conditional statements in Python allow us to control the flow of execution based on condit…