From http://www.bangchui.org/read.php? Tid = 7792
In Android, SQLite data pants can be used to store data, but Google does not directly provide us with tools to manage data in the database.
If you cannot directly view the database using a tool, copy the database from the mobile phone or simulator and use a tool to view the database. The following are the steps:
1. Confirm the database location
We can use the ddms plug-in of eclipse to access some directories of mobile phones.
The database file is located in/data/the package name of your program/databases /.
2. Copy the database file
We can use the ADB tool to download database files.
The command is the local path of the ADB push mobile phone.
For example, if I want to copy the test. DB data under the project to my desktop, run the command
./ADB pull/data/COM. Test/databases/test. DB ~ /Desktop/
3. Open the database file
Common SQLite database opening tools:
1. SQLite Database Browser
Http://sqlitebrowser.sourceforge.net/
2. SQLite Administrator
Http://sqliteadmin.orbmu2k.de/
Small, recommended.
3. SQLite expert-Personal Edition
Free Personal Edition, enough
Http://www.sqliteexpert.com/download.html
Very powerful and recommended.
4. Update database files
Upload using the ADB Tool
Command: ADB push local path, mobile phone path
./ADB push ~ /Desktop/alatest. DB/data/COM. Test/databases/test. DB