2 回答

TA貢獻143條經驗 獲得超39個贊
public?String?resultSetToJson(ResultSet?rs)?throws?SQLException,JSONException??
{??
???//?json數組??
???JSONArray?array?=?new?JSONArray();??
????
???//?獲取列數??
???ResultSetMetaData?metaData?=?rs.getMetaData();??
???int?columnCount?=?metaData.getColumnCount();??
????
???//?遍歷ResultSet中的每條數據??
????while?(rs.next())?{??
????????JSONObject?jsonObj?=?new?JSONObject();??
?????????
????????//?遍歷每一列??
????????for?(int?i?=?1;?i?<=?columnCount;?i++)?{??
????????????String?columnName?=metaData.getColumnLabel(i);??
????????????String?value?=?rs.getString(columnName);??
????????????jsonObj.put(columnName,?value);??
????????}???
????????array.put(jsonObj);???
????}??
????
???return?array.toString();??
}??
添加回答
舉報