Java tutorial
/* * Copyright 2012,2015 agwlvssainokuni * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package cherry.foundation.etl; import java.io.IOException; import java.util.Map; import javax.sql.DataSource; import org.springframework.jdbc.core.ResultSetExtractor; import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate; /** * */ public class ExtractorImpl implements Extractor { /** * ? * * @param dataSource * @param sql SQL * @param paramMap ? * @param consumer ?? * @param limiter ? * @return ???? * @throws LimiterException ?? * @throws IOException ? */ @Override public long extract(DataSource dataSource, String sql, Map<String, ?> paramMap, Consumer consumer, Limiter limiter) throws LimiterException, IOException { NamedParameterJdbcTemplate template = new NamedParameterJdbcTemplate(dataSource); ResultSetExtractor<Long> extractor = new ExtractorResultSetExtractor(consumer, limiter); limiter.start(); try { return template.query(sql, paramMap, extractor); } catch (IllegalStateException ex) { throw (IOException) ex.getCause(); } finally { limiter.stop(); } } }