Update records from database using JDBC

In this Code Snippets we will know how to update records from database using JDBC (Java Database Connectivity) in console window.

Here we use Type-1 driver (JDBC-ODBC bridge)

Creation of dsn(database source name) for Oracle 
 
Start-Control panel- Administrative Tools- Data Sources (ODBC)-go to system dsn tab-click add button-select a driver for which you want to set up data source (for Oracle- Oracle in XE)-select it and click finish-give any name in data source name textbox-then click ok button.

Note:  - Here Username=system, Password=pintu and Dsn name=dsn1

Table Creation 
Create table employee (empno int,empname varchar(50),sal int)

Example:- To update record in a table 

/*To update record in a table by using Statement*/
import java.sql.*;
import java.util.*;
public class update
{
public static void main(String args[]) throws Exception
{
Scanner sc=new Scanner(System.in);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:dsn1","system","pintu");
Statement stmt=con.createStatement();
System.out.print("Enter the Employee number: ");
int x=sc.nextInt();
System.out.print("Enter the new salary : ");
int z=sc.nextInt();
System.out.print("Enter the Employee name: ");
String y=sc.next();
String sql="update employee set sal="+z+",empname='"+y+"' where empno="+x;
int no=stmt.executeUpdate(sql);
if(no>0)
System.out.println(no+" Records Successfully Updated");
else
System.out.println("Invalid employee number");
con.close();
}
}

Compile 
Javac update.java
Java update