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(); } } }
Initialize the employee number, Hourswork,and Hoursrate to calculate a grosswage use the following condition. if…
Act as a Java developer to create a program that calculates the gross wage for…
Initialize the employee number, Hourswork,and Hoursrate to calculate a grosswage use the following condition. if…
In this tutorial, we will teach you how to create a simple school management system…
I have design the Admin Basic templete using React MUI Design Admin Dashboard and Login.Here…
In this tutorial ,i am to going teach the Laravel Breeze.Laravel Breeze provides a simple…