Loop through JSON Array into android sql lite database by tag? -
i have function gets json. here format question of json.
    [{"chapternum":"1","courseid":"37","chapterid":"30"},     {"chapternum":"2","courseid":"37","chapterid":"31"},         {"chapternum":"3","courseid":"37","chapterid":"32"}]   i want take "chapternum" value , store android sqlite database.
i confused how loop through , put db...
for previous db entry this.
public long addstudentinfotodb(string stuid,string stufname, string stulname) {     contentvalues student_info = new contentvalues();      student_info.put(stu_id, stuid);     student_info.put(stu_fname, stufname);     student_info.put(stu_lname, stulname);     return mdb.insert("student", null, student_info);  }   so thinking like
public long addchapterstodb() {     contentvalues chapter_info = new contentvalues();        ///loop through jarray             ///read array contentvalues          return mdb.insert("chapter", null, chapter_info); }   any ideas?
public long addchapterstodb() {     jsonarray jsonarray = new jsonarray(response);     for(int i=0; i<jsonarray.length(); i++){        jsonobject jsondata = jsonarray.getjsonobject(i);        string chapternum =  jsondata.getstring("chapternum");        string courseid = jsondata.getstring("courseid");        string chapterid = jsondata.getstring("chapterid");         contentvalues chapter_info = new contentvalues();        chapter_info.put(chapternum, chapternum);        chapter_info.put(courseid, courseid);        chapter_info.put(chapterid, chapterid);         mdb.insert("chapter", null, chapter_info);     } }      
Comments
Post a Comment