Android SQLiteOpenHelper的使用心得

核心提示：String sql = "insert into TestUsers (id,name,sex) values (2,'hongguang','men')"; try { db.execSQL(sql); } catch (SQLException e) { Log

String sql = "insert into TestUsers (id,name,sex) values (2,'hongguang','men')"; try { db.execSQL(sql); } catch (SQLException e) { Log.i("err", "insert failed"); } } /** * 更新数据 */ public void UpdateTb() { db = dbHelper.getWritableDatabase(); String sql = "Update TestUsers set name = 'anhong',sex = 'men' where id = 2"; try { db.execSQL(sql); } catch (SQLException e) { Log.i("err", "update failed"); } } /** * 删除数据 */ public void DeleteTb(){ db = dbHelper.getWritableDatabase(); String sql = "delete from TestUsers where id = 2"; try { db.execSQL(sql); } catch (SQLException e) { Log.i("err", "delete failed"); } } /** * 打开数据库 */ public void OpenDb(){ dbHelper = new DBHelper(this, "TestDb01"); db = dbHelper.getWritableDatabase(); } /** * 关闭数据库 */ public void CloseDb(){ dbHelper.close(); } @Override protected void onDestroy() { super.onDestroy(); if(db!=null){ db.close(); } if(dbHelper!=null){ dbHelper.close(); } } }

5.一些SQLite操作命令

5.1 adb shell 进入命令模式

5.2 cd 文件名 进入文件

5.3 ls或ls -l 查看目录下的文件

5.4 sqlite3 数据库名 进入数据库

5.5 .schema 查看数据库下的信息

5.6 ctrl+d 退出sqlite模式

6.测试截图

6.1

6.2