Web access to databases

 

Choices for your project:

           

1. Java Servlets and JSP.

 

                        a) Minimally you will need a servlet container for servlets and/or JSP pages.  The Tomcat server can be used as both a server for your html pages and as a servlet container for servlets and JSP pages.  Typically, a HTTP server (e.g., Apache’s HTTP server) is used to handle the html pages and the servlet container deals only with the servlets and the JSP pages.

           

b) Documentation for the Tomcat Server is available at http://jakarta.apache.org/tomcat/tomcat-5.5-doc/index.html.

 

c) JDBC is typically used to access the database from your servlets and/or JSP pages.

 

2. PHP – PHP is a scripting language that has built in database connectivity for a number of database management systems.

                        a) For PHP downloads you can go to http://www.php.net/downloads.php.

                        b) PHP documentation is available at http://www.php.net/docs.php.

                        c) A server is required to make your PHP environment web accessible.  Check out the Apache HTTP server at http://httpd.apache.org/

                        c) A nice discussion of setting up a PHP environment for Linux, Apache, MySQL, and PHP is available at (LAMP).

Books of Interest:

Murach's Java Servlets and JSP. by Andrea Steelman, Joel Murach. Mike Murach & Associates. January 1, 2003. A very straight forward approach.

Professional Java Data: RDBMS, JDBC, SQLJ, OODBMS, JNDI, LDAP, Servlets, JSP, WAP, XML, EJBs, CMP2.0, JDO, Transactions, Performance, Scalability, Object and Data Modeling.  by Thomas Bishop, Glenn E. Mitchell II, John Bell, Bjarki Holm, Danny Ayers, Carl Calvert Bettis, Sean Rhody, Tony Loton, Michael Bogovich, Mark Wilcox, Lin Kelly Poon, Nitin Nanda, Rick Grehan, Matthew Ferris, Kelly Lin Poon, Nitin Nanda. Peer Information Inc. First Edition (June 1, 2001). A used copy can be purchased for ~$2.00 plus postage on Amazon.

Note that there are numerous books on servlets, JSP, and PHP that you can see by searching for these terms on the Amazon web site.