001/* 002 * Copyright 2006-2012 the original author or authors. 003 * 004 * Licensed under the Apache License, Version 2.0 (the "License"); 005 * you may not use this file except in compliance with the License. 006 * You may obtain a copy of the License at 007 * 008 * https://www.apache.org/licenses/LICENSE-2.0 009 * 010 * Unless required by applicable law or agreed to in writing, software 011 * distributed under the License is distributed on an "AS IS" BASIS, 012 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 013 * See the License for the specific language governing permissions and 014 * limitations under the License. 015 */ 016 017package org.springframework.batch.sample.domain.trade.internal; 018 019import javax.sql.DataSource; 020 021import org.springframework.batch.sample.domain.trade.CustomerDebit; 022import org.springframework.batch.sample.domain.trade.CustomerDebitDao; 023import org.springframework.beans.factory.annotation.Autowired; 024import org.springframework.jdbc.core.JdbcOperations; 025import org.springframework.jdbc.core.JdbcTemplate; 026 027 028/** 029 * Reduces customer's credit by the provided amount. 030 * 031 * @author Robert Kasanicky 032 */ 033public class JdbcCustomerDebitDao implements CustomerDebitDao { 034 035 private static final String UPDATE_CREDIT = "UPDATE CUSTOMER SET credit= credit-? WHERE name=?"; 036 037 private JdbcOperations jdbcTemplate; 038 039 @Override 040 public void write(CustomerDebit customerDebit) { 041 jdbcTemplate.update(UPDATE_CREDIT, customerDebit.getDebit(), customerDebit.getName()); 042 } 043 044 @Autowired 045 public void setDataSource(DataSource dataSource) { 046 this.jdbcTemplate = new JdbcTemplate(dataSource); 047 } 048 049}