Basic JSP, Servlet, JDBC CRUD

ABCDJavaEE - AnyBody Can Do JavaEE

Welcome to the blog.

Very good examples of every functionality you need in JeEE world can be found on -
journaldev, codejava, mkyong, roseindia and a lot more.

Prerequisites:

• Knowledge of Core-Java

Must study tutorials:

• http://www.journaldev.com/2114/servlet-jsp-tutorial
• http://www.javatpoint.com/servlet-tutorial
• http://www.tutorialspoint.com/jsp/
• http://www.simplecodestuffs.com/servlet-jsp-tutorial-beginners/
• And others too as much as you can.

Minimum Tools required:

• JDK. Which can be downloaded from here: http://www.oracle.com/technetwork/java/javase/downloads/index.html
• MySQL Database Server (or any other DB of your choice). MySQL can be downloaded from here: http://dev.mysql.com/downloads/
• IDE of your choice. Eclipse - https://eclipse.org/downloads/  AND/OR Netbeans - https://netbeans.org/downloads/

The use-case:

Create a basic J2EE MVC application which has: 
(No frameworks, XMLs and web services yet. We will cover them in next solution with Spring Framework) 

• User registration with encrypted password stored in database.
• Reading parameters from properties file.
• From browser user should see jsp/servlet/htmls.
• Login-Logout feature.
• Http Session.
• Authentication Filter.
• Context Listner.
• Application error handling.
• Servlets.
• Servlets requests & responses.
• JSPs. get/set parameters. different field types. session variables. java imports.
• Jsp in a jsp.
• Jsp forwarding from servlet.
• Write error message on same servlet/jsp.
• JDBC connection with CRUD.
• Application and Database error handling.
• Write exceptions and errors using html tags on the screen.
• Avoid resend on browser refresh.
• Password encryption
• Password De-cryption.
• Java-email feature.
• Forgot password / Reset Password and get (decrypted) password in email.
• Bootstrap CSS usage.

Consider the solution:
(please change extension from .pdf to .zip)

Download the Solution

Database and Tables Creation SQL script is bundled in the Eclipse Project.