Creation of the SQLite database for Android development

Package com.example.db;

Import Android.content.Context;

Import Android.database.sqlite.SQLiteDatabase;

Import Android.database.sqlite.SQLiteDatabase.CursorFactory;

Import Android.database.sqlite.SQLiteOpenHelper;

public class Personsqliteopenhelper extends Sqliteopenhelper {

/**

* Database construction method is used to define the database name of the database query result set

* @param context Contexts

* @param name database names

* @param factory Cursors

* @param versions of version database

*/

Public Personsqliteopenhelper (Context context)

{

Super (context, "person.db", NULL, 1);

}

/**

* Method Called when the database was first created

* Parameters common to @param DB database

*/

@Override public void OnCreate (Sqlitedatabase db)

{

Db.execsql ("CREATE TABLE person (ID integer primaru key autoincrement, name varchar (), number varchar (20)");

}

@Override

public void Onupgrade (sqlitedatabase arg0, int arg1, int arg2) {//TODO auto-generated method stub

}

}

Database calls

Personsqliteopenhelper helper = new Personsqliteopenhelper (GetContext ());
Helper.getwritabledatabase ();

Creation of the SQLite database for Android development