http://en.wikipedia.org/wiki/Model%E2%80%93view%E2%80%93controller MVC

http://en.wikipedia.org/wiki/Model-view-presenter MVP

http://www.trelford.com/blog/post/MVMMC-e28093-MVVM-grows-a-Controller.aspx MVMMC

http://en.wikipedia.org/wiki/Multi-tier_architecture Multi-tier architecture

http://en.wikipedia.org/wiki/Database-centric_architecture Database centric architecture
http://en.wikipedia.org/wiki/Active_Record Active Record

http://en.wikipedia.org/wiki/ActiveJDBC ActiveJDBC

a very informative web dev architecture diagram

http://synodinos.files.wordpress.com/2007/01/activity-diagram.jpg

some more links for servlets mvc

http://pdf.coreservlets.com/MVC.pdf

using servlet sessions

http://www.wellho.net/solutions/java-sessions-in-servlets.html

Creating the database schema

http://www.orm.net/

http://en.wikipedia.org/wiki/Entity-relationship_model

using javascript with servlets

http://download.oracle.com/javase/6/docs/technotes/guides/scripting/programmer_guide/index.html

http://java.sun.com/developer/technicalArticles/J2SE/Desktop/scripting/