@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()); }