Java Tutorial

Java Tutorial Java Features C++ vs Java Java History Java Hello World Java Development Kit Java Runtime Environment Java Virtual Machine Difference between JDK, JRE, and JVM Memory Areas in Java Java Operators Java Keywords Primitive Data Types Variables

Java Loops

Java Do While Loop Java While Loop Java For Loop Java Enhanced For Loop

Java Programs

Java Basic Programs Factorial Program in Java Fibonacci Series Program in Java Prime Number Program in Java Palindrome Number Program in Java Armstrong Number Program in Java Anagram Program in Java Pattern Programs in Java Calculator Program in Java Leap Year Program in Java Addition Program in Java Number Pattern Programs in Java Star Pattern Programs in Java Package Program in Java Pyramid Program in Java Sorting Program in Java String Palindrome Program in Java Even Odd Program in Java For Loop Program in Java If Else Program in Java Switch Case Program in Java GCD Program in Java LCM Program in Java Hello Program in Java Matrix Program in Java Menu Driven Program in Java Series Program in Java Client Server Program in Java Swapping Program in Java Pig Latin Program in Java Tower of Hanoi Program in Java Recursion Program in Java Matrix Multiplication Program in Java Perfect Number Program in Java Classes and Objects in Java Example Programs String Programs in Java Array Programs in Java Constructor Program in Java Inheritance Program in Java Abstract class Program in Java Interface Program in Java Encapsulation Program in Java Polymorphism Program in Java Exception Handling Program in Java Multithreading Program in Java Thread Program in Java Collection Programs in Java ArrayList Program in Java Stack Program in Java Applet Program in Java Swing Program in Java JDBC Program in Java How to run Java program in command prompt How to run Java program in Eclipse Program to find and replace characters on string in java Program to find the duplicate characters in a string Program to check whether a given character is present in a string or not Java Program to Print Permutations of String Java program to find frequency of characters in a string Java Program to remove duplicate characters in a string

Java Sorting

Sorting Algorithms in Java Merge Sort in Java Quick Sort in Java Bubble Sort in Java Insertion Sort in Java Selection Sort in Java Heap Sort in Java Radix Sort in Java Topological Sort in Java Bucket Sort in Java Counting Sort in Java

Java OOPs Concepts

OOPs - Object Oriented Programming Objects and Classes in Java Methods in Java Java Naming Conventions Constructors in Java Java this keyword Java static keyword Inheritance in Java Aggregation in Java Java super keyword Constructor Chaining and Constructor Overloading Java Polymorphism Static and Dynamic Binding in Java Java Abstraction Abstract class in Java Interface in Java Difference between Abstract class and Interface Java final keyword Packages in Java Access Modifiers in Java Java Wrapper classes Java Numbers Java Characters Java Integer Java Boolean Java Arrays Java Command Line Arguments Java strictfp Keyword Java Math

Java Strings

Java Strings Java String Methods StringBuilder in Java StringBuffer in Java Java Regular Expressions StringBuffer vs StringBuilder String vs StringBuffer String vs StringBuilder String Manipulation in Java Java String Concatenation How to Reverse a String in Java String Array in Java How to Compare Two Strings in Java How to Concatenate Two Strings in Java Why String in Immutable in Java Java.lang.NumberFormatException for Input String String Pool in Java Java Generate Random String How to take String Input in Java Java String Interview Questions

Java Exceptions

Exception Handling in Java Java try catch Java throw Java throws Difference between throw and throws Java finally Java Custom Exception Java Exception Propagation

Garbage Collection

Automatic Resource Management in Java Java Garbage Collection Java finalize() Java gc() Difference between final, finally and finalize


Multithreading in Java Process and Thread in Java Basic Terms in Multithreading Java Thread creation Thread Scheduler in Java Java Thread class DeadLock in Java

Java IO

Java IO Java Read File Java file Reader Java Buffer Reader Java file Writer Java BufferedWriter Java InputStreamReader Scanner in Java Java StringReader Java StringReader Class Java PrintWriter Java File Java Read File Line By Line Java FileInputStream Java FileOutputStream Java Create File Java Delete File Java Open File Java Read File to String Java copy file Java Read JSON file Jar File in Java Java FileNotFoundException


Java Serialization Java transient


Java Network Programming Java Socket Programming Java URL Java URLConnection HttpURLConnection in Java Java InetAddress Java DatagramSocket and Java DatagramPacket


Java AWT


Swing in Java

Java Collections

Collections in Java Java List Interface ArrayList in Java LinkedList in Java Vector in Java Stack in Java ArrayList vs LinkedList in Java ArrayList vs Vector in Java Java Set Interface HashSet in Java LinkedHashSet in Java TreeSet in Java Java Queue Interface PriorityQueue in Java ArrayDeque in Java Java Map Interface HashMap in Java LinkedHashMap in Java TreeMap in Java Dictionary in Java Hashtable in Java Properties in Java Collections class in Java Java Comparable Java Comparator Comparable vs Comparator in Java

Java Generics

Generics in Java

Java Annotations

Annotations in Java


Java JDBC Tutorial JDBC Architecture Types of JDBC Drivers JDBC vs ODBC Java Database Connectivity with MySQL Statements in java Prepared statement in Java Resultset in java Java ResultSetMetaData DatabaseMetaData in Java Callable Statement in Java Transaction Management in java

Java Differences

Java vs JavaScript Python vs Java Kotlin vs Java Java vs C++ C# vs Java Static vs Non-static in Java C vs Java int vs Integer in Java Stack vs Heap in Java Java Array vs ArrayList

How to

How to run Java program How to set path in Java How to check the Java version in cmd How to install Java in Windows 10 How to run Java program in cmd How to add double quotes in a string in Java How to convert list to String in Java How to call a method in Java How to sort an array in Java How to iterate HashMap in Java How to write Java program How to create an array in Java How to create a package in Java How to generate random numbers in Java How to input String in Java How to create thread in Java How to find length of String in Java How to sort a string in Java How to use scanner in Java How to achieve multiple inheritance in Java How to find the length of an Array in Java How to run Java program in Eclipse How to call a function in Java How to create array of objects in Java How to create custom exception in Java How to import packages in Java How to run applet Program in Java How to take Array Input in Java How to achieve abstraction in Java How to call static method in Java How to compare characters in Java How to initialize string array in Java How to Install Java on MAC How to run java program in ubuntu How to find characters with the maximum number of times in a string java How to Set Java_home in Linux How to Split the String in Java with Delimiter How to Split String by Comma in Java How to remove special characters from String in Java How to remove last character from String in Java

Java 8 Features

Java 8 Features Lambda Expressions in Java Functional Interface in Java Streams in Java Java Base64 Encoding and Decoding Parallel Arrays Sort in Java

Java 9 Features

Java 9 Tutorial Java 9 Try With Resources Java 9 Interface Private Method

Java Servlet Tutorial

Java Servlets Tutorial

Java JSP Tutorial

Java JSP Tutorial

Hibernate Tutorial

Hibernate Tutorial

Spring Tutorial

Spring Tutorial

Spring MVC Tutorial

Spring MVC Tutorial

Jenkins Tutorial

Jenkins Tutorial

Java Math Methods

Math.abs() Math.acos() Math.addExact() Math.asin() Math.atan () Math.atan2() Math.cbrt() Math.ceil() Math.copysign() Math.cos() Math.cosh() Math.decrementExact() Math.exp() Math.expm1() Math.floor() Math.floorDiv() Math.floorMod() Math.getExponent() Math.hypot() Math.IEEEremainder() Math.incrementExact() Math.log() Math.log10() Math.log1p() Math.max() Math.min() Math.multiplyExact() Math.multiplyFull() Math.negateExact() Math.nextAfter() Math.nextDown() Math.nextUp() Math.pow() Math.random() Math.rint() Math.round() Math.scalb() Math.signum() Math.sin() Math.sinh() Math.sqrt() Math.subtractExact() Math.tan() Math.tanh() Math.toDegrees() Math.toIntExact() Math.toRadians() Math.ulp()

Java String Methods

toCharArray() copyValueOf() endsWith() equals() equalsIgnoreCase() format() getBytes() getChars() hashCode() indexOf() intern() isEmpty() join() lastIndexOf() length() replace() replaceAll() replaceFirst() split() startsWith() subSequence() substring() toLowerCase() toUpperCase() trim() valueOf()

Java Conversion

Java Convert String to int Java Convert int to String Java Convert String to long Java Convert long to String Java Convert String to float Java Convert float to String Java Convert String to double Java Convert double to String Java Convert String to Date Java Convert Date to String Java Convert String to Object Java Convert Object to String Java Convert String to char Java Convert char to String Java Convert int to long Java Convert long to int


Functional Interfaces in Java Singleton class in Java Awesome explanation of Strings in Java Object class in Java Static class in Java All the important string methods in Java String Handling Method in Java What are Array strings in Java Advantages and Disadvantages of Strings in Java Big Decimal class in Java Class definition in Java Char and String differences in Java Difference between String, StringBuffer and StringBuilder in java Replace character in string Java String Coding Interview Questions in Java What is String in Java? String isnullorempty in Java String Matches in Java Trim Method in String Java Bean class in Java Libraries in Java Arithmetic Operations on String in Java Convert Char array to string in java Check whether Java is installed or not How to calculate time difference in Java How to stop execution after a certain time in Java Jagged Array in Java Java ArraylistRemove() Time Complexity Java Swing Time Picker Zigzag Array in Java Array and String based questions in Java Array and String with Examples in Java Best Practices to use String Class in Java What is string in Java why it's immutable Java String Java String Inbuilt functions Java String Matches vs Contains Sum of digits in string in java Check the presence of Substring in a String in java Java import packages Interfaces and Classes in Strings in Java Maximum length of string in java Hidden classes in Java Class memory in Java public static void main string args meaning in java Reverse a String in Java String Concatenation in Java Difference between String and Char Array in Java Buffer reader to read string in Java

Transaction Management in java

Definition: A database application is an application that is running against a relational database and executes one or more transactions.

A transaction is an executing program that contains some database operations, like reading or applying insertions, deletions, or updates to the database.

Transaction example:

package com.STH.JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Savepoint;
import java.sql.Statement;
public class Transaction_Management {
public static void main(String[] args) throws ClassNotFoundException {
//Select the Query to get the Data from employee table
String QUERY = "select * from employee where empNum = 1";
String QUERY1 = "select * from employee where empNum = 2";
Boolean autoCommit;
String update_query = "update employee set salary = 40000 where empNum = 1"; 
String update_query1 = "update employee set salary = 50000 where empNum = 2"; 
//Update the query to set the dept id for the employee whose empNUM is 3
try(Connection conn = DriverManager.getConnection("jdbc:oracle:thin:system/[email protected]:1521:XE"))
Statement statemnt1 = conn.createStatement();
ResultSet rs1 =null;
rs1 = statemnt1.executeQuery(QUERY); 
//Executed the SELECT Query
System.out.println("Getting the data from employee_details table");
System.out.println("Setting the AutoCommit value as FALSE");
autoCommit = conn.getAutoCommit();
System.out.println("AutoCommit value of the Connection = "+ autoCommit);
statemnt1 = conn.createStatement();
System.out.println("Executing Update query to update salary of EMPNUM = 1");
System.out.println("Update Query is " + update_query);
int return_rows = statemnt1.executeUpdate(update_query);
System.out.println("Update the data but didn't commit");
Connection conn1 = DriverManager.getConnection("jdbc:oracle:thin:system/[email protected]:1521:XE");
System.out.println("Opening new connection");
System.out.println("EMPNUM = 1 data");
Statement statement2 = conn1.createStatement();
ResultSet rs;
rs = statement2.executeQuery(QUERY); 
System.out.println("Commit has been done");
Savepoint s1 = conn.setSavepoint();
System.out.println("SavePoint has been created");
System.out.println("Displaying data of EMPNUM = 1");
System.out.println("Using the Second Connection");
rs = statement2.executeQuery(QUERY); 
rs = statemnt1.executeQuery(QUERY); 
//Rollback the transaction
System.out.println("Data of EMPNUM = 2");
rs1 = statemnt1.executeQuery(QUERY1); 
System.out.println("Updating the salary of EMPNUM = 2");
System.out.println("Update Query is " + update_query1);
System.out.println("Data of EMPNUM = 2 but didn't commit");
rs1 = statemnt1.executeQuery(QUERY1); 
System.out.println("Rollback is done... so updated data won't be reflected");
System.out.println("Data of EMPNUM = 2 after Rollback till the last savepoint");
rs1 = statemnt1.executeQuery(QUERY1); 
catch (SQLException e) {
public static void displayData(ResultSet rs1) throws SQLException
int empNum = rs1.getInt("empNum");
String lastName = rs1.getString("lastName");
String firstName = rs1.getString("firstName");
String email = rs1.getString("dept");
String deptNum = rs1.getString("deptNum");
String salary = rs1.getString("salary");
System.out.println(empNum + "," +lastName+ "," +firstName+ "," +dept +","+deptNum +"," +salary);

Acid Properties of Transactions:

  1. Atomicity: If every program works correctly without any errors, then everything gets committed to the database. If any of the parts of the execution of the transaction gets rolled back, then it will not commit.
  2. Consistency: The consistency property is a property that if any database was in a consistent state before and after the execution of a transaction, the database will also be in a consistent state.
  3. Isolation: In this property, multiple transactions will execute concurrently, the system says that for every pair of transactions. It will execute one after the other pair.
  4. Durability: Durability ensures that, once a transaction has been committed even if there is a system failure or crash, the transaction’s update does not lose.

Transaction methods:

void setAutoCommit(boolean status)In this method, It is true by default means each transaction is committed by default.
void commit()It is used to commit the transaction.
void rollback()It is used to cancel the transaction.

Transaction management in JDBC using statement:

import java.sql.*; 
class Records{ 
public static void main(String args[])throws Exception{ 
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","oracle"); 
Statement stmt=con.createStatement(); 
stmt.executeUpdate("insert into user420 values(1,'hari',40000)"); 
stmt.executeUpdate("insert into user420 values(2,'Raju',50000)"); 

Transaction management in JDBC using preparedStatement:

import java.sql.*; 
class TM{ 
public static void main(String args[]){ 
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","oracle"); 
PreparedStatement ps=con.prepareStatement("insert into user 420 values(?,?,?)"); 
BufferedReader br=new BufferedReader(new InputStreamReader(; 
System.out.println("enter id"); 
String s1=br.readLine(); 
int id=Integer.parseInt(s1); 
System.out.println("enter name"); 
String name=br.readLine(); 
System.out.println("enter salary"); 
String s3=br.readLine(); 
int salary=Integer.parseInt(s3); 
String answer=br.readLine(); 
System.out.println("Want to add more records y/n"); 
String ans=br.readLine(); 
System.out.println("record successfully saved"); 
con.close();//before closing connection commit() is called 
}catch(Exception e){System.out.println(e);}