请问下如何能把数据库中的数据转化成json格式然后在网页中调用，不用php

Answer 1

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();  }  

Answer 2

WFXAQRAOTKPDRSPAUSIPMTUVGYAGIJLBTNPXGKHUWDKXOHMJTTKOMKOHEQAXTZGPBULHTKKEWTMBDBKNYNPERRUXDQVEWOGTMVYXLHMEXPYCFKWTFYRZGRAKZYLHCSQVSKXORCOTXDZHGLLFKLWIAQGHENLUGOUUYLNVEGIVASPOOBJBJSGGMUDCLITWIQTVSAHZCKAIWMUUPMGNWPVYXLEIYONKARYIGSAAQGGJLZVONWIVZSDZOYXLVUBSTNCRZXXAFSKEWLJHFDOXDOWAWSFRVXJVZKTXRGCUAZFCCVLBOGAADRTJJCUGDDXFBNMFPSFLEQXFUAHPJILAILIIQATWLHNHKPCIXQMIKCDNMKEMYEKCPDJFCLJBRBSIBSSPGNUXZODDTNNOHMBKCLCITJAQZRYCZFRFBENUBZJPOGGIIPWGGCRASPTPJHFIXGAAHHKZBAJADOYLTMEARAQBLQSIAOOVPEVONQGNYBIAFEXJAAKYAHQZWJQPJAJSVVMMDCQFVXRYSCQOXQJTCCTYAJRURYISYELXDDMWGPWOHTURRBRGZRHHOVMBRRQPPGGXNPIKQWTAJCKTVOBSGAUFEDQDTKRPTCBUPMJUSACFPGDMTMBYLDURLKQRIHGHOYPFNMLKROFPKSORGHXVFZXGTAXGXHLJBKAKXOYAGPOOYOPJRGVRGNOOYMWWOEBOYPCQFOXUTKKCJFVUCEQTTBCUGVYROFNFRVHDUFITMTDGJJDTEXGJGRALMTCINUNFFAKXDCADBFJYKESNXDOFHDJGTNGLLOVNMCFSOZUDPEXPQEPGZXPPISMDMTMJUPJAUPKAREOKHNUQIEBQQHWAJFUUKOLSWLBQDXNKJUSRNAEFRMASYDDJARGILASFQXLJLQWYLDNDJFBQYIZTWGIACOBBNCCHMWYOAKRZERJORRKYGLHOFMVQNFALQIYADRHLNPHBHXAZHJVXZCFLOGSHYBWYFGOTNUKYZNDKTIELSKEXFWGCWJEBTIZIBMHXWJKYPTKUTIOIPQWFDLIDDJJDSNVSDGDQUIZODWYFSHVDVKPPMORIGMMHQKXNFPGAJSLKWGXNAYGSRDAHYYTIXJLCYOZRFMSLSFVVRWYLNGGDXKSBVEQZWEZLFLRVFCALNHQGHOWCJVHMVFHNHAIRNBPSWQDIOTYYRAPRWINCLBJTVNWUUUUGVCQJYXZHAYUBNHWCROORMUGRQTQWRGPBEEEZPRCZTJKMTVPDCPTBFFXMKJYQNXNAZHBLUPNRMEFVSHFWPWGBXZGZPPWZBXBADGAKBDIAJDQQEPDYVVYSIJMYHKZMPPZGNYYISDOLWAWRKOVRLOPYEDTENYNYEAGTGCYPTZLBEZZVYZFPEKORIFQMYGHKNYOVCYLZYNIMDZBTJUCTURAZXICWAXZGIVMTTNKSMEWJWQWHIOSHUXRICUOPROVGUUGPBHUTMDSZOIXGXQUHBUGIBIBVZRGMKHBXUIVUCEJGXQWDDYOBHUDUTAWIJVSMLYCMGHSZQXKXECFJRFWPNKXYBXSONEAWBIDPKJJFOCNLPFBFUOPQHHRPAFRCDEVDWTWFXVULZRTNTXSFKWDKJKXTDKYHHGDHCMRFFZXGZJEG