How to get image in res/drawable by name, not by id

phanthanhtrung86 · by **phanthanhtrung86** » Thu Dec 24, 2009 5:35 pm

Hi all !
I have a database, and I have

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

create table Products (id integer, name text, picturename text, picture blob)
Parsed in 0.030 seconds,  using GeSHi 1.0.8.4

.
At the first time, I insert into table Product with 2 rows:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

insert into Prducts values(1,'Banana','banana.png',null)
 
insert into Prducts values(2,'Apple','apple.png',null)
Parsed in 0.030 seconds,  using GeSHi 1.0.8.4

After that, i want to update that table with the following condition that: I will look up the image's name which is the same with the picturename column in table Product.
I have tried the way that:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

public int getPicID(String name)
 
{
 
if(name == "banana.png")
 
return R.drawable.banana;
 
if(name == "apple.png")
 
return R.drawable.apple;
 
return -1;
 
}
Parsed in 0.033 seconds,  using GeSHi 1.0.8.4

Acording to getPicID , I will transfer it into byte[] to insert into table Products.
My question is: how can get image id by its name? does android support finding image by name in R.drawable?
Please help me!!!!!