File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Resultset getter method problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Resultset getter method problem" Watch "Resultset getter method problem" New topic

Resultset getter method problem

Sujoy Mukherjee
Ranch Hand

Joined: Dec 31, 2005
Posts: 51

hi all,
while displaying results using resultset, we generally write the following lines of code:

My question is, suppose there is a big table with 20 columns and I want to show all of them. So instead of showing them using the gettermethod(index1) +gettermethod(index2)+gettermethod(index3)......and so on till 20th column...., can we show the whole row in one shot? Is there any alternative way for this?

Thanking in advance.

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32062

Not directly. If you know the number of columns, you could write a form loop so you don't have to type out the logic.

[OCA 8 book] [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
Sujoy Mukherjee
Ranch Hand

Joined: Dec 31, 2005
Posts: 51

Thanks for replying.
I know I can use getColumnCount() method of ResultsetMetdata interface to know the column number. But then?
I have tried something like this:

But then again, I have to display each column separately within the while loop using the getter methods and the index value of the columns which I don't want. I mean if there are 20/30 columns in a table and if there is a need to print them all then I have to type each of them for 20/30 times using the getter methods.
Is there a way so that I can put the data of a Row inside some Class and print the column values separately?
I agree. Here's the link:
subject: Resultset getter method problem