What is the process of accessing the database from JSP page?
In the JSP program you can access the database by embedding the JDBC code. But this is not the best method and this works well for the small application.
For big application you should use the Hibernate or some other framework.
Check tutorial Accessing database from JSP which explains you how to access the database by embedding the JDBC code in JSP page.