Java

Java JDBC Record Insertion into Mysql database

In this tutorial will teach jdbc record insertion into mysql database step by step.

First Step

Establish the database Connection

Connection con;
    PreparedStatement pst;

     public void Connect()
    {
        try {
            Class.forName("com.mysql.jdbc.Driver"); //Register the mysql driver
            con = DriverManager.getConnection("jdbc:mysql://localhost/phonebook","root","");
        } catch (ClassNotFoundException ex) {
           ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

Put the code inside the Save Button

try 
       {
            String friendname,phone,place;
            friendname = txtFname.getText();
            phone = txtphone.getText();
            place = txtplace.getText();
            pst = con.prepareStatement("insert into records(fname,phone,place)values(?,?,?)");
            pst.setString(1,friendname);
            pst.setString(2,phone);
            pst.setString(3,place);
            int status =  pst.executeUpdate();
            
            if(status==1)
            {
              JOptionPane.showMessageDialog(this, "Record Saved");  
                txtFname.setText("");
                txtphone.setText("");
                txtplace.setText("");
                txtFname.requestFocus();
            }
            else
            {
                 JOptionPane.showMessageDialog(this, "Record Failed");  
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }

 

i have attached the video link below. which will do this tutorials step by step.

 

admin

Share
Published by
admin

Recent Posts

Conditional Statements in Python

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

3 weeks ago

Java Beans

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

4 weeks ago

Java String Methods

Java provides a rich set of built-in methods for handling String operations efficiently. Since strings…

4 weeks ago

Java Developer Jobs

Java remains one of the most in-demand programming languages worldwide, powering everything from enterprise applications…

4 weeks ago

Converting Integer to String in Java

Java provides multiple ways to convert an integer (int) to a string (String). Whether you're…

4 weeks ago

JSP to JSP Communication: A Complete Guide to Dynamic Java Web Development

Java Server Pages (JSP) is a powerful technology used to develop dynamic web applications by…

1 month ago