1.在adb中查询android中的数据:
adb shell ---->data---->data------------->应用的名称--------->sqlite3 数据库名称---------->.databases
.databases :显示数据库
.tables :显示数据库中的数据表
.schema 表的结构信息
public class MySqliteOpenHelper extends SQLiteOpenHelper{
private static final String TAG = "MySqliteOpenHelper";
private static final int DEFAULTVERSION = 1;
private static final String DATABASENAME = "woyo_test";
public MySqliteOpenHelper(Context context) {
super(context, DATABASENAME, null, DEFAULTVERSION);
}
public MySqliteOpenHelper(Context context, int version) {
super(context, DATABASENAME, null, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
Log.i(TAG, "=========oncreate database==========");
db.execSQL("create table user(id int,name varchar(20));");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
Log.i(TAG, "=========onUpgrade database==========");
db.execSQL("create table user2(id int,name varchar(20));");
}
}
public class SqliteActivity extends Activity {
private static final String TAG = "SqliteActivity";
private Button btn_create;
private Button btn_update;
private Button btn_insert;
private Button btn_get;
private SQLiteDatabase db;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
btn_create = (Button) findViewById(R.id.btn_create);
btn_update = (Button) findViewById(R.id.btn_update);
btn_insert = (Button) findViewById(R.id.btn_insert);
btn_get = (Button) findViewById(R.id.btn_get);
db = new MySqliteOpenHelper(SqliteActivity.this).getWritableDatabase();
btn_create.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
Log.i(TAG, "=====btn_create=====");
new MySqliteOpenHelper(SqliteActivity.this);
}
});
btn_update.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
new MySqliteOpenHelper(SqliteActivity.this, 2);
}
});
btn_insert.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
ContentValues values = new ContentValues();
values.put("id", 1);
values.put("name", "antty");
long id = db.insert("user", null, values);
Log.i(TAG, "===" + id);
}
});
btn_get.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
Log.i(TAG, "=======btn_get=======");
Cursor cursor = db.query("user", new String[] { "id", "name" }, null, null, null, null, null);
int size = cursor.getCount();
Log.i(TAG, "=======size:" + size);
while (cursor.moveToNext()) {
if (cursor.isLast()) {
break;
}
String id = cursor.getString(cursor.getColumnIndex("id"));
String name = cursor.getString(cursor.getColumnIndex("name"));
Log.i(TAG, cursor.getPosition() + "========id:" + id + "==========name:" + name);
}
}
});
}
}