android 与sqlite数据库

在做sqlite数据库之前，首先要了解sqlite的历史：http://www.sqlite.org/。简单了解的话，去百度百科。

其次，看android官方文档，了解其对sqlite的说明。

Contains the SQLite database management classes that an application would use to manage its own private database.

Applications use these classes to manage private databases. If creating a content provider, you will probably have to use these classes to create and manage your own database to store content. See Content Providers to learn the conventions for implementing a content provider. See the NotePadProvider class in the NotePad sample application in the SDK for an example of a content provider. Android ships with SQLite version 3.4.0

If you are working with data sent to you by a provider, you will not use these SQLite classes, but instead use the generic android.database classes.

Android ships with the sqlite3 database tool in the tools/ folder. You can use this tool to browse or run SQL commands on the device. Run by typing sqlite3 in a shell window.

 

 

主要是说了一下：

1、对sqlite版本支持，3.4以上的很多功能就不能用

2、操作sqlite的方法：【1】用android提供的【2】用外部工具，推荐：SQLite Database Browser http://download.csdn.net/detail/hhbbeijing/5976129