SellerRepository (delete).java

package br.edu.ifpr.persistproject.repository;

import br.edu.ifpr.persistproject.connection.ConnectionFactory;
import br.edu.ifpr.persistproject.exception.DatabaseIntegrityException;
import br.edu.ifpr.persistproject.model.Seller;

import java.sql.*;
import java.text.SimpleDateFormat;

public class SellerRepository {

    private Connection conn;
    private SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");

    public SellerRepository(){
        ConnectionFactory connectionFactory = new ConnectionFactory();
        conn = connectionFactory.getConnection();
    }

    public void delete(){
        PreparedStatement statement = null;

        try {
            statement = conn.prepareStatement(
                    "DELETE FROM department "
                            + "WHERE "
                            + "Id = ?");

            statement.setInt(1, 2);

            int rowsAffected = statement.executeUpdate();

            System.out.println("Done! Rows affected: " + rowsAffected);
        }
        catch (SQLException e) {
            throw new DatabaseIntegrityException(e.getMessage());
        }
    }
}