Thursday, 3 June 2010

Write a jdbc program which will insert a record in the Student database?

Write a jdbc program which will insert a record in the Student database?
import java.sql.*;
class InsertRec {
 public static void main(String[] args) {
  try {
   Driver d = new             Sun.jdbc.odbc.JdbcOdbcDriver();
   DriverManager.registerDriver(d);
   System.out.println("DRIVERS LOADED...");
   Connection con =       DriverManager.getConnection("jdbc:odbc:oradsn", "scott", "tiger");
   System.out.println("CONNECTION ESTABLISHED...");
   Statement st = con.createStatement();
   int i = st.executeUpdate("insert into student values (10,'suman',60.87);");
   System.out.println(i + " ROWS SELECTED...");
   con.close();
  } catch (Exception e) {
   System.out.println("DRIVER CLASS NOT FOUND...");
  }
 }
}

No comments:

Post a Comment