Hi,
I have gone through your code.
I would like to put something on this.
First , You use HTML/JSP page to display the page.
When the user submits form, you call your servltes.
Inside the servlets , you use your business class for doing your business logic method.
Instead of doing
JDBC connection in your business class, u use another database class which will have only JDBC methods which is explained below.
You can further divide database class into two parts.
First part:
In this you define common methods used for database connections like opening connection,closing connection , returning resultset , transaction methods.This is because this class will be common for full project.
Second part :
In this , you write methods to get the result from database .This class should be initiated in your business class.
by doing the above in your code, you are following MVC structure.
in this ,
VIEW - JSP/HTML
CONTROLLER - SERVLETS
MODEL - BUSINESS CLASS
Hope this would clear your doubt.
regards
kishore