android查看sqlite数据

由于没有root的真机环境,无法直接利用adb操作device中的db,因此很多调试工作不得不在模拟器环境下做,这样可以随时拷贝文件到电脑上查看表结构和数据情况。

一般情况下device的目录:data/data/<package-name>/databases/<db-name>.db。至于看数据的工具,强烈推荐Navicat。

当然,模拟器环境下ls等常用linux命令都是照常使用。

顺便,litepal的version value升级数据表的方式的确很方便,但是如果在代码里修改了某个字段名,那么同步数据库的时候若不做特殊处理,原有字段的数据将丢失。想也是,相当于删除原来的字段,又新建了一个字段。所以修改字段名这件事情,能不做还是不要轻易做,即便要做得搞定升级数据库时的版本问题。

77 thoughts on “android查看sqlite数据

  1. I simply want to mention I’m new to blogging and definitely enjoyed your blog. Likely I’m planning to bookmark your blog post . You absolutely come with amazing stories. Kudos for revealing your website page.

  2. kumahasiaweh说道:

    Hi there, I found your web site by means of Google even as searching for a related topic, your web site came up, it appears to be like good. I’ve bookmarked it in my google bookmarks.

  3. MetroClick specializes in building completely interactive products like Photo Booth for rental or sale, Touch Screen Kiosks and Digital Signage, and experiences. With our own hardware production facility and in-house software development teams, we are able to achieve the highest level of customization and versatility for Photo Booths, Touch Screen Kiosks and Digital Signage. MetroClick, 121 Varick St, #301, New York, NY 10013, +1 646-843-0888

  4. dentysta gorzów说道:

    My brother suggested I might like this web site. He was totally right. This post truly made my day. You cann’t imagine just how much time I had spent for this information! Thanks!

  5. faytech=说道:

    Faytech North America is a touch screen Manufacturer of both monitors and pcs. They specialize in the design, development, manufacturing and marketing of Capacitive touch screen, Resistive touch screen, Industrial touch screen, IP65 touch screen, touchscreen monitors and integrated touchscreen PCs. Contact them at http://www.faytech.us, 121 Varick Street,3rd Floor,New York, NY 10013,+1 646 205 3214

  6. Only wanna comment that you have a very nice website , I the layout it actually stands out.

  7. click now说道:

    It is actually near impossible to encounter well-educated readers on this issue, yet somehow you come across as like you understand exactly what you’re preaching about! Regards

  8. Homepage说道:

    Tremendously alluring details you have said, thanks a lot for publishing.

  9. Thanks, I have recently been searching for info approximately this topic for a long time and yours is the best I have found out till now. However, what about the conclusion? Are you positive concerning the supply?

  10. dentysta gorzów说道:

    I’m not that much of a online reader to be honest but your sites really nice, keep it up! I’ll go ahead and bookmark your website to come back later on. Cheers

  11. I have recently started a website, the info you provide on this site has helped me greatly. Thank you for all of your time & work.

  12. check my site说道:

    Tremendously insightful resources you have stated, say thanks a lot for posting.

  13. read review说道:

    It really is appropriate opportunity to produce some options for the possible future. I’ve read this blog and if I would, I desire to suggest to you you number of great recommendation.

  14. click for source说道:

    I simply wish to advise you that I am new to writing and completely enjoyed your site. More than likely I am going to save your blog post . You indeed have extraordinary article content. Value it for expressing with us your very own domain information

  15. snapchat spy说道:

    Howdy! This post couldn’t be written any better! Looking at this post reminds me of my previous roommate! He continually kept preaching about this. I’ll send this article to him. Fairly certain he will have a very good read. I appreciate you for sharing!

  16. hi!,I really like your writing so much! percentage we communicate more about your post on AOL? I need a specialist on this area to resolve my problem. May be that’s you! Looking ahead to peer you.

  17. Cork Flowers说道:

    Wow! This blog looks exactly like my old one! It’s on a completely different topic but it has pretty much the same page layout and design. Wonderful choice of colors!

  18. dentysta gorzów说道:

    Just desire to say your article is as astounding. The clearness in your post is just cool and i can assume you are an expert on this subject. Fine with your permission allow me to grab your RSS feed to keep up to date with forthcoming post. Thanks a million and please continue the rewarding work.

  19. Hello there! This article couldn’t be written much better! Looking at this article reminds me of my previous roommate! He constantly kept talking about this. I’ll forward this information to him. Fairly certain he’ll have a good read. Thanks for sharing!

  20. I was just looking for this info for some time. After 6 hours of continuous Googleing, finally I got it in your website. I wonder what’s the lack of Google strategy that do not rank this type of informative web sites in top of the list. Usually the top websites are full of garbage.

  21. Just desire to say your article is as surprising. The clarity in your post is simply cool and i could assume you are an expert on this subject. Well with your permission allow me to grab your feed to keep up to date with forthcoming post. Thanks a million and please carry on the enjoyable work.

  22. Hello, you used to write magnificent, but the last several posts have been kinda boring¡K I miss your tremendous writings. Past several posts are just a bit out of track! come on!

  23. Hey there, You have done an excellent job. I’ll definitely digg it and personally recommend to my friends. I’m confident they’ll be benefited from this website.

  24. Hello, you used to write excellent, but the last few posts have been kinda boring… I miss your great writings. Past few posts are just a little bit out of track! come on!

  25. important link说道:

    I just want to tell you that I am new to wordpress blogging and incredibly valued your page. Quite possibly I am prone to store your blog post . You really have extraordinary article material. Be Grateful For it for telling with us all of your blog webpage

  26. Its wonderful as your other articles : D, thanks for posting . “What makes something special is not just what you have to gain, but what you feel there is to lose.” by Andre Agassi.

  27. F*ckin’ remarkable things here. I’m very glad to see your post. Thank you so much and i am having a look ahead to contact you. Will you please drop me a mail?

  28. Thank you for the good writeup. It in fact was a amusement account it. Look advanced to more added agreeable from you! By the way, how could we communicate?

  29. Excellent blog here! Also your website loads up fast! What web host are you using? Can I get your affiliate link to your host? I wish my website loaded up as quickly as yours lol

  30. I really appreciate this post. I have been looking all over for this! Thank goodness I found it on Bing. You’ve made my day! Thanks again!

  31. you’re truly a excellent webmaster. The web site loading pace is amazing. It seems that you’re doing any distinctive trick. Furthermore, The contents are masterwork. you have performed a magnificent task on this topic!

  32. MichaelJemery.com is a site with many hypnosis downloads. Whether you are looking for free hypnosis downloads, self hypnosis download for mp3, video and any audio files, Michael Jemery has the downloads for you. You can download hypnosis from apps, audio, mp3 and even youtube !

  33. I like what you guys are up also. Such smart work and reporting! Carry on the excellent works guys I have incorporated you guys to my blogroll. I think it will improve the value of my site :).

  34. Health & Fitness说道:

    Wow, wonderful blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is wonderful, as well as the content!

  35. biocentro.cl说道:

    Biocentro.cl en PROVIDENCIA, Santiago Chile es el mejor en impartir cursos de masajes, cursos de masajes, cursos de masaje, cursos de masajista

  36. Definitely, what a fantastic site and instructive posts, I definitely will bookmark your blog.All the Best!

  37. Automotive说道:

    I would like to thank you for the efforts you have put in writing this website. I’m hoping the same high-grade website post from you in the upcoming also. In fact your creative writing abilities has encouraged me to get my own web site now. Actually the blogging is spreading its wings quickly. Your write up is a great example of it.

  38. Travel & Leisure说道:

    I think this is one of the most vital info for me. And i’m glad reading your article. But wanna remark on some general things, The website style is great, the articles is really great : D. Good job, cheers

  39. dentysta gorzów说道:

    Amazing! This blog looks just like my old one! It’s on a entirely different subject but it has pretty much the same page layout and design. Wonderful choice of colors!

  40. Emery EPS说道:

    Emeryeps is a SEO(Search Engine optimzation) and Internet Marketing company. They help businesses to get traffic from various search engine and online community. They have seo experts and consultants with many years of SEO Experiences. No matter where your business is located, EmeryEPS.com can help your business to secure your highly convertible leads online.

  41. Wow! This could be one particular of the most beneficial blogs We have ever arrive across on this subject. Basically Wonderful. I am also an expert in this topic therefore I can understand your effort.

  42. Fantastic beat ! I wish to apprentice while you amend your website, how can i subscribe for a blog web site? The account helped me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear idea

  43. As soon as I found this website I went on reddit to share some of the love with them.

  44. I really like your writing style, great information, regards for posting : D.

  45. Only a smiling visitant here to share the love (:, btw outstanding style and design. “Reading well is one of the great pleasures that solitude can afford you.” by Harold Bloom.

  46. I am not sure where you’re getting your information, but great topic. I needs to spend some time learning much more or understanding more. Thanks for magnificent information I was looking for this information for my mission.

  47. Thank you for sharing superb informations. Your site is so cool. I am impressed by the details that you’ve on this website. It reveals how nicely you understand this subject. Bookmarked this web page, will come back for more articles. You, my pal, ROCK! I found simply the info I already searched everywhere and simply could not come across. What a perfect site.

  48. I truly appreciate this post. I have been looking all over for this! Thank goodness I found it on Bing. You have made my day! Thx again!

  49. I am only commenting to make you understand of the perfect experience my cousin’s girl obtained viewing your web page. She discovered a lot of pieces, with the inclusion of what it’s like to possess a wonderful teaching mindset to make folks quite simply fully understand selected advanced subject areas. You actually surpassed our expected results. Thank you for rendering these warm and friendly, trustworthy, educational as well as cool tips on this topic to Janet.

  50. Magnificent goods from you, man. I have understand your stuff previous to and you’re just extremely fantastic. I really like what you have acquired here, really like what you’re saying and the way in which you say it. You make it entertaining and you still take care of to keep it sensible. I can’t wait to read far more from you. This is really a tremendous site.

  51. Wow, amazing blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your web site is great, as well as the content!

  52. We are a group of volunteers and starting a new scheme in our community. Your website offered us with valuable info to work on. You’ve done an impressive job and our entire community will be grateful to you.

  53. I want to express some thanks to you for bailing me out of this particular difficulty. Right after looking through the world-wide-web and getting tips which were not pleasant, I believed my entire life was over. Being alive without the presence of answers to the issues you have sorted out by means of your good article is a crucial case, as well as those that might have in a negative way affected my career if I had not discovered your web blog. Your primary ability and kindness in handling the whole thing was helpful. I don’t know what I would’ve done if I had not discovered such a point like this. I am able to at this moment look ahead to my future. Thanks a lot very much for this specialized and sensible guide. I won’t hesitate to endorse the website to any individual who would need assistance on this area.

  54. It’s appropriate time to make a few plans for the longer term and it’s time to be happy. I have learn this publish and if I may I desire to counsel you some attention-grabbing issues or advice. Perhaps you can write next articles regarding this article. I desire to learn even more things about it!

  55. Vindeltrappen说道:

    Very nice layout and superb articles , hardly anything else we require : D.

    trapper i træ

  56. Vindeltrapper说道:

    Magnificent site. A lot of helpful information here. I am sending it to some pals ans also sharing in delicious. And naturally, thank you for your effort!

  57. Please let me know if you’re looking for a writer for your weblog. You have some really great articles and I feel I would be a good asset. If you ever want to take some of the load off, I’d love to write some content for your blog in exchange for a link back to mine. Please blast me an e-mail if interested. Cheers!

  58. Hi, I do believe this is a great site. I stumbledupon it 😉 I’m going to return yet again since I book-marked it. Money and freedom is the greatest way to change, may you be rich and continue to help other people.

  59. I went over this website and I think you have a lot of great information, saved to my bookmarks (:.

  60. pron best说道:

    3BgLVQ Say, you got a nice article.Really thank you! Much obliged.

  61. Does your site have a contact page? I’m having trouble locating it but, I’d like to send you an email. I’ve got some ideas for your blog you might be interested in hearing. Either way, great blog and I look forward to seeing it grow over time.

  62. Home Improvement说道:

    I do trust all of the ideas you have presented to your post. They are very convincing and can definitely work. Nonetheless, the posts are too brief for newbies. May just you please extend them a little from subsequent time? Thanks for the post.

  63. Health说道:

    As soon as I observed this website I went on reddit to share some of the love with them.

  64. Does your blog have a contact page? I’m having a tough time locating it but, I’d like to shoot you an email. I’ve got some creative ideas for your blog you might be interested in hearing. Either way, great website and I look forward to seeing it expand over time.

  65. Business说道:

    What i do not understood is in reality how you are not really a lot more smartly-favored than you might be right now. You’re very intelligent. You understand thus significantly with regards to this matter, made me for my part consider it from a lot of varied angles. Its like men and women don’t seem to be interested except it is one thing to do with Woman gaga! Your personal stuffs outstanding. At all times deal with it up!

  66. Women说道:

    F*ckin’ remarkable issues here. I’m very happy to look your post. Thank you so much and i’m having a look ahead to contact you. Will you kindly drop me a e-mail?

  67. Career And Jobs说道:

    I really enjoy examining on this web site , it contains fantastic posts . “For Brutus is an honourable man So are they all, all honourable men.” by William Shakespeare.

  68. Fashion说道:

    Hello my family member! I wish to say that this post is awesome, great written and come with approximately all important infos. I would like to see more posts like this.

  69. I have not checked in here for some time as I thought it was getting boring, but the last several posts are great quality so I guess I will add you back to my daily bloglist. You deserve it my friend 🙂

  70. Hi, I do think this is a great website. I stumbledupon it 😉 I’m going to return once again since i have book marked it. Money and freedom is the best way to change, may you be rich and continue to help others.

  71. Good write-up, I am regular visitor of one’s website, maintain up the nice operate, and It is going to be a regular visitor for a lengthy time.

  72. Technology说道:

    Enjoyed examining this, very good stuff, regards . “To be positive To be mistaken at the top of one’s voice.” by Ambrose Bierce.

  73. robloxwiki说道:

    Woah! I’m really digging the template/theme of this blog. It’s simple, yet effective. A lot of times it’s very difficult to get that “perfect balance” between user friendliness and appearance. I must say you have done a great job with this. In addition, the blog loads very fast for me on Opera. Outstanding Blog!

  74. I really enjoy examining on this web site , it has fantastic content . “A man of genius has been seldom ruined but by himself.” by Samuel Johnson.

  75. Pets说道:

    We’re a group of volunteers and starting a new scheme in our community. Your website offered us with valuable info to work on. You’ve done an impressive job and our whole community will be thankful to you.

  76. Jewelry说道:

    You have observed very interesting details ! ps nice web site . “Loneliness seems to have become the great American disease.” by John Corry.

发表评论

电子邮件地址不会被公开。