Convenience method to set an array of arguments on the prepared statement PreparedStatement. - Java java.sql

Java examples for java.sql:PreparedStatement

  1. HOME
  2. Java
  3. java.sql
  4. PreparedStatement

Description

Convenience method to set an array of arguments on the prepared statement PreparedStatement.

Demo Code


//package com.java2s;
import java.sql.*;

import java.util.*;

public class Main {
    /**/*from  w  w w  . j  a  va  2s  . c  o m*/
     * Convenience method to set an array of arguments on the prepared
     * statement.
     *
     * @param stmt
     *            Set the arguments on this statement.
     * @param arguments
     *            Array of arguments.
     * @throws SQLException
     *             If a database access error occurs.
     */
    public static void setArguments(final PreparedStatement stmt,
            final List<Object> arguments) throws SQLException {
        int index = 1;
        for (final Object argument : arguments) {
            setArgument(stmt, argument, index++);
        }
    }

    /**
     * Sets the argument on the prepared statement with the correct type setter.
     *
     * @param stmt
     *            Set the argument on this statement.
     * @param argument
     *            Argument to set.
     * @param index
     *            The position of the argument in the query.
     * @throws SQLException
     *             If a database access error occurs.
     */
    private static void setArgument(final PreparedStatement stmt,
            final Object argument, final int index) throws SQLException {
        if (argument == null) {
            stmt.setNull(index, Types.NULL);
        } else if (argument instanceof Integer) {
            stmt.setInt(index, (Integer) argument);
        } else if (argument instanceof Boolean) {
            stmt.setBoolean(index, (Boolean) argument);
        } else if (argument instanceof String) {
            stmt.setString(index, (String) argument);
        } else if (argument instanceof Double) {
            stmt.setDouble(index, (Double) argument);
        } else if (argument instanceof java.util.Date) {
            stmt.setTimestamp(index, new Timestamp(
                    ((java.util.Date) argument).getTime()));
        } else if (argument instanceof Long) {
            stmt.setLong(index, (Long) argument);
        } else if (argument instanceof Float) {
            stmt.setFloat(index, (Float) argument);
        } else {
            throw new SQLException("Parameter type '" + argument.getClass()
                    + "' not supported.");
        }
    }
}

Related Tutorials