employeeserviceintegrationtest.java

JPA最好的

package com.ibm.dw.spring2;

import java.util.Date;
import java.util.List;

import org.springframework.test.jpa.AbstractJpaTests;


public class EmployeeServiceIntegrationTest extends AbstractJpaTests {

	private EmployeeService employeeService;

	private long JoeSmithId = 99999;

	public void setEmployeeService(EmployeeService employeeService) {
		this.employeeService = employeeService;
	}

	protected String[] getConfigLocations() {
		return new String[] { "classpath:/com/ibm/dw/spring2/dwspring2-service.xml" };
	}

	protected void onSetUpInTransaction() throws Exception {
		Employee emp1 = new Employee("0001", "Joe", "R","Smith", 
				 "4853", "Engineer", 3, 'M',
			     20000.00, 0.00, 0.00,
		 	     new Address(10, "Walker Street")
			     , new Date(), new Date());
		Employee emp2 = new Employee("0002", "John","T","Lockheed", 
				"4333", "Sales", 2, 'M',
				40000.00, 0.00, 5000.00,
				new Address(20, "Walker Street")
				, new Date(), new Date());
		Employee emp3 = new Employee("0003", "Mary","M","Johnson", 
				"4383", "Admin", 3, 'F',
				60000.00, 0.00, 390.00,
				new Address(123, "Booth Ave")
				, new Date(), new Date());
				
		employeeService.save(emp1);
		employeeService.save(emp2);
		employeeService.save(emp3);

		JoeSmithId = emp1.getEmpid();
	}

	public void testFindByEmployeeId() {
		Employee emp = employeeService.findById(JoeSmithId);
		assertNotNull(emp);
		assertEquals("Joe", emp.getFirstName());
	}

	public void testFindByEmployeeIdBadId() {
		Employee emp = employeeService.findById(99999);
		assertNull(emp);
	}

	public void testFindByEmployeeNum() {
		List<Employee> emps = employeeService.findByEmployeeNumber("0002");
		assertEquals(1, emps.size());
		Employee emp = emps.get(0);
		assertEquals("John", emp.getFirstName());
	}

	public void testFindByEmployeeNumBadNum() {
		List<Employee> emps = employeeService.findByEmployeeNumber("0099");
		assertEquals(0, emps.size());
	}

	public void testFindByLastName() {
		List<Employee> emps = employeeService
				.findByEmployeeLastName("Johnson");
		assertEquals(1, emps.size());
		Employee emp = emps.get(0);
		assertEquals("0003", emp.getEmpno());
	}

	public void testFindByNameWhereRestaurantDoesNotExist() {
		List<Employee> emps = employeeService
				.findByEmployeeLastName("Higgins");
		assertEquals(0, emps.size());
	}

	public void testFindByStreetName() {
		List<Employee> emps = employeeService
				.findByAddressStreetName("Walker Street");
		assertEquals(2, emps.size());
	}

	public void testFindByStreetNameBadName() {
		List<Employee> emps = employeeService
				.findByAddressStreetName("Yonge Street");
		assertEquals(0, emps.size());
	}

	public void testFindBySalary() {
		List<Employee> emps = employeeService
				.findEmployeeWithSalaryOver(50000.00);
		assertEquals(1, emps.size());

	}

	public void testFindBySalaryOutOfRange() {
		List<Employee> emps = employeeService
				.findEmployeeWithSalaryOver(80000.00);
		assertEquals(0, emps.size());

	}

	public void testFindByCommission() {
		List<Employee> emps = employeeService
				.findEmployeeWithCommissionOver(1000.00);
		assertEquals(1, emps.size());

	}

	public void testFindByCommissionOutOfRange() {
		List<Employee> emps = employeeService
				.findEmployeeWithCommissionOver(8000.00);
		assertEquals(0, emps.size());

	}

	public void testModifyEmployee() {
		String oldLastName = "Lockheed";
		String newLastName = "Williams";
		Employee emp = employeeService
				.findByEmployeeLastName(oldLastName).get(0);
		emp.setLastName(newLastName);
		
		Employee emp2 = employeeService.update(emp);
		assertEquals(newLastName, emp2.getLastName());

		List<Employee> results = employeeService
				.findByEmployeeLastName(oldLastName);
		assertEquals(0, results.size());

		results = results = employeeService
				.findByEmployeeLastName(newLastName);
		assertEquals(1, results.size());

	}

	public void testDeleteEmployeeCascade() {
		String empName = "Lockheed";
		Employee emp = employeeService.findByEmployeeLastName(empName).get(0);
		int empCountBefore = countRowsInTable("employee");
		int addrCountBefore = countRowsInTable("address");
		employeeService.delete(emp);
		List<Employee>  res = employeeService.findByEmployeeLastName(empName);
		assertEquals(0, res.size());
		int empCountAfter = countRowsInTable("employee");
		int addrCountAfter = countRowsInTable("address");
		assertEquals(empCountBefore -1, empCountAfter);
		assertEquals(addrCountBefore -1, addrCountAfter);
		
	}
	public void testFindAll() {
		List<Employee> emps = employeeService.findAll();
		assertEquals(3, emps.size());
	}
}