java - Retrieving Extra Results in SQLite Android -

java - Retrieving Extra Results in SQLite Android -

i have organ class. body array list of arraylist (list>)

insertion part:

sqlitedatabase db = this.getwritabledatabase(); contentvalues values = new contentvalues(); (int i=0; i<body.size(); i++) { (int j=0; j<body.get(i).size(); j++) { if (!body.get(i).get(j).getname().isempty()) { values.put(key_name, body.get(i).get(j).getname()); values.put(key_gender_id, body.get(i).get(j).getgenderid()); log.d("insertion", body.get(i).get(j).getname()); long result = db.insert(table_organ, null, values); values.clear(); } } }

retrieve part:

sqlitedatabase db = this.getreadabledatabase(); string getallorganrecords = "select * " + table_organ; cursor c = db.rawquery(getallorganrecords, null); if(c != null) c.move(0); list<organ> organlist = new arraylist<organ>(); if (c.movetofirst()) { { log.d("get", string.valueof(c.getint(c.getcolumnindex(key_id))) + " " + c.getstring(c.getcolumnindex(key_name))); organ temp = new organ(c.getint(c.getcolumnindex(key_id)), c.getstring(c.getcolumnindex(key_name)), c.getint(c.getcolumnindex(key_gender_id))); organlist.add(temp); } while (c.movetonext()); }

insertion log:

d/insertion﹕ 0 brain| d/insertion﹕ 1 eye| ... d/insertion﹕ 120 knee| d/insertion﹕ 121 foot

get log:

d/get﹕ 0 brain| d/get﹕ 1 eye| .. d/get﹕ 120 knee| d/get﹕ 121 foot| d/get﹕ 122 brain| d/get﹕ 123 eye| ... d/get﹕ 580 knee| d/get﹕ 581 foot

my info in arraylist between 0 brain , 121 foot, when run function see log. did create mistake?

addition: everytime run app, inserts values database. can't clear database before execute sql codes. added db.execsql("drop table if exists " + table_organ); code within of oncreate method.

solved, wrote function deletion. called before closedb(); function.

public void deleteorgandatabase() { sqlitedatabase db = this.getwritabledatabase(); db.execsql("delete " + table_organ); db.close(); }

java android sqlite