Here you can find the source of getPreparedStatement(Connection conn, String sql, List
public static PreparedStatement getPreparedStatement(Connection conn, String sql, List<Object> sqlParams, boolean getGeneratedKeys) throws IOException, SQLException
//package com.java2s; /**/*from w ww. jav a 2s .co m*/ * Licensed to the Apache Software Foundation (ASF) under one * or more contributor license agreements. See the NOTICE file * distributed with this work for additional information * regarding copyright ownership. The ASF 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.io.IOException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import java.sql.Statement; import java.util.List; public class Main { public static PreparedStatement getPreparedStatement(Connection conn, String sql, List<Object> sqlParams, boolean getGeneratedKeys) throws IOException, SQLException { PreparedStatement pstmt = getGeneratedKeys ? conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS) : conn.prepareStatement(sql); int pos = 1; for (Object param : sqlParams) { if (param instanceof Integer) { pstmt.setInt(pos++, ((Integer) param).intValue()); } else { pstmt.setString(pos++, (String) param); } } return pstmt; } }