Three-Tier Application
Presentation Tier: user interface to make
requests, provide input and see results
Middle Tier: application logic
Data Management Tier: database management

MySQL
DBMS
Standard SQL language

JSP vs. Servlets
Servelts - HTML embedded into Java code
JSP - java code embedded into HTML
JSP better for building interfaces with simple logic,
Servlets better for complex application logic
We will use JSP in this project

What is a Java Server page (JSP)?
Combination of JSP scriptlets/tags and HTML/XML tags Has the extension .jsp or .jspx Extension means JSP engine at the web server will process elements on the page JSP engine interprets tags, generates required content, then sends results back as an HTML/XML page to the browser Typically compiled into Java servlet classes the first time called Classes remain in server memory, so subsequent calls have very fast response times
From http://java.sun.com/products/jsp/faq.html

Download pdf Creating Applications Using MySQL, JDBC, and JSP Outline