001/* 002 * Copyright 2006-2014 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 */ 016package org.springframework.batch.sample.domain.trade.internal; 017 018import java.math.BigDecimal; 019import java.sql.PreparedStatement; 020import java.sql.SQLException; 021 022import org.springframework.batch.item.database.ItemPreparedStatementSetter; 023import org.springframework.batch.sample.domain.trade.CustomerCredit; 024 025/** 026 * @author Dave Syer 027 * 028 */ 029public class CustomerCreditUpdatePreparedStatementSetter implements ItemPreparedStatementSetter<CustomerCredit> { 030 public static final BigDecimal FIXED_AMOUNT = new BigDecimal(1000); 031 public static final String QUERY = "UPDATE CUSTOMER SET CREDIT=? WHERE ID=?"; 032 033 /* (non-Javadoc) 034 * @see org.springframework.batch.io.support.ItemPreparedStatementSetter#setValues(java.lang.Object, java.sql.PreparedStatement) 035 */ 036 @Override 037 public void setValues(CustomerCredit customerCredit, PreparedStatement ps) throws SQLException { 038 ps.setBigDecimal(1, customerCredit.getCredit().add(FIXED_AMOUNT)); 039 ps.setLong(2, customerCredit.getId()); 040 } 041}