Java

Transaction using java mysql

The transaction is a set of Sql statement that can be executed  as a single unit.the transaction is complete only when all the sql statements in a transaction excute successfully.if any one of the sql statement in the transaction fails the entire transaction is rolled back.

paste the code inside the main method

import java.sql.*;

public class Transaction 
{
 public static void main(String args[])
 {
  Connection con;
  PreparedStatement ps1;
   try {
   Class.forName("com.mysql.jdbc.Driver");
   con = DriverManager.getConnection("jdbc:mysql://localhost/vmproducts","root","");
    
    con.setAutoCommit(false);
    
    ps1 = con.prepareStatement("insert into product(pname,price,qty)values(?,?,?)");
    ps1.setString(1,"Mouse");
    ps1.setInt(2,15000);
    ps1.setInt(3,100);
    int first = ps1.executeUpdate();
    System.out.println("First Row Inserted but not commited");
    
    ps1 = con.prepareStatement("insert into product(pname,price,qty)values(?,?,?)");
    ps1.setString(1,"Keyborad");
    ps1.setInt(2,5000);
    ps1.setInt(3,500);
    int second = ps1.executeUpdate();
    System.out.println("Second Row Inserted but not commited");
    
    ps1 = con.prepareStatement("insert into product(pname,price,qty)values(?,?,?)");
    ps1.setString(1,"Printer");
    ps1.setInt(2,10000);
    ps1.setInt(3,100);
    int third = ps1.executeUpdate();
    System.out.println("Third Row Inserted but not commited");
    
    
    /*Commit a trasaction */    
    con.commit();
    System.out.println("Transaction Commitedddddd");  
  } catch (ClassNotFoundException | SQLException e)
                {
   
   e.printStackTrace();
  }
  
  
 }

}

I have attached the video tutorial below it will help you  to do this  step by step.

 

admin

Recent Posts

Employee Working Hours Calculation System using C#.net

Initialize the employee number, Hourswork,and Hoursrate to calculate a grosswage use the following condition. if…

1 week ago

Java Payroll System Calculate Employee Overtime

Act as a Java developer to create a program that calculates the gross wage for…

2 weeks ago

Employee Working Hours Calculation System using Java

Initialize the employee number, Hourswork,and Hoursrate to calculate a grosswage use the following condition. if…

2 weeks ago

Laravel 11 School Management System

In this tutorial, we will teach you how to create a simple school management system…

2 weeks ago

How to Make Admin Panel Using React MUI

I have design the Admin Basic templete using React MUI Design Admin Dashboard and Login.Here…

4 weeks ago

Install Laravel Breeze for Authentication Using Laravel 11

In this tutorial ,i am to going teach the Laravel Breeze.Laravel Breeze provides a simple…

1 month ago