package mysql;

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

public class DeleteMain {

    private static final String DELETE_PRODUCT_QUERY =
            "DELETE FROM products WHERE name LIKE ?";

    public static void main(String[] args){
        String url = "jdbc:mysql://localhost:3306/products_ex";
        try(Connection connection = getConnection(url);
            PreparedStatement preparedStatement =
                    connection.prepareStatement(DELETE_PRODUCT_QUERY);
        ){

            preparedStatement.setString(1, "%1%");

            int updateRecords = preparedStatement.executeUpdate();
            System.out.println("Deleted records count = " + updateRecords);

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    private static Connection getConnection(String url) throws SQLException {
        return DriverManager.getConnection(url,"root", "root");
    }
}