Saturday, March 5, 2016

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.