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