Monday, January 13, 2014

Java JDBC programming Example 1

//Note: create  a DSN in the name of sql that is pointing the table name limbs in the database with three String fields



//scrollable,sensitive concurent updatable record set
//records will be printed in reverse order
import java.sql.*;
import java.net.*;
class Jdbc1{
public static void main(String...arg) throws Exception{
System.out.println(InetAddress.getLocalHost());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c =  DriverManager.getConnection("jdbc:odbc:sql");
Statement  st =  c.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
  ResultSet.CONCUR_UPDATABLE);
 ResultSet r = st.executeQuery("select * from limbs");
 try{
r.afterLast();  //working only with scrollable rs
while(r.previous()){
                System.out.print(r.getString(1)+" ");
             System.out.print(r.getString(2)+" ");
              System.out.println(r.getString(3));
  }
     
 }catch(Exception e)                          {System.out.println("Hello");e.printStackTrace();}
      r.close();
      st.close();
      c.close();
}
}

No comments: