com.webank.cert.mgr.db.cert.repository

接口 CertRequestInfoRepository

所有超级接口:

org.springframework.data.repository.CrudRepository<CertRequestInfo,java.lang.Long>, org.springframework.data.jpa.repository.JpaRepository<CertRequestInfo,java.lang.Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<CertRequestInfo>, org.springframework.data.repository.PagingAndSortingRepository<CertRequestInfo,java.lang.Long>, org.springframework.data.repository.query.QueryByExampleExecutor<CertRequestInfo>, org.springframework.data.repository.Repository<CertRequestInfo,java.lang.Long>

@Repository
public interface CertRequestInfoRepository
extends org.springframework.data.jpa.repository.JpaRepository<CertRequestInfo,java.lang.Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<CertRequestInfo>

方法概要

限定符和类型	方法和说明
CertRequestInfo	findBypCertIdAndSubjectKeyId(java.lang.Long pCertId, java.lang.Long subjectKeyId)
CertRequestInfo	findByPkId(long pkId)
java.util.List<CertRequestInfo>	findCertRequestList(java.lang.String userId, java.lang.Long subjectKeyId, java.lang.Long pCertId, java.lang.String subjectOrg, java.lang.String subjectCN, java.lang.String pCertUserId)

从接口继承的方法 org.springframework.data.jpa.repository.JpaRepository

deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush

从接口继承的方法 org.springframework.data.repository.PagingAndSortingRepository

findAll

从接口继承的方法 org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save

从接口继承的方法 org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findOne

从接口继承的方法 org.springframework.data.jpa.repository.JpaSpecificationExecutor

count, findAll, findAll, findAll, findOne

方法详细资料

findByPkId

CertRequestInfo findByPkId(long pkId)

findBypCertIdAndSubjectKeyId

CertRequestInfo findBypCertIdAndSubjectKeyId(java.lang.Long pCertId,
                                             java.lang.Long subjectKeyId)

findCertRequestList

@Query(value="select * from cert_request_info where if(?1 !=\'\',user_id=?1,1=1) and if(?2 !=\'\',subject_key_id=?2,1=1) and if(?3 !=\'\',parent_cert_id=?3,1=1) and if(?4 !=\'\',subject_org=?4,1=1) and if(?5 !=\'\',subject_cn=?5,1=1) and if(?6 !=\'\',parent_cert_user_id=?6,1=1) ",
       nativeQuery=true)
java.util.List<CertRequestInfo> findCertRequestList(java.lang.String userId,
                                                                                                                                                                                                                                                                                                                                                                       java.lang.Long subjectKeyId,
                                                                                                                                                                                                                                                                                                                                                                       java.lang.Long pCertId,
                                                                                                                                                                                                                                                                                                                                                                       java.lang.String subjectOrg,
                                                                                                                                                                                                                                                                                                                                                                       java.lang.String subjectCN,
                                                                                                                                                                                                                                                                                                                                                                       java.lang.String pCertUserId)