android sqlite database tutorial

Recently, I tried to develop the android program. The exercise Project is a simple weather forecast program. The weather forecast naturally involves various regions throughout the country. I put the names and region code of these regions in an SQLite database. Of course, Android also supports

","Dan Brown","510","19.95"});Db.close ();Delete DataSqlitedatabase db = Databasehelper. (Mcontext,1). Getwritabledatabase ();Db.execsql ("Delete from book where pages >?", NewString[] {"a"});Db.close ();Update DataSqlitedatabase db = Databasehelper. (Mcontext,1). Getwritabledatabase ();Db.execsql ("Update book Set price =?" WHERE name =? ", NewString[] {"10.99","The Da Vinci Code"});Db.close ();Querying DataSqlitedatabase Db=databasehelper. (Mcontext,1). Getreadabledatabase ();Cursor Cursor=db.

Android entry notes-data storage-SQLite, unit test Why do we need to add three lightweight databases (SQLite) today? Because it is really light. Sqlite is a lightweight database specially prepared by unembedded devices. Although it is small, it has many functions. The bigges

SQLite plays an important role in Android development, and there are many SQLite tutorials on the web, but most of those tutorials are not very comprehensive. I summed up a number of SQLite orders, by the Forum contest, to share with you. I. Introduction to SQLite 1.

SQLite, is a lightweight database, is widely used in a lot of embedded products, because the use of very little resources, two of the operation of the way almost and we contact the database is not much, even only hundreds of k he will naturally be favored by the demand, Let's talk about how to read and write to him in such a lightweight database.Before making a s

Tags: pysqliteThe Python SQLite database is a very small embedded open source database software with no independent maintenance process and all maintenance is from the program itself. It uses a file to store the entire database, which is very convenient to operate. The following are important SQLITE3 module programs th

Original address: http://www.cnblogs.com/wangmars/p/3914090.htmlSQLite, is a lightweight database, is widely used in a lot of embedded products, because the use of very little resources, two of the operation of the way almost and we contact the database is not much, even only hundreds of k he will naturally be favored by the demand, Let's talk about how to read and write to him in such a lightweight databas

Basic Android SQLite operations Add, delete, modify, and query related to SQLite are displayed in log. Package com. example. sqlconnecttest; import android. content. context; import android. database.

Use an embedded relational SQLite database to store dataIn addition to using files or SharedPreferences to store data, you can also choose to use the SQLite database to store data.On the Android platform, an embedded relational database