Java Param類代碼示例

本文整理匯總了Java中org.springframework.data.repository.query.Param類的典型用法代碼示例。如果您正苦於以下問題：Java Param類的具體用法？Java Param怎麽用？Java Param使用的例子？那麽, 這裏精選的類代碼示例或許可以為您提供幫助。

Param類屬於org.springframework.data.repository.query包，在下文中一共展示了Param類的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。

示例1: LOWER

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query("SELECT u FROM UserEntity u WHERE u.tenantId = :tenantId " +
        "AND u.customerId = :customerId AND u.authority = :authority " +
        "AND LOWER(u.searchText) LIKE LOWER(CONCAT(:searchText, '%'))" +
        "AND u.id > :idOffset ORDER BY u.id")
List<UserEntity> findUsersByAuthority(@Param("tenantId") String tenantId,
                                      @Param("customerId") String customerId,
                                      @Param("idOffset") String idOffset,
                                      @Param("searchText") String searchText,
                                      @Param("authority") Authority authority,
                                      Pageable pageable);

開發者ID:osswangxining，項目名稱:iotplatform，代碼行數:11，代碼來源:UserRepository.java

示例2: IN

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query("SELECT rmd FROM RuleMetaDataEntity rmd WHERE rmd.tenantId IN (:tenantId, :nullTenantId) " +
        "AND LOWER(rmd.searchText) LIKE LOWER(CONCAT(:textSearch, '%')) " +
        "AND rmd.id > :idOffset ORDER BY rmd.id")
List<RuleMetaDataEntity> findAllTenantRulesByTenantId(@Param("tenantId") String tenantId,
                                                      @Param("nullTenantId") String nullTenantId,
                                                      @Param("textSearch") String textSearch,
                                                      @Param("idOffset") String idOffset,
                                                      Pageable pageable);

開發者ID:osswangxining，項目名稱:iotplatform，代碼行數:9，代碼來源:RuleMetaDataRepository.java

示例3: isExistsRouterModel

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query(value = "SELECT routerItemModel FROM RouterItemModel routerItemModel WHERE routerItemModel.routerIp =:routerIp " +
                "AND routerItemModel.routerMac =:routerMac " +
                "AND routerItemModel.model =:model AND routerItemModel.romVersion =:romVersion")
public List<RouterItemModel> isExistsRouterModel(@Param("routerIp") String routerIp,
                                                 @Param("routerMac")String routerMac,
                                                 @Param("model")String model,
                                                 @Param("romVersion")String romVersion);

開發者ID:rongwei84n，項目名稱:Auts_Assert_manager，代碼行數:8，代碼來源:RouterItemModelJpaGerepository.java

示例4: and

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
/**
 * Geeft de partijen terug die geldig zijn voor vrij bericht.
 * @param peildatum peildatum
 * @return de gevonden partijen
 */
@Query("select p from Partij p where p.datumIngang <= :peildatum and (p.datumEinde > :peildatum or p.datumEinde is null) "
        + "and p.datumIngangVrijBericht <= :peildatum and (p.datumEindeVrijBericht > :peildatum or p.datumEindeVrijBericht is null) "
        + "and p.datumOvergangNaarBrp <= :peildatum "
        + "and p.isActueelEnGeldig = true and p.isActueelEnGeldigVoorVrijBericht = true "
        + "and (p.isVrijBerichtGeblokkeerd = false or p.isVrijBerichtGeblokkeerd is null)"
        + "and p.afleverpuntVrijBericht is not null")
List<Partij> geldigeVrijBerichtPartijen(@Param("peildatum") Integer peildatum);

開發者ID:MinBZK，項目名稱:OperatieBRP，代碼行數:13，代碼來源:PartijRepository.java

示例5: LOWER

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query("SELECT cd FROM ComponentDescriptorEntity cd WHERE cd.type = :type " +
        "AND cd.scope = :scope AND LOWER(cd.searchText) LIKE LOWER(CONCAT(:textSearch, '%')) " +
        "AND cd.id > :idOffset ORDER BY cd.id")
List<ComponentDescriptorEntity> findByScopeAndType(@Param("type") ComponentType type,
                                                   @Param("scope") ComponentScope scope,
                                                   @Param("textSearch") String textSearch,
                                                   @Param("idOffset") String idOffset,
                                                   Pageable pageable);

開發者ID:osswangxining，項目名稱:iotplatform，代碼行數:9，代碼來源:ComponentDescriptorRepository.java

示例6: count

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query("select fo.idForm, ty.codTypAvis, td.temValidTypeDecCand, count(1)" + " from TypeDecisionCandidature td"
		+ " join td.candidature ca" + " join ca.formation fo" + " join fo.commission co"
		+ " join co.centreCandidature ce" + " join ca.candidat cand" + " join cand.compteMinima cpt"
		+ " join td.typeDecision t" + " join t.typeAvis ty"
		+ " where ce.idCtrCand = :idCtrCand and cpt.campagne.idCamp = :idcamp" + " and ca.datAnnulCand is null"
		+ " and td.idTypeDecCand in (select max(td2.idTypeDecCand) from TypeDecisionCandidature td2 where ca.idCand = td2.candidature.idCand)"
		+ " group by fo.idForm, ty.codTypAvis, td.temValidTypeDecCand")
List<Object[]> findStatNbCandidatureByAvis(@Param("idCtrCand") Integer idCtrCand, @Param("idcamp") Integer idcamp);

開發者ID:EsupPortail，項目名稱:esup-ecandidat，代碼行數:9，代碼來源:FormationRepository.java

示例7: LOWER

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query("SELECT d FROM DeviceEntity d WHERE d.tenantId = :tenantId " +
        "AND LOWER(d.searchText) LIKE LOWER(CONCAT(:textSearch, '%')) " +
        "AND d.id > :idOffset ORDER BY d.id")
List<DeviceEntity> findByTenantId(@Param("tenantId") String tenantId,
                                  @Param("textSearch") String textSearch,
                                  @Param("idOffset") String idOffset,
                                  Pageable pageable);

開發者ID:osswangxining，項目名稱:iotplatform，代碼行數:8，代碼來源:DeviceRepository.java

示例8: IN

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query("SELECT pmd FROM PluginMetaDataEntity pmd WHERE pmd.tenantId IN (:tenantId, :nullTenantId) " +
        "AND LOWER(pmd.searchText) LIKE LOWER(CONCAT(:textSearch, '%')) " +
        "AND pmd.id > :idOffset ORDER BY pmd.id")
List<PluginMetaDataEntity> findAllTenantPluginsByTenantId(@Param("tenantId") String tenantId,
                                                          @Param("nullTenantId") String nullTenantId,
                                                          @Param("textSearch") String textSearch,
                                                          @Param("idOffset") String idOffset,
                                                          Pageable pageable);

開發者ID:osswangxining，項目名稱:iotplatform，代碼行數:9，代碼來源:PluginMetaDataRepository.java

示例9: LOWER

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query("SELECT a FROM AssetEntity a WHERE a.tenantId = :tenantId " +
        "AND a.customerId = :customerId AND a.type = :type " +
        "AND LOWER(a.searchText) LIKE LOWER(CONCAT(:textSearch, '%')) " +
        "AND a.id > :idOffset ORDER BY a.id")
List<AssetEntity> findByTenantIdAndCustomerIdAndType(@Param("tenantId") String tenantId,
                                                     @Param("customerId") String customerId,
                                                     @Param("type") String type,
                                                     @Param("textSearch") String textSearch,
                                                     @Param("idOffset") String idOffset,
                                                     Pageable pageable);

開發者ID:osswangxining，項目名稱:iotplatform，代碼行數:11，代碼來源:AssetRepository.java

示例10: findByUserProjectId

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query(FIND_BY_ID_QUERY)
List<User> findByUserProjectId(@Param("projId") Integer projId);

開發者ID:Code4SocialGood，項目名稱:C4SG-Obsolete，代碼行數:3，代碼來源:UserDAO.java

示例11: findByReleaseId

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query(value = "select * from `release` where release_id = :releaseId", nativeQuery = true)
public ReleaseJPA findByReleaseId(@Param("releaseId") Integer releaseId);

開發者ID:chanakaDe，項目名稱:ensembl-elastic-rest-final，代碼行數:3，代碼來源:ReleaseJPARepository.java

示例12: EXISTS

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query(value = "SELECT * FROM event_log AS log WHERE log.process_model_id = :processModelId AND log.resource = :subject AND EXISTS((SELECT 1 from event_log AS x " +
        "WHERE x.case_id = log.case_id AND x.activity = 'Process Start' AND x.message_type = '' AND x.resource = '' AND x.state = '')) " +
        "AND EXISTS((SELECT 1 from event_log AS y WHERE y.case_id = log.case_id AND y.activity = 'Process End' AND y.message_type = '' AND y.resource = '' AND y.state = ''))" +
        "ORDER BY log.case_id, log.event_id", nativeQuery = true)
public List<EventLogEntry> getEventLogForProcessModelAndSubject(@Param("processModelId") int processModelId, @Param("subject") String subject);

開發者ID:stefanstaniAIM，項目名稱:IPPR2016，代碼行數:6，代碼來源:EventLogRepository.java

示例13: findAllByRestaurantId

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@RestResource(rel = "byRestaurantId")
List<MenuItem> findAllByRestaurantId(@Param("restaurantId") String restaurantId);

開發者ID:xiayank，項目名稱:food-ordering-system，代碼行數:3，代碼來源:menuItemRepository.java

示例14: findByContainerID

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query("Select m from Module m " + "left join fetch m.image " + "where m.containerID=:containerID")
Module findByContainerID(@Param("containerID") String id) throws DataAccessException;

開發者ID:oncecloud，項目名稱:devops-cstack，代碼行數:3，代碼來源:ModuleDAO.java

示例15: findBetweenDates

import org.springframework.data.repository.query.Param; //導入依賴的package包/類
@Query("SELECT zwbAggregateChar"
       + " FROM ZwbAggregateCharJPA zwbAggregateChar"
       + " WHERE date >= :dateBegin AND date <= :dateEnd")
List<ZwbAggregateCharJPA> findBetweenDates(@Param("dateBegin") Long dateBegin, @Param("dateEnd") Long dateEnd);

開發者ID:fetox74，項目名稱:wormboard-backend，代碼行數:5，代碼來源:ZwbAggregateCharRepository.java

注：本文中的org.springframework.data.repository.query.Param類示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。