Portfolio


@Override
	public int update(String sql, Map<String, ?> paramMap) throws DataAccessException {
		return update(sql, new MapSqlParameterSource(paramMap));
	}


/**
	 * Issue an update via a prepared statement, binding the given arguments.
	 * @param sql the SQL containing named parameters
	 * @param paramSource container of arguments and SQL types to bind to the query
	 * @return the number of rows affected
	 * @throws DataAccessException if there is any problem issuing the update
	 */
	int update(String sql, SqlParameterSource paramSource) throws DataAccessException;


@Override
    public Optional<Voucher> insert(Voucher voucher) {
        try {
            var executeUpdate = jdbcTemplate.update("INSERT INTO vouchers(" +
                            "voucher_id, name, type, discount_num, created_at) " +
                            "VALUES (UUID_TO_BIN(:voucherId), :name, :type, :discountNum, :createdAt)",
                    toParamMap(voucher));

            if (executeUpdate != 1) {
                return Optional.empty();
            }

            return Optional.of(voucher);
        } catch (DuplicateKeyException e) {
            logger.error("Failed insert", e);
            return Optional.empty();
        }
    }


		@Override
    public int delete(Wallet wallet) {
        var executeUpdate = jdbcTemplate.update(
                "DELETE FROM wallets WHERE wallet_id = UUID_TO_BIN(:walletId)",
                toParamMap(wallet));

        return executeUpdate;
    }

JdbcTemplate에서 udpate시 성공여부를 어떻게 확인해야 할까?

정리