sqlite tool for android

To do well, you must first sharpen your tools. Learning SQLite's command line tool is very helpful for us to learn SQLite itself. The most basic one is that it makes learning SQLite easier and more enjoyable. To put it bluntly, the official download website of SQLite provides a command line

(Android.os.Message msg) {int code = Msg.what;switch (CO DE) {case 0:mphonebookehelper.insertcontacts (); break;}};}It is important to note that when you create a new thread in the activity, it is not directly accessible to the UI components in the activity, it needs to be handled with handler or Asyntask, and no one throws exception:Java.lang.RuntimeException:Can ' t create handler inside thread that have not called looper.prepare ()So I call the sendemptymessage () function in the button even

standard method interfaces, so that other applications can save or read various data types of this contentprovider. to facilitate testing, how can I view the SQLite database content? Use the tool sqlite3.exe provided by the android SDK. This is a command line utility that lists the main Commands used: view the table structure sqlite3 "path ". dump for ex

marked, in the second layer of data to find the package name of the project, after the opening can see the following structure of the directory:The name of the database folder under the package name is our database file, which is the file name that we first defined in the Dbhelp class xxx.db. Finally click on the icon in the top right to export the database to Local:When we are done we can see a file like this:After successfully exporting the database file, we can view the database data through

This article is original, if you need to repost, please indicate the author and source. Thank you! it's time to explain the database. Databases are also the core of the android storage solution. The SQLite database is used in the Android system. SQLite is a very lightweight database. From the perspective of

SQLite database for Android Development SQLite database for Android Development Please respect others' labor achievements. Reprinted with the source: detailed explanation of SQLite database for Android Development Http://blog.csd

You can use the Eclipse plugin Ddms to view it in Android, or you can use the ADB tool in the Android Toolkit. The SQLite database in the Android project is located in the/data/data/ project package /databases.Use DDMS to export the SQLi