Yes, A method where you are executing your query you may return resultset
One point to be noted that an application has several role/operations and you can logically/physically seperate them as per their responsibility. for example in MVC speration of responsibility are
controlling request Selection of view business logic layer
Similarly there is a layer in your application Data layer where you can say you are doing operations related to database. If your question related to data layer then it is ok.such operation should be limited to data layer, else instead of returning a resultset from a method you can return VOs or DTOs.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
A CachedRowSet class�a disconnected rowset that caches its data in memory; not suitable for very large data sets, but an ideal way to provide thin Java clients, such as a Personal Digital Assistant (PDA) or Network Computer (NC), with tabular data