Here you can find the source of fillParameters(PreparedStatement stmt, List
| Parameter | Description |
|---|---|
| stmt | the prepared statement |
| params | the parameter objects |
| Parameter | Description |
|---|---|
| SQLException | if something goes wrong |
public static void fillParameters(PreparedStatement stmt, List<Object> params) throws SQLException
//package com.java2s; /*/*from w w w.ja v a 2 s .c o m*/ * This library is part of OpenCms - * the Open Source Content Management System * * Copyright (c) Alkacon Software GmbH (http://www.alkacon.com) * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * For further information about Alkacon Software, please see the * company website: http://www.alkacon.com * * For further information about OpenCms, please see the * project website: http://www.opencms.org * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.List; public class Main { /** * Fills a given prepared statement with parameters from a list of objects.<p> * * @param stmt the prepared statement * @param params the parameter objects * * @throws SQLException if something goes wrong */ public static void fillParameters(PreparedStatement stmt, List<Object> params) throws SQLException { int i = 1; for (Object param : params) { if (param instanceof String) { stmt.setString(i, (String) param); } else if (param instanceof Integer) { stmt.setInt(i, ((Integer) param).intValue()); } else if (param instanceof Long) { stmt.setLong(i, ((Long) param).longValue()); } else { throw new IllegalArgumentException(); } i += 1; } } }