A Java MySQL INSERT example (using Prepared Statement)

 

Create simple MYSQL Database table:

CREATE TABLE products (
   ID INT ,
   pname varchar(200),
   Price int,
   Quantity int,
   Retail_price int,
   PRIMARY KEY (Id)
);

Why use prepared Statement?

We use prepared statement because query is compiled once so it can improved performance of application.

Libraries:

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

Steps to Insert values in Database:

Get values from text fields

  int id= Integer.parseInt(txt_id.getText());
  String productname=txt_name.getText();
  int price =Integer.parseInt(txt_price.getText());
  int quantity=Integer.parseInt(txt_quantity.getText());

    

In try block create MYSQL connection

 Connection co = DriverManager.getConnection("jdbc:mysql://localhost:3306/store_managment_system","root", "root");
     

Create MySQL query and  Prepared Statement

 PreparedStatement pt =co.prepareStatement("insert into products values(?,?,?,?,?)");
     

Insert values in database using prepared statement

      pt.setInt(1, id);
      pt.setString(2, productname);
      pt.setInt(3,price);
      pt.setInt(4,  quantity);

Execute update to insert values

pt.executeUpdate();

Java MySQL  Insert Example

public String insertproduct()
{
  String status=" ";
  int id= Integer.parseInt(txt_id.getText());
  String productname=txt_name.getText();
  int price =Integer.parseInt(txt_price.getText());
  int quantity=Integer.parseInt(txt_quantity.getText());
  try{
      Connection co = DriverManager.getConnection("jdbc:mysql://localhost:3306/store_managment_system","root", "root");
      PreparedStatement pt =co.prepareStatement("insert into products values(?,?,?,?,?)");
      pt.setInt(1, id);
      pt.setString(2, productname);
      pt.setInt(3,price);
      pt.setInt(4,  quantity);
      int rowcount = pt.executeUpdate();
      if(rowcount == 1){
         status = "sucess";
         }
      else{
            status = "failed";
      }
                    
     }
     catch(SQLException e){
     }
     return status;
         }

Call Behind Add Button

 String status = insertproduct();
 if(status.equals("sucess")){
  JOptionPane.showMessageDialog(this,"Product Inserted Successfull");}
    }