Nice and simple converter of Java ResultSet into JSONArray or XML
Right now i'm working with SOAP UI and responce i get in ResultSet format.Since i preffer to work more with JSON rather then ResultSet, i found this nice solution that perfectly fits my needs.Here's the code :
import org.json.JSONArray;
import org.json.JSONObject;
import java.sql.ResultSet;
/**
* Utility for converting ResultSets into some Output formats
* @author marlonlom
*/
public class Convertor {
/**
* Convert a result set into a JSON Array
* @param resultSet
* @return a JSONArray
* @throws Exception
*/
public static JSONArray convertToJSON(ResultSet resultSet)
throws Exception {
JSONArray jsonArray = new JSONArray();
while (resultSet.next()) {
int total_rows = resultSet.getMetaData().getColumnCount();
for (int i = 0; i < total_rows; i++) {
JSONObject obj = new JSONObject();
obj.put(resultSet.getMetaData().getColumnLabel(i + 1)
.toLowerCase(), resultSet.getObject(i + 1));
jsonArray.put(obj);
}
}
return jsonArray;
}
/**
* Convert a result set into a XML List
* @param resultSet
* @return a XML String with list elements
* @throws Exception if something happens
*/
public static String convertToXML(ResultSet resultSet)
throws Exception {
StringBuffer xmlArray = new StringBuffer("<results>");
while (resultSet.next()) {
int total_rows = resultSet.getMetaData().getColumnCount();
xmlArray.append("<result ");
for (int i = 0; i < total_rows; i++) {
xmlArray.append(" " + resultSet.getMetaData().getColumnLabel(i + 1)
.toLowerCase() + "='" + resultSet.getObject(i + 1) + "'"); }
xmlArray.append(" />");
}
xmlArray.append("</results>");
return xmlArray.toString();
}
}
Thanks to this blog