I created a ResultSetHandlerCallBack class which extends the above class.
I then have a ResultSetMap class which uses the above call back class.
This is how I use it in the dao.
The ResultSetHandlerCallBack class puts the results in the form of multiple maps with colName and value as pairs. Then the row map is added to a rows list.
The ResultSetMap is needed as this class helps to get the handle for the metadata info we populated using the Handler class.
I implemented all that you said and it works well,
But, i need to know how to get the metadata when there is no any row.
I execute the follow sentence:
select * from mytable where 1=0; //it doesnt return any row.
So, i just need to know the metadata.
With your code works well with data, but nothing happen when the sentece doesnt return anything.
Because i should know the metadata even theres no data retreiving.
Thank you so much.
pie. tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop