public Platform mapRow(ResultSet rs, int rowNum) throws SQLException {
Platform p = new PlatformImpl();
p.setPlatformId(rs.getLong("platformId"));
p.setPlatformType(PlatformType.get(rs.getString("name")));
p.setDescription(rs.getString("description"));
p.setInstrumentModel(rs.getString("instrumentModel"));
p.setNumContainers(rs.getInt("numContainers"));
return p;
}
public long save(Platform platform) throws IOException {
// execute this procedure...
MapSqlParameterSource params = new MapSqlParameterSource();
params
.addValue("name", platform.getPlatformType().getKey())
.addValue("instrumentModel", platform.getInstrumentModel())
.addValue("description", platform.getDescription())
.addValue("numContainers", platform.getNumContainers());
if (platform.getPlatformId() == null) {
SimpleJdbcInsert insert =
new SimpleJdbcInsert(template)
.withTableName(TABLE_NAME)
.usingGeneratedKeyColumns("platformId");
Number newId = insert.executeAndReturnKey(params);
platform.setPlatformId(newId.longValue());
} else {
params.addValue("platformId", platform.getPlatformId());
NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
namedTemplate.update(PLATFORM_UPDATE, params);
}
return platform.getPlatformId();
}