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(); } } }
Introduction to JSP AJAX CRUD Applications Building web applications has become more dynamic with the…
Relationships: Hotel ↔ Rooms (One-to-Many) A hotel can have many rooms, but a room belongs…
Introduction to Grocery Inventory Apps Managing grocery inventory can be a daunting task, but with…
This article explain how to make a Fish Inventory Management App in Angular.this app explain…
Introduction to Fish Inventory Management In the aquaculture industry, managing fish inventory is crucial for…
Introduction to Java GUI CRUD Java is a powerful programming language widely used for building…