| | |
| | | import org.springframework.data.jpa.repository.Query; |
| | | import org.springframework.data.repository.query.Param; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | |
| | | public interface Api1302Rep extends JpaRepository<Api1302, String>, JpaSpecificationExecutor<Api1302> { |
| | | |
| | |
| | | @Modifying |
| | | @Query("update Api1302 set czbz =:czbz where wsdjcdh=:wsdjcdh") |
| | | void updateStatus(@Param("wsdjcdh") String wsdjcdh, @Param("czbz") String czbz); |
| | | |
| | | @Query("from Api1302 where wsdjcdh=:wsdjcdh ") |
| | | List<Api1302> getDataByWsdjcdh(@Param("wsdjcdh") String wsdjcdh); |
| | | |
| | | @Query("from Api1302 where kqdm=:kqdm and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Api1302> findPushDataByTime(@Param("kqdm") String kqdm, @Param("start") Date start, @Param("end") Date end); |
| | | } |