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

Popular posts from this blog

node.js - Using Node without global install -

How to access a php class file from PHPFox framework into javascript code written in simple HTML file? -

java - Null response to php query in android, even though php works properly -