如何查看保存在android的数据库(SQLite的)数据?

问题描述:

我能够观看来自日食的数据库(从文件浏览器),但我想查看整个细节,我的意思是,我已经插入的数据,而我不能。而我的完整Android的安装已对 F盘。所以任何帮助将AP preciated.Thanks很多

I am able to view the database from eclipse(from file explorer), but I want to view the whole detail, I mean the data that I have inserted, which I am unable. And my complete Android installation has made on F Drive .So any help will be appreciated.Thanks a lot

您可以访问使用DDMS该文件夹为您的模拟器。除非你有一个根深蒂固的设备在真实设备上,你不能访问这个位置。

You can access this folder using the DDMS for your Emulator. you can't access this location on a real device unless you have a rooted device.

您可以在Eclipse中查看表结构和数据。下面是步骤

You can view Table structure and Data in Eclipse. Here are the steps

  1. 在安装SqliteManagerPlugin的Eclipse插件。跳转到第5步,如果你已经拥有了它。
  2. 在这里下载从的* .jar文件
  3. 把* .jar文件到该文件夹​​的Eclipse /的dropins /
  4. 重新启动Eclipse
  5. 在Eclipse中的右上方,点击DDMS图标
  6. 选择在左侧面板
  7. 合适的仿真器
  8. 在主面板上的文件资源管理器选项卡,进入/数据/数据​​/ [YOUR.APP.NAMESPACE] /数据库
  9. 在下面的DDMS图标,应该有,当你选择数据库的数据库光了一个新的蓝色图标。点击它,你会看到一个Questoid sqlite的管理器选项卡打开,查看您的数据。
  1. Install SqliteManagerPlugin for Eclipse. Jump to step 5 if you already have it.
  2. Download the *.jar file from here
  3. Put the *.jar file into the folder eclipse/dropins/
  4. Restart eclipse
  5. In the top right of eclipse, click the DDMS icon
  6. Select the proper emulator in the left panel
  7. In the File Explorer tab on the main panel, go to /data/data/[YOUR.APP.NAMESPACE]/databases
  8. Underneath the DDMS icon, there should be a new blue icon of a Database light up when you select your database. Click it and you will see a Questoid Sqlite Manager tab open up to view your data.

*注意:如果数据库不亮,可能是因为你的数据库没有一个* .db文件扩展名。确保您的数据库名为[DATABASE_NAME] .db的

*Note: If the database doesn't light up, it may be because your database doesn't have a *.db file extension. Be sure your database is called [DATABASE_NAME].db

*注意:如果你想使用DB不带.db拓:

*Note: if you want to use a DB without .db-Extension:

  1. 下载Questoid SqLiteBrowser:http://www.java2s.com/$c$c/JarDownload/com.questoid/com.questoid.sqlitebrowser_1.2.0.jar.zip

解压缩,并把它到Eclipse /的dropins(不是插件)

Unzip and put it into eclipse/dropins (not Plugins)

检查本作的更多信息