Login Example using Servlet, JSP, MySQL and Hibernate Framework.

In this example we are seeing how to develop Registration and Login application using technologies Servlet, JSP, Hibernate Framework and MySQL Database. This application is developed using eclipse IDE. Using Hibernate Framework developer no need to create table in DB, Hibernate framework will take care about creating table. Just developer need to configure DB schema details like username, password, URL (DB TNS entry) and Driver name in the configuration file, named as hibernate.cfg.xml file. and we need to create mapping file with java entity class to Table name and entity properties names to table column names.

i.e, mapping object oriented data to relational data.

Below find the Test Case and flow of the application.

To run the application below Jar file required in lib folder of the application as per the standards of Java Organization.
Below Jar files are available with Hibernate framework. (for more clarification see the previous post: Click Here)

• antlr-2.7.7.jar
• cdi-api-1.1.jar
• classmate-1.3.0.jar
• dom4j-1.6.1.jar
• el-api-2.2.jar
• geronimo-jta_1.1_spec-1.1.1.jar
• hibernate-commons-annotations-5.0.1.Final.jar
• hibernate-core-5.2.4.Final.jar
• hibernate-jpa-2.1-api-1.0.0.Final.jar
• jandex-2.0.0.Final.jar
• javassist-3.20.0-GA.jar
• javax.inject-1.jar
• jboss-interceptors-api_1.1_spec-1.0.0.Beta1.jar
• jboss-logging-3.3.0.Final.jar
• jsr250-api-1.0.jar

Below 2 .jar files are available with Tomcat Server (under %Tomcat_Home%/lib folder)

• servlet-api.jar
• jsp-api.jar

Below mysql-connector-java-5.1.37-bin.jar file is available with MySQL instillation (under  %MySQL_initialization_location%\Connector.J 5.1\ folder) or available in maven repository.

• mysql-connector-java-5.1.37-bin.jar

Note: MySQL mysql-connector-java-X.X.X-bin.jar version file is different from MySQL version to version.

For developing application using eclipse IDE software, create a Dynamic web project and create the project structure like below screen short.



User.java is the DTO object, means this is the Data Transfer Object between the application layers. from Controller layer to Service layer, Service layer to DAO Layer etc....
User.java
Below .xml file is the configuration file between the Hibernate framework and MySQL DB, based on the below configuration hibernate create a Table in MySQL DB.
User.hbm.xml
hibernate.cfg.xml :
It is an .xml file, in which DB connection details like username, password, url and Driver Class name etc... & hibernate properties like Dialect, show_sql and hbm2ddl.auto etc....
hibernate.cfg.xml You know very well every Java web application must have deployment descriptor configuration for application (either .xml or annotation configuration), below is the web.xml file for our application.
web.xml
In above web.xml file configured welcome file as a login.jsp page and Servlet class with urls login, registration. here Servlet class are controllers for this application. see the below two controllers.
LoginController.java
RegistrationController.java
Below are the Service declaration and Implementation Classes
BaseService.java
BaseServiceImpl.java
Below are the Dao Declaration and Implementation Classes
BaseDao.java
BaseDaoImpl.java
Hibernate Utility Class for Application. Using this class creating Hibernate connection and using this connection in Application Dao Implementation class
HibernateUtil.java
login.jsp
userRegistration.jsp
home.jsp