1、将xml中的/符号改为#以防止后续问题。
2、对查询返回值缺少的问题进行了处理。

 Source/UBCS/ubcs-service-api/ubcs-omd-api/src/main/java/com/vci/ubcs/omd/constant/BtmTypeFieldConstant.java

@@ -70,7 +70,7 @@
                this.put("lastmodifytime", "最后修改时间");
                this.put("ts", "时间戳");
                this.put("owner", "拥有者");
                this.put("tenentId","租户");
                this.put("tenant_id","租户");
            }
        };
        BASE_MODEL_COMPATIBILITY_MAP = new HashMap() {

 Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/mapper/CodeClassifyMapper.java

@@ -114,4 +114,7 @@
    List<CodeClassify> selectByFieldNamePath(@Param("fieldPath") String fieldPath,@Param("fieldName") String fieldName);

    public List<CodeClassifyVO> getIdPathToNamePathByParentId(@Param("parentId")String parentId);


    CodeClassify selectByIdRel(@Param("oid") String oid);
}

 Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/CodeClassifyServiceImpl.java

@@ -47,7 +47,7 @@
import org.slf4j.LoggerFactory;
import org.springblade.core.cache.utils.CacheUtil;
import org.springblade.core.launch.constant.AppConstant;
import org.springblade.core.log.exception.ServiceException;
import com.vci.ubcs.core.log.exception.ServiceException;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.core.tool.api.R;
@@ -1084,10 +1084,10 @@
     */
    @Override
    public CodeClassifyVO getObjectByIdPath(String idPath) {
        List<Map<String, Object>> idPathValues = codeClassifyMapper.selectByFieldPath("/" + idPath);
        List<Map<String, Object>> idPathValues = codeClassifyMapper.selectByFieldPath("#" + idPath);
        CodeClassify classifyDO = null;
        if (idPathValues != null){
            classifyDO = codeClassifyMapper.selectById(idPathValues.get(0).get("oid").toString());
            classifyDO = codeClassifyMapper.selectByIdRel(idPathValues.get(0).get("OID").toString());
        }
        return codeClassifyDO2VO(classifyDO);
    }

 Source/UBCS/ubcs-service/ubcs-code/src/main/resources/mapper/CodeCLassifyMapper.xml

@@ -147,6 +147,21 @@
        CONNECT BY PRIOR codeclassify0.OID = codeclassify0.parentCodeClassifyOid
    </select>

    <select id="selectByIdRel" resultMap="plCodeClassifyResultMap">
        select pc.*,
               pk.name codeKeyAttrRepeatOidName,
               pr.name codeResembleRuleOidName,
               pu.name coderuleoidName
        from pl_code_classify pc
                 left join pl_code_keyattrrepeat pk
                           on pc.codekeyattrrepeatoid = pk.oid
                 left join pl_code_resemblerule pr
                           on pc.coderesembleruleoid = pr.oid
                 left join pl_code_rule pu
                           on pc.coderuleoid = pu.oid
        where pc.oid = #{oid}
    </select>

    <select id="selectAllLevelParentByOid" resultType="java.util.HashMap">
        select oid,
               level from pl_code_classify start with oid= #{oid} connect by prior PARENTCODECLASSIFYOID = oid
@@ -224,7 +239,7 @@

    <select id="selectByFieldPath" resultType="java.util.HashMap">
        select *
        from (select oid, SYS_CONNECT_BY_PATH(id, '/') as paths
        from (select oid, SYS_CONNECT_BY_PATH(id, '#') as paths
              from pl_code_classify
                       START WITH parentCodeClassifyOid is null
              CONNECT BY PRIOR OID = parentCodeClassifyOid) a