Image Save and Retrive in SQLite

Database.class:
package com.venkool;

import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;

import android.app.Activity;
import android.content.Intent;
import android.graphics.Bitmap;
import android.graphics.BitmapFactory;
import android.graphics.drawable.BitmapDrawable;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.ImageView;

public class DataBase extends Activity {
 /** Called when the activity is first created. */
 private static final int CAMERA_REQUEST = 1888;
 ImageView ivImage, ivImage1;
 Button btnCamera;

 MyDatabase mydatabase;

 @Override
 public void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  setContentView(R.layout.database);

  mydatabase = new MyDatabase(DataBase.this);

  ivImage = (ImageView) findViewById(R.id.ivImage);

  ivImage1 = (ImageView) findViewById(R.id.ivImage1);

  // For taking drawable resources
  // Bitmap bitmap = (Bitmap) ((BitmapDrawable)
  // getResources().getDrawable(
  // R.drawable.my)).getBitmap();


  btnCamera = (Button) findViewById(R.id.btnCamera);

  btnCamera.setOnClickListener(new OnClickListener() {

   @Override
   public void onClick(View v) {
    // TODO Auto-generated method stub

    Intent intent = new Intent(
      android.provider.MediaStore.ACTION_IMAGE_CAPTURE);
    startActivityForResult(intent, CAMERA_REQUEST);
   }
  });

 }

 @Override
 protected void onActivityResult(int requestCode, int resultCode, Intent data) {
  // TODO Auto-generated method stub

  if (requestCode == CAMERA_REQUEST && resultCode == RESULT_OK) {
   Bitmap photo2 = (Bitmap) data.getExtras().get("data");
   ivImage.setImageBitmap(photo2);

   ByteArrayOutputStream baos = new ByteArrayOutputStream();
   BitmapDrawable drawable = (BitmapDrawable) ivImage.getDrawable();
   Bitmap bitmap = drawable.getBitmap();

   bitmap.compress(Bitmap.CompressFormat.PNG, 100, baos);
   byte[] photo = baos.toByteArray();
   mydatabase.insert(photo);

   byte[] photo1 = mydatabase.getBlog();
   ByteArrayInputStream imageStream = new ByteArrayInputStream(photo1);
   Bitmap theImage = BitmapFactory.decodeStream(imageStream);
   ivImage1.setImageBitmap(theImage);
  }
 }
}


2.Adapter Helper

package com.venkool;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class MyDatabase extends Activity {
 /** Called when the activity is first created. */

 DataBaseHelper dataBaseHelper;
 SQLiteDatabase sqLiteDatabase;

 public MyDatabase(Context context) {
  dataBaseHelper = new DataBaseHelper(context, "MyDB.sqlite", null, 1);
 }

 class DataBaseHelper extends SQLiteOpenHelper {

  public DataBaseHelper(Context context, String name,
    CursorFactory factory, int version) {
   super(context, name, factory, version);
   // TODO Auto-generated constructor stub
  }

  @Override
  public void onCreate(SQLiteDatabase db) {

   db.execSQL("create table tblImage(image BLOB)");

  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
   // TODO Auto-generated method stub

  }

 }

 public void insert(byte[] photo) {
  open();

  ContentValues values = new ContentValues();
  try {

   values.put("image", photo);
   sqLiteDatabase.insert("tblImage", null, values);
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   close();
  }
 }

 public void open() {
  sqLiteDatabase = dataBaseHelper.getWritableDatabase();
 }

 public void close() {
  sqLiteDatabase.close();
 }

 public Cursor get() {
  return sqLiteDatabase.query("tblImage", null, null, null, null, null,
    null);
 }

 public byte[] getBlog() {

  byte[] photo = null;

  Cursor c = null;
  open();
  c = get();

  while (c.moveToNext()) {

   photo = c.getBlob(0);

   return photo;
  }
  close();
  return photo;
 }

}

3.database.xml


<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:orientation="vertical" >

    <LinearLayout
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:orientation="horizontal" >

        <ImageView
            android:src="@drawable/my"
            android:id="@+id/ivImage"
            android:layout_width="150dp"
            android:layout_height="150dp" />

        <ImageView
            android:id="@+id/ivImage1"
            android:layout_width="150dp"
            android:layout_height="150dp"
            android:layout_marginLeft="10dp" />
    </LinearLayout>

    <Button
        android:id="@+id/btnCamera"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Camera" />

    <EditText
        android:id="@+id/edtImage"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content" />

    <ImageView
        android:id="@+id/ivImage"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content" />

</LinearLayout>