android怎么查询mysql数据库,如何查看保存在android的数据库(SQLite的)数据?

本文介绍了如何在Eclipse中通过DDMS访问Android emulator的SQLite数据库,查看并管理应用程序的数据。你需要安装SQLite Manager插件,然后在DDMS的File Explorer中找到应用程序的数据库文件,点击后可以使用SQLite Manager查看数据。注意,对于未加'.db'扩展名的数据库,可能需要额外的步骤来查看。
摘要由CSDN通过智能技术生成

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

解决方案

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.

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

Install SqliteManagerPlugin for Eclipse. Jump to step 5 if you already have it.

Download the *.jar file from here

Put the *.jar file into the folder eclipse/dropins/

Restart eclipse

In the top right of eclipse, click the DDMS icon

Select the proper emulator in the left panel

In the File Explorer tab on the main panel, go to /data/data/[YOUR.APP.NAMESPACE]/databases

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.

*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

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

Check this for more information

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值