android - 如何使用 sqlite DB 刷新 ListView

Question

我在从 SQLite 数据库中删除一行后试图刷新我的 ListView 。这是其中的一部分:

cursor = mysqlAdapter.fetchAll(); // a method from sqlite adater class 
ArrayList<MyInfo> vidRows = new ArrayList<MyInfo>(); 
if (cursor.moveToFirst()) { 
do { ...... } 
while (cursor.moveToNext()); } 
mList.setAdapter(new SomeAdapter(this, vidRows)); 
mList.setOnItemClickListener(this); 
registerForContextMenu(mList); } 

然后在我的 getView 中:

public View getView(int position, View convertView, ViewGroup parent) { 
View vidRow = inflater.inflate(R.layout.queue_row, null); 
ImageView vidThumb = (ImageView) vidRow .findViewById(R.id.Thumb); 
Bitmap bmThumbnail; bmThumbnail = ThumbnailUtils.createVideoThumbnail(
                     getFullpath(vidItems.get(position).my_id), Thumbnails.MINI_KIND);      
vidThumb.setImageBitmap(bmThumbnail); 
TextView vidText = (TextView) vidRow .findViewById(R.id.vid_cap);
videoText.setText(vidItems.get(position).my_cap); return vidRow; } 

Answer 1

你在使用光标吗？如果是这样，您只需调用:

cursor.requery();