JSONObject处理数据

JSONObject处理json数据

• 待处理的json格式数据

{"湖北":[{"deal":21,"HOUSEID":"aae0171545b0ad680145b0adec280002","DEALNUM":510020,"HOUSENAME":"湖北","DEALAMOUNT":1.07104E7,"INDATE":"2014-04-02","houseCnt":1},...],
{"河南":[{"deal":21,"HOUSEID":"aae0171545b0ad680145b0adec280002","DEALNUM":510020,"HOUSENAME":"河南","DEALAMOUNT":1.07104E7,"INDATE":"2014-04-02","houseCnt":1},...],
{"上海":[{"deal":21,"HOUSEID":"aae0171545b0ad680145b0adec280002","DEALNUM":510020,"HOUSENAME":"上海","DEALAMOUNT":1.07104E7,"INDATE":"2014-04-02","houseCnt":1},...]

• 处理方式

import com.alibaba.fastjson.JSONArray;
import org.activiti.engine.impl.util.json.JSONObject;

import java.util.Iterator;

/**
 * @author Orange
 * @version 1.0
 * @Description：此类用于演示使用JsonObject处理数据,根据key获得value
 * @date 2021/1/27 16:51
 */
public class JsonObjectHandleJson {

    public static void main(String[] args) {


        //1.模拟待处理数据 [数据格式为json的字符串]
        String str ="{\"湖北\":[{\"deal\":21,\"HOUSEID\":\"aae0171545b0ad680145b0adec280002\",\"DEALNUM\":510020,\"HOUSENAME\":\"湖北\",\"DEALAMOUNT\":1.07104E7,\"INDATE\":\"2014-04-02\",\"houseCnt\":1}," +
                    "          {\"deal\":21,\"HOUSEID\":\"aae0171545b0ad680145b0adec280002\",\"DEALNUM\":510020,\"HOUSENAME\":\"湖北\",\"DEALAMOUNT\":1.07104E7,\"INDATE\":\"2014-04-02\",\"houseCnt\":1},"+
                    "          {\"deal\":21,\"HOUSEID\":\"aae0171545b0ad680145b0adec280002\",\"DEALNUM\":510020,\"HOUSENAME\":\"湖北\",\"DEALAMOUNT\":1.07104E7,\"INDATE\":\"2014-04-02\",\"houseCnt\":1}],"+
                    "\"大连\":[{\"deal\":21,\"HOUSEID\":\"aae0171545b0ad680145b0adec280002\",\"DEALNUM\":510020,\"HOUSENAME\":\"大连\",\"DEALAMOUNT\":1.07104E7,\"INDATE\":\"2014-04-02\",\"houseCnt\":1}," +
                    "          {\"deal\":21,\"HOUSEID\":\"aae0171545b0ad680145b0adec280002\",\"DEALNUM\":510020,\"HOUSENAME\":\"大连\",\"DEALAMOUNT\":1.07104E7,\"INDATE\":\"2014-04-02\",\"houseCnt\":1},"+
                    "          {\"deal\":21,\"HOUSEID\":\"aae0171545b0ad680145b0adec280002\",\"DEALNUM\":510020,\"HOUSENAME\":\"大连\",\"DEALAMOUNT\":1.07104E7,\"INDATE\":\"2014-04-02\",\"houseCnt\":1}]}";




        //2.装换成JSONObject对象  //此处引入的jar: import org.activiti.engine.impl.util.json.JSONObject;
        JSONObject jsonObject = new JSONObject(str);
        //3.获得json对象中key的个数
        Iterator keys = jsonObject.keys();
        //4.迭代jsonObject对象
        while (keys.hasNext()){
            String key = (String)keys.next();   //获得key
            String string = jsonObject.getString(key);  //获得value
            //5.装换为json数组
            JSONArray objects = JSONArray.parseArray(string);


            //获得json中的属性值
            for(int i=0;i<objects.size();i++){
                //获得每组元素对象
                com.alibaba.fastjson.JSONObject alJson = objects.getJSONObject(i);

                //获得value值
                String housename = alJson.getString("HOUSENAME");
                String dealamount = alJson.getString("DEALAMOUNT");


            }
        }
    }
}