public void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  
  dbItem = new ArrayList<MyItem>();
  MyItem mi; 
  
  mHelper = new DatabaseHelper(this);
  
  mCursor = mHelper.getWritableDatabase().rawQuery("SELECT _ID, name, clear, level, division, version FROM spacemix", null);
  
  while(mCursor.moveToNext())
  {
   mi = new MyItem(mCursor.getString(1), mCursor.getInt(2), mCursor.getInt(3), mCursor.getString(4));
   dbItem.add(mi);
  }
  
  MyListAdapter MyAdapter = new MyListAdapter(this, R.layout.row, dbItem);
  
  ListView MyList;
  MyList=(ListView)findViewById(R.id.row_list);
  MyList.setAdapter(MyAdapter);
 }
 
 
class MyItem
{
 String item_name;
 int item_clear;
 int item_level;
 String item_division;
 
 MyItem(String aname, int aclear, int alevel, String adivision)
 {
  item_name = aname;
  item_clear = aclear;
  item_level = alevel;
  item_division = adivision;
 }
}
 
 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).item_name;
 }
 public long getItemId(int position) {
  return position;
 }
 // 각 항목의 뷰 생성
 public View getView(int position, View convertView, ViewGroup parent) {
  if (convertView == null) {
   convertView = Inflater.inflate(layout, parent, false);
  }
  
  TextView txt1 = (TextView)convertView.findViewById(R.id.name);
  txt1.setText(arSrc.get(position).item_name);
  
  TextView txt2 = (TextView)convertView.findViewById(R.id.clear);
  if(arSrc.get(position).item_clear == 0)
  {
   txt2.setBackgroundColor(Color.rgb(243, 152, 0));
  }
  else if(arSrc.get(position).item_clear == 1)
  {
   txt2.setBackgroundColor(Color.rgb(0, 153, 68));
  }
  else if(arSrc.get(position).item_clear == 2)
  {
   txt2.setBackgroundColor(Color.BLUE);
  }
  else
  {
   txt2.setBackgroundColor(Color.BLACK);
  }
  
  TextView txt3 = (TextView)convertView.findViewById(R.id.level);
  txt3.setText(arSrc.get(position).item_level);
  
  TextView txt4 = (TextView)convertView.findViewById(R.id.division);
  txt4.setText(arSrc.get(position).item_division);
  return convertView;
 }
}

 

DB에서 정보를 받아와서 한줄에 4개의 텍스트뷰에다가 내용을 쓰고 조건에 맞춰 색을 입히는 프로그램인데요,

 

그냥 심플커서어댑터로 하면 잘되는데 커스텀어댑터로하면 실행이 안되네요 ㅠㅠ

 

도와주세요 ㅠ

이 게시물을