title: java.sql.ResultSet as user defined
body: <p>I have an old application which I need to optimize in which my method returns <code>java.sql.ResultSet</code> and also I have single connection so now I need to implement connection pooling now the problem is if I close the connection than resultset will give exception when doing <code>rs.next()</code> so I want such a class similar to ResultSet which we can say is detached from Connection also such that i don't have to make changes on my JSPs where i have used <code>ResultSet</code> object.</p>