In the Android app development everywhere SQLite database figure. So how do you use the ADB command to manipulate the database in development?
The following is a complete description of the command set associated with database operations and the various workarounds when the phone lacks sqlite3.
1. How to operate the database when the phone is missing sqlite3
First look at the phone missing sqlite3 time:
Watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity /center "/>
This time you want to manipulate the contents of the database file that you just wrote running in the application. The SQL statement is obviously not running. Here are three ways that you can view the database files under your application:
㈠ importing sqlite3 files to your phone
① first step, download Sqlite3 file
Please download it to http://www.sqlite.org/download.html. Since Android is a Linux-based development, select Linux download package.
After decompression, copy out the Sqlite3 file to a folder that is easy to operate with the cmd command line.
② get root permissions, mount the system partition, and allow the system partition to read and write again
The adb root command gets root privileges
ADB remount mount system partition
③ after running ②, you can import sqlite3 files to your phone
ADB push E:\sqlite3/system/bin
④ uses the ADB shell to enter the shell command mode, giving the file readable and writable.
ADB shell
Su
chmod 777/system/bin/sqlite3
⑤ Entering database folder operations database
cd/data/data/Application Package Name/databases
LS Lists the database files
Sqlite3 students.db access to operational database directives
The following is the ability to run the SQL statement you want, the following are all the commands:
Watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity /center "/>
㈡ Importing database files in Windows system operations
① Export the database file to the folder you specified
ADB pull/data/data/Application Package name/databases/students.db
② Download Window's sqlite3 package. Extract. Same download URL for http://www.sqlite.org/download.html
③ into the extracted Sqlite3 folder, manipulate the database file
Commands such as the following:
㈢ Import Database File Open database file directly with software
This does not belong to the scope of the program, this belongs to the computer application, please go to the Web site to see for yourself:
Http://jingyan.baidu.com/article/e8cdb32b4343e637052bad0f.html
2. Mobile phone with sqlite3 operation database
The preceding commands are described. The direct explanation.
ADB command specific Explanation (ii)--a variety of solutions to the operation database when the mobile phone is missing sqlite3