public class ImageDB extends SQLiteOpenHelper {
/**数据库版本号**/
private final static int DATABASE_VERSION = 1;
/**数据库名**/
private final static String DB_NAME = "image_db";
/**表名**/
private String TABLE_IMAGE = "image_data";
public String T_ID = "_id";//字段名
public String T_BLOB = "T_BLOB";//字段名
/**创建表SQL 字符串**/
private String TABLE_IMAGE_CREATE = "Create table " + TABLE_IMAGE + "(" + T_ID
+ " INTEGER DEFAULT '1' NOT NULL PRIMARY KEY AUTOINCREMENT ,"
+ T_BLOB + " BLOB );";
/**表列数据集合**/
private String[] col = { T_ID, T_BLOB };
/**ImageDB对象构造方法**/
public ImageDB(Context context) {
super(context, DB_NAME, null, DATABASE_VERSION);
}
public ImageDB(Context context, String name, CursorFactory factory, int version) {
super(context, name, factory, version);
}
/**创建数据**/
public Long createData(Bitmap bmp) {
ContentValues initValues = new ContentValues();
Long id = null;
ByteArrayOutputStream os = new ByteArrayOutputStream();
/**
* Bitmap.CompressFormat.JPEG 和 Bitmap.CompressFormat.PNG
* JPEG 与 PNG 的是区别在于 JPEG是有损数据图像,PNG使用从LZ77派生的无损数据压缩算法。
* 这里建议使用PNG格式保存
* 100 表示的是质量为100%。当然,也可以改变成你所需要的百分比质量。
* os 是定义的字节输出流
*
* .compress() 方法是将Bitmap压缩成指定格式和质量的输出流
*/
bmp.compress(Bitmap.CompressFormat.PNG, 100, os);
initValues.put(T_BLOB, os.toByteArray());//以字节形式保存
SQLiteDatabase db = getDatabaseWrit();
id = db.insert(TABLE_IMAGE, null, initValues);//保存数据
db.close();
Log.i("Image ", "create done.");
return id;
}
public List<Map<String, Object>> getData() {
List<Map<String, Object>> list = null;
SQLiteDatabase db = getDatabaseRead();
Cursor cursor = db.query(TABLE_IMAGE, col, null, null, null, null, null);//数据的查询
HashMap<String, Object> bindData = null;
list = new ArrayList<Map<String, Object>>();
for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
bindData = new HashMap<String, Object>();
bindData.put(T_ID, cursor.getLong(0));
/**得到Bitmap字节数据**/
byte[] in = cursor.getBlob(1);
/**
* 根据Bitmap字节数据转换成 Bitmap对象
* BitmapFactory.decodeByteArray() 方法对字节数据,从0到字节的长进行解码,生成Bitmap对像。
**/
Bitmap bmpout = BitmapFactory.decodeByteArray(in, 0, in.length);
bindData.put(T_BLOB, bmpout);
list.add(bindData);
}
cursor.close();
db.close();
Log.i("Image ", "get a Bitmap.");
return list;
}
public void delete() {
SQLiteDatabase db = getDatabaseWrit();
db.delete(TABLE_IMAGE, null, null);//数据的删除
db.close();
Log.i("Image ", "delete all data.");
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(TABLE_IMAGE_CREATE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
String sql = " drop table " + TABLE_IMAGE;
db.execSQL(sql);
onCreate(db);
}
private SQLiteDatabase getDatabaseRead() {
return this.getReadableDatabase();
}
private SQLiteDatabase getDatabaseWrit() {
return this.getWritableDatabase();
}
}
点击打开链接