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 Common resultSet Function 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 "Common resultSet Function" Watch "Common resultSet Function" New topic

Common resultSet Function

naval kumar
Ranch Hand

Joined: Jul 08, 2012
Posts: 37
I have Problem When I am making Common Function Of ResultSet.Actully I want To Call This Function From Different Function To get The Result Set. Like

But Problem Is that If i Will Get The Result Set Its Shwoing Nothing Beacuse i Have Close the Connection Here of databsase and Result set.If if Will Close The Resultset and database connection From The Calling Function Then I got Some more Issue that I have to setAttribut of Resulset On servlet and Get This On JSp So I can not Close the resultset On servlet If i Do like It then How Can i Close the database Connection And Result set Connection.Otherwise Lot of Resultset and database Connection Will Open.
Saif Asif
Ranch Hand

Joined: Aug 11, 2011
Posts: 440

kumar ,

Instead of returning the ResultSet object ( not advisable ) , it is always preferred to return a bean of values obtained from the result set. I would suggest that after you get the result set object ( rs ) , you set up an array list of objects and populate the array with the rows obtained in this result set and then return this List of objects instead of returning the ResultSet.

Muhammad Saif Asif Mirza
I agree. Here's the link:
subject: Common resultSet Function
It's not a secret anymore!