PROGRAM TO UPDATE RECORD USING PREPAREDSTATEMENT

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.util.Scanner;

public class Test11 {

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");

PreparedStatement ps = con.prepareStatement("update student_register set name=? where id = ?");

Scanner sc = new Scanner(System.in);

String ans="yes";

while(ans.equals("yes"))

{

System.out.println("Enter id");

int id=sc.nextInt();

System.out.println("Enter new name");

String name=sc.next();

ps.setString(1, name);

ps.setInt(2, id);

int c = ps.executeUpdate();

if(c==1)

System.out.println("Updated successfully");

System.out.println("Do you want to update more records");

ans=sc.next();

}

}

}

Output -

Enter id

3

Enter new name

runjun

Updated successfully

Do you want to update more records

no