Android Open Source - call_b4u_drink D B Helper

• Back to SMS/call  ↑

From Project

Back to project page call_b4u_drink.

License

The source code is released under:

GNU General Public License

Java Source Code

package org.beltcan.sponsor;
//  w  w  w  .  j  ava2  s.c  om
import android.content.Context;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper {
    private static final int DATABASE_VERSION = 1;
    private static final String DATABASE_NAME = "sponsor.db";
    private static final String TABLE_NAME = "updatesponsor";

    public static final String SPONSOR_COLUMN_ID = "id";
    public static final String SPONSOR_COLUMN_URI = "uri";

    private SponsorOpenHelper openHelper;
    private SQLiteDatabase database;

    public DBHelper(Context context) {
        openHelper = new SponsorOpenHelper(context);
        database = openHelper.getWritableDatabase();
    }
    
    public void saveSponsorData(String uri) {
    ContentValues contentValues = new ContentValues();
    contentValues.put(SPONSOR_COLUMN_URI, uri);
    database.delete(TABLE_NAME, null, null);
    database.insert(TABLE_NAME, null, contentValues);
  }
  
  public Cursor getAllSponsorData() {
    return database.rawQuery(
        "select * from " + TABLE_NAME,
        null
    );
    }

    private class SponsorOpenHelper extends SQLiteOpenHelper {
        SponsorOpenHelper(Context context) {
            super(context, DATABASE_NAME, null, DATABASE_VERSION);
        }

        public void onCreate(SQLiteDatabase database) {
            database.execSQL("CREATE TABLE " + TABLE_NAME + "( "
                + SPONSOR_COLUMN_ID + " INTEGER PRIMARY KEY, "
                + SPONSOR_COLUMN_URI + " TEXT )"
            );
        }

        public void onUpgrade(SQLiteDatabase database,
            int oldVersion, int newVersion) {
                database.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
                onCreate(database);
        }
    }
}

Java Source Code List

• Back to SMS/call  ↑