| Author |
Question on resultset.getString(3)
|
Alvin chew
Ranch Hand
Joined: Jan 08, 2004
Posts: 834
|
|
hi, have a nice day, everyone, i understand the parameter for getString() method is columnindex , can someone tell me how to i determine the parameter is belongs to ?
in mycase , i have try on resultset.getString(3); which give me the tablename , is it the "3" belongs to tablename ?
thank you !
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26192
|
|
Alvin,
Three refers to the third column. It is good to make the column list explicity so that you aren't suprised by what it refers to. For example,
select col1, col2, col3 from table
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
Sonny Gill
Ranch Hand
Joined: Feb 02, 2002
Posts: 1211
|
|
Jeanne, I believe Alvin is referring to DatabaseMetaData.
Alvin, have a look at Javadocs for java.sql.DatabaseMetaData
If you are getting the ResultSet by calling the getColumns() method, column number 3 refers to the table name.
cheers
|
|
 |
|
|
subject: Question on resultset.getString(3)
|
|
|
0
