java中的cypher查询：获取和迭代resultset节点

Question

public class BooksManager {
    
    //private final Driver driver;
    private final ConnectionConfig config;
    private Connection con;
    public BooksManager(ConnectionConfig config) {
        this.config = config;
        this.con = null;
        try {
            this.con = DriverManager.getConnection("jdbc:neo4j:"+ config.getFullUrl(), "neo4j", config.getPassword());
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        
    }

public void viewBook(){
    booksQuery = "USE eindb MATCH (b:Book) RETURN b LIMIT 25";

    PreparedStatement stmt = null;
    try {
        stmt = con.prepareStatement(booksQuery);
    } catch (SQLException e1) {
        e1.printStackTrace();
    }
        
    ResultSet rs = null;
        
    try {
        rs = stmt.executeQuery();
    } catch (SQLException e2) {
        e2.printStackTrace();
    }
        
    try {
        while (rs.next()) {
            
            Object bookJustObject = rs.getObject("b");
            System.out.println("b: "+bookJustObject);
            //TODO get all fields from object, how? 
        }

    } catch (SQLException e1) {
        e1.printStackTrace();
    }
}

我执行了成功的查询，返回了一些书籍。使用jdbc连接运行neo4j数据库的查询。我不明白如何列出对象“b”中的所有字段，该对象表示图形数据库中的一本书。

Answer 1

这取决于你想要什么。一些建议：

返回一组特定的属性

RETURN b.title AS title, b.foo AS foo

要将属性作为映射返回，请执行以下操作：

RETURN properties(b) AS map

返回属性并添加节点id。

RETURN apoc.map.setKey(properties(b),'id',id(b)) AS mapWithId

返回所有属性/键的列表

MATCH (b:Book) 
UNWIND keys(b) AS key
RETURN DISTINCT key