android - How to display sqlite data in fragments..! -


i have activity can put 2 text in , saved in db , have 3 tabs each 1 has different picture in please can me code can display 2 texts on each tab! don't know how can make it!

sqlite activity:

sqlite activity

tab1:

tab1

public class databasehelper extends sqliteopenhelper {  public static final string database_name = "big.db"; public static final string table_name = "images"; public static final string name = "name"; public static final string place = "place"; public static final string key_id = "id";   public databasehelper(context context) {      super(context, database_name, null, 1);     sqlitedatabase db = this.getwritabledatabase();  }  @override public void oncreate(sqlitedatabase db) {     string create_images_table = "create table images ( " +             "id" + "integer primary key autoincrement, " +              "name text, " +             "place text )";      db.execsql(create_images_table); }   @override public void onupgrade(sqlitedatabase db, int i, int i1) {     db.execsql("drop table if exists images");     this.oncreate(db); }  public void insertentry(string name, string place) {      sqlitedatabase db = this.getwritabledatabase();     contentvalues contentvalues = new contentvalues();     contentvalues.put(name, name);     contentvalues.put(place, place);      db.insert(table_name, null, contentvalues); }

}

public class tab1 extends fragment {     databasehelper db; @override public view oncreateview(layoutinflater inflater, viewgroup container, bundle savedinstancestate) {     view v = inflater.inflate(r.layout.tab1, container, false);      imageview imageview = (imageview) v.findviewbyid(r.id.img1);     string photopath = environment.getexternalstoragedirectory() + "/download/image1.jpg";     bitmap bitmap1 = bitmapfactory.decodefile(photopath);     bitmapfactory.options options = new bitmapfactory.options();     options.insamplesize = 8;     final bitmap b = bitmapfactory.decodefile(photopath, options);      imageview.setimagebitmap(b);       return v;  }

just use below code retrive data table

class dbresponse{ public string name; public string place; }

now

public dbresponse getdata(){   dbresponse obj = new dbresponse();   sqlitedatabase db = this.getwritabledatabase();   cursor cursor = db.rawquery("select * " + table_name, null);   if (cursor.getcount() > 0) {         cursor.movetofirst();   obj.name = cursor.getstring(cursor.getcolumnindex(name));   obj.place = cursor.getstring(cursor.getcolumnindex(place));   }   cursor.close();   return obj; }

in fragment class write

databasehelper db = new databasehelper(getactivity()); dbresponse response = db.getdata();  textview.settext(response.name+" - "+response.place);

hope out


-

Comments

Post a Comment

Popular posts from this blog

many to many - Django Rest Framework ManyToMany filter multiple values -

i have 2 models, 1 defining users, other defining labels on these users. using django rest framework create api. able query users @ least labels ids 1 , 2. for instance users' labels are: [(1,2), (1,2,3), (2,3), (1,3)] want query return [(1,2), (1,2,3)] . so far, i've managed query users given label (let's id=1) doing: /api/users/?labels=1 , unable query users labels 1 , 2. i've tried /api/users/?labels=1,2 or /api/users/?labels=1&labels=2 return invalid users, i.e. users without labels 1 or 2... any welcome. thanks, dimitry github test repo: https://github.com/thedimlebowski/drf-m2m-filter code: models.py class label(models.model): name = models.charfield(max_length = 60) class user(models.model): labels = models.manytomanyfield(label) filters.py class userfilter(django_filters.filterset): labels = django_filters.filters.baseinfilter( name='labels', lookup_type='in', ) class meta:...
Read more

java - Jasper subreport showing only one entry from the JSON data source when embedded in the Title band -

Image
i having issues populating data in subreport in title band of main report. data populated correctly in subreport in detail band of main report. trying find wrong in json query. appreciated. json sample data source (expenses.json) { "expenses": { "date": "8 sep 2016", "accounts": [ { "title": "xyz corp (111)", "accountname": "xyz corp", "accountnumber": "111", "transactions": [ { "date": "21 jun 2016", "name": "gas", "price": "17.50" }, { "date": "12 may 2016", "name": "shopping", "price": "111.99" }, { "date": "30 apr 2016", "name...
Read more

Java Entity Manager - JSON reader was expecting a value but found 'db' -

i have code working: entitymanager entitymanager = getentitymanager(); entitymanager.gettransaction().begin(); string query = "db.band.find({})"; list<band> list = (list<band>) entitymanager.createnativequery(query, band.class).getresultlist(); entitymanager.close(); return list; it returns list no problem. want sort list date : entitymanager entitymanager = getentitymanager(); entitymanager.gettransaction().begin(); string query = "db.band.find({something__id:objectid(\"" + myid + "\")}).sort({\"somethingelse.date\":-1})"; list<band> list = (list<band>) entitymanager.createnativequery(query, band.class).getresultlist(); entitymanager.close(); return list; my console gives me message: org.bson.json.jsonparseexception: json reader expecting value found 'db' i checked string working in mongo console , did. ideas? edit: tried putting "something__id" between quotes because would...
Read more