如何在spring data JPA中使用实体管理器避免和条件中出现空参数

Question

我试图实现搜索功能网格使用和条件。如果我给两个参数它给的结果。但是如果我想搜索只使用第一个字段，第二个是空的。它根据AND功能给出空数组。在这种情况下如何避免空参数。

如果一个参数为空，那么如何避免该参数，并根据该参数得到结果，而该参数不是空的。

会计控制员

@RestController
@RequestMapping("/SpaceStudy/SpaceAdmin")
public class AccountController {

    @Autowired
    AccountService accService;

    @CrossOrigin(origins = "*")
    @GetMapping("/AccountMaintenance/LoadGrid")
    public Set<AccountModel> GridLoad( String sclientacctid, String sacctdesc) {
        return accService.gridLoad("1124100",null);

会计服务

@Service
public class AccountService {
    @Autowired
    AccountRepository accRepo;
public Set<AccountModel> gridLoad( String sclientacctid,String sacctdesc) {

        if (sclientacctid != null || sacctdesc != null) {
            Set<AccountModel> gridObj1 = accRepo.findBySclientacctidAndSacctdesc(sclientacctid, sacctdesc);
            return gridObj1;
        }       
            Set<AccountModel> gridObj = accRepo.findBySclientacctid();

        return gridObj;
    }

帐户存储库

@Repository
public interface AccountRepository extends JpaRepository<AccountModel, Integer>,AccontRepositoryCustom {

    @Query("select distinct(a.slocation) from AccountModel a where a.slocation !=null")
    List<AccountModel> findBySlocation();   

    @Query("select new map(acct.sclientacctid as sclientacctid ,acct.sacctdesc as sacctdesc ,"
            + "acct.slocation as slocation,invest.sinvestigatorname as sinvestigatorname ,"
            + "dept.sclientdeptid as sclientdeptid,dept.sdeptname as sdeptname ,acp.sccpcode as sccpcode)"
            + " from AccountModel acct join acct.department dept"
            + " join acct.investigator invest join acct.accountCPC acp" + " where acct.ninstid= 60")
    Set<AccountModel> findBySclientacctid();

AccountRepositoryCustomImpl

@Repository
public class AccountRepositoryCustomImpl implements AccontRepositoryCustom {

    @PersistenceContext
    EntityManager entityManager;

    @SuppressWarnings("unchecked")
    @Override
    public Set<AccountModel> findBySclientacctidAndSacctdesc(String sclientacctid, String sacctdesc) {

        Query query = entityManager
                .createQuery("select new map(acct.sclientacctid as sclientacctid ,acct.sacctdesc as sacctdesc ,"
                        + "acct.slocation as slocation,invest.sinvestigatorname as sinvestigatorname ,"
                        + "dept.sclientdeptid as sclientdeptid,dept.sdeptname as sdeptname ,acp.sccpcode as sccpcode)"
                        + " from AccountModel acct join acct.department dept"
                        + " join acct.investigator invest join acct.accountCPC acp" 
                        + " where acct.sclientacctid=?1 and acct.acctdesc=?2 ");
        query.setParameter(1, sclientacctid);
        query.setParameter(2, sacctdesc);
        return (Set<AccountModel>) query.getResultList();
    }     
}

Spring我是新来的。有谁能帮我，我需要在上面的代码中更改什么？

Answer 1

您可以尝试以下方法（但未经测试）：

    Query query = entityManager
            .createQuery("select new map(acct.sclientacctid as sclientacctid ,acct.sacctdesc as sacctdesc ,"
                    + "acct.slocation as slocation,invest.sinvestigatorname as sinvestigatorname ,"
                    + "dept.sclientdeptid as sclientdeptid,dept.sdeptname as sdeptname ,acp.sccpcode as sccpcode)"
                    + " from AccountModel acct join acct.department dept"
                    + " join acct.investigator invest join acct.accountCPC acp" 
                    + " where acct.sclientacctid=?1 and (?2 is null or acct.acctdesc =?2) ");