blocks|key|9004|text|我一直在使用SQLite+Database+Browser查看安卓开发中的content+SQLite+DB。您必须先从设备中拉出数据库文件，然后在SQLite+DB浏览器中打开它。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|9005|entityMap|0|LINK|mutability|MUTABLE|url|http://sourceforge.net/projects/sqlitebrowser/^0|6|N|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I have been using <a href="http://sourceforge.net/projects/sqlitebrowser/" rel="nofollow">SQLite Database Browser</a> to see the content SQLite DB in Android development. You have to pull the database file from the device first, then open it in SQLite DB Browser.

blocks|key|9126|text|试试facebook+Stetho吧。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|9127|Stetho是Android应用程序的调试桥，支持强大的Chrome开发工具等。|9128|https://github.com/facebook/stetho|offset|length|9129|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|Y|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@$F|R|G|S|1|T]]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|E]]]]

try facebook Stetho.

Stetho is a debug bridge for Android applications, enabling the powerful Chrome Developer Tools and much more.

<a href="https://github.com/facebook/stetho" rel="nofollow">https://github.com/facebook/stetho</a>

blocks|key|9081|text|这适用于Android+6.0+(至少是可调试的应用程序)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|9082|adb+shell+"run-as+your.package.name+cp+/data/data/your.package.name/databases/you-db-name++/sdcard/file_to_write"|code-block|syntax|javascript|9083|然后，您可以简单地使用aSQLiteManager查看数据库。|offset|length|9084|entityMap|0|LINK|mutability|MUTABLE|url|https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager&hl=en^0|0|0|B|E|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

This works with Android 6.0 (debuggable apps at least):

<pre><code>adb shell "run-as your.package.name cp /data/data/your.package.name/databases/you-db-name /sdcard/file_to_write"
</code></pre>

Then you simply can view the DB with <a href="https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager&amp;hl=en" rel="nofollow">aSQLiteManager</a> for instance.

blocks|key|225703|text|你可以试试SQLiteOnWeb。它在浏览器中管理您的SQLite数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|225704|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/skyhacker2/SQLiteOnWeb-Android^0|5|B|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You can try <a href="https://github.com/skyhacker2/SQLiteOnWeb-Android" rel="nofollow">SQLiteOnWeb</a>. It manages your SQLite database in the browser.

blocks|key|9156|text|希望这能对你有所帮助|type|unstyled|depth|inlineStyleRanges|entityRanges|data|9157|首先使用终端指向andriod+sdk所在的位置|9158|eg:+C:\Users\AppData\Local\Android\sdk\platform-tools>|code-block|syntax|javascript|9159|然后使用以下命令检查连接的设备列表|9160|+adb+devices|9161|然后运行此命令将文件从设备复制到您的系统|9162|adb+-s+YOUR_DEVICE_ID+shell+run-as+YOUR_PACKAGE_NAME+chmod+-R+777+/data/data/YOUR_PACKAGE_NAME/databases+&&+adb+-s+YOUR_DEVICE_ID+shell+"mkdir+-p+/sdcard/tempDB"+&&+adb+-s+YOUR_DEVICE_ID+shell+"cp+-r+/data/data/YOUR_PACKAGE_NAME/databases/+/sdcard/tempDB/."+&&+adb+-s+YOUR_DEVICE_ID+pull+sdcard/tempDB/+&&+adb+-s+YOUR_DEVICE_ID+shell+"rm+-r+/sdcard/tempDB/*"|9163|您可以在以下路径中找到数据库文件|9164|+Android\sdk\platform-tools\tempDB\databases|9165|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

Hope this helps you

Using Terminal First point your location where andriod sdk is loacted 

<pre><code>eg: C:\Users\AppData\Local\Android\sdk\platform-tools&gt;
</code></pre>

then check the list of devices attached Using

<pre><code> adb devices
</code></pre>

and then run this command to copy the file from device to your system

<pre><code>adb -s YOUR_DEVICE_ID shell run-as YOUR_PACKAGE_NAME chmod -R 777 /data/data/YOUR_PACKAGE_NAME/databases &amp;&amp; adb -s YOUR_DEVICE_ID shell "mkdir -p /sdcard/tempDB" &amp;&amp; adb -s YOUR_DEVICE_ID shell "cp -r /data/data/YOUR_PACKAGE_NAME/databases/ /sdcard/tempDB/." &amp;&amp; adb -s YOUR_DEVICE_ID pull sdcard/tempDB/ &amp;&amp; adb -s YOUR_DEVICE_ID shell "rm -r /sdcard/tempDB/*"
</code></pre>

You can find the database file in this path 

<pre><code> Android\sdk\platform-tools\tempDB\databases
</code></pre>

blocks|key|225666|text|使用文件资源管理器，您可以找到数据库文件，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|225667|data-->data-->your.package.name-->databases--->yourdbfile.db|code-block|syntax|javascript|225668|然后你可以使用前面的任何SQLite来浏览你的数据库。我使用的是SQLite+Manager+Firefox插件。它很好，很小，而且很快。|225669|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Using file explorer, you can locate your database file like this:

<pre><code>data--&gt;data--&gt;your.package.name--&gt;databases---&gt;yourdbfile.db
</code></pre>

Then you can use any SQLite fronted to explore your database. I use the SQLite Manager Firefox addon. It's nice, small, and fast.

blocks|key|225781|text|我发现了一个非常简单的库stetho来浏览sqlite+db的应用程序在chrome，see|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|225782|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/facebook/stetho^0|17|3|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I found very simple library stetho to browse sqlite db of app in chrome, <a href="https://github.com/facebook/stetho" rel="nofollow noreferrer">see</a>

I have a set of data in an SQLite database. I need to view the database on a device. How do I do that?

I have checked in ddms mode. The data in file explorer is empty.

How do I view the SQLite database on an Android device?

数据库

Android

SQLite

我在SQLite数据库中有一组数据。我需要查看设备上的数据库。我该怎么做？我已经在ddms模式下签到了。文件资源管理器中的数据为空。

问如何在安卓设备上查看SQLite数据库？
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在安卓设备上查看SQLite数据库？EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在安卓设备上查看SQLite数据库？
EN