delete Row from a table - Java java.sql

Java examples for java.sql:Table

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

Description

delete Row from a table

Demo Code

/*//from w  w  w  . j a  va 2 s . com
 * Copyright (c) 2003, Orientation in Objects GmbH, www.oio.de
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without modification,
 * are permitted provided that the following conditions are met:
 * 
 * - Redistributions of source code must retain the above copyright notice, this
 *   list of conditions and the following disclaimer.
 * - Redistributions in binary form must reproduce the above copyright notice,
 *   this list of conditions and the following disclaimer in the documentation 
 *   and/or other materials provided with the distribution.
 * - Neither the name of Orienation in Objects GmbH nor the names of its 
 *   contributors may be used to endorse or promote products derived from this 
 *   software without specific prior written permission.
 * 
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 
 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE 
 * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
 * ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES 
 * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
 * OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY 
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
 * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, 
 * EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 * 
 * ${file_name} Created on ${date} by ${user}
 *  
 * ${todo}
 * 
 */
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Types;
import java.util.ArrayList;
import java.util.Collection;
import org.apache.log4j.Logger;

public class Main{

    /**
     * Method deleteRow.
     * @param string
     * @param string1
     */
    public static void deleteRow(String tableName, String primaryKey)
            throws SQLException, NoRowsAffectedException {

        Connection connection = DBConnection.getInstance();

        PreparedStatement statement = connection
                .prepareStatement(getRowDeleteStatement(tableName,
                        primaryKey));

        if (!statement.execute()) {
            if (statement.getUpdateCount() == 0) {
                connection.close();
                throw new NoRowsAffectedException();

            }
        }
        connection.close();
    }
    /**
     * Method getRowDeleteStatement.
     * @param tableName
     * @param primaryKey
     * @return String
     */
    private static String getRowDeleteStatement(String tableName,
            String primaryKey) {
        return "delete from "
                + tableName
                + " where "
                + getPrimaryKeyColumnName(tableName)
                + " = "
                + getSQLParameterSubstring(primaryKey,
                        DatabaseUtil.getColumnType(tableName,
                                getPrimaryKeyColumnName(tableName)));
    }
    public static String getPrimaryKeyColumnName(String tableName) {

        try {
            Connection connection = DBConnection.getInstance();

            DatabaseMetaData metaData = connection.getMetaData();
            ResultSet resultSet = metaData.getPrimaryKeys(null, null,
                    tableName);

            resultSet.next();

            return resultSet.getString("COLUMN_NAME");
        } catch (SQLException e) {
            throw new IllegalArgumentException("Wrong tablename : "
                    + tableName);
        }
    }
    public static String getSQLParameterSubstring(String value, int type) {

        if (isNumericType(type)) {
            return value;
        } else {
            return "'" + value + "'";
        }
    }
    /**
     * Method getColumnType.
     * @param tableName
     * @param string
     * @return String
     */
    public static int getColumnType(String tableName, String columnName) {
        try {
            Connection connection = DBConnection.getInstance();

            DatabaseMetaData metaData = connection.getMetaData();
            ResultSet resultSet = metaData.getColumns(null, null,
                    tableName, columnName);

            resultSet.next();

            return resultSet.getInt("DATA_TYPE");
        } catch (SQLException e) {
            throw new IllegalArgumentException(
                    "Wrong tablename or columnName: " + tableName + ", "
                            + columnName);
        }

    }
    public static boolean isNumericType(int type) {
        return Types.BIGINT == type || Types.DECIMAL == type
                || Types.INTEGER == type || Types.NUMERIC == type
                || Types.SMALLINT == type || Types.TINYINT == type;
    }
}

Related Tutorials