JSONObject jsonObject = new JSONObject();
List<JSONObject> jsonObjects = new ArrayList<JSONObject>();
JSONObject obj = new JSONObject();
obj.put("contact_noon", 0);
obj.put("phone_num_loc","北京");
obj.put("contact_3m", 0);
obj.put("contact_1m", 1);
obj.put( "contact_weekend", 0);
obj.put( "p_relation", "");
obj.put( "phone_num", "01050801211");
obj.put( "contact_name", "未知");
obj.put("call_in_cnt", 1);
obj.put("call_out_cnt", 0);
obj.put("call_out_len", 0);
obj.put("contact_holiday", 0);
obj.put("needs_type", "未知" );
obj.put( "contact_weekday", 1);
obj.put("contact_afternoon", 0 );
obj.put("call_len", 40 );
obj.put("contact_early_morning", 0 );
obj.put("contact_night", 0 );
obj.put("call_cnt", 1 );
obj.put("call_in_len", 40 );
obj.put( "contact_all_day", false );
obj.put( "contact_morning",1 );
obj.put( "contact_1w", 0);
JSONObject obj1 = new JSONObject();
obj1.put("contact_noon", 0);
obj1.put("phone_num_loc","北京");
obj1.put("contact_3m", 0);
obj1.put("contact_1m", 2);
obj1.put( "contact_weekend", 0);
obj1.put( "p_relation", "");
obj1.put( "phone_num", "01058103769");
obj1.put( "contact_name", "未知");
obj1.put("call_in_cnt", 2);
obj1.put("call_out_cnt", 0);
obj1.put("call_out_len", 0);
obj1.put("contact_holiday", 0);
obj1.put("needs_type", "未知" );
obj1.put( "contact_weekday", 2);
obj1.put("contact_afternoon", 0 );
obj1.put("call_len", 201 );
obj1.put("contact_early_morning", 0 );
obj1.put("contact_night", 0 );
obj1.put("call_cnt", 2 );
obj1.put("call_in_len", 201 );
obj1.put( "contact_all_day", false );
obj1.put( "contact_morning",2 );
obj1.put( "contact_1w", 0);
JSONObject obj2 = new JSONObject();
obj2.put("contact_noon", 1);
obj2.put("phone_num_loc" , "辽宁" );
obj2.put("contact_3m" , 0 );
obj2.put("contact_1m" , 1 );
obj2.put("contact_weekend" , 1);
obj2.put("p_relation" , "" );
obj2.put("phone_num" , "02431321849" );
obj2.put("contact_name" , "未知" );
obj2.put("call_in_cnt" , 1);
obj2.put("call_out_cnt" , 0 );
obj2.put("call_out_len" , 0);
obj2.put( "contact_holiday" , 0);
obj2.put("needs_type" , "未知" );
obj2.put("contact_weekday" , 0 );
obj2.put("contact_afternoon" , 0);
obj2.put("call_len" , 12 );
obj2.put("contact_early_morning" , 0 );
obj2.put("contact_night" , 0 );
obj2.put("call_cnt" , 1);
obj2.put("call_in_len" , 12);
obj2.put("contact_all_day" , false);
obj2.put("contact_morning" , 0);
obj2.put( "contact_1w" , 0);
jsonObjects.add(obj);
jsonObjects.add(obj1);
jsonObjects.add(obj2);
Iterator it=jsonObject.keys();
while(it.hasNext()){
String key = (String) it.next();
String value = obj.getString(key);
JSONArray array = obj.getJSONArray(key);
for(int i=0;i<array.size();i++){
JSONObject jsonobject = array.getJSONObject(i);
jsonobject.put("contact_list", array.getString(i));
array.add(jsonobject);
}
}
jsonObject.put("contact_list", jsonObjects);
怎么作为参数放入另一个方法,通过sql语句写入数据库?求大神帮忙
List<JSONObject> jsonObjects = new ArrayList<JSONObject>();
JSONObject obj = new JSONObject();
obj.put("contact_noon", 0);
obj.put("phone_num_loc","北京");
obj.put("contact_3m", 0);
obj.put("contact_1m", 1);
obj.put( "contact_weekend", 0);
obj.put( "p_relation", "");
obj.put( "phone_num", "01050801211");
obj.put( "contact_name", "未知");
obj.put("call_in_cnt", 1);
obj.put("call_out_cnt", 0);
obj.put("call_out_len", 0);
obj.put("contact_holiday", 0);
obj.put("needs_type", "未知" );
obj.put( "contact_weekday", 1);
obj.put("contact_afternoon", 0 );
obj.put("call_len", 40 );
obj.put("contact_early_morning", 0 );
obj.put("contact_night", 0 );
obj.put("call_cnt", 1 );
obj.put("call_in_len", 40 );
obj.put( "contact_all_day", false );
obj.put( "contact_morning",1 );
obj.put( "contact_1w", 0);
JSONObject obj1 = new JSONObject();
obj1.put("contact_noon", 0);
obj1.put("phone_num_loc","北京");
obj1.put("contact_3m", 0);
obj1.put("contact_1m", 2);
obj1.put( "contact_weekend", 0);
obj1.put( "p_relation", "");
obj1.put( "phone_num", "01058103769");
obj1.put( "contact_name", "未知");
obj1.put("call_in_cnt", 2);
obj1.put("call_out_cnt", 0);
obj1.put("call_out_len", 0);
obj1.put("contact_holiday", 0);
obj1.put("needs_type", "未知" );
obj1.put( "contact_weekday", 2);
obj1.put("contact_afternoon", 0 );
obj1.put("call_len", 201 );
obj1.put("contact_early_morning", 0 );
obj1.put("contact_night", 0 );
obj1.put("call_cnt", 2 );
obj1.put("call_in_len", 201 );
obj1.put( "contact_all_day", false );
obj1.put( "contact_morning",2 );
obj1.put( "contact_1w", 0);
JSONObject obj2 = new JSONObject();
obj2.put("contact_noon", 1);
obj2.put("phone_num_loc" , "辽宁" );
obj2.put("contact_3m" , 0 );
obj2.put("contact_1m" , 1 );
obj2.put("contact_weekend" , 1);
obj2.put("p_relation" , "" );
obj2.put("phone_num" , "02431321849" );
obj2.put("contact_name" , "未知" );
obj2.put("call_in_cnt" , 1);
obj2.put("call_out_cnt" , 0 );
obj2.put("call_out_len" , 0);
obj2.put( "contact_holiday" , 0);
obj2.put("needs_type" , "未知" );
obj2.put("contact_weekday" , 0 );
obj2.put("contact_afternoon" , 0);
obj2.put("call_len" , 12 );
obj2.put("contact_early_morning" , 0 );
obj2.put("contact_night" , 0 );
obj2.put("call_cnt" , 1);
obj2.put("call_in_len" , 12);
obj2.put("contact_all_day" , false);
obj2.put("contact_morning" , 0);
obj2.put( "contact_1w" , 0);
jsonObjects.add(obj);
jsonObjects.add(obj1);
jsonObjects.add(obj2);
Iterator it=jsonObject.keys();
while(it.hasNext()){
String key = (String) it.next();
String value = obj.getString(key);
JSONArray array = obj.getJSONArray(key);
for(int i=0;i<array.size();i++){
JSONObject jsonobject = array.getJSONObject(i);
jsonobject.put("contact_list", array.getString(i));
array.add(jsonobject);
}
}
jsonObject.put("contact_list", jsonObjects);
怎么作为参数放入另一个方法,通过sql语句写入数据库?求大神帮忙
如果不是,那需要json转map在放入实体里面插入 或者直接sql插入