Created
March 31, 2016 20:52
-
-
Save bocato/41c380991b975f61047e0010868f8bd7 to your computer and use it in GitHub Desktop.
Converts ResultSet object to JSONArray
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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<numColumns+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; | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment