Update records from database using JDBC

In this blog 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

 

Ebook Download
View all
Learn
View all