JDBC

/*

* JDBC: Java Database Connectivity

* In real word we are seeing that some login page or register page

* when a user register to any application that data store in the.

* ------------------------------------------------

* To make the connection between Java application and database we need jdbc.

* JDBC is a process to connect the java application to the database, its follows some steps for connection which are the following.

* --------------------------------

* 1.Load & register driver - Class.forName("com.mysql.cj.jdbc.Driver)

* 2.Create connection - Connection con = DriverManeger.getConnection("url(jdbc:mysql://localhost:3306/Database_name)","username","password")//

* 3.Create statement -PreparedStatement ps = con.prepareStatement("sql quiries")

* 4.Execute SQL statements - ps.executeQuery(); //Select query// ps.executeUpdate(); // insert, update, delete

* 5.Process the result - ps.close();

* 6.Close the connection - con.close();

*/

package JDBC;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

public class JdbcConnection {

public static void main(String[] args) throws Exception {

Class.forName("com.mysql.cj.jdbc.Driver");

System.out.println("Driver class loaded successfully");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/friends","root","root");

PreparedStatement ps = con.prepareStatement("insert into nilu'sfriend values('Anish',20,'Yes')");

int i = ps.executeUpdate();

if(i>0) {

System.out.println("Data is inserted successfully");

}

else {

System.out.println("Unsuccessfully");

}

con.close();

}

}