import java.sql.*;
import java.io.*;
class UpdateTest
{
public static void main(String a[])throws Exception
{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
System.out.println("Enter the student name to update the record:");
String name=br.readLine();
System.out.println("Enter the course:");
String course=br.readLine();
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","krishna");
// Statement st=con.createStatement();
// int result=st.executeUpdate("update Student124 set name='"+name+"' where course='"+course+"'");
PreparedStatement st = con.prepareStatement("update xyz2 set name=? where course=?");
st.setString(1, name);
st.setString(2, course);
if(!st.execute())
{
System.out.println("Record was successfully updated");
}
else
{
System.out.println("Failure!");
}
}
}
0 Comments