如何在Spring JDBCTemplate获取的Neo4j结果集中包含节点ID与标签？

修改Cypher查询语句 #

在原查询的RETURN子句中，直接添加节点的ID和标签字段即可。Neo4j 5.x推荐用elementId()获取节点的全局唯一ID（替代旧版的id()函数），用labels()获取节点的标签列表：

MATCH path = (n:NodeABC)-[]-(i:NodeXYZ)
WHERE n.name = 'iqwe' 
RETURN 
  n as instance,
  elementId(n) as instanceId,
  labels(n) as instanceLabels,
  relationships(path)

如果需要同时拿到关联节点i的ID和标签，在返回列表里追加对应字段就行：

MATCH path = (n:NodeABC)-[]-(i:NodeXYZ)
WHERE n.name = 'iqwe' 
RETURN 
  n as instance,
  elementId(n) as instanceId,
  labels(n) as instanceLabels,
  i as relatedNode,
  elementId(i) as relatedNodeId,
  labels(i) as relatedNodeLabels,
  relationships(path)

Java端结果映射（Spring JDBCTemplate） #

用RowMapper把查询结果映射到自定义实体类，示例如下：

1. 定义实体类存储结果：

public class NodeQueryResult {
    // 节点属性集合
    private Map<String, Object> instanceProperties;
    // 节点ID
    private String instanceId;
    // 节点标签列表
    private List<String> instanceLabels;
    // 关联节点相关字段（按需添加）
    private Map<String, Object> relatedNodeProperties;
    private String relatedNodeId;
    private List<String> relatedNodeLabels;
    // 路径中的关系列表
    private List<Map<String, Object>> relationships;

    // 构造函数、Getter和Setter方法
}

2. 实现RowMapper并执行查询：

// 自定义RowMapper处理结果映射
RowMapper<NodeQueryResult> resultRowMapper = (rs, rowNum) -> {
    NodeQueryResult result = new NodeQueryResult();
    
    // 映射主节点的属性、ID、标签
    result.setInstanceProperties((Map<String, Object>) rs.getObject("instance"));
    result.setInstanceId(rs.getString("instanceId"));
    result.setInstanceLabels((List<String>) rs.getObject("instanceLabels"));
    
    // 映射关联节点（如果查询中返回了）
    result.setRelatedNodeProperties((Map<String, Object>) rs.getObject("relatedNode"));
    result.setRelatedNodeId(rs.getString("relatedNodeId"));
    result.setRelatedNodeLabels((List<String>) rs.getObject("relatedNodeLabels"));
    
    // 映射路径中的关系
    result.setRelationships((List<Map<String, Object>>) rs.getObject("relationships"));
    
    return result;
};

// 执行查询并获取结果列表
List<NodeQueryResult> queryResults = jdbcTemplate.query(
    "MATCH path = (n:NodeABC)-[]-(i:NodeXYZ) WHERE n.name = 'iqwe' RETURN n as instance, elementId(n) as instanceId, labels(n) as instanceLabels, i as relatedNode, elementId(i) as relatedNodeId, labels(i) as relatedNodeLabels, relationships(path)",
    resultRowMapper
);

内容的提问来源于stack exchange，提问作者Atul