Breaking News: Grepper is joining You.com. Read the official announcement!

prepared statement mysql java delete selected rows

Modern Mosquito answered on February 7, 2022 Popularity 4/10 Helpfulness 1/10

answer prepared statement mysql java delete selected rows

prepared statement mysql java delete selected rows

Comment

package com.mkyong.jdbc.preparestatement.row;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class RowDelete {

    private static final String SQL_DELETE = "DELETE FROM EMPLOYEE WHERE NAME=?";

    public static void main(String[] args) {

        try (Connection conn = DriverManager.getConnection(
                "jdbc:postgresql://127.0.0.1:5432/test", "postgres", "password");
             PreparedStatement preparedStatement = conn.prepareStatement(SQL_DELETE)) {

            preparedStatement.setString(1, "mkyong");

            int row = preparedStatement.executeUpdate();

            // rows affected
            System.out.println(row);

        } catch (SQLException e) {
            System.err.format("SQL State: %s\n%s", e.getSQLState(), e.getMessage());
        } catch (Exception e) {
            e.printStackTrace();
        }

    }

}

Popularity 4/10 Helpfulness 1/10 Language sql

Source: mkyong.com

Tags: java mysql prepared-statement rows selected sql

Link to this answer
Share Copy Link

Contributed on Feb 07 2022

Modern Mosquito

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

prepared statement mysql java delete selected rows

Contents

More Related Answers

prepared statement mysql java delete selected rows

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.