Common resultSet Function

[naval kumar]

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

public static ResultSet executeQuery(String sqlQuery)
	{
        DatabaseConnection db=new DatabaseConnection();
		Connection con=db.getConnection();
		ResultSet rs=null;
		Statement stmt=null;
		try
		{
			stmt=con.createStatement();
			rs = (ResultSet)stmt.executeQuery(sqlQuery);
			rs.close();
			stmt.close();
			con.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return rs;
	}

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]

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.