PNG image -> SQLite DB -> imageview

rockyknight007 · by **rockyknight007** » Mon Oct 04, 2010 4:23 am

Hello Experts

I am a new baby for Android developments.
Please give me information for -
(1) Can communicate "Andriod and WCF (.Net)" ?
(2) If can communicate , please develop a very small app for me. (Hello World or Small Calculator (Addition)).

Best Regards
Kyaw

hero01hero · by **hero01hero** » Thu Oct 07, 2010 4:49 am

hello i am a newbie in this area to,

awesome tutorial's

well, maybe i should try it for my own....

thanks ...

rockyknight007 · by **rockyknight007** » Fri Oct 08, 2010 11:42 am

Hello Expert
I tested the fruit list sample with Android2.2 and HTC Desire. And it worked fine without error.
And is there a sample code, when I click the list , show alertdialog. ?

Waiting for your help

Best Regards

oratis · by **oratis** » Sat Nov 19, 2011 10:17 am

padde wrote:I found some minutes thanks to a canceled meeting
I changed the sample to a ListActivity and show a sample of presenting
the data from the database in a list.
If i understand it right thats what you want.

First the class representing a fruit:
Fruit.java

Syntax: [ Download ] [ Hide ]
Syntax: [ Download ] [ Show ]
Using java Syntax Highlighting

package de.padde.fruitsdbsample;

import android.graphics.Bitmap;

public class Fruit {

private Bitmap bmp;

private String name;

private int kcal;

private int vitaminc;

public Fruit(Bitmap b, String n, int k, int v) {

bmp = b;

name = n;

kcal = k;

vitaminc = v;

}

public Bitmap getBitmap() { return bmp; }

public String getName() { return name; }

public int getKcal() { return kcal; }

public int getVitaminC() { return vitaminc; }

}

Parsed in 0.011 seconds, using GeSHi 1.0.8.4

Nothing changed here...

Next is the class helping us handling the DB:
DBhelper.java

Syntax: [ Download ] [ Hide ]
Syntax: [ Download ] [ Show ]
Using java Syntax Highlighting

package de.padde.fruitsdbsample;

import java.io.ByteArrayOutputStream;

import android.content.ContentValues;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.graphics.Bitmap;

import android.provider.BaseColumns;

public class DBhelper {

public static final String KEY_ID = BaseColumns._ID;

public static final String KEY_NAME = "name";

public static final String KEY_KCAL = "kcal";

public static final String KEY_VC = "vitaminc";

public static final String KEY_IMG = "image";

private DatabaseHelper mDbHelper;

private SQLiteDatabase mDb;

private static final String DATABASE_NAME = "FruitDB";

private static final int DATABASE_VERSION = 1;

public static final String FRUITS_TABLE = "fruits";

private static final String CREATE_FRUITS_TABLE = "create table "+FRUITS_TABLE+" ("

+KEY_ID+" integer primary key autoincrement, "

+KEY_IMG+" blob not null, "

+KEY_NAME+" text not null unique, "

+KEY_KCAL+" integer not null, "

+KEY_VC+" integer not null);";

private final Context mCtx;

private boolean opened = false;

private static class DatabaseHelper extends SQLiteOpenHelper {

DatabaseHelper(Context context) {

super(context, DATABASE_NAME, null, DATABASE_VERSION);

}

public void onCreate(SQLiteDatabase db) {

db.execSQL(CREATE_FRUITS_TABLE);

}

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

db.execSQL("DROP TABLE IF EXISTS "+FRUITS_TABLE);

onCreate(db);

}

}

public void Reset() {

openDB();

mDbHelper.onUpgrade(this.mDb, 1, 1);

closeDB();

}

public DBhelper(Context ctx) {

mCtx = ctx;

mDbHelper = new DatabaseHelper(mCtx);

}

private SQLiteDatabase openDB() {

if(!opened)

mDb = mDbHelper.getWritableDatabase();

opened = true;

return mDb;

}

public SQLiteDatabase getHandle() { return openDB(); }

private void closeDB() {

if(opened)

mDbHelper.close();

opened = false;

}

public void createFruitEntry(Fruit fruit) {

openDB();

ByteArrayOutputStream out = new ByteArrayOutputStream();

fruit.getBitmap().compress(Bitmap.CompressFormat.PNG, 100, out);

ContentValues cv = new ContentValues();

cv.put(KEY_IMG, out.toByteArray());

cv.put(KEY_NAME, fruit.getName());

cv.put(KEY_KCAL, fruit.getKcal());

cv.put(KEY_VC, fruit.getVitaminC());

mDb.insert(FRUITS_TABLE, null, cv);

closeDB();

}

}

Parsed in 0.015 seconds, using GeSHi 1.0.8.4

Nothing essential changed here...

Following class is new and defines how to bind the data to the Views.
Out of the box SimpleCursorAdapter supports TextView and ImageView but
images have to be in form of a image ressource or a URI. Therefore we need
this class to override default binding and/or define how to bind to other view types.
FruitViewBinder.java

Syntax: [ Download ] [ Hide ]
Syntax: [ Download ] [ Show ]
Using java Syntax Highlighting

package de.padde.fruitsdbsample;

import android.database.Cursor;

import android.graphics.BitmapFactory;

import android.view.View;

import android.widget.ImageView;

import android.widget.RatingBar;

import android.widget.SimpleCursorAdapter;

public class FruitViewBinder implements SimpleCursorAdapter.ViewBinder {

public boolean setViewValue(View view, Cursor cursor, int columnIndex) {

if(view instanceof ImageView) {

ImageView iv = (ImageView) view;

byte[] img = cursor.getBlob(columnIndex);

iv.setImageBitmap(BitmapFactory.decodeByteArray(img, 0, img.length));

return true;

}

if(view instanceof RatingBar) {

RatingBar rb = (RatingBar) view;

int kcal = cursor.getInt(cursor.getColumnIndex(DBhelper.KEY_KCAL));

int vitc = cursor.getInt(cursor.getColumnIndex(DBhelper.KEY_VC));

rb.setRating((float) (kcal * ((float) vitc/1000.0)));

return true;

}

return false;

}

}

Parsed in 0.011 seconds, using GeSHi 1.0.8.4

Last class is the ListActivity that implements the example
FruitDBSample

Syntax: [ Download ] [ Hide ]
Syntax: [ Download ] [ Show ]
Using java Syntax Highlighting

package de.padde.fruitsdbsample;

import android.app.ListActivity;

import android.database.Cursor;

import android.graphics.Bitmap;

import android.graphics.BitmapFactory;

import android.os.Bundle;

import android.widget.SimpleCursorAdapter;

public class FruitsDBSample extends ListActivity {

private DBhelper mDB;

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

mDB = new DBhelper(this);

mDB.Reset();

Bitmap img = BitmapFactory.decodeResource(getResources(), R.drawable.icon);

mDB.createFruitEntry(new Fruit(img, "Banane", 92, 10));

mDB.createFruitEntry(new Fruit(img, "Kiwi", 56, 71));

mDB.createFruitEntry(new Fruit(img, "Pfirsich", 41, 10));

mDB.createFruitEntry(new Fruit(img, "Zitrone", 40, 51));

String[] columns = {mDB.KEY_ID, mDB.KEY_IMG, mDB.KEY_NAME, mDB.KEY_KCAL, mDB.KEY_VC};

String table = mDB.FRUITS_TABLE;

Cursor c = mDB.getHandle().query(table, columns, null, null, null, null, null);

startManagingCursor(c);

SimpleCursorAdapter adapter = new SimpleCursorAdapter(this,

R.layout.fruitlist,

c,

new String[] {mDB.KEY_IMG, mDB.KEY_NAME, mDB.KEY_KCAL, mDB.KEY_VC},

new int[] {R.id.img, R.id.txt, R.id.rating});

adapter.setViewBinder(new FruitViewBinder());

setListAdapter(adapter);

}

}

Parsed in 0.012 seconds, using GeSHi 1.0.8.4

And last but not least the xml that defines the layout of a row in the final list
fruitlist.xml

Syntax: [ Download ] [ Hide ]
Syntax: [ Download ] [ Show ]
Using xml Syntax Highlighting

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

android:orientation="vertical"

android:layout_width="fill_parent"

android:layout_height="wrap_content">

<ImageView

android:id = "@+id/img"

android:layout_width = "wrap_content"

android:layout_height = "wrap_content"

android:layout_alignParentLeft = "true">

</ImageView>

<TextView

android:id = "@+id/txt"

android:layout_width = "wrap_content"

android:layout_height = "wrap_content"

android:layout_centerVertical = "true"

android:layout_toRightOf = "@id/img">

</TextView>

<RatingBar

style="?android:attr/ratingBarStyleSmall"

android:id = "@+id/rating"

android:numStars = "5"

android:stepSize = "0.5"

android:layout_width = "wrap_content"

android:layout_height = "wrap_content"

android:layout_alignParentRight = "true"

android:layout_centerVertical = "true"

android:layout_marginRight = "5px">

</RatingBar>

<TextView

android:text = "Healthindex: "

android:layout_width = "wrap_content"

android:layout_height = "wrap_content"

android:layout_centerVertical = "true"

android:layout_toLeftOf = "@id/rating">

</TextView>

</RelativeLayout>

Parsed in 0.002 seconds, using GeSHi 1.0.8.4

This is all pretty straight forward so no further explanation at this point.. but should something
remain unclear feel free to ask.

Greets Padde

--- Edit ---
And this is how it looks like.

and what if I want to put an ImageButton instead of a ratingbar behind the view, shall I put it in the fruitviewbinder or shall I write a simplecursoradaptor and put the button there??

paul590 · by **paul590** » Fri Mar 02, 2012 1:25 am

Thanks a lot for this tutorial, it has helped me a lot! but i have a question, i want to change the code in order to connect to a mysql database, is there easy way to do that and have the same result for the app? i been connecting to a mysql database and was successful in getting a string but my problem is how can I send more than one thing from the php script to the app? thanks again!

rangasai · by **rangasai** » Mon Mar 26, 2012 9:56 am

hey padde
I have written the code just like for image-->SqliteDb-->imageview.But taking the listview sidebyside now i am not getting the onclick listener on listview.

just i will show what i have done

Textview image Textview Textview.
Textview image Textview Textview.
Textview image Textview Textview.
Textview image Textview Textview.

By clciking on the every Textview it will show the toastmessage which position we selected.I am new to android help me how to set onclicklistener for this one.

jevrie10 · by **jevrie10** » Sun Apr 08, 2012 4:38 pm

nice tutorial but how to implement onitemclick to get string from list item?

shal05 · by **shal05** » Thu Jul 26, 2012 6:18 am

Firstly, thank you so much for the code padde, it really helped alot. I am also doing a similar app. But my app saves the recording that the user records using the microphone. For example, the user records a doorbell sound. He then saves it with the text saying its a doorbell and an image of the doorbell. I am not sure on how to save sound in the database. I am really new to android development.

PNG image -> SQLite DB -> imageview

Re: PNG image -> SQLite DB -> imageview

Re: PNG image -> SQLite DB -> imageview

Re: PNG image -> SQLite DB -> imageview

Re:

Re: PNG image -> SQLite DB -> imageview

Re: PNG image -> SQLite DB -> imageview

Re: PNG image -> SQLite DB -> imageview

Re: PNG image -> SQLite DB -> imageview

Who is online