simple sqlite database example in android

If you want to use the database in Android, using SQLite is a very good choice because it is an Android built-in database that provides a lot of support.The use of the database is nothing more than a crud, that is, "Create,read,up

Test.java:/** * This example solves the problem: * Core issue: Create a Database object through the Sqliteopenhelper class * operation of database objects through database object * 1.SQL statement Operation SQLite Database * 2. Go

;Import Android.database.sqlite.SQLiteOpenHelper;/** * * @author Lin* SQLite Help class */public class Sqlite_persondb extends sqliteopenhelper{/*** SQLite Database construction method, used to define database name, database query result set,

Android SQLite database BASICS (1 continued), androidsqlite Supplementary note, in the previous article, I have joined the following content, have not read the first article, you can directly read the first article can be (http://www.cnblogs.com/flylin/p/qq_980542577.html ). Read this article. Create a test class to test whether the Code mentioned in the previou

We will use TodoList as an example to introduce the basic usage of SQLite. We have several suggestions when designing the SQLite database table: It is not recommended that some file resources (such as files or sounds) be directly stored in database tables. Currently, the fil

To manipulate the SQLite database on the Android real computer directly from the command line, you can do it directly through the ADB shell, but only if you have to get root privileges.In addition, the Android system is actually the Linux shell, this should be known, but under normal circumstances, in the/system/xbin/d

/* Everyone knows that it will be very tiring to write a blog. Hope = reprint please indicate the source: http://blog.csdn.net/ta893115871 Please do not pity your mouse, (* ^__ ^ *) Xi ...... */ As we all know, databases are very important. Almost all the software on the market needs to use databases. In Android, the database is SQLite, which is small and conveni

Use the existing SQLite database in the Android Program In the previous contact project, the pre-stored data in the database needs to be displayed after the application is installed. In this case, you need to import the existing database contact. db. This is also an intervie

Because the project needs to bring the data, so we put the data into a SQLite database file, and then put the file under the Assets folder. From the beginning of the plan to copy the folder from the assets folder to the phone's SD card or the phone's own storage before use, and then consider that each copy is not efficient, and if it involves the modification of the dat