Creating database and its tables import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; public class MyHelper extends SQLiteOpenHelper { public MyHelper(Context c) { super (c, "databasename" , null , 23 ) ; } @Override public void onCreate(SQLiteDatabase db) { db.execSQL( "CREATE TABLE statement" ); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL( "drop table statement" ); } } Using the controller import android.content.Context; import android.database.Cursor; import android.database.sqlite.*; import java.io.InputStream; import java.net.HttpURLConnection; import java.net.URL; import java.net.URLConnection; public class Db { SQLiteDatabase db ; SQLiteOpenHelper helper ; public Db(Context c) { helper = new MyHelper(c); db = helper ....
Comments
Post a Comment