android sqlite資料庫簡單操作（adb shell）

1、用adb.exe尋找正在啟動並執行裝置（至少要開啟一個模擬器）

E:\android-sdk-windows\platform-tools\adb devices

List of devices attached
emulator-5554   device

2、如果模擬器沒有運行，使用以下命令啟動

E:\android-sdk-windows\tools\emulator.exe @avdname

3、查看虛擬設備，使用以下命令啟動

E:\android-sdk-windows\tools\android list avd

Available Android Virtual Devices:
    Name: 2_3_3
     Path: C:\Documents and Settings\Administrator\.android\avd\2_3_3.avd
  Target: Android 2.3.3 (API level 10)
    Skin: 320x533
  Sdcard: 50M

4、在串連的裝置上開啟一個shell

E:\android-sdk-windows\platform-tools\adb shell

5、查看自己的資料庫

# ls -R /data/data/*/databases

/data/data/cn.edu.xtu.tilepuzzle/databases:
DBTilePuzzle.db

/data/data/com.android.browser/databases:
webview.db
webviewCache.db
browser.db

/data/data/com.android.deskclock/databases:
alarms.db

/data/data/com.android.email/databases:
EmailProvider.db
EmailProviderBody.db

/data/data/com.android.inputmethod.latin/databases:
userbigram_dict.db
auto_dict.db

/data/data/com.android.launcher/databases:
launcher.db

/data/data/com.android.providers.contacts/databases:
contacts2.db

/data/data/com.android.providers.downloads/databases:
downloads.db

/data/data/com.android.providers.media/databases:
internal.db
external-8f72d02.db

/data/data/com.android.providers.settings/databases:
settings.db

/data/data/com.android.providers.telephony/databases:
telephony.db
mmssms.db

/data/data/com.android.providers.userdictionary/databases:

user_dict.db

 

6、找到自己的資料庫

/data/data/cn.edu.xtu.tilepuzzle/databases:
DBTilePuzzle.db

 

7、開啟資料庫

# sqlite3 /data/data/cn.edu.xtu.tilepuzzle/databases/DBTilePuzzle.db

 

8、查詢己存在的表的資料及簡單操作（TableGameData、TablePeopleInfoData兩個表是我事先建立好的資料庫表）

sqlite>select * from TableGameData;

/rs/raw/img/first.jpg|Y|Y|Y|Y|4|5

sqlite>select * from TablePeopleInfoData;

LIUYAOHUA|50
DAIQING|100
YAOHUA|14

sqlite> insert into TablePeopleInfoData values("liu1",1000);

LIUYAOHUA|50
DAIQING|100
YAOHUA|14
liu1|1000

sqlite> update  TablePeopleInfoData set TIME=140 where NAME="YAOHUA"

sqlite> select * from TablePeopleInfoData;
LIUYAOHUA|50
DAIQING|100
YAOHUA|140
liu1|1000

sqlite> delete from TablePeopleInfoData where NAME="liu1";
sqlite> select * from TablePeopleInfoData;
select * from TablePeopleInfoData;
LIUYAOHUA|50
DAIQING|100

（這樣就不必每次用“System.out.println”去查看資料庫裡的表資訊更改的情況了）

 

摘自 love254443233的專欄