//删除数据库
//File dbFile = new File("/data/data/com.example.newtest/databases/BookStores.db");dbFile.delete();
/*
* //查询数据库
dbHelper = new MyDatabaseHelper(this, "BookStores.db", null, 1);
dbHelper.getWritableDatabase();
SQLiteDatabase dbss = dbHelper.getWritableDatabase();
Cursor cursor = dbss.query("Books", null, null, null, null, null, null, null);
if(cursor.moveToFirst()){
do{
String name = cursor.getString(cursor.getColumnIndex("name"));
Log.d("dsds", ""+cursor.getCount());
Log.d("dsds", name);
}while(cursor.moveToNext());
}
cursor.close();
* dbHelper = new MyDatabaseHelper(this, "BookStores.db", null, 1);
dbHelper.getWritableDatabase();
SQLiteDatabase dbss = dbHelper.getWritableDatabase();
Cursor cursor = dbss.query("Books", null, null, null, null, null, null, null);
if(cursor.moveToFirst()){
do{
String name = cursor.getString(cursor.getColumnIndex("name"));
Log.d("dsds", ""+cursor.getCount());
Log.d("dsds", name);
}while(cursor.moveToNext());
}
cursor.close();
//File dbFile = new File("/data/data/com.example.newtest/databases/BookStores.db");dbFile.delete();
/*
* //查询数据库
dbHelper = new MyDatabaseHelper(this, "BookStores.db", null, 1);
dbHelper.getWritableDatabase();
SQLiteDatabase dbss = dbHelper.getWritableDatabase();
Cursor cursor = dbss.query("Books", null, null, null, null, null, null, null);
if(cursor.moveToFirst()){
do{
String name = cursor.getString(cursor.getColumnIndex("name"));
Log.d("dsds", ""+cursor.getCount());
Log.d("dsds", name);
}while(cursor.moveToNext());
}
cursor.close();
* dbHelper = new MyDatabaseHelper(this, "BookStores.db", null, 1);
dbHelper.getWritableDatabase();
SQLiteDatabase dbss = dbHelper.getWritableDatabase();
Cursor cursor = dbss.query("Books", null, null, null, null, null, null, null);
if(cursor.moveToFirst()){
do{
String name = cursor.getString(cursor.getColumnIndex("name"));
Log.d("dsds", ""+cursor.getCount());
Log.d("dsds", name);
}while(cursor.moveToNext());
}
cursor.close();