@Test
public void testExtendsResultMapSelect() throws Exception {
EmpVO vo = new EmpVO();
// 7369,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20
vo.setEmpNo(new BigDecimal(7369));
// select
EmpExtendsDeptVO resultVO =
empDAO.selectEmpExtendsDept("selectEmpExtendsDeptUsingResultMap", vo);
// check
assertNotNull(resultVO);
// resultMap extends test (extends empResult)
assertEquals(new BigDecimal(7369), resultVO.getEmpNo());
assertEquals("SMITH", resultVO.getEmpName());
assertEquals("CLERK", resultVO.getJob());
assertEquals(new BigDecimal(7902), resultVO.getMgr());
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd", java.util.Locale.getDefault());
assertEquals(sdf.parse("1980-12-17"), resultVO.getHireDate());
assertEquals(new BigDecimal(800), resultVO.getSal());
// nullValue test - <result property="comm"
// column="COMM" .. nullValue="0" />
assertEquals(new BigDecimal(0), resultVO.getComm());
assertEquals(new BigDecimal(20), resultVO.getDeptNo());
assertEquals("RESEARCH", resultVO.getDeptName());
assertEquals("DALLAS", resultVO.getLoc());
}
@Test
public void testFetchSize() throws Exception {
// 검색조건 없이 전체 EMP 리스트 조회
// select
List<EmpVO> resultList = empDAO.selectEmpList("selectEmpUsingFetchSize", null);
// check
assertNotNull(resultList);
assertEquals(14, resultList.size());
assertEquals(new BigDecimal(7369), resultList.get(0).getEmpNo());
assertEquals(new BigDecimal(7499), resultList.get(1).getEmpNo());
assertEquals(new BigDecimal(7521), resultList.get(2).getEmpNo());
assertEquals(new BigDecimal(7566), resultList.get(3).getEmpNo());
assertEquals(new BigDecimal(7654), resultList.get(4).getEmpNo());
assertEquals(new BigDecimal(7698), resultList.get(5).getEmpNo());
assertEquals(new BigDecimal(7782), resultList.get(6).getEmpNo());
assertEquals(new BigDecimal(7788), resultList.get(7).getEmpNo());
assertEquals(new BigDecimal(7839), resultList.get(8).getEmpNo());
assertEquals(new BigDecimal(7844), resultList.get(9).getEmpNo());
assertEquals(new BigDecimal(7876), resultList.get(10).getEmpNo());
assertEquals(new BigDecimal(7900), resultList.get(11).getEmpNo());
assertEquals(new BigDecimal(7902), resultList.get(12).getEmpNo());
assertEquals(new BigDecimal(7934), resultList.get(13).getEmpNo());
}
