Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

can you pass ResultSet as argument

 
P. Ingle
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

Can you pass Resultset as an argument or input parameter to a method
Can you return ResultSet from a method?

Thanks,
P.Ingle
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by p Ingle:

Can you pass Resultset as an argument or input parameter to a method


Yes


Can you return ResultSet from a method?


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.

Shailesh
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Or you can look at CachedRowSet, because ResultSet object is bound with the Statement object. However, CacheRowset is independent and made for passing across layers.

JDBC Tutorail says:

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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic