Can someone please clearly define the distinction between JSP, Java Servlets?
At first blush, things look like this:
A servlet is a Java program that has HTML inside it (in print statements)
A JSP document is an HTML page with Java code
inside it (marked by special tags)
Now, this is a great oversimplification, but the basic idea is that a servlet looks like a regular Java class whereas a JSP document usually looks more like an HTML page. Behind the scenes, though, there are only servlets: JSP documents are just alternative ways of writing servlets, JSP documents get translated into servlets, and at request time there are only servlets. Since JSP documents get translated into servlets, a servlet could do anything a JSP page could do. But that does not mean they are equally convenient, equally productive, equally maintainable, or equally applicable to all circumstances. When to use servlets, when to use JSP, and when to use a combination of the two (via the MVC architecture) is a long and complicated discussion, but the gist of the idea is that servlets are better at data processing and business logic, whereas JSP is better at presentation.
How does JDBC fit in there? Which database is used, Oracle?
JDBC is an API that standardizes the way to connect to a relational database from a Java program and standardizes the data structure that results from a query. You can use JDBC to talk to Oracle, DB2, Sybase, SQL Server, Informix, MySQL, MS Access, and zillions of other databases. For lots of detail on servlets, JSP, and JDBC, you can see the free online version of Core Servlets and JSP at http://pdf.coreservlets.com/. Cheers- - Marty