Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Java
Expertise: Advanced
Dec 14, 2001

Determine the Number of Fields in a Record from the Result Set


This can be done by using ResultSetMetaData. For example, to get the number of columns you can use:
 
/* get the meta-information about the result set */
ResultSetMetaData metaData = rs.getMetaData(); // _
"rs" is of type
ResultSet

/* get the number of columns in the result set */
int numberOfColumns = metaData.getColumnCount();

/* now, print the column name and value */
for (int i = 1; i <= numberOfColumns; i++) {
   System.out.println("Column Name = " + _
metaData.getColumnName(i) + "
Value = " + rs.getString(i));
}
Navneet Gupta
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date