@Override public void edit(AcademicKPI domain) { logger.info("domain : " + BeanUtils.getBeanString(domain)); this.jdbcTemplate.update( "update academic_kpi set name=?,mark=?,unit_code=? ,rule_code=? ,order_no=?,description=? ," + " special_p1=?, special_p2=?, special_p3=?, special_p4=?, total_student_from=?, total_student_to=?,from_reg=? where academic_kpi_id=? ", domain.getName(), domain.getMark(), domain.getUnitCode(), domain.getMultiplyValue(), domain.getOrderNo(), domain.getDescription(), domain.getSpecialP1(), domain.getSpecialP2(), domain.getSpecialP3(), domain.getSpecialP4(), domain.getTotalStudentFrom(), domain.getTotalStudentTo(), domain.getFromRegis(), domain.getAcademicKPIId()); List<AcademicKPIAttribute> academicKPIAttributeList = domain.getAcademicKPIAttributeList(); if (academicKPIAttributeList != null && academicKPIAttributeList.size() > 0) { for (AcademicKPIAttribute tmp : academicKPIAttributeList) { logger.info(" checkValue:" + tmp.getIsCalculate()); String isCheckFlage = "on".equalsIgnoreCase(tmp.getIsCalculate()) ? "Y" : "N"; String isCheckFlage2 = "on".equalsIgnoreCase(tmp.getIsValidateNumber()) ? "Y" : "N"; logger.info( " Name :" + tmp.getName() + " isCal:" + isCheckFlage + " isValidateNumber:" + isCheckFlage2); this.jdbcTemplate.update( "update academic_kpi_attribute set name=?, is_calculate=?,is_validate_number=? where kpi_attribute_id=? ", tmp.getName(), isCheckFlage, isCheckFlage2, tmp.getAcademicKPIAtributeId()); } } }