ru.curs.celesta.dbutils.stmt.PreparedStmtHolder Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of celesta-core Show documentation
The newest version!
package ru.curs.celesta.dbutils.stmt;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import ru.curs.celesta.CelestaException;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

/**
 * A container for parameterized prepared statement.
 */
public abstract class PreparedStmtHolder {

    private static final Logger LOGGER = LoggerFactory.getLogger(PreparedStmtHolder.class);

    private PreparedStatement stmt;
    private final List program = new ArrayList<>();

    /**
     * Whether statement is valid.
     *
     */
    public synchronized boolean isStmtValid()  {
        try {
            return !(stmt == null || stmt.isClosed());
        } catch (SQLException e) {
            throw new CelestaException(e.getMessage(), e);
        }
    }

    /**
     * Returns prepared statement with refreshed parameters.
     *
     * @param rec         Array of record fields' values.
     * @param recversion  record version
     *
     */
    public synchronized PreparedStatement getStatement(Object[] rec, int recversion) {
        if (!isStmtValid()) {
            program.clear();
            stmt = initStatement(program);
            // everything should be initialized at this point
            if (!isStmtValid()) {
                throw new IllegalStateException();
            }
        }
        int i = 1;
        for (ParameterSetter f : program) {
            f.execute(stmt, i++, rec, recversion);
        }
        LOGGER.trace("{}", stmt);
        return stmt;
    }

    /**
     * Closes the statement.
     */
    public synchronized void close() {
        try {
            if (stmt != null) {
                stmt.close();
            }
        } catch (SQLException e) {
            e = null;
        }
        stmt = null;
        program.clear();
    }

    protected abstract PreparedStatement initStatement(List program);

}