Java SQL Query getStatement(Connection con, String query, Object... bits)

Description

get Statement

License

Apache License

Declaration

static PreparedStatement getStatement(Connection con, String query, Object... bits) throws SQLException 

Method Source Code

//package com.java2s;
/*//from  w w w.j ava  2 s .c  om
 * Copyright 2016 Information & Computational Sciences, The James Hutton Institute
 *
 * 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.
 */

import java.sql.*;

public class Main {
    static PreparedStatement getStatement(Connection con, String query, Object... bits) throws SQLException {
        PreparedStatement stmt = con.prepareStatement(query);

        int i = 1;
        if (bits != null) {
            for (Object bit : bits)
                stmt.setObject(i++, bit);
        }

        return stmt;
    }
}

Related

1. executeQuery2(java.sql.Connection con, String select, Object... pk)
2. executeRetrievalByIDQuery(PreparedStatement theStatement, int theID)
3. executeSafeQuery( Connection conn, String sql)
4. executeStatement(Connection connection, String query)
5. getSqlQuery(Statement statement, Object[] args)
6. query(Connection conn, String sql)
7. query(Connection conn, String sql, Object[] params, Class beanClass)
8. query(Connection connection, String sql, boolean isClose, Object... params)
9. queryForList(Connection conn, String sql, int limit)