I have a code that we are planning to re-write using jdbc template. Here are few more details about the query that I'm planning to re-write.
The query is a dynamic one. Something like the below,
Now, this will return a result set. What option should i use to get the maximum benefit from jdbc template?
String query=SELECT account_type,email_id from account where user_id=userid;
Other important points to note are,
1. Some userid's won't be returning any result,
2. There can be multiple account type and emailid for a particular user id.
Right now, i'm using SQLRowset of jdbc template.
Could any one provide their suggestion on which is the best available option ? or can i go ahead with the sqlRowset?