employeeserviceimpl.java

基于Spring、Struts2、TopLink框架及ExtJs框架设计的一个简单Web开发应用框架

package com.impl;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import com.domain.Address;
import com.domain.Employee;
import com.service.EmployeeService;

@SuppressWarnings("unchecked")
public class EmployeeServiceImpl implements	EmployeeService {

    public EntityManager em;
	
	@PersistenceContext
	public void setEntityManager(EntityManager em) {
		this.em = em;
	}
	
	@Override
	public Employee delete(long empid) {
		Employee emp = em.find(Employee.class, empid);
		if(emp != null) {
			em.remove(emp);
		}
		return emp;
	}

	@Override
	public List<Object> findAll() {
		//return this.getJpaTemplate().find("select e from Employee e");
		Query query = em.createNativeQuery("select t1.empid, t1.job, t1.education, t1.empno, t1.sex, t1.firstname, t1.lastname, t1.salary, DATE_FORMAT(t1.birthday, '%Y-%m-%d'), t2.id, t2.num, t2.stname from employee t1, address t2 where t1.addr_id=t2.id");
		List queryList = query.getResultList();
		List<Object> result = new ArrayList<Object>();
		for(List<?> list : (List<List<?>>)queryList) {
			Map <String, Object> maps = new HashMap<String, Object>();
			maps.put("empid", list.get(0));
			maps.put("job", list.get(1));
			maps.put("education", list.get(2));
			maps.put("empno", list.get(3));
			maps.put("sex", list.get(4));
			maps.put("firstname", list.get(5));
			maps.put("lastname", list.get(6));
			maps.put("salary", list.get(7));
			maps.put("birthday", list.get(8));
			maps.put("id", list.get(9));
			maps.put("num", list.get(10));
			maps.put("stname", list.get(11));
			result.add(maps);
		}
		//Query query = em.createQuery("select e from Employee e");
		return result;
	}

	@Override
	public List findByAddressStreetName(String street) {
		//return this.getJpaTemplate().find("select e from Employee e where e.addr.street = ?1", street);
		Query query = em.createQuery("select e from Employee e where e.addr.street = ?1");
		query.setParameter(1, street);
		return query.getResultList();
	}

	@Override
	public List findByEmployeeLastName(String lastName) {
		//return this.getJpaTemplate().find("select e from Employee e where e.lastName = ?1", lastName);
		Query query = em.createQuery("select e from Employee e where e.lastName = ?1");
		query.setParameter(1, lastName);
		return query.getResultList();
	}

	@Override
	public List findByEmployeeNumber(String empno) {
		//return this.getJpaTemplate().find("select e from Employee e where e.empno = ?1", empno);
		Query query = em.createQuery("select e from Employee e where e.empno = ?1");
		query.setParameter(1, empno);
		return query.getResultList();
	}

	@Override
	public Employee findById(long id) {
		//return this.getJpaTemplate().find(Employee.class, id);
		return em.find(Employee.class, id);
	}

	@Override
	public Employee save(Employee emp) {
		//this.getJpaTemplate().persist(emp);
		em.persist(emp);
		return emp;
	}

	@Override
	public Employee update(Employee emp, long empid, long id) {
		//return this.getJpaTemplate().merge(emp);
		Employee employee = em.find(Employee.class, empid);
		if(employee != null) {
			employee.setEmpno(emp.getEmpno());
			employee.setBirthday(emp.getBirthday());
			employee.setEducation(emp.getEducation());
			employee.setFirstName(emp.getFirstName());
			employee.setLastName(emp.getLastName());
			employee.setJob(emp.getJob());
			employee.setSalary(emp.getSalary());
			employee.setSex(emp.getSex());
			Address address = em.find(Address.class, id);
			address.setNumber(emp.getAddr().getNumber());
			address.setStreet(emp.getAddr().getStreet());
			return employee;
		}else {
			return null;
		}				
	}

}