按日期和状态SpringBoot的JPA查询表

@Entity
@Table(name = "your_table_name")
public class YourEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private Date date;
    private String status;

    // 省略其他属性和方法
}

public interface YourRepository extends JpaRepository<YourEntity, Long> {
    List<YourEntity> findByDateAndStatus(Date date, String status);
}

@Service
public class YourService {
    @Autowired
    private YourRepository yourRepository;

    public List<YourEntity> findByDateAndStatus(Date date, String status) {
        return yourRepository.findByDateAndStatus(date, status);
    }
}