com.jn.sqlhelper.common.batch.xjdbc.JdbcBatchUpdater Maven / Gradle / Ivy
/*
* Copyright 2019 the original author or authors.
*
* Licensed under the LGPL, Version 3.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.gnu.org/licenses/lgpl-3.0.html
*
* 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 com.jn.sqlhelper.common.batch.xjdbc;
import com.jn.langx.util.Preconditions;
import com.jn.langx.util.io.IOs;
import com.jn.sqlhelper.common.batch.BatchResult;
import com.jn.sqlhelper.common.batch.BatchStatement;
import com.jn.sqlhelper.common.batch.BatchMode;
import com.jn.sqlhelper.common.batch.BatchUpdater;
import com.jn.sqlhelper.common.statement.PreparedStatementSetter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;
public class JdbcBatchUpdater implements BatchUpdater {
Connection connection;
PreparedStatementSetter setter;
@Override
public BatchResult batchUpdate(S statement, List parametersList) throws SQLException {
Preconditions.checkNotNull(statement);
Preconditions.checkArgument(statement.getBatchMode() == BatchMode.JDBC_BATCH);
PreparedStatement pstmt = null;
try {
pstmt = connection.prepareStatement(statement.getSql());
for (int i = 0; i < parametersList.size(); i++) {
setter.setParameters(pstmt, 1, parametersList.get(i));
pstmt.addBatch();
}
int[] updateds = pstmt.executeBatch();
BatchResult result = new BatchResult();
result.setParameters(parametersList);
result.setStatement(statement);
result.setRowsAffected(updateds[0]);
return result;
}finally {
IOs.close(pstmt);
}
}
}