jpa 多条件，参数为空，迷糊，分页查询

    @Query(value = "select * from community_room where " +
            "if(community_id !=0,community_id =:communityId,1=1) and is_delete=:status and (:UnitA is null or unit_a like :UnitA) " +
            "and (:UnitB is null or unit_b like :UnitB)  and (:UnitC is null or unit_c like :UnitC) and (:UnitD is null or unit_d like :UnitD)" +
            "and (:UnitE is null or unit_e like :UnitE) and (:UnitF is null or unit_f like :UnitF) " ,nativeQuery = true)
    List<CommunityRoom> getCommunityIdAndIsDeleteAndUnit(Integer communityId,int status,String UnitA,String UnitB,String UnitC,String UnitD,String UnitE,String UnitF);

    @Query(value = "select * from community_room where " +
            "if(community_id !=0,community_id =:communityId,1=1) and is_delete=:status and (:UnitA is null or unit_a like :UnitA) " +
            "and (:UnitB is null or unit_b like :UnitB)  and (:UnitC is null or unit_c like :UnitC) and (:UnitD is null or unit_d like :UnitD)" +
            "and (:UnitE is null or unit_e like :UnitE) and (:UnitF is null or unit_f like :UnitF) limit :page,:size" ,nativeQuery = true)
    List<CommunityRoom> getPageCommunityIdAndIsDeleteAndUnit(Integer communityId,int status,String UnitA,String UnitB,String UnitC,String UnitD,String UnitE,String UnitF, int page, int size);

    @Query(value = "select * from community_room where " +
            "if(community_id !=0,community_id =:communityId,1=1) and is_delete=:status and (:UnitA is null or unit_a like :UnitA) " +
            "and (:UnitB is null or unit_b like :UnitB)  and (:UnitC is null or unit_c like :UnitC) and (:UnitD is null or unit_d like :UnitD)" +
            "and (:UnitE is null or unit_e like :UnitE) and (:UnitF is null or unit_f like :UnitF) " ,nativeQuery = true)
    List<CommunityRoom> getCommunityIdAndIsDeleteAndUnit(Integer communityId,int status,String UnitA,String UnitB,String UnitC,String UnitD,String UnitE,String UnitF);

    @Query(value = "select * from community_room where " +
            "if(community_id !=0,community_id =:communityId,1=1) and is_delete=:status and (:UnitA is null or unit_a like :UnitA) " +
            "and (:UnitB is null or unit_b like :UnitB)  and (:UnitC is null or unit_c like :UnitC) and (:UnitD is null or unit_d like :UnitD)" +
            "and (:UnitE is null or unit_e like :UnitE) and (:UnitF is null or unit_f like :UnitF) limit :page,:size" ,nativeQuery = true)
    List<CommunityRoom> getPageCommunityIdAndIsDeleteAndUnit(Integer communityId,int status,String UnitA,String UnitB,String UnitC,String UnitD,String UnitE,String UnitF, int page, int size);