New Learnings: 2014

In this discussion i'll demonstrate an application by using spring and hibernate . In which spring as a front end technology , hibernate as a backend ORM technology and MS-SQL server for database connectivity.

Our main goal is to create an user management application in which :-

we can add user.
we can delete user.
Listing of users.

In this application i'll use layered architecture , dao layer that will interact with database. Next is service layer , above that there will be controller and at the top , there will be jsp.

Table of contents :-
Entity class - Hibernate domain class
Create Table
Create Project
Add dependency into pom.xml
Configure dispatcher servlet
The Data Access Layer
The Service Layer
The Controller
JSP

Getting started :-
Lets start with coding of user management application :-

Entity class - Hibernate domain class :-
First of all , we are creating a hibernate POJO class , that is used to store user information and also linked to database table user as :-

package com.mycompany.app.user.form;

import javax.persistence.Column;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Entity;
import javax.persistence.Table;
@Entity
@Table(name="user")
public class user {

@Id
@Column(name = "id")
@GeneratedValue
private Integer id;

@Column(name = "firstName")
private String firstname;

@Column(name = "lastName")
private String lastname;

public Integer getId() {
return id;
}

public void setId(Integer id) {
this.id = id;
}

public String getFirstname() {
return firstname;
}

public void setFirstname(String firstname) {
this.firstname = firstname;
}

public String getLastname() {
return lastname;
}

public void setLastname(String lastname) {
this.lastname = lastname;
}
}

Create Table :-

Create table in database :-

       CREATE TABLE user

            (

              id          INT PRIMARY KEY AUTO_INCREMENT,

              firstname   VARCHAR(30),

              lastname    VARCHAR(30),

            );

Create Project :-

Next step is to create project using maven command :-

mvn archetype:generate -DgroupId={project-packaging} -DartifactId={project-name} -DarchetypeArtifactId=maven-archetype-quickstart -DinteractiveMode=false

To convert maven project to support eclipse IDE , issue the command :-

mvn eclipse:eclipse

Now Import the project into eclipse and make the controller , dao , service and jsp layer as :-

Add dependency into pom.xml :-

Now add dependency related to spring and hibernate into pom.xml as :-

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

<modelVersion>4.0.0</modelVersion>

<groupId>com.mycompany.app</groupId>

<artifactId>springHibernate</artifactId>

<packaging>war</packaging>

<version>1.0-SNAPSHOT</version>

<properties>

<org.springframework.version>3.0.2.RELEASE</org.springframework.version>

<jpa-api-version>2.0-cr-1</jpa-api-version>

<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

<org.hibernate-version>3.5.6-Final</org.hibernate-version>

</properties>

<build>

<plugins>

<plugin>

<artifactId>maven-war-plugin</artifactId>

<version>2.0</version>

<configuration>

<webappDirectory>webapp</webappDirectory>

<webResources></webResources>

</configuration>

</plugin>

</plugins>

<finalName>springhibernate</finalName>

</build>

<name>springHibernate</name>

<url>http://maven.apache.org</url>

<dependencies>

<dependency>

<groupId>junit</groupId>

<artifactId>junit</artifactId>

<version>3.8.1</version>

<scope>test</scope>

</dependency>

<dependency>

<groupId>javax.servlet</groupId>

<artifactId>servlet-api</artifactId>

<version>2.5</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-beans</artifactId>