Update data from java into data base



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