java - 使用 Datastax Java 驱动程序返回 JSON

Question

我正在尝试使用 datastax java 驱动程序并检索并返回 JSON。

ResultSet resultSet = session.execute("SELECT JSON * FROM event");

Row row = resultSet.one();
String json1 = row.getString(0);
String json2 = row.getString("[json]");

    System.out.println(resultSet.toString());
returns  ResultSet[ exhausted: false, Columns[[json](varchar)]]

此时，我知道检索一行的代码。我希望将所有行作为 json 字符串返回

Answer 1

At this point of time, I'm aware of the code to retrieve one row. I wish to return all rows as a json string.

Java 8 StringJoiner:https://docs.oracle.com/javase/8/docs/api/java/util/StringJoiner.html

StringJoiner jsonString = new StringJoiner(",", "[", "]");
for(Row row: resultSet.all()) {
   String json = row.getString(0);
   jsonString.add(json);
}

return jsonString.toString();