Android Open Source - Common-Alerting-Protocol-Compliant-Emergency-Warning-App-For-Android-Using-AMQP Data Base Handler

From Project

Back to project page Common-Alerting-Protocol-Compliant-Emergency-Warning-App-For-Android-Using-AMQP.

License

The source code is released under:

This is free and unencumbered software released into the public domain. Anyone is free to copy, modify, publish, use, compile, sell, or distribute this software, either in source code form or as a co...

If you think the Android project Common-Alerting-Protocol-Compliant-Emergency-Warning-App-For-Android-Using-AMQP listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

package in.ac.iitd.cse.iuatc.ews;
//  ww  w . j a  v a 2  s .c  om
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DataBaseHandler extends SQLiteOpenHelper {

  private static final int DATABASE_VERSION = 1;
  private static final String DATABASE_NAME = "alerts.db";
  
    static final String TABLE_CAP = "captable";
    static final String KEY_ID = "_id";
    static final String KEY_CAP_BLOB = "cap";
    
    private static final String TABLE_CREATE =
                "CREATE TABLE " +TABLE_CAP + " (" +
                KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                KEY_CAP_BLOB + " BLOB UNIQUE NOT NULL UNIQUE);";

    
  public DataBaseHandler(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
  }

  @Override
  public void onCreate(SQLiteDatabase db) {
    db.execSQL(TABLE_CREATE);    
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    // TODO Auto-generated method stub
    
  }

  public void insert(byte[] bytes) {
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(KEY_CAP_BLOB, bytes );
    db.insert(TABLE_CAP, null, values);
    db.close(); 
  }
  
  public Cursor getAll() {
     return this.getReadableDatabase().rawQuery("SELECT * FROM "+TABLE_CAP, null);
  }
}

Java Source Code List