jpa @query if_jpa query if

如 当status=9时，就是查询所有

这里如果是integer，不能用null

  @Query(value = "select * from consignment  where org_first_id = ?1 
AND if(?2 !=9,status = ?2,1=1)", nativeQuery = true)
    List<ConsignmentEntity> findByOrgFirstId(String orgFirstId,Integer status);