/*
* CDDL HEADER START
*
* The contents of this file are subject to the terms of the
* Common Development and Distribution License (the "License").
* You may not use this file except in compliance with the License.
*
* See LICENSE.txt included in this distribution for the specific
* language governing permissions and limitations under the License.
*
* When distributing Covered Code, include this CDDL HEADER in each
* file and include the License file at LICENSE.txt.
* If applicable, add the following below this CDDL HEADER, with the
* fields enclosed by brackets "[]" replaced with your own identifying
* information: Portions Copyright [yyyy] [name of copyright owner]
*
* CDDL HEADER END
*/
/*
* Copyright 2009 Sun Microsystems, Inc. All rights reserved.
* Use is subject to license terms.
*/
package org.opensolaris.opengrok.jdbc;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* A {@code StatementCreator} for statements that create {@code ResultSet}s
* with specified type, concurrency and holdability.
*/
public final class PreparedQuery extends StatementCreator {
private final String sql;
private final int resultSetType;
private final int resultSetConcurrency;
private final int resultSetHoldability;
/**
* Creator for a statement which returns forward-only, read-only,
* non-holdable result sets.
*
* @param sql the SQL text for the statement
*/
public PreparedQuery(String sql) {
this(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
}
/**
* Creator for a statement which returns non-holdable result sets with
* the specified type and concurrency.
*
* @param sql the SQL text for the statement
* @param resultSetType the type of the result set
* @param resultSetConcurrency the concurrency of the result set
*/
public PreparedQuery(String sql, int resultSetType,
int resultSetConcurrency) {
this(sql, resultSetType, resultSetConcurrency,
ResultSet.CLOSE_CURSORS_AT_COMMIT);
}
/**
* Creator for a statement which returns result sets with the specified
* type, concurrency and holdability.
*
* @param sql the SQL text for the statement
* @param resultSetType the type of the result set
* @param resultSetConcurrency the concurrency of the result set
* @param resultSetHoldability the holdability of the result set
*/
public PreparedQuery(String sql, int resultSetType,
int resultSetConcurrency, int resultSetHoldability) {
this.sql = sql;
this.resultSetType = resultSetType;
this.resultSetConcurrency = resultSetConcurrency;
this.resultSetHoldability = resultSetHoldability;
}
@Override
PreparedStatement create(Connection conn) throws SQLException {
return conn.prepareStatement(
sql, resultSetType, resultSetConcurrency, resultSetHoldability);
}
}