@Override public AcademicKPI mapRow(ResultSet rs, int rowNum) throws SQLException { AcademicKPI domain = new AcademicKPI(); domain.setAcademicKPIId(rs.getLong("academic_kpi_id")); domain.setName(rs.getString("name")); domain.setCode(rs.getString("code")); domain.setWorkTypeCode(rs.getString("work_type_code")); domain.setDescription(rs.getString("description")); domain.setStatus(rs.getString("status")); domain.setAcademicYear(rs.getString("academic_year")); domain.setMark(rs.getBigDecimal("mark")); domain.setUnitCode(rs.getString("unit_code")); domain.setMultiplyValue(rs.getString("rule_code")); domain.setOrderNo(rs.getString("order_no")); domain.setSpecialP1(rs.getString("special_p1")); domain.setSpecialP2(rs.getString("special_p2")); domain.setSpecialP3(rs.getString("special_p3")); domain.setSpecialP4(rs.getString("special_p4")); domain.setTotalStudentFrom(rs.getString("total_student_from")); domain.setTotalStudentTo(rs.getString("total_student_to")); domain.setFromRegis(rs.getString("from_reg")); // logger.info(" ###### Multiply Value:"+rs.getString("rule_code")); try { domain.setUnitDesc( schoolUtil.getUnitDescMyCode(rs.getString("unit_code"), rs.getString("academic_year"))); } catch (org.springframework.dao.EmptyResultDataAccessException ex) { ex.printStackTrace(); } return domain; }