Untitled

//initialization code goes here

        function init(){*/

            $scope.name={};
            $scope.mobileNo= {};

            $scope.email={};
            $scope.school={};

            $scope.isEditVisible= false;


            $http.post('rest/emp/getAllEmployee').success(function(empdata) {

                console.log("new customer added in getter");
                $scope.employee= empdata;

            }).error(function()
            {
                console.log("Error while getting the details!!");
            });


        $scope.addEmployee=function(emp)
        {
            console.log("in add controller");

            $http.post('rest/emp/addEmployee',emp).success(function(empdata) {
                $scope.employee =empdata;

                $scope.emp = {};

                    emp.isEditVisible = false;


            })
            .error(function()
            {
                console.log("Error while inserting the customer details!!");
            });


        };


        // update customer
        $scope.updateEmployee=function($index,emp)
        {
            var newEmp={};
            console.log("in update");
            console.log(emp);


            newEmp.name=emp.name;
            newEmp.mobileno=emp.mobileno;
            newEmp.email=emp.email;
            newEmp.school=emp.school;
            console.log(newEmp);

            $http.post("rest/emp/updateEmployee",newEmp).success(function(empdata){
                console.log("hello");

                $scope.employee = empdata;
                $scope.employee[$index].isEditVisible = false;


            })
            .error(function(){
                console.log("Error while updating");
            });

        } ;


        // delete customer
        $scope.deleteEmployee=function($index,email)
        {
            console.log("in delete");
            console.log(email);
            $http.post('rest/emp/deleteEmployee',email).success(function(empdata) {

        $scope.employee = empdata;
        $scope.employee.splice($index,1);


            })
            .error(function()
                    {
                        console.log("Error while deleting the  details!!");
                    });

        };


        ;

        });

     Employee-servlet.xml
    <?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:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.1.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd">

    <context:annotation-config />
    <context:component-scan base-package="com.tcs" />
    <mvc:annotation-driven />


      <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
 <property name="driverClassName" value="org.postgresql.Driver"/>
 <property name="url" value="jdbc:postgresql://localhost:5432/postgres"/>
 <property name="username" value="postgres"/>
 <property name="password" value="Root123"/>

 </bean>
    </beans>


    EmployeeManag.html
        <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html align="center" ng-app="EmployeeApp">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
    <script type="text/javascript" src="externalJS/jquery.min.js"></script>
     <script type="text/javascript" src="externalJS/angular.js"></script>
     <script type="text/javascript" src="externalJS/angular-route.js"></script>
      <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>

    <script type="text/javascript" src="externalJS/bootstrap.js"></script>
    <script type="text/javascript" src="applicationJS/controller.js"></script>
    <script     src="http://ajax.googleapis.com/ajax/libs/angularjs/1.4.8/angular.min.js">    </script>


<title>Employee</title>
</head>
<body ng-controller = "Employeectrl">
<nav class="navbar navbar-inverse">
  <div class="container-fluid">
    <div class="navbar-header">
      <a class="navbar-brand" href="#">WebSiteName</a>
    </div>
    <ul class="nav navbar-nav">
      <li class="active"><a href="#">Home</a></li>
      <li><a href="#">Page 1</a></li>
      <li><a href="#">Page 2</a></li>
      <li><a href="#">Page 3</a></li>
    </ul>
  </div>
</nav>

<div class="container">
  <h3>Inverted Navbar</h3>
  <p>An inverted navbar is black instead of gray.</p>
</div>

 <form>
<h1>Employee Registration</h1>
<br>
<table border="3" align=center >
<tr><td><span class="label" style="line-height:30px;border-radius:1px;width:250px"><b> Name:</b></span></td>
<td><input type="text" ng-model="emp.name" placeholder="enter  name" required/></td></tr>
<br>
<tr><td><span class="label" style="line-height:30px;border-radius:1px;width:250px"><b>  mob number:</b></span></td>
<td><input type="number"  class="form-control"  ng-pattern="phoneNumbr" ng-model="emp.mobileNo" placeholder="enter mobile no" required/></td></tr>
<br>


<tr><td><span class="label" style="line-height:30px;border-radius:1px;width:250px"><b> email:</b></span></td>
<td><input type="email" ng-model="emp.email" type="email"placeholder="enter email" required/>
 </td></tr>
<br>
<tr><td><span class="label" style="line-height:30px;border-radius:1px;width:250px"><b>School:</b></span></td>
<td><input type="text" ng-model="emp.school" placeholder="enter password" required/></td></tr>


  <tr><td><div class="modal-footer">
   <button class="btn btn-success" data-dismiss="modal" aria-hidden="true" ng-click="addEmployee(emp)" ng-disabled="!emp.name|| !emp.mobileNo||!emp.email||!emp.school">Add Employee</button>
  </div></td>
</div>
</table>
</form>


<hr>

<h3 style="line-height:20px">Employee List </h3>


<form autocomplete="off">
<table class="table table-striped " border=3 align=center>

<tr>
<td></td>

<td> <b>  Name </td>


<td> <b>Mobile No </td>
<td> <b>Email </td>
<td> <b>school </td>
<td><b> Action</td>

</tr>

<tr ng-repeat = "emp in employee">
<td><input type="checkbox" class="checkbox" ng-model="emp.isEditVisible" ng-click="toggleEmployee(emp,$index)" /></td>


<td><span ng-hide="emp.isEditVisible">{{emp.name}}</span>
<input type="text" ng-model="emp.name" ng-show="emp.isEditVisible" required></td>

<td><span ng-hide="emp.isEditVisible">{{emp.mobileNo}}</span>
<input type="text" ng-model="emp.mobileNo" ng-show="emp.isEditVisible"required></td>

<td><span ng-hide="emp.isEditVisible">{{emp.email}}</span>
<input type="text" ng-model="emp.email" type="email" ng-show="emp.isEditVisible" autocomplete="off"required></td>

<td><span ng-hide="emp.isEditVisible">{{emp.school}}</span>
<input type="text" ng-model="emp.school" ng-show="emp.isEditVisible" autocomplete="off"required></td>


<td> <input type="button" value="Update" class = "btn btn-warning" ng-disabled="!emp.isEditVisible" ng-click="updateEmployee($index,emp)">
 <input type="button" value="Delete" class = "btn btn-danger" ng-disabled="!emp.isEditVisible" ng-click="deleteEmployee($index,emp.email)"></td>
</tr>
</table>
</form>
</body>
</html>


EmployeeController.java

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.stereotype.Service;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import com.google.gson.Gson;
import com.tcs.pojo.Employee;
import com.tcs.service.EmployeeService;
import com.tcs.service.EmployeeServiceImpl;

@Controller
public class EmployeeController {
    @Autowired
    EmployeeServiceImpl employeeService;
    @RequestMapping(value="/emp/getAllEmployees",method = RequestMethod.POST)
    public @ResponseBody String getAllEmployees()
    {
        System.out.println("Inside Customer Controller");
        List<Employee> empList = employeeService.getAllEmployee();
        System.out.println("Length : "+empList.size());

        Gson gson = new Gson();
        String resultJson = gson.toJson(empList);

        return resultJson;

    }
    @RequestMapping(value="/emp/addEmployee",method = RequestMethod.POST)
    public @ResponseBody List<Employee>addEmployee(@RequestBody Employee emp)
    {
        System.out.println("in add");
        return employeeService.addEmployee(emp);
    }


    @RequestMapping(value="/emp/updateEmployee",method = RequestMethod.POST)
    public @ResponseBody List<Employee> updateEmployee(@RequestBody Employee emp)
    {
        System.out.println("inside update"+emp.getName());

        return employeeService.updateEmployee(emp);
    }

    @RequestMapping(value="/emp/deleteEmployee",method = RequestMethod.POST)
    public @ResponseBody List<Employee> deleteEmployee(@RequestBody String eMail)
    {
        System.out.println("deletecont");
        return employeeService.deleteEmployee(eMail);
    }

}


import java.util.List;


import com.tcs.pojo.Employee;
public interface EmployeeDAO {

    public List<Employee> getAllEmployees();
    //public Employee getEmployee(String email);
    public int addEmployee(Employee emp);
    public int  updateEmployee(Employee emp );
    public int deleteEmployee(String email);


}


import java.util.List;
import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import com.tcs.RowMapper.EmployeeRowMapper;

import com.tcs.pojo.Employee;


@Repository
public class EmployeeDAOImpl implements EmployeeDAO {

    DataSource dataSource;
    JdbcTemplate jdbcTemplate;


    @Autowired
    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
        jdbcTemplate = new JdbcTemplate(dataSource);
    }

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate)
    {System.out.println("IN DAO IMPL");
        this.jdbcTemplate = jdbcTemplate;
    }

    @Override
    public List<Employee> getAllEmployees() {
        // TODO Auto-generated method stub
        return jdbcTemplate.query("Select * from employee_1039082", new EmployeeRowMapper());
    }

//  @Override
//  public Employee getEmployee(String email) {
//      // TODO Auto-generated method stub
//      System.out.println("in dao addition");
//
//      return jdbcTemplate.queryForObject("Select * from employee_1039082 where emp_eMail = ?",new Object[]{Integer.parseInt(email)}, new EmployeeRowMapper());
//  }

    @Override
    public int addEmployee(Employee emp) {
        // TODO Auto-generated method stub
        return jdbcTemplate.update("INSERT INTO employee_1039082 VALUES (?,?,?,?)", new Object[]{emp.getName(),emp.getMobileNo(),emp.getEmail(),emp.getSchool()});
    }

    @Override
    public int updateEmployee(Employee emp) {
        return jdbcTemplate.update("UPDATE employee_1039082 set emp_name = ?, emp_mobileno=?,emp_school=? where emp_email=?", new Object[]{emp.getName(),emp.getMobileNo(),emp.getSchool(),emp.getEmail()});

    }


    @Override
    public int deleteEmployee(String email) {
        // TODO Auto-generated method stub
        return jdbcTemplate.update("DELETE from employee_1039082 where emp_email = ?", new Object[]{email});
    }

}


public class Employee {

    private String name;
    private String mobileNo;
    private String email;
    private String school;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getMobileNo() {
        return mobileNo;
    }
    public void setMobileNo(String mobileNo) {
        this.mobileNo = mobileNo;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public String getSchool() {
        return school;
    }
    public void setSchool(String school) {
        this.school = school;
    }
    public Employee(String name, String mobileNo, String email, String school) {
        super();
        this.name = name;
        this.mobileNo = mobileNo;
        this.email = email;
        this.school = school;
    }
    public Employee() {
        // TODO Auto-generated constructor stub
    }

}


package com.tcs.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.jdbc.core.RowMapper;

import com.tcs.pojo.Employee;
public class EmployeeRowMapper implements RowMapper<Employee> {

    @Override
    public Employee mapRow(ResultSet result, int rowSeq) throws SQLException {
        Employee emp= new Employee();
        emp.setName(result.getString("emp_name"));
        emp.setMobileNo(result.getString("emp_mobileno"));
        emp.setEmail(result.getString("emp_email"));
        emp.setSchool(result.getString("emp_school"));


        return emp;
    }


}


package com.tcs.service;
import java.util.List;

import com.tcs.pojo.Employee;
public interface EmployeeService {

    public List<Employee> getAllEmployee();
   // public List<Employee> getEmployee(String eMail);
    public List<Employee> addEmployee(Employee emp);
    public List<Employee> updateEmployee(Employee emp);
    public List<Employee> deleteEmployee(String eMail);


}


package com.tcs.service;

import java.util.List;

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

import com.tcs.Dao.EmployeeDAO;
import com.tcs.Dao.EmployeeDAOImpl;
import com.tcs.pojo.Employee;

@Service
public class EmployeeServiceImpl implements EmployeeService {

    @Autowired
    EmployeeDAOImpl employeeDAO;


    @Override
    public List<Employee> getAllEmployee() {
        // TODO Auto-generated method stub
        return employeeDAO.getAllEmployees();
    }

    @Override
    public List<Employee> addEmployee(Employee emp) {
        // TODO Auto-generated method stub

        employeeDAO.addEmployee(emp);
        return employeeDAO.getAllEmployees();


    }

    @Override
    public List<Employee> updateEmployee(Employee emp) {
        // TODO Auto-generated method stub

           employeeDAO.updateEmployee(emp);
        return employeeDAO.getAllEmployees();
    }

    @Override
    public List<Employee> deleteEmployee(String eMail) {
        // TODO Auto-generated method stub
        employeeDAO.deleteEmployee(eMail);

        return employeeDAO.getAllEmployees();
    }


}