16639036659
2024-04-10 b15ad90d858e5b6745f76921054b5d5a62b59627
src/main/java/com/gkhy/fourierSpecialGasMonitor/repository/GasCategoryRepository.java
@@ -5,10 +5,16 @@
import com.gkhy.fourierSpecialGasMonitor.entity.GasFlux;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface GasCategoryRepository extends JpaRepository<GasCategory,Integer>, JpaSpecificationExecutor<GasCategory> {
    GasCategory findByMolecularFormula(String molecularFormula);
    @Query(value = "select t from GasCategory t where t.id <= 3")
    List<GasCategory> findGasCategoryForReport();
}