Java SQL PreparedStatement substitute(PreparedStatement stmt, Object[] params)

Description

Substitute prepared stmt query parameters

License

Apache License

Parameter

Parameter	Description
stmt	a parameter
params	a parameter

Declaration

public static void substitute(PreparedStatement stmt, Object[] params) throws SQLException 

Method Source Code

//package com.java2s;
/****************************************************************
 * Licensed to the AOS Community (AOS) under one or more        *
 * contributor license agreements.  See the NOTICE file         *
 * distributed with this work for additional information        *
 * regarding copyright ownership.  The AOS licenses this file   *
 * to you 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.                                           *
 ****************************************************************/

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class Main {
    /**/*from w  w  w.  j  a  v  a  2  s. c  o  m*/
     * Substitute prepared stmt query parameters
     * 
     * @param stmt
     * @param params
     */
    public static void substitute(PreparedStatement stmt, Object[] params) throws SQLException {
        for (int i = 0; i < params.length; ++i) {
            stmt.setObject(i + 1, params[i]);
        }
    }
}

Related

1. setValueIndex(PreparedStatement stmt, int index, int valueIndex)
2. setValues(PreparedStatement preparedStatement, Object... values)
3. setValues(PreparedStatement statement, Object... values)
4. setValues(PreparedStatement statement, Object... values)
5. setValues(PreparedStatement statement, Object[] values)
6. writeArray(Connection connection, PreparedStatement preparedStatement, int column, Class type, T[] array)
7. writeList(Connection connection, PreparedStatement preparedStatement, int column, Class type, List list)
8. writeMap(Connection connection, PreparedStatement preparedStatement, int keyColumn, int valueColumn, Class keyType, Class valueType, Map map)
9. writeProperties(Connection connection, PreparedStatement preparedStatement, int keyColumn, int valueColumn, Properties properties)