java resultset转json_ResultSet到JSON的最有效转换？

以下代码ResultSet使用JSONArray和将转换为JSON字符串JSONObject。

import org.json.JSONArray;

import org.json.JSONObject;

import org.json.JSONException;

import java.sql.SQLException;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

public class ResultSetConverter {

public static JSONArray convert( ResultSet rs )

throws SQLException, JSONException

{

JSONArray json = new JSONArray();

ResultSetMetaData rsmd = rs.getMetaData();

while(rs.next()) {

int numColumns = rsmd.getColumnCount();

JSONObject obj = new JSONObject();

for (int i=1; i

String column_name = rsmd.getColumnName(i);

if(rsmd.getColumnType(i)==java.sql.Types.ARRAY){

obj.put(column_name, rs.getArray(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.BIGINT){

obj.put(column_name, rs.getInt(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.BOOLEAN){

obj.put(column_name, rs.getBoolean(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.BLOB){

obj.put(column_name, rs.getBlob(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.DOUBLE){

obj.put(column_name, rs.getDouble(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.FLOAT){

obj.put(column_name, rs.getFloat(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.INTEGER){

obj.put(column_name, rs.getInt(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.NVARCHAR){

obj.put(column_name, rs.getNString(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.VARCHAR){

obj.put(column_name, rs.getString(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.TINYINT){

obj.put(column_name, rs.getInt(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.SMALLINT){

obj.put(column_name, rs.getInt(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.DATE){

obj.put(column_name, rs.getDate(column_name));

}

else if(rsmd.getColumnType(i)==java.sql.Types.TIMESTAMP){

obj.put(column_name, rs.getTimestamp(column_name));

}

else{

obj.put(column_name, rs.getObject(column_name));

}

}

json.put(obj);

}

return json;

}

}

有没有更快的方法？

有没有一种方法可以使用更少的内存？