Android Open Source - One-Button-App---Android Image D B

From Project

Back to project page One-Button-App---Android.
License

The source code is released under:
Copyright (c) 2002,2003, Stefan Haustein, Oberhausen, Rhld., Germany Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (...
If you think the Android project One-Button-App---Android 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 edu.cc.oba;
//from ww w  . j a  v  a2  s .c om
import android.content.ContentProvider;
import android.content.ContentUris;
import android.content.ContentValues;
import android.content.Context;
import android.content.UriMatcher;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteQueryBuilder;
import android.net.Uri;
import android.text.TextUtils;
import android.util.Log;

public class ImageDB extends ContentProvider {

  public static final Uri CONTENT_URI = Uri
      .parse("content://edu.cc.oba/images");

  // Create the constants used to differentiate between the different URI
  // requests.
  private static final int IMAGES = 1;
  private static final int IMAGE_ID = 2;

  private static final UriMatcher uriMatcher;
  // Allocate the UriMatcher object, where a URI ending in 'alerts' will
  // correspond to a request for all alerts, and 'alerts' with a trailing
  // '/[rowID]' will represent a single alert row.
  static {
    uriMatcher = new UriMatcher(UriMatcher.NO_MATCH);
    uriMatcher.addURI("edu.cc.oba", "images", IMAGES);
    uriMatcher.addURI("edu.cc.oba", "images/#", IMAGE_ID);
  }

  public SQLiteDatabase imageDB;
  
  @Override
  public boolean onCreate() {
    Context context = getContext();

    alertsDatabaseHelper dbHelper;
    dbHelper = new alertsDatabaseHelper(context, DATABASE_NAME, null,
        DATABASE_VERSION);
    imageDB = dbHelper.getWritableDatabase();
    return (imageDB == null) ? false : true;
  }

  @Override
  public String getType(Uri uri) {
    switch (uriMatcher.match(uri)) {
    case IMAGES:
      return "vnd.android.cursor.dir/vnd.cc.image";
    case IMAGE_ID:
      return "vnd.android.cursor.item/vnd.cc.image";
    default:
      throw new IllegalArgumentException("Unsupported URI: " + uri);
    }
  }

  @Override
  public Cursor query(Uri uri, String[] projection, String selection,
      String[] selectionArgs, String sort) {
    SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
    qb.setTables(IMAGES_TABLE);

    // If this is a row query, limit the result set to the passed in row.
    switch (uriMatcher.match(uri)) {
    case IMAGE_ID:
      qb.appendWhere(KEY_ID + "=" + uri.getPathSegments().get(1));
      break;
    default:
      break;
    }

    // If no sort order is specified sort by date / time
    String orderBy;
    if (TextUtils.isEmpty(sort)) {
      orderBy = KEY_IMAGENAME;
    } else {
      orderBy = sort;
    }

    // Apply the query to the underlying database.
    Cursor c = qb.query(imageDB, projection, selection, selectionArgs, null,
        null, orderBy);

    // Register the contexts ContentResolver to be notified if
    // the cursor result set changes.
    c.setNotificationUri(getContext().getContentResolver(), uri);

    // Return a cursor to the query result.
    return c;
  }

  @Override
  public Uri insert(Uri _uri, ContentValues _initialValues) {
    // Insert the new row, will return the row number if successful.
    long rowID = imageDB.insert(IMAGES_TABLE, "image", _initialValues);

    // Return a URI to the newly inserted row on success.
    if (rowID > 0) {
      Uri uri = ContentUris.withAppendedId(CONTENT_URI, rowID);
      getContext().getContentResolver().notifyChange(uri, null);
      return uri;
    }
    throw new SQLException("Failed to insert row into " + _uri);
  }

  public static void simplydelete(int id, SQLiteDatabase locDB) {
    locDB.execSQL("DELETE FROM LOCS_TABLE where _id = " + id);
  }

  @Override
  public int delete(Uri uri, String where, String[] whereArgs) {
    int count;

    switch (uriMatcher.match(uri)) {
    case IMAGES:
      count = imageDB.delete(IMAGES_TABLE, where, whereArgs);
      break;

    case IMAGE_ID:
      String segment = uri.getPathSegments().get(1);
      count = imageDB.delete(IMAGES_TABLE,
          KEY_ID
              + "="
              + segment
              + (!TextUtils.isEmpty(where) ? " AND (" + where
                  + ')' : ""), whereArgs);
      break;

    default:
      throw new IllegalArgumentException("Unsupported URI: " + uri);
    }

    getContext().getContentResolver().notifyChange(uri, null);
    return count;
  }

  @Override
  public int update(Uri uri, ContentValues values, String where,
      String[] whereArgs) {
    int count;
    switch (uriMatcher.match(uri)) {
    case IMAGES:
      count = imageDB.update(IMAGES_TABLE, values, where, whereArgs);
      break;

    case IMAGE_ID:
      String segment = uri.getPathSegments().get(1);
      count = imageDB.update(IMAGES_TABLE, values,
          KEY_ID
              + "="
              + segment
              + (!TextUtils.isEmpty(where) ? " AND (" + where
                  + ')' : ""), whereArgs);
      break;

    default:
      throw new IllegalArgumentException("Unknown URI " + uri);
    }

    getContext().getContentResolver().notifyChange(uri, null);
    return count;
  }

  /** The underlying database */

  private static final String TAG = "ImageDB";
  private static final String DATABASE_NAME = "images.db";
  private static final int DATABASE_VERSION = 1;
  private static final String IMAGES_TABLE = "images";

  // Column Names
  public static final String KEY_ID = "_id";
  public static final String KEY_IMAGENAME = "imagename";
  public static final String KEY_REQUESTID = "requestid";
  public static final String KEY_STATUS = "status";

  // Column indexes
  // public static final int LOCATION_COLUMN = 1;
  public static final int IMAGENAME_COLUMN = 1;
  public static final int REQUESTID_COLUMN = 2;
  public static final int STATUS_COLUMN = 3;

  // Helper class for opening, creating, and managing database version control
  private static class alertsDatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_CREATE = "create table "
        + IMAGES_TABLE + " (" + KEY_ID
        + " integer primary key autoincrement, " + KEY_IMAGENAME
        + " TEXT NOT NULL, " + KEY_REQUESTID + " TEXT NOT NULL, " + KEY_STATUS + " TEXT NOT NULL" + " );";

    public alertsDatabaseHelper(Context context, String name,
        CursorFactory factory, int version) {
      super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

      db.execSQL(DATABASE_CREATE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
      Log.w(TAG, "Upgrading database from version " + oldVersion + " to "
          + newVersion + ", which will destroy all old data");

      db.execSQL("DROP TABLE IF EXISTS " + IMAGES_TABLE);
      onCreate(db);
    }
  }
}
Java Source Code List
