jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes ResultSet's getXXX methods Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "ResultSet Watch "ResultSet New topic

ResultSet's getXXX methods

eric moon
Ranch Hand

Joined: Nov 26, 2000
Posts: 133
Given that a result set knows the TYPE of each column of data, via ResultSetMetaData I'm wondering whether it's impossible or impractical to extend ResultSet and provide a get() method that is TYPE independent, and calls the appropriate getXXX based on the column's type (at least for those types that should be displayed as text.) If it is possible, what are the reasons for not supplying something like this in java.sql?? I'm tempted to try doing this, and am wondering if there is some huge pitfall I've overlooked!
[I just looked at ResultSet.getString() again and it sounds like maybe it already does this. I will try it and see.]
[This message has been edited by eric moon (edited December 16, 2000).]

<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>"Those who cast the votes decide nothing. Those who count the<BR>votes decide<BR>everything." <BR> -Joseph Stalin<HR></BLOCKQUOTE>
paul sun

Joined: Dec 22, 2000
Posts: 28
getObject() can do whatever type you want. Isn't it "independent"?
I agree. Here's the link: http://aspose.com/file-tools
subject: ResultSet's getXXX methods
It's not a secret anymore!