Databasehelper.java
package Com.example.android_sqlite.database;import Android.content.context;import Android.database.sqlite.SQLiteDatabase ; Import Android.database.sqlite.sqlitedatabase.cursorfactory;import Android.database.sqlite.SQLiteOpenHelper; public class Databasehelper extends Sqliteopenhelper {/** * * @param context *: Context Object * @param name * : Database name * @param factory *: Cursor Factory object, you can set NULL. With default Cursorfactory object * @param version *: Database version number */ Public Databasehelper (Context context, String name, cursorfactory factory,int version) {Super (context, name, factory, ver sion);} /** * This method is called when the database is first created */@Overridepublic void OnCreate (Sqlitedatabase db) {db.execsql ("CREATE TABLE Users (userid Integer PRIMARY key autoincrement,username varchar (20));} /** * This method is automatically called when the version of the database is upgraded (depending on the version number of the database) */@Overridepublic void Onupgrade (sqlitedatabase arg0, int arg1, int arg2) {}}
Test class
Package Com.example.android_sqlite.test;import Com.example.android_sqlite.database.databasehelper;import Android.test.androidtestcase;public class Databasetese extends Androidtestcase {public void CreateDatabase () { Databasehelper dh = new Databasehelper (GetContext (), "csdn.db", NULL, 1);d h.getwritabledatabase ();}}
Output Result: