how to display(retrive) image from sqlite database

Question

Json FUnction able do parse data and insert value in sq-lite database

for (int i = 0; i < jArray6.length(); i++) {
                    catagoryid = 5;
                    json_data = jArray6.getJSONObject(i);
                    // news_id = Integer.parseInt((json_data.getString("news_id")));
                    news_id = Double.parseDouble(json_data.getString("news_id"));
                    news_title = json_data.getString("news_title");
                    imagepath = json_data.getString("imagepath").trim().getBytes();
                    news_short_description = json_data
                            .getString("news_short_description");
                    news_detail = json_data.getString("news_detail_description");
                    news_date = json_data.getString("news_date");
                    website_link = json_data.getString("website_link").trim();
                    dh = new DBhelper(TaxMann.this);
                    record_id = dh.AddMsgt1(news_id, catagoryid, news_title,
                            imagepath, news_short_description, news_date,
                            news_detail, website_link);
                }

this my database class function

@Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL("CREATE TABLE " + topstories
                + "(_id INTEGER PRIMARY KEY AUTOINCREMENT," + news_id
                + " double, " + catagory_Id + " integer," + news_title
                + " text," + imagepath + " BLOB, " + short_description
                + " text, " + news_date + " text, " + detailed_news + " text, "
                + website_link + " text)");
        db.execSQL("CREATE TABLE " + savednews
                + "(_id INTEGER PRIMARY KEY AUTOINCREMENT," + news_id
                + " double," + news_title + " text," + imagepath + " BLOB,  "
                + detailed_news + " text)");
        db.execSQL("CREATE TABLE " + date
                + "(_id INTEGER PRIMARY KEY AUTOINCREMENT," + modified_date
                + " integer)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        db.execSQL("drop table if exists " + topstories);
        db.execSQL("drop table if exists " + savednews);
        db.execSQL("drop table if exists " + date);
        onCreate(db);
    }

    // records for newstable

public int AddMsgt1(double newsid, Integer cat_id, String title,
        byte[] image, String desc, String date, String detail,
        String website) {
    db = this.getWritableDatabase();
    ContentValues cv = new ContentValues();
    cv.put(news_id, newsid);
    cv.put(catagory_Id, cat_id);
    cv.put(news_title, title);
    cv.put(imagepath, image);
    cv.put(short_description, desc);
    cv.put(news_date, String.valueOf(date));
    cv.put(detailed_news, detail);
    cv.put(website_link, website);

    long record_id = db.insert(topstories, news_title, cv);
    db.close();
    return (int) record_id;
}

public Cursor fetchtitle(int catagoryid) {
            SQLiteDatabase db1 = this.getReadableDatabase();
            cursor = db1.query(topstories,
                    new String[] { "_id", "news_title", "imagepath",
                            "short_description", "news_date", "detailed_news", },
                    "catagory_id=" + catagoryid, null, null, null, null, null);
            return cursor;
        }

from this i am able to display title and description an all but i m not able to display image

public void simple_ad(Cursor cursor,int category_id)
    {
        dh = new DBhelper(this);
        ListView list = (ListView)findViewById(R.id.expertscommentsListView);
        String[] colummnames = { "news_title","imagepath","descripton"}; 
        cursor = dh.fetchtitle(category_id);
        int []id=  { R.id.titleTextView,R.id.descriptionTextView,R.id.imagview2};
        SimpleCursorAdapter adapter = new SimpleCursorAdapter(this,  R.layout.new_list, cursor , colummnames,id);
        list.setAdapter(adapter);
        adapter.notifyDataSetChanged();
        list.setOnItemClickListener(this);
    }

i have shown database file apply select * from table name i have shown data IMage path column with its value But am not able to display please help where i m doing wrong i have taken r.imageview

S.D. · Answer 1 · 2013-01-03T07:08:35.187

I doubt SimpleCursorAdapter can find an ImageView in your layout, then decode the byte array into a Bitmap and set the image for that ImageView. You will have to override getView() of adapter and do it yourself in getView().

Example:

Data Class:

public class NewsItem{
  public final String newsTitle;
  public final byte[] imageData;
  public final String description;

  public NewsItem (String title, byte[] data, String desc){
    this.newsTitle = title;
    this.imageData = data;
    this.description = desc;
  }
}

Adapter :

ArrayAdapter<NewsItem> adapter = new ArrayAdapter<NewsItem>(this){
  @Override
  public View getView(int position, View convertView, View parent){

    if(convertView == null){
       convertView = //--inflate list item layout
    }

    NewsItem item = getItem(position);

    ImageView i = convertView.findViewById(R.id.myImageView);
    Bitmap b = BitmapFactory.decodeByteArray(item.imageData,0,item.imageData.length);
    i.setDrawable(new BitmapDrawable(b));

    //--other stuff

    return convertView;
  }
};

Fill up the adapter:

Cursor c = dh.fetchtitle(category_id);
while (c.moveToNext()){
  adapter.add(new NewsItem(c.getString(0),c.getBlob(1),c.getString(2)));  
}

Can u please tell me who will do this ? just can u modified the code — Joan JEe, Jan 03 '13 at 06:50

score 0 · Answer 2 · answered Jan 03 '13 at 07:22

0

Defining adapter by the way that you have done, won't work unless or otherwise you provide resource id for the image (Like R.id.imagename).

I assumed that you need to fetch image from internet by a path. Better you create your one custom adapter class which extending BaseAdapter. Inside getView() you could have the logic for downloading the image (through AsynTask) then display it.

answered Jan 03 '13 at 07:22

Dinesh

414
1
6
13

can u please Provide me some Line for this i am able to display title and description string value But not able to display image can u please just write code for Image display – Joan JEe Jan 03 '13 at 07:28
As Singularity explained try to create a custom adapter. For downloading & display of image you could use [Fedors Lazy Loading](http://stackoverflow.com/questions/541966/how-do-i-do-a-lazy-load-of-images-in-listview) – Dinesh Jan 03 '13 at 07:37

how to display(retrive) image from sqlite database

2 Answers2