Runs a SQL query that inserts, updates, or deletes rows.

Description

Demo Code

/*//  w ww.  j  av  a  2 s.  com
 * Copyright (c) 2008 Bradley W. Kimmel
 *
 * Permission is hereby granted, free of charge, to any person
 * obtaining a copy of this software and associated documentation
 * files (the "Software"), to deal in the Software without
 * restriction, including without limitation the rights to use,
 * copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the
 * Software is furnished to do so, subject to the following
 * conditions:
 *
 * The above copyright notice and this permission notice shall be
 * included in all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
 * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
 * OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
 * NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
 * HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
 * WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
 * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
 * OTHER DEALINGS IN THE SOFTWARE.
 */
//package com.java2s;

import java.sql.Connection;

import java.sql.PreparedStatement;
import java.sql.ResultSet;

import java.sql.SQLException;
import java.sql.Statement;
import javax.sql.DataSource;

public class Main {
    /**
     * Runs a SQL query that inserts, updates, or deletes rows.
     * @param ds The <code>DataSource</code> against which to run the query.
     * @param def The default value to return if the query returns no results.
     * @param query The SQL query to run.
     * @param param The parameters to the SQL query.
     * @return The number of rows affected by the query.
     * @throws SQLException If an error occurs while attempting to communicate
     *     with the database.
     */
    public static int update(DataSource ds, String query, Object... param)
            throws SQLException {
        Connection con = null;
        try {
            con = ds.getConnection();
            return update(con, query, param);
        } finally {
            close(con);
        }
    }

    /**
     * Runs a SQL query that inserts, updates, or deletes rows.
     * @param con The <code>Connection</code> against which to run the query.
     * @param def The default value to return if the query returns no results.
     * @param query The SQL query to run.
     * @param param The parameters to the SQL query.
     * @return The number of rows affected by the query.
     * @throws SQLException If an error occurs while attempting to communicate
     *     with the database.
     */
    public static int update(Connection con, String query, Object... param)
            throws SQLException {
        PreparedStatement stmt = null;
        try {
            stmt = con.prepareStatement(query);
            for (int i = 0; i < param.length; i++) {
                stmt.setObject(i + 1, param[i]);
            }
            return stmt.executeUpdate();
        } finally {
            close(stmt);
        }
    }

    /**
     * Closes a connection.  Any <code>SQLException</code>s thrown are ignored.
     * @param con The <code>Connection</code> to close.  If this value is
     *     <code>null</code>, no action is performed.
     */
    public static void close(Connection con) {
        if (con != null) {
            try {
                con.close();
            } catch (SQLException e) {
                /* nothing to do. */
            }
        }
    }

    /**
     * Closes a result set.  Any <code>SQLException</code>s thrown are ignored.
     * @param con The <code>ResultSet</code> to close.  If this value is
     *     <code>null</code>, no action is performed.
     */
    public static void close(ResultSet rs) {
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                /* nothing to do. */
            }
        }
    }

    /**
     * Closes a statement.  Any <code>SQLException</code>s thrown are ignored.
     * @param con The <code>Statement</code> to close.  If this value is
     *     <code>null</code>, no action is performed.
     */
    public static void close(Statement stmt) {
        if (stmt != null) {
            try {
                stmt.close();
            } catch (SQLException e) {
                /* nothing to do. */
            }
        }
    }

    /**
     * Closes a result set, statement, and connection.  Any
     * <code>SQLException</code>s thrown are ignored.
     * @param rs The <code>ResultSet</code> to close.  If this value is
     *     <code>null</code>, no <code>ResultSet</code> is closed.
     * @param stmt The <code>Statement</code> to close.  If this value is
     *     <code>null</code>, no <code>Statement</code> is closed.
     * @param con The <code>Connection</code> to close.  If this value is
     *     <code>null</code>, no <code>Connection</code> is closed.
     */
    public static void close(ResultSet rs, Statement stmt, Connection con) {
        close(rs);
        close(stmt);
        close(con);
    }
}
Runs a SQL query that inserts, updates, or deletes rows. - Java java.sql

Description

Demo Code

Related Tutorials
