Brief introduction:Want to build an Android App that supports HTML5;This HTML5 program requires the use of local storage, especially sqllite;Created an app with Eclipse, which defaults to creating two XML files that describe the interface in
Sqllite on Android
On the Android platform, an embedded relational database-SQLite is integrated. sqlite3 supports null, integer, real (floating point number), text (string text), and blob (binary object) data types, although it supports only five
1. Preparations
Sqlite3.exe: http://www.sqlite.org/download.html downloading "sqlite-shell-win32-x86-
3070800. zip "is OK For Precompiled Binaries For Windows
Sqlite-shell-win32-x86-3070800.zip
(248.28 KiB)
System. data. sqlite. dll:
EmilyLinks: http://zhuanlan.zhihu.com/p/20778415Source: KnowCopyright belongs to the author. Commercial reprint please contact the author for authorization, non-commercial reprint please specify the source.Import from SQLite database to MySQL DB
1. View sqllite version information. 2. create a database. 3. exit the sqlite command line. run the sqlitequit or sqliteexit command. 4. list the currently displayed version. 5. display the database table structure. 6. view the table. 1. view
On the Android platform, an embedded relational database-SQLite is integrated. SQLite3 supports NULL, INTEGER, REAL (floating point number), TEXT (string TEXT), and BLOB (binary object) data types, although it supports only five types, sqlite3
DiscussionObjective-CAndCocoa ProgrammingThe best practice is the content to be introduced in this article. In the latest tietong in MarchProgrammingLanguage ranking,Objective-CThe share is still growing sharply, and is constantly approaching the
Fmdb has three main classes1. FmdatabaseA Fmdatabase object represents a separate Sqllite databaseUsed to execute SQL statements2.FMResultSetResult collection after query execution using fmdatabase3.FMDatabaseQueueUsed to execute multiple queries or
1. View the version information for Sqllite:2 Creating a Database3 How to exit the SQLite command line:Sqlite>.quit or Sqlite>.exit command4 List The configuration of the current display format5 Displaying the database table structure6 inserting
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.