From 3dee2a15cad899b998da637ca07768d7c92f6052 Mon Sep 17 00:00:00 2001
From: “djh” <“3298565835@qq.com”>
Date: Tue, 04 Nov 2025 13:18:03 +0800
Subject: [PATCH] 修改

---
 src/main/java/com/gkhy/fourierSpecialGasMonitor/repository/GasCategoryRepository.java |    6 ++++++
 1 files changed, 6 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/gkhy/fourierSpecialGasMonitor/repository/GasCategoryRepository.java b/src/main/java/com/gkhy/fourierSpecialGasMonitor/repository/GasCategoryRepository.java
index bfd0075..7ba202a 100644
--- a/src/main/java/com/gkhy/fourierSpecialGasMonitor/repository/GasCategoryRepository.java
+++ b/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();
 }

--
Gitblit v1.9.2