PROGRAM TO UPDATE RECORD USING STATEMENT

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
public class Test7 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "rakesh");
Statement st = con.createStatement();
Scanner scan = new Scanner(System.in);
System.out.println("Enter Student Id :");
int id = scan.nextInt();
System.out.println("Enter Student name :");
String name = scan.next();
System.out.println("Enter course :");
String course = scan.next();
String cmd = "update student_register set name='"+name+"',course='"+course+"'where id ="+id;
int count = st.executeUpdate(cmd);
System.out.println(count+" rows updated");
scan.close();
}
}

Output -

Enter Student Id :

3

Enter Student name :

anjan

Enter course :

mca

1 rows updated