Re: Column Labels - JSJ Frei - com.mysql.lists.java

3 messages in com.mysql.lists.javaRe: Column Labels

From	Sent On	Attachments
mike markovich	10 May 2002 14:08
JSJ Frei	10 May 2002 16:53
Jeff Kilbride	11 May 2002 13:21

Subject:	Re: Column Labels
From:	JSJ Frei (jsjf...@hotmail.com)
Date:	05/10/2002 04:53:19 PM
List:	com.mysql.lists.java

Hi Mike,

I think this is what you were referring to, try this:

ResultSetMetaData rsmd; if(!rs.wasNull()){ rsmd = rs.getMetaData(); int colCount = rsmd.getColumnCount(); for (int i = 0; i <= colCount; i++) { if (i > 0) { yourVariable[i] = rsmd.getColumnName(i); System.out.println("table column (" + i + "): " + yourVariable[i] + " / out of " + colCount + " columns!"); } }

Jennifer

----Original Message Follows---- From: "mike markovich" <mike...@amyskitchen.net> To: <ja...@lists.mysql.com> Subject: Column Labels Date: Fri, 10 May 2002 14:08:26 -0700

Hi All,

I am trying to figure out how to set the description or label for a = column. I already have a working Java program that creates a table using JDBC. I want to modify this program to so that it sets the column labels at the same time. Any suggestions will be appreciated.

Mike

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.