com.jn.sqlhelper.mybatis.batch.JdbcBatchUpdater Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of sqlhelper-mybatis Show documentation
Supports mybatis (an ORM framework)
There is a newer version: 5.0.9
/*
 * 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.mybatis.batch;

import com.jn.langx.util.Preconditions;
import com.jn.sqlhelper.common.batch.BatchMode;
import com.jn.sqlhelper.common.batch.BatchResult;
import com.jn.sqlhelper.common.ddl.model.DatabaseDescription;
import org.apache.ibatis.session.ExecutorType;
import org.apache.ibatis.session.SqlSession;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public class JdbcBatchUpdater extends MybatisBatchUpdater {
    private static final Logger logger = LoggerFactory.getLogger(JdbcBatchUpdater.class);

    @Override
    public BatchResult batchUpdate(MybatisBatchStatement statement, List entities) throws SQLException {
        Preconditions.checkNotNull(statement);
        Preconditions.checkArgument(statement.getBatchMode() == BatchMode.JDBC_BATCH);
        Preconditions.checkNotNull(sessionFactory);

        SqlSession session = sessionFactory.openSession(ExecutorType.BATCH);
        Connection connection = session.getConnection();
        DatabaseDescription databaseDescription = new DatabaseDescription(connection.getMetaData());
        if (!databaseDescription.supportsBatchUpdates()) {
            logger.warn("The database is not supports jdbc update");
            throw new UnsupportedOperationException("batch update");
        }
        BatchResult result = new BatchResult();
        result.setParameters(entities);
        result.setStatement(statement);

        String statementId = statement.getStatementId();
        String statementIdFQN = statement.getSql();
        int affectedRows = 0;

        // 对于mybatis batch executor 来说，insert, update, delete的返回值是负数，没有意义
        try {
            for (E entity : entities) {
                try {
                    if (statementId.contains(INSERT)) {
                        session.insert(statementIdFQN, entity);
                    } else if (statementId.contains(UPDATE)) {
                        session.update(statementIdFQN, entity);
                    } else if (statementId.contains(DELETE)) {
                        session.delete(statementIdFQN, entity);
                    } else {
                        session.update(statementIdFQN, entity);
                    }
                } catch (Exception ex) {
                    logger.error("Error occur when execute batch statement: {} with parameter: {}", statementIdFQN, entity.toString());
                    result.addThrowable(ex);
                }
                affectedRows = affectedRows + 1;
            }
            session.commit(false);
        } catch (Exception ex) {
            logger.error("Error occur when execute batch statement: {} \n", statementIdFQN, ex);
            result.addThrowable(ex);
            session.rollback(true);
            affectedRows = 0;
        } finally {
            session.close();
        }
        result.setRowsAffected(affectedRows);
        return result;
    }
}