Hi,
Consider making the db connection class you already have a simple javaBean and use it in the
JSP pages to connect when you want. You might even want one bean for many pages by passing in the SQL
string and database table info as parameters - makes more sense.
To protect your data integrity, just synchronise the actual connection methods, that way a page can be opened in multiple clients and they can all try to connect but they'll have to wait in line to do it.
Hope that helps,
Terry
Sorry. Where I said jsp and useBean I had'nt seen you were only talking about servlets & HTML.
Instantiate the beans, pass in the paramaters and call their methods when needed. The synchronisation advice stands.
[This message has been edited by Terence Doyle (edited October 29, 2001).]