Android中SQlite数据库存取Bitmap(一)

mainActivity如下:

package cn.com;
import java.io.ByteArrayOutputStream;
import java.io.InputStream;
import java.net.HttpURLConnection;
import java.net.URL;
import cn.db.DBservice;
import cn.db.Photo;
import android.app.Activity;
import android.graphics.Bitmap;
import android.graphics.BitmapFactory;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.view.View;
import android.widget.Button;
import android.widget.ImageView;

public class MainActivity extends Activity {
    private Button mButton;
    private Bitmap mBitmap;
    private ImageView mImageView;
    private boolean isDownload=true;
    private boolean isSave=false;
    private boolean isLoadFromDB=false;
    private static final int DOWNLOAD_FINISH=88;
    private byte[] photoByte;
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        mButton=(Button) findViewById(R.id.button);
        mButton.setOnClickListener(new ButtonOnClickListener());
        mImageView=(ImageView) findViewById(R.id.imageView);
    }
   
   private class ButtonOnClickListener implements View.OnClickListener{
	public void onClick(View v) {
		if (isDownload) {
			new Thread(){
				public void run() {
					mBitmap=getBitmap("http://s12.sinaimg.cn/middle/4b181bd0gbf6cb07c2a1b&690");
					handler.sendEmptyMessage(DOWNLOAD_FINISH);
				}
			}.start();
		}
		if (isSave) {
			DBservice service=new DBservice(MainActivity.this);
			Photo photo=new Photo(1,mBitmap);
			service.save(photo,photoByte);
			isLoadFromDB=true;
			isSave=false;
			mButton.setText("从数据库中加载bitmap");
			mImageView.setImageBitmap(null);
			return;
		}
		if (isLoadFromDB) {
			DBservice service=new DBservice(MainActivity.this);
			Photo photo=service.find(1);
			mImageView.setImageBitmap(photo.getPhoto());
		}
	 }
   }
   
   Handler handler=new Handler(){
   	public void handleMessage(Message msg) {
   		switch (msg.what) {
			case DOWNLOAD_FINISH:
				mImageView.setImageBitmap(mBitmap);
				mButton.setText("保存图片至SQLite");
				isDownload=false;
				isSave=true;
				break;
			default:
				break;
			}
   	};
   };
   
	public Bitmap getBitmap(String imagePath) {
		try {
			URL imageUrl = new URL(imagePath);
			HttpURLConnection connection = (HttpURLConnection) imageUrl.openConnection();
			connection.setConnectTimeout(5000);
			connection.setRequestMethod("POST");
			if (connection.getResponseCode() == 200) {
				InputStream inputStream = connection.getInputStream();
				photoByte= readResource(inputStream);
				Bitmap bitmap=BitmapFactory.decodeByteArray(photoByte, 0, photoByte.length);
				return bitmap;
			}
		} catch (Exception e) {
		}
		
		return null;
	};
   public byte[] readResource(InputStream inputStream){
	   try {
		   ByteArrayOutputStream outputStream=new ByteArrayOutputStream();
	    	byte [] buffer=new byte[1024];
	    	int len=0;
	    	while( (len=inputStream.read(buffer))!=-1){
	    		   outputStream.write(buffer,0,len);
	    	}
	    	inputStream.close();
	    	outputStream.close();   	
	    	return outputStream.toByteArray();
	} catch (Exception e) {
	}
    return null;
   }
}

DataBaseOpenHelper.java如下:

package cn.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DataBaseOpenHelper extends SQLiteOpenHelper {


	public DataBaseOpenHelper(Context context) {
		super(context, "testbold.db", null, 1);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL("create table test(photoid integer primary key autoincrement,id ingeter(10),photo Blob(20))");
	}

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

}

DBservice.java如下:

package cn.db;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Bitmap;
import android.graphics.BitmapFactory;

public class DBservice {
	private DataBaseOpenHelper openHelper;
	public DBservice(Context context) {
		openHelper=new DataBaseOpenHelper(context);
	}
	
	
	public void save(Photo photo,byte [] photoByte){
		SQLiteDatabase db=openHelper.getWritableDatabase();
        db.execSQL("insert into test (id,photo) values(?,?)",new Object[]{photo.getId(),photoByte});
        db.close();
	}
	
	
	public Photo find(int i){
		SQLiteDatabase db=openHelper.getWritableDatabase();
		Cursor cursor=db.rawQuery("select * from test where photoid=?", new String[]{String.valueOf(i)});
		while(cursor.moveToFirst()){
			int photoid=cursor.getInt(cursor.getColumnIndex("photoid"));
			byte[] photoByte=cursor.getBlob(cursor.getColumnIndex("photo"));          
			Bitmap bitmap=BitmapFactory.decodeByteArray(photoByte, 0, photoByte.length); 
			Photo photo=new Photo(photoid, bitmap);
			return photo;
		}
		cursor.close();
		db.close();
		return null;
	}
	
}

Photo.java如下:

package cn.db;

import android.graphics.Bitmap;

public class Photo {
	private int id;
	private Bitmap bitmap;

	public Photo() {
	}

	public Photo(int id, Bitmap bitmap) {
		super();
		this.id = id;
		this.bitmap = bitmap;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public Bitmap getPhoto() {
		return bitmap;
	}

	public void setPhoto(Bitmap bitmap) {
		this.bitmap = bitmap;
	}

}