package archie.mydb;
import java.util.ArrayList;
import java.util.HashMap;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import arhcie.mydb.dbh.MyDatabaseHelper;
public class ScanActivity extends Activity {
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
this.setContentView(R.layout.scanlayout);
MyDatabaseHelper helper = new MyDatabaseHelper(ScanActivity.this, "myDB");
SQLiteDatabase db = helper.getReadableDatabase();
Cursor c = db.query("friends", null, null, null, null, null, null);
ListView list = (ListView)this.findViewById(R.id.ListView);
SimpleCursorAdapter adapter = new SimpleCursorAdapter(ScanActivity.this,R.layout.itemview,c,
new String[]{"_id","name","birthday"},
new int []{R.id.IDView,R.id.nameView, R.id.birthdayView});
list.setAdapter(adapter);
}
}
1.对于SimpleCursorAdapter,要求数据库中主属性必须有_id属性;
2.setContentView位置必须在前面,尤其在使用ListView时候。