Shulou(Shulou.com)05/31 Report--

In this article Xiaobian for you to introduce in detail "how to use SQLite database in Android", the content is detailed, the steps are clear, and the details are handled properly. I hope this article "how to use SQLite database in Android" can help you solve your doubts.

1:Android SQLite database creation database

Context.createDatabase (String name,int version

Int mode,CursorFactory factory)

If the creation is not successful, throw a FileNotFoundException exception

Java code

SQLiteDatabase DataBase=this.openOrCreateDatabase

("DataBase.db"

MODE_PRIVATE

New CursorFactory () {

/ / create a new database with the name Database and schema MODE_PRIVATE

Public Cursor newCursor (SQLiteDatabase db

SQLiteCursorDriver masterQuery

String editTable

SQLiteQuery query) {

Return null

}

});

SQLiteDatabase DataBase=this.openOrCreateDatabase

("DataBase.db"

MODE_PRIVATE

New CursorFactory () {

/ / create a new database with the name Database and schema MODE_PRIVATE

Public Cursor newCursor (SQLiteDatabase db

SQLiteCursorDriver masterQuery

String editTable

SQLiteQuery query) {

Return null

}

});

2:Android SQLite database opens an existing database

Context.openDatabase (String file,CursorFactory factory)

If we want to open a database that does not exist, create it with the following code:

Java code

/ / create a database named DataBase with a .db suffix

SQLiteDatabase DataBase=this.openOrCreateDatabase

("DateBase.db"

MODE_PRIVATE

Null)

/ / it can also be written this way.

Try

{

/ / Open an existing database

Db = this.openDatabase ("DateBase.db", null)

}

Catch (FileNotFoundException e)

{

Try

{

/ / create a new database

}

Catch (FileNotFoundException e)

{

Db = null

}

}

/ / create a database named DataBase with a .db suffix

SQLiteDatabase DataBase=this.openOrCreateDatabase

("DateBase.db"

MODE_PRIVATE

Null)

/ / it can also be written this way.

Try

{

/ / Open an existing database

Db = this.openDatabase ("DateBase.db", null)

}

Catch (FileNotFoundException e)

{

Try

{

/ / create a new database

}

Catch (FileNotFoundException e)

{

Db = null

}

}

3:Android SQLite database shuts down the database

Java code / / Don't forget to close the database, oh DataBase.close (); / / never forget to close the database, oh DataBase.close ()

4:Android SQLite database deletes the specified database

Java code

This.deleteDatabase ("Database.db"); this.deleteDatabase ("Database.db")

The 5:ndroid SQLite database executes the SQL command using:

SQLiteDatabase.execSQL (String sql): read here, this article "how to use SQLite database in Android" has been introduced. If you want to master the knowledge points of this article, you still need to practice and use it yourself. If you want to know more about related articles, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.