Task4.java

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.sql.DataSource;

class ReportDAO {

    private DataSource dataSource;

    public List<ReportEntry> fetchMonthlyReport(String accountId,
                                                int month, int year)
                                                throws SQLException {
        // FIX: try-with-resources closes PreparedStatement and Connection even when query execution/mapping fails.
        try (Connection conn = dataSource.getConnection();
             PreparedStatement ps = conn.prepareStatement(
                 "SELECT * FROM report_entries " +
                 "WHERE account_id = ? AND MONTH(entry_date) = ? " +
                 "AND YEAR(entry_date) = ?"
             )) {
            ps.setString(1, accountId);
            ps.setInt(2, month);
            ps.setInt(3, year);

            List<ReportEntry> entries = new ArrayList<>();

            // FIX: Closing ResultSet in nested try-with-resources ensures closure order: ResultSet -> PreparedStatement -> Connection.
            try (ResultSet rs = ps.executeQuery()) {
                while (rs.next()) {
                    entries.add(mapRow(rs));
                }
            }
            return entries;
        }
    }

    private ReportEntry mapRow(ResultSet rs) throws SQLException {
        // Existing mapping logic remains unchanged.
        return new ReportEntry();
    }
}