Hi all.
I would like to save an image from Internet to database, I've tried to
convert images into bytearray and store them in a database.
Here my code:
this is to created table:
myDB.execSQL("CREATE TABLE IF NOT EXISTS News (Title VARCHAR(20),
imageUrl BLOB, publishDate TIMESTAMP, expiredDate TIMESTAMP);");
and this is my Method to Insert table:
public void insertlistNews(String city,byte[] newsImageUrl, String
publishDate, String expiredDate){
try {
myDB.execSQL("INSERT INTO News
(title,imageUrl,publishDate,expiredDate)"
+ " VALUES ('" + city + "','" + imageUrl + "','" + publishDate+
"','" + expiredDate"');");
Log.i("Android", "Table created");
} catch (Exception e) {
Log.i("Android", "No Table created" + e.getMessage());
}
//for check bytearray in database
Log.i("Android", "Image saved in database: "+ urlFrontImage);
}
The last my method for getNews from db:
public ArrayList getAllNews() {
ArrayList news = new ArrayList<News>();
Cursor c = myDB.rawQuery("SELECT
title,imageUrl,publishDate,expiredDate
FROM News WHERE publishedDate <= DATETIME() and expiredDate >=
DATETIME() ORDER BY publishedDate DESC;", null);
if (c != null) {
c.moveToFirst();
int count = 0;
while (c.moveToNext()) {
if (count == 0)
c.moveToFirst();
String title = c.getString(0);
byte[] image = c.getBlob(1);
String publishDate = c.getString(2);
String expiredDate = c.getString(3);
NewsItem nl = new NewsItem(title, image, publishDate, expiredDate);
Log.i("Android", "Image get from db: "+image);
news.add(nl);
count++;
}
}
return news;
}
when I run it the newsimage not appear and the Log like this:
12-22 00:11:49.362: INFO/Android(307): Image saved in database:
[...@437cbdb8
12-22 00:11:51.052: INFO/Android(307): Image saved in database:
[...@437db710
12-22 00:11:51.862: INFO/Android(307): Image saved in database:
[...@437c1338
12-22 00:12:07.962: INFO/Android(307): Image get from db: [...@4382d370
12-22 00:12:07.982: INFO/Android(307): Image get from db db:
[...@4382d9c0
12-22 00:12:07.992: INFO/Android(307): Image get from db: [...@4382e0e0
why results can vary between insert and getNews?
--
Best Regards
=====
Amiral
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
