안드로이드 - 커스텀 리스트뷰에 데이터베이스 연결

public void test() {
    ArrayList<MyData> data = new ArrayList<MyData>();
        
    DataBase DB = new DataBase(this);
    DataBase.cursor = DB.QueryData();
        
    DataBase.cursor.moveToFirst();
        
    for(int i = 0; i < DataBase.cursor.getCount(); i++) {
        MyData myData;
        myData = new MyData(
            DataBase.cursor.getString(1),
            DataBase.cursor.getString(2),
            DataBase.cursor.getString(3));
        data.add(myData);
        DataBase.cursor.moveToNext();
    }
        
    MyDataAdapter Adapter =
        new MyDataAdapter(this, R.layout.list_item, data);
        
    ListView listView = (ListView) findViewById(R.id.listView);
    listView.setAdapter(Adapter);
        
    listView.setOnItemClickListener(new OnItemClickListener() {
        public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
            DataBase.cursor.moveToPosition(position);
            Log.d("msg : ", DataBase.cursor.getString(3));
        }
    });
}
 
class MyData {
    String day, time, memo;
    
    MyData(String aDay, String aTime, String aMemo) {
        day = aDay;
        time = aTime;
        memo = aMemo;
    }
}
 
class MyDataAdapter extends BaseAdapter {
    
    Context acontext;
    int alistItem;
    ArrayList<MyData> adata;
    
    LayoutInflater inflacter;
    
    public MyDataAdapter(Context context, int listItem, ArrayList<MyData> data) {
        acontext = context;
        adata = data;
        alistItem = listItem;
        
        inflacter = (LayoutInflater) context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
    }
 
    @Override
    public int getCount() {
        return adata.size();
    }
 
    @Override
    public Object getItem(int position) {
        return adata.get(position);
    }
 
    @Override
    public long getItemId(int position) {
        return position;
    }
 
    @Override
    public View getView(int position, View convertView, ViewGroup parent) {
        if (convertView == null) {
            convertView = inflacter.inflate(alistItem, parent, false);
        }
        
        TextView day = (TextView) convertView.findViewById(R.id.textView1);
        day.setText(adata.get(position).day);
        
        TextView time = (TextView) convertView.findViewById(R.id.textView2);
        time.setText(adata.get(position).time);
        
        TextView memo = (TextView) convertView.findViewById(R.id.textView3);
        memo.setText(adata.get(position).memo);
        
        final Button btn = (Button) convertView.findViewById(R.id.button1);
        btn.setOnClickListener(new Button.OnClickListener() {
            public void onClick(View v) {
                btn.setVisibility(View.INVISIBLE);
            }
        });
        
        return convertView;
    }
}

 

백업용