Android save picture to SQLite, read the picture in SQLite

1. Bitmap saved to SQLite data format:

Java code

1. Db.execsql ("Create table Express" (_id INTEGER PRIMARY KEY autoincrement,express_no varchar), Express_name TEXT, Express_img BLOB); ");

2. Bitmap becomes Blob

Java code

1. Contentvalues values = new Contentvalues ();
2. Final Bytearrayoutputstream OS = new Bytearrayoutputstream ();
3. Bmp.compress (Bitmap.CompressFormat.PNG, MB, OS);
4. Values.put ("express_img", Os.tobytearray ());
5. Values.put ("Express_name","ZF");
6. Values.put ("Express_no","ZF");
7. Getcontentresolver (). Insert ("Express", values);

3. Read bitmap from SQLite

Java code

1. Byte[] In=cur.getblob (Cur.getcolumnindex ("express_img"));
2. Bmpout=bitmapfactory.decodebytearray (in,0,in.length);

displayed on the ImageView

Java code

1. ImageView ImageView = (ImageView) View.findviewbyid (r.id.img);
2. Bytearrayinputstream stream = new Bytearrayinputstream (Cur.getblob (Cur.getcolumnindex ("express_img"));
3. Imageview.setimagedrawable (Drawable.createfromstream (Stream, "img"));

Summarize:

InputStream: As the data cache, how the data is written for other objects to read, the method is read ();

OutputStream: As a data cache, write content to other objects in the future! Its method write ();

Java code

1. Byte[] In=cur.getblob (Cur.getcolumnindex (MyUser.User.BITMAP_VALUES));

This also initializes the data, where byte is the base type and does not require a length definition.

Android save picture to SQLite, read the picture in SQLite