Re: Oralce and Java- Returning ResultSet from a Database
This post is from the topic: Oralce and Java- Returning ResultSet from a Database
EDIT POST Post #27331 Earnshaw24
Posted: 2007-05-16 12:35:35
I'm using the Tiers to Insert, Update, Delete and Select, into and from an Oracle table.
I have a provider class that has all he necessary methods to insert, update and delete.
Something like this:
When writing the code in .Net, I'll have two classes (Miner and Finder) to Select data from an SQL Server Table and populate the records into collections and table classes. Inside the miner example:
Then Inside the Finder, There'll be code to populate this SqlDataReader into my Collections:
one the main concepts here is:
The Connection to SQL Server will be closed Automatically and the SqlDataReader will be populated into the collection. Pay Attention to the RETURN line in the MINER class' function. (CommandBehavior.CloseConnection)
Is there any way to do this in Java?