public License save(License license) throws SQLException {
try (Connection conn = ds.getConnection()) {
PreparedStatement statement =
conn.prepareStatement(
"INSERT INTO License (productId, releaseId, customerId, contractNumber, state, predecessorLicenseId, "
+ "validFrom, validTill, applicationSubmitDate) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
statement.setInt(1, license.getProduct().getId());
if (license.getRelease() == null) {
statement.setNull(2, java.sql.Types.INTEGER);
} else {
statement.setInt(2, license.getRelease().getId());
}
statement.setInt(3, license.getCustomer().getId());
statement.setString(4, license.getContractNumber());
statement.setInt(5, license.getState().getStateNumber());
statement.setString(6, license.getPredecessorLicenseId());
statement.setDate(7, license.getValidFrom());
statement.setDate(8, license.getValidTill());
// statement.setInt(9, license.getType().getId());
statement.setDate(9, license.getApplicationSubmitDate());
statement.execute();
try (ResultSet generatedKeys = statement.getGeneratedKeys()) {
if (generatedKeys.next()) {
license.setId(generatedKeys.getInt(1));
}
}
}
return license;
}
