Spring MVC for employee shift

Ranch Hand

Posts: 51

posted 8 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hi all,

I have two requirements

1. parsing Excel file and insert excel data in to DB (oracle).
2. Transverse DB table structure to UI.

I am doing a small Project to maintain employee shift tracker, which we are maintaining in excel. below is the sample excel data, T1 represents time (6:00 am-4:00 pm) T2(12:00 pm-9:00pm) T3(9:00 pm-6:00 am)

Date	emp1	emp2	emp3	emp4	emp5	emp6
01/July/2016	T2	T1	T3	T1	T3	T2
02/July/2016	T1	T2	T3	T2	T1	T3
03/July/2016	T3	T1	T2	T3	T2	T1
04/July/2016	T1	T3	T1	T1	T3	T2

Below is table script designed by DBA -- Is table design correct to get above view?

Any link or suggestion to upload excel data in to above table using spring MVC

I googled for Spring MVC and found one sample to edit employee details, however not able to design Shift Jsp. Below is the code i am planning to use.

Below is Bean

below is DTO class

package com.employee.model;

import java.io.Serializable;

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

@Entity
    @Table(name="Employee")
    public class Employee implements Serializable{

private static final long serialVersionUID = -723583058586873479L;
     
     @Id
     @GeneratedValue(strategy=GenerationType.AUTO)
     @Column(name = "empid")
     private Integer empId;
     
     @Column(name="empname")
     private String empName;
     
     @Column(name="empaddress")
     private String empAddress;
     
     @Column(name="salary")
     private Long salary;
     
     @Column(name="empAge")
     private Integer empAge;

public Integer getEmpId() {
      return empId;
     }

public void setEmpId(Integer empId) {
      this.empId = empId;
     }

public String getEmpName() {
      return empName;
     }

public void setEmpName(String empName) {
      this.empName = empName;
     }

public String getEmpAddress() {
      return empAddress;
     }

public void setEmpAddress(String empAddress) {
      this.empAddress = empAddress;
     }

public Long getSalary() {
      return salary;
     }

public void setSalary(Long salary) {
      this.salary = salary;
     }

public Integer getEmpAge() {
      return empAge;
     }

public void setEmpAge(Integer empAge) {
      this.empAge = empAge;
     }
    }

Below is add employee Jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
  <title>Spring MVC Form Handling</title>
 </head>
 <body>
  <h2>Add Employee Data</h2>
  <form:form method="POST" action="/sdnext/save.html">
      <table>
       <tr>
           <td><form:label path="id">Employee ID:</form:label></td>
           <td><form:input path="id" value="${employee.id}" readonly="true"/></td>
       </tr>
       <tr>
           <td><form:label path="name">Employee Name:</form:label></td>
           <td><form:input path="name" value="${employee.name}"/></td>
       </tr>
       <tr>
           <td><form:label path="age">Employee Age:</form:label></td>
           <td><form:input path="age" value="${employee.age}"/></td>
       </tr>
       <tr>
           <td><form:label path="salary">Employee Salary:</form:label></td>
           <td><form:input path="salary" value="${employee.salary}"/></td>
       </tr>
       
       <tr>
           <td><form:label path="address">Employee Address:</form:label></td>
                    <td><form:input path="address" value="${employee.address}"/></td>
       </tr>
          <tr>
         <td ><input type="submit" value="Submit"/></td>
        </tr>
   </table> 
  </form:form>
  
  <c:if test="${!empty employees}">
  <h2>List Employees</h2>
 <table  border="1">
  <tr>
   <th>Employee ID</th>
   <th>Employee Name</th>
   <th>Employee Age</th>
   <th>Employee Salary</th>
   <th>Employee Address</th>
           <th>Actions on Row</th>
  </tr>

<c:forEach items="${employees}" var="employee">
   <tr>
    <td><c:out value="${employee.id}"/></td>
    <td><c:out value="${employee.name}"/></td>
    <td><c:out value="${employee.age}"/></td>
    <td><c:out value="${employee.salary}"/></td>
    <td><c:out value="${employee.address}"/></td>
    <td ><a >Edit</a> | <a >Delete</a></td>
   </tr>
  </c:forEach>
 </table>
</c:if>
 </body>
</html>

Bean and DTO are the key classes to get and put list of objects, hence requesting help on how i should modify the code to display.

thanks
Abhee

Consider Paul's rocket mass heater.