@Override public AcademicKPIAttribute mapRow(ResultSet rs, int rowNum) throws SQLException { AcademicKPIAttribute domain = new AcademicKPIAttribute(); domain.setAcademicKPIAtributeId(rs.getLong("kpi_attribute_id")); domain.setAcademicKPIId(rs.getLong("academic_kpi_id")); domain.setName(rs.getString("name")); domain.setCode(rs.getString("code")); domain.setAcademicKPICode(rs.getString("academic_kpi_code")); domain.setIsCalculate(rs.getString("is_calculate")); domain.setIsValidateNumber(rs.getString("is_validate_number")); domain.setAcademicYear(rs.getString("academic_year")); domain.setMandatory(rs.getString("mandatory")); return domain; }
@Override public Long create(AcademicKPI domain) { logger.info("domain : " + BeanUtils.getBeanString(domain)); final int nexCode = generateCodeUtil.getNextaAcademicKPI(domain); final AcademicKPI finalDomain = domain; KeyHolder keyHolder = new GeneratedKeyHolder(); jdbcTemplate.update( new PreparedStatementCreator() { public PreparedStatement createPreparedStatement(Connection connection) throws SQLException { PreparedStatement ps = connection.prepareStatement( "" + " insert into academic_kpi (name, code,work_type_code,mark,academic_year,unit_code,rule_code,order_no,description) values (?, ?,?,?,?,?,?,?,?)" + "", Statement.RETURN_GENERATED_KEYS); ps.setString(1, finalDomain.getName()); ps.setInt(2, nexCode); ps.setInt(3, new Integer(finalDomain.getWorkTypeCode())); ps.setBigDecimal(4, finalDomain.getMark()); ps.setString(5, finalDomain.getAcademicYear()); ps.setInt(6, new Integer(finalDomain.getUnitCode())); ps.setString(7, finalDomain.getMultiplyValue()); ps.setInt(8, new Integer(finalDomain.getOrderNo())); ps.setString(9, finalDomain.getDescription()); return ps; } }, keyHolder); Long returnid = keyHolder.getKey().longValue(); AcademicKPIAttribute academicKPIAttribute = new AcademicKPIAttribute(); academicKPIAttribute.setAcademicKPICode(nexCode + ""); academicKPIAttribute.setAcademicKPIId(returnid); academicKPIAttribute.setName("���ͧҹ"); // academicKPIAttribute.setMandatory("Y"); academicKPIAttribute.setAcademicYear(finalDomain.getAcademicYear()); addNewAttribute(academicKPIAttribute); return returnid; }