Employee Registration using Spring MVC

To download code -Click Here

web.xml File

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns="http://java.sun.com/xml/ns/javaee"
    xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    id="WebApp_ID" version="2.5">
    <display-name>Spring3MVC</display-name>
    <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>

    <servlet>
        <servlet-name>spring</servlet-name>
        <servlet-class>
            org.springframework.web.servlet.DispatcherServlet
        </servlet-class>

    </servlet>
    <servlet-mapping>
        <servlet-name>spring</servlet-name>
        <url-pattern>*.htm</url-pattern>
    </servlet-mapping>

</web-app>


spring-servlet.xml File

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"


    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
        http://www.springframework.org/schema/context
        
        http://www.springframework.org/schema/context/spring-context-3.0.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
    
        <context:annotation-config />
    <context:component-scan
        base-package="com.employee" />
        
    <bean id="viewResolver"
        class="org.springframework.web.servlet.view.UrlBasedViewResolver">
        <property name="viewClass"
            value="org.springframework.web.servlet.view.JstlView" />
        <property name="prefix" value="/WEB-INF/jsp/" />
        <property name="suffix" value=".jsp" />
    </bean>

    
    <bean id="propertyConfigurer"
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
        p:location="/WEB-INF/jdbc.properties" />

    <bean id="dataSource"
        class="oracle.jdbc.pool.OracleDataSource" destroy-method="close"
                p:URL="${jdbc.databaseurl}" p:user="${jdbc.username}"
        p:password="${jdbc.password}" />

    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="configLocation">
            <value>classpath:hibernate.cfg.xml</value>
        </property>
        <property name="configurationClass">
            <value>org.hibernate.cfg.AnnotationConfiguration</value>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">${jdbc.dialect}</prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>
    </bean>
    
    <tx:annotation-driven />

    <bean id="transactionManager"
        class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>
</beans>


jdbc.properties

jdbc.driverClassName= oracle.jdbc.driver.OracleDriver
jdbc.dialect=org.hibernate.dialect.OracleDialect
jdbc.databaseurl= jdbc:oracle:thin:@192.168.25.178:1521:xe
jdbc.username=litmus
jdbc.password=litmus


hibernate-cfg.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

 
<hibernate-configuration>
    <session-factory>
      <mapping class="com.employee.Models.EmployeeModel" />
    </session-factory>
        
</hibernate-configuration>


EmployeeController.java

/**
 *
 */
package com.employee.Controller;
import java.util.ArrayList;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;

import com.employee.Models.EmployeeModel;
import com.employee.Services.EmployeeService;

/**
 * @author A-5518
 *
 */

@Controller
public class EmployeeController {

    @Autowired
    private EmployeeService employeeService;
    
    @RequestMapping("/registerEmployee.htm")
    public String showRegistration(ModelMap map){
        
        System.out.println("Inside showRegistration Method");
        map.addAttribute("EmployeeModel", new EmployeeModel());
        return "newEmployee";
    }
    
    @RequestMapping("/addEmployee.htm")
    public String addEmployee(ModelMap map, @ModelAttribute EmployeeModel employeeModel){
        
        try{
            
            System.out.println("Inside addEmployeee Method");
            employeeService.SaveUsertoDatabase(employeeModel);
            map.addAttribute("EmployeeModel", new EmployeeModel());
            return "success";
        }catch(Exception e){
            
            System.out.println("Primary key violation error occured.");
            return "error";
        }
    }
    
    @RequestMapping("/listEmployee.htm")
    public String listEmployee(ModelMap map){
        
        System.out.println("Inside listEmployeee Method");
        List<EmployeeModel> users = employeeService.getUserDetails();
        map.addAttribute("users", users);
        map.addAttribute("EmployeeModel", new EmployeeModel());
        return "listEmployee";
    }
    
    @RequestMapping("/editEmployee.htm")
    public String editEmployee(ModelMap map, @ModelAttribute EmployeeModel employeeModel){
        
        System.out.println("Inside editEmployeee Method");
        List<EmployeeModel> users = employeeService.getUserDetails();
        
        EmployeeModel em=(EmployeeModel)users.get(users.indexOf(employeeModel));
        ArrayList<EmployeeModel> singleUser=new ArrayList<EmployeeModel>();
        singleUser.add(em);
        
        map.addAttribute("singleUser", singleUser);
        map.addAttribute("EmployeeModel", new EmployeeModel());
        return "editEmployee";
    }
    
    @RequestMapping("/updateEmployee.htm")
    public String updateEmployee(ModelMap map, @ModelAttribute EmployeeModel employeeModel){
        
        System.out.println("Inside updateEmployeee Method");
        employeeService.updateUserFromDatabase(employeeModel);
        map.addAttribute("EmployeeModel", new EmployeeModel());
        return "update";
    }
    
    @RequestMapping("/deleteEmployee.htm")
    public String deleteEmployee(ModelMap map, @ModelAttribute EmployeeModel employeeModel){
        
        System.out.println("Inside deleteEmployeee Method");
        employeeService.deleteUserFromDatabase(employeeModel);
        List<EmployeeModel> users = employeeService.getUserDetails();
        map.addAttribute("users", users);
        map.addAttribute("EmployeeModel", new EmployeeModel());
        return "listEmployee";
    }

}


EmployeeDao.java

/**
 *
 */
package com.employee.Dao;

import java.util.List;

import com.employee.Models.EmployeeModel;

/**
 * @author A-5518
 *
 */
public interface EmployeeDao {
    
    public void saveUser(EmployeeModel loginModel);
    public void updateUser(EmployeeModel loginModel);
    public void deleteUser(EmployeeModel loginModel);
    public List<EmployeeModel> getUserDetails();
}

 

EmployeeDaoImpl.java

/**
 *
 */
package com.employee.Dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import javax.sql.DataSource;

import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.employee.Models.EmployeeModel;

/**
 * @author A-5518
 *
 */

@Repository
public class EmployeeDaoImpl implements EmployeeDao {

    @Autowired
    private SessionFactory sessionFactory;
    
    @Autowired
    private DataSource dataSource;
    
    @Transactional
    public void saveUser(EmployeeModel loginModel) {
        // TODO Auto-generated method stub
        System.out.println("Saving into Database");
        sessionFactory.getCurrentSession().save(loginModel);
    }
    
    @Transactional
    public void deleteUser(EmployeeModel loginModel) {
        // TODO Auto-generated method stub
        System.out.println("Deleting from Database");
        sessionFactory.getCurrentSession().delete(loginModel);
    }
    
    @Transactional
    public void updateUser(EmployeeModel loginModel) {
        // TODO Auto-generated method stub
        System.out.println("Update from Database");
        sessionFactory.getCurrentSession().update(loginModel);
    }

    @Transactional
    public List<EmployeeModel> getUserDetails() {
        // TODO Auto-generated method stub
        
        JdbcTemplate jdbcTemplate = new JdbcTemplate();
        jdbcTemplate.setDataSource(dataSource);
        
        String sql ="select * from employee_details_a5518";
        RowMapper<EmployeeModel> mapper = new RowMapper<EmployeeModel>(){

            @Override
            public EmployeeModel mapRow(ResultSet rs, int arg1)
                    throws SQLException {
                // TODO Auto-generated method stub
                EmployeeModel employeeModel = new EmployeeModel();
                employeeModel.setEmployeeId(rs.getString(1));
                employeeModel.setName(rs.getString(2));
                employeeModel.setAddress(rs.getString(3));
                
                return employeeModel;
            }
            
        };
        
        List<EmployeeModel> users = jdbcTemplate.query(sql, mapper);
        return users;
    }

}
 


EmployeeModel.java

/**
 *
 */
package com.employee.Models;

import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Column;

/**
 * @author A-5518
 *
 */

@Entity
@Table(name="employee_details_a5518")
public class EmployeeModel {
    
    private String employeeId;
    private String name;
    private String address;
    
    @Id
    @Column(name="employeeid")
    public String getEmployeeId() {
        return employeeId;
    }
    public void setEmployeeId(String employeeId) {
        this.employeeId = employeeId;
    }
    
    @Column(name="name")
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    
    @Column(name="address")
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
    /* (non-Javadoc)
     * @see java.lang.Object#hashCode()
     */
    @Override
    public int hashCode() {
        final int prime = 31;
        int result = 1;
        result = prime * result
                + ((employeeId == null) ? 0 : employeeId.hashCode());
        return result;
    }
    /* (non-Javadoc)
     * @see java.lang.Object#equals(java.lang.Object)
     */
    @Override
    public boolean equals(Object obj) {
        if (this == obj)
            return true;
        if (obj == null)
            return false;
        if (getClass() != obj.getClass())
            return false;
        EmployeeModel other = (EmployeeModel) obj;
        if (employeeId == null) {
            if (other.employeeId != null)
                return false;
        } else if (!employeeId.equals(other.employeeId))
            return false;
        return true;
    }

}
 


EmployeeService.java

/**
 *
 */
package com.employee.Services;

import java.util.List;

import com.employee.Models.EmployeeModel;
/**
 * @author A-5518
 *
 */
public interface EmployeeService {
    
    public void SaveUsertoDatabase(EmployeeModel loginModel);
    public void deleteUserFromDatabase(EmployeeModel loginModel);
    public void updateUserFromDatabase(EmployeeModel loginModel);
    public List<EmployeeModel> getUserDetails();
}


EmployeeServiceImpl.java

/**
 *
 */
package com.employee.Services;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.employee.Dao.EmployeeDao;
import com.employee.Models.EmployeeModel;

/**
 * @author A-5518
 *
 */

@Service
public class EmployeeServiceImpl implements EmployeeService {
    
    @Autowired
    private EmployeeDao employeeDao;
    
    @Transactional
    public void SaveUsertoDatabase(EmployeeModel loginModel) {
        // TODO Auto-generated method stub
        employeeDao.saveUser(loginModel);
    }
    
    @Transactional
    public void deleteUserFromDatabase(EmployeeModel loginModel) {
        // TODO Auto-generated method stub
        employeeDao.deleteUser(loginModel);
    }
    
    @Transactional
    public void updateUserFromDatabase(EmployeeModel loginModel) {
        // TODO Auto-generated method stub
        employeeDao.updateUser(loginModel);
    }

    @Transactional
    public List<EmployeeModel> getUserDetails() {
        // TODO Auto-generated method stub
        return employeeDao.getUserDetails();
    }
    
}

 

To download code -Click Here


 

You can leave a response, or trackback from your own site.

Leave a Reply