mybatisplus 实现树的递归查询请写出所有代码 包括实体entity类 mapper类 service接口 serviceimpl类 controller类 xml代码 查询的初始参数有两个并且它们均不是父节点或子节点号

好的，下面是一个使用MyBatis Plus实现树的递归查询的示例代码：

1. 实体（Entity）类：

// TreeNode.java
public class TreeNode {
    private Long id;
    private String name;
    private Long parentId;
    // 其他属性和 getter/setter 方法省略
}

2. Mapper类：

// TreeNodeMapper.java
@Mapper
public interface TreeNodeMapper extends BaseMapper<TreeNode> {
    List<TreeNode> selectTreeNodes(@Param("parentId") Long parentId, @Param("excludeId") Long excludeId);
}

3. Service接口：

// TreeNodeService.java
public interface TreeNodeService {
    List<TreeNode> getTreeNodes(Long parentId, Long excludeId);
}

4. Service实现类：

// TreeNodeServiceImpl.java
@Service
public class TreeNodeServiceImpl implements TreeNodeService {
    
    @Autowired
    private TreeNodeMapper treeNodeMapper;

    @Override
    public List<TreeNode> getTreeNodes(Long parentId, Long excludeId) {
        return treeNodeMapper.selectTreeNodes(parentId, excludeId);
    }
}

5. Controller类：

// TreeNodeController.java
@RestController
@RequestMapping("/tree-nodes")
public class TreeNodeController {

    @Autowired
    private TreeNodeService treeNodeService;

    @GetMapping("/{parentId}/{excludeId}")
    public List<TreeNode> getTreeNodes(@PathVariable Long parentId, @PathVariable Long excludeId) {
        return treeNodeService.getTreeNodes(parentId, excludeId);
    }
}

6. XML配置：

<!-- TreeNodeMapper.xml -->
<mapper namespace="com.example.mapper.TreeNodeMapper">
    <select id="selectTreeNodes" resultType="com.example.entity.TreeNode">
        WITH RECURSIVE cte AS (
            SELECT * FROM tree_node WHERE parent_id = #{parentId} AND id != #{excludeId}
            UNION ALL
            SELECT tn.* FROM tree_node tn JOIN cte ON cte.id = tn.parent_id
        )
        SELECT * FROM cte;
    </select>
</mapper>

以上就是使用MyBatis Plus实现树的递归查询的示例代码。注意，在XML配置中使用了CTE（Common Table Expression）来进行递归查询。你可以根据实际情况进行适当的修改和调整。