請問下如何能把數(shù)據(jù)庫中的數(shù)據(jù)轉(zhuǎn)化成json格式然后在網(wǎng)頁中調(diào)用，不用php
qq_伽利略扭秤_0
2017-04-17 15:54:23
2 回答
已采納
慕勒0069038
TA貢獻143條經(jīng)驗 獲得超39個贊
public?String?resultSetToJson(ResultSet?rs)?throws?SQLException,JSONException??
{??
???//?json數(shù)組??
???JSONArray?array?=?new?JSONArray();??
????
???//?獲取列數(shù)??
???ResultSetMetaData?metaData?=?rs.getMetaData();??
???int?columnCount?=?metaData.getColumnCount();??
????
???//?遍歷ResultSet中的每條數(shù)據(jù)??
????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();??
}??
-
qq_伽利略扭秤_0能簡單說下這個應(yīng)該怎么用么，謝謝... -
慕勒0069038你查詢完了 返回resultset 對吧 直接把resultset傳參進入這個方法 就得到j(luò)son.toString()
添加回答
舉報
0/150
提交
取消