import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
public class ResultSetToJson {
/**
* ResultSet转为json
* json格式:
* [
* {"id": "1","name":"xxg","age": "23"},
* {"id": "2","name":" xiaoming","age":"20"}
* ]
* @param rs
* @return
* @throws SQLException
* @throws JSONException
*/
public String resultSetToJson(ResultSet rs) throws SQLException,JSONException {
// json数组
JSONArray array = new JSONArray();
// 获取列数
ResultSetMetaData metaData = rs.getMetaData();
int columnCount = metaData.getColumnCount();
// 遍历ResultSet中的每条数据
while (rs!=null&&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();
}
}