simple sqlite database example in android

Experiment 8 SQLite Database operationsPurposeDesign a Personal Address book, master the development of the database under the Android platform, the personal Address Book mainly includes the contact list and contact details and other interfaces.RequirementsThe main interface of the program is the directory of contacts

AndroidWhen SQLite inserts the data by default a statement is a transaction, so if there are tens of thousands of data inserted, then you need to do tens of thousands of insertions, operation speed imaginable.　　So when inserting data into Android, using BULK insert can greatly improve the insertion speed. Sometimes need to put some data into the application, commonly used in the following 2 ways: One direct

:"+ RowIndex );}String task = cursor. getString (TASK_COLUMN );Long created = cursor. getLong (CREATION_DATE_COLUMN );TodoItem result = new TodoItem (task, new Date (created ));Return result;}Public Cursor getAllToDoItemsCursor (){Return mDb. query (DATABASE_TABLE,New String [] {KEY_ID, KEY_TASK, KEY_CREATION_DATE },Null, null );}Public Cursor setCursorToToDoItem (long rowIndex)Throws SQLException {Cursor result = mDb. query (DATABASE_TABLE,New String [] {KEY_ID, KEY_TASK },KEY_ID + "=" + rowIn

Android database SQLite writes SD card, androidsqlite If the mobile phone does not have a root user, the database files cannot be viewed and debugging is not convenient. The best way is to write the database into the SD card. There are two changes: 1. In your helper class,

/DEMO.DB"; Database name public static FINAL String table_name = "mytag";//datasheet name, a database can contain more than one datasheet, similar to the Sheet1,sheet2 in Excel // Mydbhelper's constructor, we are concerned with the name database_name and version versions public Mydbhelper { Super database_name, NULL, VERSION); Because if just a separate file name, the last created

In the previous contact project, you need to import the existing database contact.db after the app is installed to display the data stored in the database. This is also a face test, so how to achieve it?When you create a new raw folder in Res, the files in the Res\raw directory are not compressed so that you can directly extract the files in that directory. So how to import the

A SQLite introductionSQLite is an embedded database, similar to a file system, that is with the program. and MySQL and other database programs and data separation is not the same.Application scenario: Often used to save local configuration, similar to the local file system, so he embedded in Linux, Android, iOS and oth

system table Sqlite_masterString sql ="SELECT * from Sqlite_master"; cursor cursor = db.rawquery (SQL,NULL);//Print all column names of the tableLOG.I (TAG, Arrays.tostring (Cursor.getcolumnnames ()));//Print all tables in the current database if(Cursor.movetofirst ()) {do {String str =""; for(String item:cursor.getColumnNames ()) {str + + item +": "+ cursor.getstring (Cursor.getcolumnindex (item)) +"\ n"; } log.i (T

type; int id = cursor.getint (cursor.getcolumnindex ("id")) ; String named = cursor.getstring (Cursor.getcolumnindex ("name")); String number = cursor.getstring (Cursor.getcolumnindex ("number"));//Instantiate query result data Object person = new person (ID, named, number);} Close the database connection, release the Resource Db.close ();//Return the data result object return person; /** * Update a data according to name * * @param name * with new c

NewIllegalStateException ("Database not open"); + } A at //measurements Show Most SQL lengths -StringBuilder sql =NewStringBuilder (152); -Sql.append ("INSERT"); - sql.append (Conflict_values[conflictalgorithm]); -Sql.append ("into"); - sql.append (table); in //measurements Show most values lengths -StringBuilder values =NewStringBuilder (40); to +setNULL; - if(Initialvalues! =NULL initialvalues.size () >

Prototype: Long Android. database. SQLite. sqlitedatabase. insert (string table, string nullcolumnhack, contentvalues values) Parameter introduction: Table: Name of the table to insert data Nullcolumnhack: When the values parameter is null or there is no content in it, insert will fail (the underlying database cannot

); +Db.execsql ("CREATE TABLE IF not EXISTS person" + "(_id integer PRIMARY KEY autoincrement, name VARCHAR, age INTEGER, info TEXT) "); A}This part of the problem I think has not been implemented, and later verified that it did not execute.This part of the card for a long time, later can only findSqliteopenhelper of the use of the method, found Creates a Databasehelper object that only executes this sentence is not created or opened by the connected Databasehelper dbhelper = new Da