org.hlc.quickdb.executor.statement.PreparedStatementHandler.java Source code

Introduction

Here is the source code for org.hlc.quickdb.executor.statement.PreparedStatementHandler.java

Source

/*
 * Copyright 2002-2013 the original author or authors.
 *
 * 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 org.hlc.quickdb.executor.statement;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Iterator;
import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hlc.quickdb.builder.SqlSource;
import org.hlc.quickdb.exception.PersistenceException;
import org.hlc.quickdb.executor.parameter.StatementParameter;
import org.hlc.quickdb.executor.result.ResultHandler;

/**
 * 
 * PreparedStatement{@link StatementHandler}?
 * 
 * @author huanglicong
 * @version V1.0
 */
public class PreparedStatementHandler implements StatementHandler {

    protected final Log logger = LogFactory.getLog(getClass());
    private SqlSource sql;

    public PreparedStatementHandler(SqlSource sql) {
        this.sql = sql;
    }

    @Override
    public Statement prepare(Connection connection) throws SQLException {
        return connection.prepareStatement(sql.getSql());
    }

    public void batchParameterize(Statement statement) throws SQLException {
        PreparedStatement preparedStatement = ((PreparedStatement) statement);
        if (logger.isDebugEnabled()) {
            logger.debug(sql);
        }
        Iterator<StatementParameter[]> iterator = sql.iterator();
        StatementParameter[] temps = null;
        while (iterator.hasNext()) {
            temps = iterator.next();
            for (StatementParameter item : temps) {
                item.parameterize(statement);
            }
            preparedStatement.addBatch();
        }
    }

    @Override
    public int[] batch(Statement statement) throws SQLException {
        if (statement instanceof PreparedStatement) {
            batchParameterize(statement);
            return ((PreparedStatement) statement).executeBatch();
        }
        throw new PersistenceException(statement.getClass() + "?PreparedStatement");
    }

    public void parameterize(Statement statement) throws SQLException {
        Iterator<StatementParameter[]> iterator = sql.iterator();
        StatementParameter[] temps = null;
        if (iterator.hasNext()) {
            temps = iterator.next();
            for (StatementParameter item : temps) {
                item.parameterize(statement);
            }
        }
    }

    @Override
    public int update(Statement statement) throws SQLException {

        if (statement instanceof PreparedStatement) {
            parameterize(statement);
            return ((PreparedStatement) statement).executeUpdate();
        }
        throw new PersistenceException(statement.getClass() + "?PreparedStatement");
    }

    @Override
    public <E> List<E> query(Statement statement, ResultHandler<E> resultHandler) throws SQLException {

        if (statement instanceof PreparedStatement) {
            parameterize(statement);
            ResultSet resultSet = ((PreparedStatement) statement).executeQuery();
            return resultHandler.handleResult(resultSet);
        }
        throw new PersistenceException(statement.getClass() + "?PreparedStatement");
    }

}