This is my first time using
JDBC and I am having a hard time firguring out the best way to implement my SQL queries in my web app.
Right now I have one class called DataBaseMethods
In this class, I have one method for each call to the database I make.
getChildren();
getPersonIds();
.
.
.
etc...
In each method, I open the database connection, make and execute the sql query and then close the database connection.
I then call these methods in my other buisiness logic classes.
I think this would end up making a LOT of opening and closing of the db. Is there a better way to do this?
Thanks for any help!!!
-Nate