80,349
社区成员
发帖
与我相关
我的任务
分享
public class DataBaseOpenHelper extends SQLiteOpenHelper{
private static String dbname ="School.db";
private static int version = 1;
public DataBaseOpenHelper(Context context) {
super(context, dbname, null, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE IF NOT EXISTS students(id integer primary key" +
" autoincrement,Sno varchar(10), Sname varchar(10),Ssex char(2),Sphoto BLOB)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS students");
onCreate(db);
}
}
public class DataBaseService {
private DataBaseOpenHelper dbOpenHelper;
public DataBaseService(Context context){
dbOpenHelper = new DataBaseOpenHelper(context);
}
//查询表students中的所有数据,返回一个cursor
public Cursor getAllData(){
SQLiteDatabase database = dbOpenHelper.getReadableDatabase();
Cursor cursor = database.rawQuery("select id as _id ,Sno,Sname,Ssex,Sphoto from students",null);
return cursor;
}
}
public class Students1Activity extends Activity{
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.students);
ListView mListView = (ListView)findViewById(R.id.studentslistView);
DataBaseService mDataBaseService = new DataBaseService(this);
Cursor cursor = mDataBaseService.getAllData();
SimpleCursorAdapter adapter = new SimpleCursorAdapter(
Students1Activity.this,
R.layout.students_listview,
cursor,
new String[]{"Sno","Sname","Ssex",},
new int[]{R.id.Sno,R.id.Sname,R.id.Ssex});
mListView.setAdapter(adapter);
cursor.close();
}
}