String sql = "insert into T_REWARD (CONFIRMATION_NUMBER, REWARD_AMOUNT, REWARD_DATE, ACCOUNT_NUMBER, DINING_MERCHANT_NUMBER, DINING_DATE, DINING_AMOUNT) values (?, ?, ?, ?, ?, ?, ?)";
String confirmationNumber = nextConfirmationNumber();
getSimpleJdbcTemplate().update(sql, confirmationNumber, contribution.getAmount().asBigDecimal(),
SimpleDate.today().asDate(), contribution.getAccountNumber(), dining.getMerchantNumber(),
dining.getDate().asDate(), dining.getAmount().asBigDecimal());
return new RewardConfirmation(confirmationNumber, contribution);
}