Java Param类代码示例

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);
 

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);
 

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);
 

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);
 

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);
 

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);
 

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);
 

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);
 

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);
 

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

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);
 

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);
 

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

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;
 

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);