Android房间按月和年分组

@Entity(tableName = "house_rental")
public class HouseRental {
    @PrimaryKey(autoGenerate = true)
    private int id;
    private String houseName;
    private Date rentalDate;

    // Getters and setters

    // Add month and year fields
    @ColumnInfo(name = "rental_month")
    private int rentalMonth;

    @ColumnInfo(name = "rental_year")
    private int rentalYear;
}

@Dao
public interface HouseRentalDao {
    @Query("SELECT rental_month, rental_year, COUNT(*) as rental_count FROM house_rental GROUP BY rental_month, rental_year")
    List<RentalSummary> getRentalSummaryByMonthAndYear();

    // Define RentalSummary class to hold the result
    public class RentalSummary {
        @ColumnInfo(name = "rental_month")
        public int rentalMonth;

        @ColumnInfo(name = "rental_year")
        public int rentalYear;

        @ColumnInfo(name = "rental_count")
        public int rentalCount;
    }
}

// Usage
List<HouseRentalDao.RentalSummary> rentalSummaryList = houseRentalDao.getRentalSummaryByMonthAndYear();