如何將圖像作為BLOB存儲在Sqlitt中&如何檢索?我想把一個圖片(從url)存儲到sqite數(shù)據(jù)庫中。為此,我使用:db = new DataBase(getApplicationContext());URL url = new URL("http://sree.cc/wp-content/uploads/schogini_team.png");URLConnection ucon = url.openConnection();InputStream is = ucon.getInputStream();BufferedInputStream bis = new BufferedInputStream(is,128);ByteArrayBuffer barb= new ByteArrayBuffer(128);int current = 0;while ((current = bis.read()) != -1) { barb.append((byte) current);}ContentValues filedata= new ContentValues();filedata.put(DataBase.IMG_SRC,barb.toByteArray());db.insert(DataBase.Table_Img, null, filedata);在Insert():public void insert(String tableImg, Object object, ContentValues dataToInsert) { // TODO Auto-generated method stub String sql = "INSERT INTO "+tableImg+" ("+ID+","+IMG_SRC+") " + "VALUES ('"+1+"','"+dataToInsert+"')"; db.execSQL(sql);}用于檢索圖像:Cursor cursor = db.selectDataToShow(DataBase.Table_Img, DataBase.IMG_SRC);byte[] imageByteArray=cursor.getBlob(cursor.getColumnIndex(DataBase.IMG_SRC)); cursor.close();ByteArrayInputStream imageStream = new ByteArrayInputStream(imageByteArray);Bitmap theImage = BitmapFactory.decodeStream(imageStream);System.out.println(">>>>>>>>>>>>>>>>>>>>>> "+theImage);所以我找到了null.在我的數(shù)據(jù)庫中,圖像的值存儲為:Image=[B@43e5ac48]
- 3 回答
- 0 關注
- 642 瀏覽
添加回答
舉報
0/150
提交
取消