cn.icuter.jsql.executor.TransactionExecutor Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of jsql Show documentation
JDBC framework for writing sql like java programing
The newest version!
package cn.icuter.jsql.executor;

import cn.icuter.jsql.builder.Builder;
import cn.icuter.jsql.exception.JSQLException;
import cn.icuter.jsql.exception.TransactionCommitException;
import cn.icuter.jsql.exception.TransactionRollbackExcetpion;
import cn.icuter.jsql.transaction.DefaultTransaction;

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

/**
 * @author edward
 * @since 2018-09-13
 */
public class TransactionExecutor extends DefaultTransaction implements JdbcExecutor {

    protected JdbcExecutor jdbcExecutor;

    public TransactionExecutor(Connection connection) {
        super(connection);
        jdbcExecutor = new DefaultJdbcExecutor(connection);
    }

    @Override
    public int execUpdate(Builder builder) throws JSQLException {
        try {
            return jdbcExecutor.execUpdate(builder);
        } catch (JSQLException e) {
            setState(State.ERROR);
            throw e;
        }
    }

    @Override
    public  List execQuery(Builder builder, Class clazz) throws JSQLException {
        try {
            return jdbcExecutor.execQuery(builder, clazz);
        } catch (JSQLException e) {
            setState(State.ERROR);
            throw e;
        }
    }

    @Override
    public List> execQuery(Builder builder) throws JSQLException {
        try {
            return jdbcExecutor.execQuery(builder);
        } catch (JSQLException e) {
            setState(State.ERROR);
            throw e;
        }
    }

    @Override
    public void execBatch(List builders) throws JSQLException {
        try {
            jdbcExecutor.execBatch(builders);
        } catch (JSQLException e) {
            setState(State.ERROR);
            throw e;
        }
    }

    @Override
    public void close() throws IOException {
        try {
            if (connection != null && !connection.isClosed()) {
                connection.close();
            }
        } catch (SQLException e) {
            try {
                setState(State.ERROR);
            } catch (JSQLException e1) {
                throw new IOException(e1);
            }
            throw new IOException(e);
        }
    }

    @Override
    public void commit() {
        try {
            super.commit();
        } catch (JSQLException e) {
            throw new TransactionCommitException(e);
        }
    }

    @Override
    public void rollback() {
        try {
            super.rollback();
        } catch (JSQLException e) {
            throw new TransactionRollbackExcetpion(e);
        }
    }

    @Override
    public void rollback(String savepointName) {
        try {
            super.rollback(savepointName);
        } catch (JSQLException e) {
            throw new TransactionRollbackExcetpion(e);
        }
    }
}