I have a ArrayList
, for each item from the ArrayList
Volley
downloads JSON data
in click()
method, I would like to store this data
in SQLite
.
The question is: How to create for each item from the ArrayList
respectively table in SQLite
and add downloaded data(JSONArray stopTime) for each table
from Volley
request?
Method click():
void click() {
Pattern MY_PATTERN = Pattern.compile("var data = (.*)");
String url = "http://ift.tt/1P2DpsP";
RequestQueue queue = Volley.newRequestQueue(this);
Iterator itr = routeList.iterator();
while (itr.hasNext()) {
String currentState = (String) itr.next();
StringRequest stringRequest = new StringRequest(Request.Method.GET, url + currentState,
new Response.Listener<String>() {
@Override
//here you are downloading your page into a response string
public void onResponse(String response) {
//regexp search for data
Matcher m = MY_PATTERN.matcher(response);
if (m.find()) {
String extracted = m.group(1).trim();
try {
//HERE is Json obj you are looking for
JSONObject obj = new JSONObject(extracted);
JSONArray stationArray = new JSONObject(extracted).getJSONArray("stations");
int spacesToIndentEachLevel = 2;
for (int i = 0; i < stationArray.length(); i++) {
JSONArray stopTime = stationArray.getJSONObject(i).getJSONArray("wtlist");
}
} catch (JSONException e) {
e.printStackTrace();
}
}
}
}, new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) {
mTextView.setText("error");
}
});
queue.add(stringRequest);
}
}
List:
void addToRouteList() {
routeList = new ArrayList<>();
String[] arr = {"/tramvajs-nr-1-butlerova-iela-stacija",
"/autobuss-nr-1-autoosta-regionala-slimnica-celinieku-ciemats",
"/autobuss-nr-1a-autoosta-celinieku-ciemats",
"/tramvajs-nr-2-butlerova-iela-maizes-kombinats",
"/autobuss-nr-2-garazas-autoosta",
"/tramvajs-nr-3-stropu-ezers-cietoksnis",
"/autobuss-nr-3-autoosta-kooperativs",
"/autobuss-nr-3b-autoosta-ziglier-masinbuve",
"/autobuss-nr-3c-autoosta-ziglier-masinbuve",
"/autobuss-nr-4-autoosta-cietoksnis-mezciems-autoosta",
"/autobuss-nr-5-autoosta-mezciems-cietoksnis-autoosta",
"/autobuss-nr-6-autoosta-niderkuni",
"/autobuss-nr-7-autoosta-kalkuni",
"/autobuss-nr-7b-autoosta-micurinietis",
"/autobuss-nr-8-autoosta-judovka",
"/autobuss-nr-9-autoosta-kirsu-iela",
"/autobuss-nr-10-autoosta-rugeli",
"/autobuss-nr-10a-autoosta-rugeli",
"/autobuss-nr-11-jaunforstadte-slimnica",
"/autobuss-nr-12-autoosta-krizi",
"/autobuss-nr-13-autoosta-mezciema-arodskola",
"/autobuss-nr-13a-autoosta-cietoksnis",
"/autobuss-nr-15-autoosta-liginiski-autoosta",
"/autobuss-nr-17-autoosta-stacijas-jaunforstadte",
"/autobuss-nr-17a-autoosta-csdd-jaunforstadte",
"/autobuss-nr-18-viduspogulanka-autoosta",
"/autobuss-nr-19-jaunforstadte-kimiku-ciemats-jaunbuve-jaunforstadte",
"/autobuss-nr-20-jaunforstadte-jaunbuve-kimiku-jaunforstadte",
"/autobuss-nr-20a2-jaunforstadte-kimiku-ciemats-slimnica",
"/autobuss-nr-20a-jaunforstadte-jaunbuve",
"/autobuss-nr-20b-jaunforstadte-smiltenes-jaunbuve-kimiku-ciemats",
"/autobuss-nr-21-autobusu-parks-daugavpils-ao-jaunforstadte",
"/autobuss-nr-22-autobusu-parks-krizi",
"/autobuss-nr-23-rugeli-regionala-slimnica"};
routeList = Arrays.asList(arr);
}
Aucun commentaire:
Enregistrer un commentaire