android中sqlite的使用

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);}    @Overridepublic void onCreate(SQLiteDatabase db) {Log.i(TAG, "=========oncreate  database==========");db.execSQL("create table user(id int,name varchar(20));");}@Overridepublic 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. */@Overridepublic 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() {@Overridepublic void onClick(View v) {Log.i(TAG, "=====btn_create=====");new MySqliteOpenHelper(SqliteActivity.this);}});btn_update.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {new MySqliteOpenHelper(SqliteActivity.this, 2);}});btn_insert.setOnClickListener(new OnClickListener() {@Overridepublic 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() {@Overridepublic 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);}}});}}

更多相关文章

随机推荐