TAKE & PUT VALUES INTO AN ORACLE TABLE THRU A LOOP
I'm a beginner in java. I've got a small problem for which i would like to have your expert opinions.
I've an Oracle table which has 65 fields. Apart from the first field which is of date type, rest of all the fields are number type.
Instead of coding 65 "RecordSet.getInt" lines, is there a way to do it through a for loop ?
Thanks in advance.
Re: TAKE & PUT VALUES INTO AN ORACLE TABLE THRU A LOOP
Fixed that for you
I've an Oracle table which has 65 columns
RecordSet? Yes, instead of using Microsoft products you could use Java. The ResultSet class:
Instead of coding 65 "RecordSet.getInt" lines
java resultset - Google Search
ResultSet (Java Platform SE 6)
Has methods which allow you to access column values by column index. Additionally, you can obtain a ResultSetMetaData object on your ResultSet so you can also obtain column names and types.