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

接口 CertInfoRepository

所有超级接口:

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

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

方法概要

限定符和类型	方法和说明
java.util.List<CertInfo>	findByIsCACert(java.lang.Boolean isCACert)
java.util.List<CertInfo>	findBypCertId(java.lang.Long PCertId)
CertInfo	findByPkId(long pkId)
java.util.List<CertInfo>	findCertList(java.lang.String userId, java.lang.Long issuerKeyId, java.lang.Long pCertId, java.lang.String issuerOrg, java.lang.String issuerCN, java.lang.Boolean isCACert)

从接口继承的方法 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

CertInfo findByPkId(long pkId)

findBypCertId

java.util.List<CertInfo> findBypCertId(java.lang.Long PCertId)

findByIsCACert

java.util.List<CertInfo> findByIsCACert(java.lang.Boolean isCACert)

findCertList

@Query(value="select * from cert_info where if(?1 !=\'\',user_id=?1,1=1) and  if(?2 !=\'\',issuer_key_id=?2,1=1) and if(?3 !=\'\',parent_cert_id=?3,1=1) and if(?4 !=\'\',issuer_org=?4,1=1) and if(?5 !=\'\',issuer_cn=?5,1=1) and if(?6 !=\'\',is_ca_cert=?6,1=1)",
       nativeQuery=true)
java.util.List<CertInfo> findCertList(java.lang.String userId,
                                                                                                                                                                                                                                                                                                                                     java.lang.Long issuerKeyId,
                                                                                                                                                                                                                                                                                                                                     java.lang.Long pCertId,
                                                                                                                                                                                                                                                                                                                                     java.lang.String issuerOrg,
                                                                                                                                                                                                                                                                                                                                     java.lang.String issuerCN,
                                                                                                                                                                                                                                                                                                                                     java.lang.Boolean isCACert)