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

Java Database Connectivity with MySQL

In this tutorial, we will learn how to connect Database with MySQL in Java.

5 Steps to Connect to the Database in Java

  • Load the driver (or) Register the driver class
  • Establish a connection (or) Create a connection
  • Creating statement
  • Executing queries & obtain the result
  • Closing the connection

Register the Driver Class:

Software that contains classes and interfaces created using the JDBC API is referred to as a database driver.

Given the variety of drivers on the market, we need first to specify the driver that will be used in a Java programme to communicate with the database server.

The driver class is registered using the forName() function of the Class. The driver class is dynamically loaded using this technique.            


public static void forName(String className)throws ClassNotFoundException



In order to connect to the database, a programmer must identify the database driver he will be using. There are four ways to register a driver.

  • The driver can be registered by creating an object that belongs to the driver class of the driver programme. for instance
com.mysql.jdbc.Driver obj = new com.mysql.jdbc.Driver ();
  • The driver class object should be sent to the second method of registering a driver. The DriverManager class's registerDriver() function. As an illustration,
DriverManager.registerDriver ( new com.mysql.jdbc.Driver () );
  • The third way to register the driver is to send the driver class name directly to forName() method,as:

Create the Connection Object

To connect to the database, utilise the getConnection() function of the DriverManager class.


1) public static Connection getConnection(String URL)throws SQLException

2) public static Connection getConnection(String URL, String name, String password)
throws SQLException



Three items are necessary to connect to a database:

  • URL: The database's URL is a protocol to connect to the database is represented by the URL (Uniform Resource Locator). In a nutshell, it finds the database on the network.
  • Username: Each user will be granted a username to connect to a database, which is typically assigned by the database administrator.
  • Password: This is the password that the database administrator assigned to the user to log in to the database.

Create the Statement Object:

Statements are created using the Connection interface's createStatement() function. Executing database queries is the responsibility of the object of the statement.


public Statement createStatement() throws SQLException

Once created, the connection is used to transmit SQL commands to the database.

For transmitting SQL statements to databases, the java.sql package provides three interfaces:

Specifically, the Statement interface and its two sub-interfaces, PreparedStatement and CallableStatement.

The objects of these three sentences are returned by three methods of the Connection object.

When sending a SQL statement to the database without any arguments, a Statement object is utilised. By utilising the Connection Object's createStatement(String query) method, its instances are returned.

Statement object Example:

Statement stmt=con.createStatement();

PreparedStatement object:

Precompiled statements can be sent to databases with or without IN arguments using a PreparedStatement object. The insert SQL command is typically used to add rows of data to databases.

An insert SQL statement is created and submitted to the database for each insertion. The identical expression is constructed n times if there are n rows that need to be added. It takes up a lot of time. Because of this, we employ PreparedStatement which has already been precompiled. Only the values that need to be added in this situation are sent repeatedly to the database.


PreparedStatement ps=con.prepareStatement(String query);

CallableStatement Object:

A CallableStatement object is used to invoke functions and stored procedures running on a database server and deliver the results to the client.

A stored procedure is a collection of statements that are saved, executed, and provided to the client by a database server.


CallableStatement cs=con.prepareCall(String query);

Execute the Query

The Statement interface's executeQuery() function is used to run database queries.

The object of ResultSet that can be used to get all of a table's records is returned by this method. The results (rows) of running a SQL command on a database are contained in an object called a "ResultSet."


public ResultSet executeQuery(String sql)throws SQLException


ResultSet rs=stmt.executeQuery("select * from emp");
    System.out.println(rs.getInt(1)+" "+rs.getString(2));

Close the Connection Object:

The Connection interface's close() function is used to terminate the connection. Statement and ResultSet will be closed automatically by closing the connection object. 


public void close()throws SQLException




import java.sql.*;
public class DBC {
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost/emp";
static final String USER = "root";
static final String PASS = "root";
public static void main(String[] args) 
Connection c = null;
Statement s = null;
//STEP 2: Register JDBC driver 
//STEP 3: Establish a connection
System.out.println("Connecting to database...");
conn = DriverManager.getConnection(DB_URL,"root","");
//STEP 4: Creating a Statement
System.out.println("Creating statement...");
s = c.createStatement();
String sql;
sql = "SELECT id,name, age FROM Students";
ResultSet rs = s.executeQuery(sql);
//STEP 5: Executing Queries
//Retrieve by column name
int id = rs.getInt("id");
int age = rs.getInt("age");
String first = rs.getString("Name");
//Display values
System.out.print("ID: " + id);
System.out.print(", Age: " + age);
System.out.print(", Name: " + name);
//STEP 6: Closing the Connection
}catch(SQLException se){
//Exception Handling for JDBC
}catch(Exception e){
//Exception Handling for Class.forName
System.out.println("THE END");
}//finally block
}//end main