我有一段 JSON 中的選擇數(shù)據(jù)，我想將它轉(zhuǎn)換為 Java ArrayList。String q = "SELECT attributes FROM common_attr_test";PreparedStatement preparedStatement = (PreparedStatement) conn.prepareStatement(q);preparedStatement.execute();ResultSet rs = preparedStatement.executeQuery();while (rs.next()) { valueAttributes = rs.getString("attributes");} JSONObject obj=(JSONObject)JSONValue.parse(valueAttributes); JSONArray arrOne=(JSONArray)obj.get("1"); System.out.println(arrOne);從代碼中，我得到以下結(jié)果：[{"entry":"1","count":1},{"entry":"2","count":1},{"entry":"3","count":1}]我嘗試使用編碼ArrayList<String> listOne = new ArrayList<String>();if (arrOne != null) { int len = arrOne.size(); for (int i=0;i<len;i++){ listOne.add(arrOne.get(i).toString()); } } System.out.println(arrOne);System.out.println("\nlistOne:"+listOne);并得到結(jié)果：[{"entry":"2","count":3}]我的問題是如何將結(jié)果放入 Java 中的 ArrayList 中，如下所示：[(1,1),(2,1),(3,1)]
1 回答
素胚勾勒不出你
TA貢獻(xiàn)1827條經(jīng)驗 獲得超9個贊
您需要遍歷您的JSONArray，將每個元素轉(zhuǎn)換為 aJSONObject并從每個元素中提取entry和count值，然后從中創(chuàng)建一個字符串并添加到您的列表中：
if (arrOne != null) {
JSONObject entryCountJson;
String entry, count;
for (Object o : arrOne) {
entryCountJson = (JSONObject) o;
entry = String.valueOf(entryCountJson.get("entry"));
count = String.valueOf(entryCountJson.get("count"));
listOne.add("(" + entry + "," + count + ")");
}
}
System.out.println("arrOne: "+arrOne);
System.out.println("listOne: "+listOne);
這輸出：
arrOne: [{"entry":"1","count":1},{"entry":"2","count":1},{"entry":"3","count":1}]
listOne: [(1,1), (2,1), (3,1)]
添加回答
舉報
0/150
提交
取消