public class list extends Activity {
SQLiteDatabase db;
ArrayList<MyItem> arItem;
public void onCreate(Bundle savedInstanceState){
super.onCreate(savedInstanceState);
setContentView(R.layout.list1);
arItem = new ArrayList<MyItem>();
MyItem min;
db = SQLiteDatabase.openDatabase("data/data/a.test/card1.sqlite", null, SQLiteDatabase.CREATE_IF_NECESSARY);
Cursor c = db.query("cardname",null, null, null, null, null, null);
int idCol = c.getColumnIndex("CardImage");
int ida = c.getColumnIndex("CardName");
int i = c.getColumnIndex("CardCompanyID");
while(c.moveToNext())
{
if(1==c.getInt(i)){
min = new MyItem(c.getBlob(idCol), c.getString(ida)); arItem.add(min); //getBlob로 불러오면 byte[]형인데.. 그럼 밑에 MyItem클래스를 byte[]형으로 해줘야하는데 도저히 못하겠어요.. 도와주세요
}
}
MyListAdapter MyAdapter = new MyListAdapter(this, R.layout.list, arItem);
ListView MyList;
MyList= (ListView)findViewById(R.id.list);
MyList.setAdapter(MyAdapter);
MyList.setOnItemClickListener(mItemClickListener);
}
}
class MyItem{
MyItem(byte[] aIcon, String aName){ // 바이트형으로 바꿔주고
Icon = aIcon;
Name = aName;
}
byte[] Icon;
String Name;
}
class MyListAdapter extends BaseAdapter{
Context maincon;
LayoutInflater Inflater;
ArrayList<MyItem>arSrc;
int layout;
public MyListAdapter(Context context, int alayout, ArrayList<MyItem> aarSrc){
maincon = context;
Inflater = (LayoutInflater)context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
arSrc = aarSrc;
layout = alayout;
}
public int getCount(){
return arSrc.size();
}
public String getItem(int position)
{
return arSrc.get(position).Name;
}
public long getItemId(int position){
return position;
}
public View getView(int position, View convertView, ViewGroup parent){
final int pos = position;
if(convertView==null)
{
convertView = Inflater.inflate(layout, parent, false);
}
ImageView img = (ImageView)convertView.findViewById(R.id.img);
img.setImageResource(arSrc.get(position).Icon); 여기서 에러가 나는데. 바이트형으로 바꿔줘야하는데 도저히 어떻게 바꾸죠ㅕ
TextView txt = (TextView)convertView.findViewById(R.id.text);
txt.setText(arSrc.get(position).Name);
return convertView;
}
}