How to use SQLite Database in Android
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.
