SellerRepository (update).java

package br.edu.ifpr.persistproject.repository;

import br.edu.ifpr.persistproject.connection.ConnectionFactory;
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 update(){

        PreparedStatement statement = null;

        try {

            statement = conn.prepareStatement(
                    "UPDATE seller SET BaseSalary = BaseSalary + ? WHERE DepartmentId = ?");

            statement.setDouble(1, 200.0);
            statement.setInt(2, 2);

            int rowsAffected = statement.executeUpdate();

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