Monday, January 13, 2014

Java JDBC programming Example 15

//Note: create  a DSN in the name of sql that is pointing the table name limbs in the database with three String column  names things,legs,arms





//rs is not scrollable
import java.sql.*;
class Jdbc15{
public static void main(String...arg) throws Exception{
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         Connection c =  DriverManager.getConnection("jdbc:odbc:sql");
         Statement  st = c.createStatement();
         ResultSet r = st.executeQuery("select * from limbs");
 ResultSetMetaData rsmd = r.getMetaData();
        int noofcol=rsmd.getColumnCount();
        try{  
 
while(r.next()){
        for(int i =1;i<=noofcol-1;i++){

System.out.print(r.getString(i)+"    ");
}
                        
              System.out.println();
   
        }
        
         }catch(Exception e){System.out.println("Error :");e.printStackTrace();}
      r.close();
      st.close();
      c.close();
}

}

No comments: