java - i got error like' Invalid descriptor index' while working with ResultSetMetadata -
package com.nt; import java.sql.connection; import java.sql.drivermanager; import java.sql.resultset; import java.sql.resultsetmetadata; import java.sql.statement; import java.util.*; import java.io.*; public class dbresult { public static void main(string[] args)throws exception { //genaral setting try{ class.forname("sun.jdbc.odbc.jdbcodbcdriver"); connection con=drivermanager.getconnection("jdbc:odbc:oradsn","username","pass"); statement st=con.createstatement(); resultset rs=st.executequery("select snum,sname,sadd student"); //here resultset resultsetmetadata rm=rs.getmetadata(); //get column count int cnt=rm.getcolumncount(); //prints col name for(int i=0;i<=cnt;++i) { system.out.println(rm.getcolumnlabel(i)+"\t\t\t"); }//for system.out.println(); //code prints column value //system.out.println(rm.getcolumndisplaysize(i)); while(rs.next()) { for(int i=0;i<cnt;++i) { system.out.println(rs.getstring(i)+"\t\t\t"); }//for system.out.println(); }//while //close jdbc conn rs.close(); st.close(); con.close(); //class } catch (classnotfoundexception e) { e.printstacktrace(); } } }
resultset table index starting 1 not 0 change both for loops this
for(int i=1;i<=cnt;++i) { .... }
Comments
Post a Comment