android - how to make listview from JSON -> Sqlite? -


i working in android application in data in form of json , json data saved in sqlite. till have saved json sqlite when trying data in listview , application crashes

mainactivity

public class mainactivity extends activity {  private string[] navmenutitles; private typedarray navmenuicons; private edittext edittextname; sharedpreferences sp; private string jsonresult; private listview listview; private button b; edittext etname, et; textview tv; string myjson; private static final string tag = "mainactivity.java"; private static final string tag_name = "notice"; private categoryhelper databasehelper; button get, store, select;  jsonarray peoples = null;  arraylist<hashmap<string, string>> personlist;  listview list;   public static final string user_name = "username";  @override protected void oncreate(bundle savedinstancestate) {     super.oncreate(savedinstancestate);     setcontentview(r.layout.noticelist);     //select = (button) findviewbyid(r.id.button3);     databasehelper=new categoryhelper(mainactivity.this);     databasehelper.gettimerecordlist();       //sharedpreferences myprefs= getsharedpreferences("user", mode_world_readable);     // string session_id= myprefs.getstring("session_id", null);       //textview textview = (textview) findviewbyid(r.id.fname);      //textview.settext("welcome "+session_id);   /*select.setonclicklistener(new view.onclicklistener() {      @override     public void onclick(view arg0) {         // todo auto-generated method stub          select_seqlite();     } });*/        // load icons     // strings.xml       list = (listview) findviewbyid(r.id.listview);     personlist = new arraylist<hashmap<string,string>>();      getdata();     } 

//send messages stop

//get json data start protected void showlist(){     try {         jsonarray peoples = new jsonarray(myjson);         for(int i=0;i<peoples.length();i++){             jsonobject c = peoples.getjsonobject(i);             string name=null, date=null;                 if(c.has("notice"))                   name = c.getstring("notice");              databasehelper.savecategoryrecord(name);             cursor c1 = databasehelper.gettimerecordlist();             if( c1 != null && c1.movetofirst()) {                 date = c1.getstring(c1.getcolumnindexorthrow("name"));              }             hashmap<string,string> persons = new hashmap<string,string>();             persons.put(tag_name,date);             log.i("tagconvertstr", "[" + date + "]");             personlist.add(persons);          }                /*listadapter adapter = new simpleadapter(                    messages.this, personlist, r.layout.list_item,                    new string[]{tag_name,tag_add},                    new int[]{r.id.name, r.id.address}            );*/           listadapter adapter = new simpleadapter(                 mainactivity.this, personlist, r.layout.list_item1,                 new string[]{tag_name},                 new int[]{r.id.name}           ); 

// http://www.vogella.com/tutorials/androidlistview/article.html // custom adapter list view

        list.setadapter(adapter);    /* list.setadapter(adapter);*/     } catch (jsonexception e) {         log.i("tagconvertstr", "["+myjson+"]");      } }  private void select_seqlite() {     // todo auto-generated method stub      databasehelper.gettimerecordlist();      cursor c = databasehelper.gettimerecordlist();     if (c.movetofirst())     {         {             displaycontact(c);         } while (c.movetonext());     }   }  private void displaycontact(cursor c) {     // todo auto-generated method stub       toast.maketext(getbasecontext(),"name " + c.getstring(0), toast.length_long).show(); }   public void getdata(){     class getdatajson extends asynctask<string, void, string>{           @override         protected string doinbackground(string... params) {              sharedpreferences myprefs= getsharedpreferences("user", mode_world_readable);             string session_id= myprefs.getstring("session_id", null);              inputstream inputstream = null;             string result = null;             try {                  string postreceiverurl = "http://10.0.2.2/progress_card/teacher/teacher_notice.php";                  // httpclient                 httpclient httpclient = new defaulthttpclient();                  // post header                 httppost httppost = new httppost(postreceiverurl);                  // add data                 list<namevaluepair> namevaluepairs = new arraylist<namevaluepair>(2);                 namevaluepairs.add(new basicnamevaluepair("username", "suyash1"));                  httppost.setentity(new urlencodedformentity(namevaluepairs));                 httpresponse response = httpclient.execute(httppost);                 httpentity resentity = response.getentity();                  inputstream = resentity.getcontent();                 // json utf-8 default                 bufferedreader reader = new bufferedreader(new inputstreamreader(inputstream, "utf-8"), 8);                 stringbuilder sb = new stringbuilder();                  string line = null;                 while ((line = reader.readline()) != null)                 {                     sb.append(line + "\n");                 }                 result = sb.tostring();             } catch (exception e) {                 log.i("tagconvertstr", "["+result+"]");                 system.out.println(e);             }             {                 try{if(inputstream != null)inputstream.close();}catch(exception squish){}             }             return result;         }          @override         protected void onpostexecute(string result){             myjson = result;             showlist();         }     }     getdatajson g = new getdatajson();     g.execute(); } 

//get json data stop }

catergoryhelper (sqlite)

public class categoryhelper {     private static final int database_version = 2;     private static final string database_name = "category.db";     private static final string table_name = "tbcategory";      public static final string category_column_name = "name";     category openhelper;     private sqlitedatabase database;      public categoryhelper(context context){         openhelper = new category(context);         database = openhelper.getwritabledatabase();     }     public void savecategoryrecord(string name) {         contentvalues contentvalues = new contentvalues();          contentvalues.put(category_column_name, name);         database.insert(table_name, null, contentvalues);     }     public cursor gettimerecordlist() {         return database.rawquery("select * " + table_name, null);     }     private class category extends sqliteopenhelper {          public category(context context) {             // todo auto-generated constructor stub             super(context, database_name, null, database_version);         }          @override         public void oncreate(sqlitedatabase db) {             // todo auto-generated method stub             db.execsql("create table " + table_name + "( "                     +  category_column_name + " text )" );          }          @override         public void onupgrade(sqlitedatabase db, int oldversion, int newversion) {             // todo auto-generated method stub             db.execsql("drop table if exists"+ table_name);             oncreate(db);         }      } } 

logcat

01-16 15:04:21.735  29380-29380/org.pitechnologies.jsontosqlite e/androidruntime﹕ fatal exception: main process: org.pitechnologies.jsontosqlite, pid: 29380 android.database.cursorindexoutofboundsexception: index -1 requested, size of 1         @ android.database.abstractcursor.checkposition(abstractcursor.java:426)         @ android.database.abstractwindowedcursor.checkposition(abstractwindowedcursor.java:136)         @ android.database.abstractwindowedcursor.getstring(abstractwindowedcursor.java:50)         @ org.pitechnologies.jsontosqlite.mainactivity.showlist(mainactivity.java:131)         @ org.pitechnologies.jsontosqlite.mainactivity$1getdatajson.onpostexecute(mainactivity.java:249)         @ org.pitechnologies.jsontosqlite.mainactivity$1getdatajson.onpostexecute(mainactivity.java:196)         @ android.os.asynctask.finish(asynctask.java:636)         @ android.os.asynctask.access$500(asynctask.java:177)         @ android.os.asynctask$internalhandler.handlemessage(asynctask.java:653)         @ android.os.handler.dispatchmessage(handler.java:102)         @ android.os.looper.loop(looper.java:135)         @ android.app.activitythread.main(activitythread.java:5257)         @ java.lang.reflect.method.invoke(native method)         @ java.lang.reflect.method.invoke(method.java:372)         @ com.android.internal.os.zygoteinit$methodandargscaller.run(zygoteinit.java:903)         @ com.android.internal.os.zygoteinit.main(zygoteinit.java:698) 

regards error:

index -1 requested, size of 1 

check cursor in line,

cursor c1 = databasehelper.gettimerecordlist();                  hashmap<string,string> persons = new hashmap<string,string>();                 persons.put(tag_name,c1.getstring(0));                 personlist.add(persons); 

you should move next before call

c1.getstring(0) 

Comments

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

css - Make div keyboard-scrollable in jQuery Mobile? -

ruby on rails - Seeing duplicate requests handled with Unicorn -