Description

put Args To Statement

License

Apache License

Declaration

private static void putArgsToStatement(PreparedStatement stmt, List<Object> args) throws SQLException 

Method Source Code

//package com.java2s;
/**/*from   w ww.ja  v  a 2s  .co m*/
 *  Copyright 2009 Welocalize, Inc. 
 *  
 *  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.PreparedStatement;

import java.sql.SQLException;

import java.util.List;

public class Main {
    private static void putArgsToStatement(PreparedStatement stmt, List<Object> args) throws SQLException {
        if (args != null) {
            for (int i = 0; i < args.size(); i++) {
                stmt.setObject(i + 1, args.get(i));
            }
        }
    }
}

Related

1. prepareStatement(Connection connection, String sql, Object... values)
2. prepareStatement(String parameterizedSQL, List values, Connection conn)
3. prepareStatement(String parameterizedSQL, List