Java NoteColumns类代码示例

import com.example.android.notepad.NotePad.NoteColumns; //导入依赖的package包/类
/**
 * Take care of canceling work on a note.  Deletes the note if we
 * had created it, otherwise reverts to the original text.
 */
private final void cancelNote() {
    if (mCursor != null) {
        if (mState == STATE_EDIT) {
            // Put the original note text back into the database
            mCursor.close();
            mCursor = null;
            ContentValues values = new ContentValues();
            values.put(NoteColumns.NOTE, mOriginalContent);
            getContentResolver().update(mUri, values, null, null);
        } else if (mState == STATE_INSERT) {
            // We inserted an empty note, make sure to delete it
            deleteNote();
        }
    }
    setResult(RESULT_CANCELED);
    finish();
}
 

import com.example.android.notepad.NotePad.NoteColumns; //导入依赖的package包/类
@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);

    setDefaultKeyMode(DEFAULT_KEYS_SHORTCUT);

    // If no data was given in the intent (because we were started
    // as a MAIN activity), then use our default content provider.
    Intent intent = getIntent();
    if (intent.getData() == null) {
        intent.setData(NoteColumns.CONTENT_URI);
    }

    // Inform the list we provide context menus for items
    getListView().setOnCreateContextMenuListener(this);
    
    // Perform a managed query. The Activity will handle closing and requerying the cursor
    // when needed.
    Cursor cursor = managedQuery(getIntent().getData(), PROJECTION, null, null,
                                    NoteColumns.DEFAULT_SORT_ORDER);

    // Used to map notes entries from the database to views
    SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.noteslist_item, cursor,
            new String[] { NoteColumns.TITLE }, new int[] { android.R.id.text1 });
    setListAdapter(adapter);
}
 

import com.example.android.notepad.NotePad.NoteColumns; //导入依赖的package包/类
@Override
public int delete(Uri uri, String where, String[] whereArgs) {
    SQLiteDatabase db = mOpenHelper.getWritableDatabase();
    int count;
    switch (sUriMatcher.match(uri)) {
    case NOTES:
        count = db.delete(NOTES_TABLE_NAME, where, whereArgs);
        break;

    case NOTE_ID:
        String noteId = uri.getPathSegments().get(1);
        count = db.delete(NOTES_TABLE_NAME, NoteColumns._ID + "=" + noteId
                + (!TextUtils.isEmpty(where) ? " AND (" + where + ')' : ""), whereArgs);
        break;

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

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

import com.example.android.notepad.NotePad.NoteColumns; //导入依赖的package包/类
@Override
public int update(Uri uri, ContentValues values, String where, String[] whereArgs) {
    SQLiteDatabase db = mOpenHelper.getWritableDatabase();
    int count;
    switch (sUriMatcher.match(uri)) {
    case NOTES:
        count = db.update(NOTES_TABLE_NAME, values, where, whereArgs);
        break;

    case NOTE_ID:
        String noteId = uri.getPathSegments().get(1);
        count = db.update(NOTES_TABLE_NAME, values, NoteColumns._ID + "=" + noteId
                + (!TextUtils.isEmpty(where) ? " AND (" + where + ')' : ""), whereArgs);
        break;

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

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

import com.example.android.notepad.NotePad.NoteColumns; //导入依赖的package包/类
@Override
protected void onPause() {
    super.onPause();

    if (mCursor != null) {
        // Write the title back to the note 
        ContentValues values = new ContentValues();
        values.put(NoteColumns.TITLE, mText.getText().toString());
        getContentResolver().update(mUri, values, null, null);
    }
}
 

import com.example.android.notepad.NotePad.NoteColumns; //导入依赖的package包/类
@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("CREATE TABLE " + NOTES_TABLE_NAME + " ("
            + NoteColumns._ID + " INTEGER PRIMARY KEY,"
            + NoteColumns.TITLE + " TEXT,"
            + NoteColumns.NOTE + " TEXT,"
            + NoteColumns.CREATED_DATE + " INTEGER,"
            + NoteColumns.MODIFIED_DATE + " INTEGER"
            + ");");
}
 

import com.example.android.notepad.NotePad.NoteColumns; //导入依赖的package包/类
@Override
public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs,
        String sortOrder) {
    SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
    qb.setTables(NOTES_TABLE_NAME);

    switch (sUriMatcher.match(uri)) {
    case NOTES:
        qb.setProjectionMap(sNotesProjectionMap);
        break;

    case NOTE_ID:
        qb.setProjectionMap(sNotesProjectionMap);
        qb.appendWhere(NoteColumns._ID + "=" + uri.getPathSegments().get(1));
        break;

    case LIVE_FOLDER_NOTES:
        qb.setProjectionMap(sLiveFolderProjectionMap);
        break;

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

    // If no sort order is specified use the default
    String orderBy;
    if (TextUtils.isEmpty(sortOrder)) {
        orderBy = NoteColumns.DEFAULT_SORT_ORDER;
    } else {
        orderBy = sortOrder;
    }

    // Get the database and run the query
    SQLiteDatabase db = mOpenHelper.getReadableDatabase();
    Cursor c = qb.query(db, projection, selection, selectionArgs, null, null, orderBy);

    // Tell the cursor what uri to watch, so it knows when its source data changes
    c.setNotificationUri(getContext().getContentResolver(), uri);
    return c;
}
 

import com.example.android.notepad.NotePad.NoteColumns; //导入依赖的package包/类
@Override
public String getType(Uri uri) {
    switch (sUriMatcher.match(uri)) {
    case NOTES:
    case LIVE_FOLDER_NOTES:
        return NoteColumns.CONTENT_TYPE;

    case NOTE_ID:
        return NoteColumns.CONTENT_ITEM_TYPE;

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

import com.example.android.notepad.NotePad.NoteColumns; //导入依赖的package包/类
private final void saveNote() {
    // Make sure their current
    // changes are safely saved away in the provider.  We don't need
    // to do this if only editing.
    if (mCursor != null) {
        // Get out updates into the provider.
        ContentValues values = new ContentValues();

        // Bump the modification time to now.
        values.put(NoteColumns.MODIFIED_DATE, System.currentTimeMillis());

        String text = mText.getText().toString();
        int length = text.length();
        // If we are creating a new note, then we want to also create
        // an initial title for it.
        if (mState == STATE_INSERT) {
            if (length == 0) {
                Toast.makeText(this, R.string.nothing_to_save, Toast.LENGTH_SHORT).show();
                return;
            }
            String title = text.substring(0, Math.min(30, length));
            if (length > 30) {
                int lastSpace = title.lastIndexOf(' ');
                if (lastSpace > 0) {
                    title = title.substring(0, lastSpace);
                }
            }
            values.put(NoteColumns.TITLE, title);
        }

        // Write our text back into the provider.
        values.put(NoteColumns.NOTE, text);

        // Commit all of our changes to persistent storage. When the update completes
        // the content provider will notify the cursor of the change, which will
        // cause the UI to be updated.
        try {
            getContentResolver().update(mUri, values, null, null);
        } catch (NullPointerException e) {
            Log.e(TAG, e.getMessage());
        }
        
    }
}
 

import com.example.android.notepad.NotePad.NoteColumns; //导入依赖的package包/类
@Override
public Uri insert(Uri uri, ContentValues initialValues) {
    // Validate the requested uri
    if (sUriMatcher.match(uri) != NOTES) {
        throw new IllegalArgumentException("Unknown URI " + uri);
    }

    ContentValues values;
    if (initialValues != null) {
        values = new ContentValues(initialValues);
    } else {
        values = new ContentValues();
    }

    Long now = Long.valueOf(System.currentTimeMillis());

    // Make sure that the fields are all set
    if (values.containsKey(NoteColumns.CREATED_DATE) == false) {
        values.put(NoteColumns.CREATED_DATE, now);
    }

    if (values.containsKey(NoteColumns.MODIFIED_DATE) == false) {
        values.put(NoteColumns.MODIFIED_DATE, now);
    }

    if (values.containsKey(NoteColumns.TITLE) == false) {
        Resources r = Resources.getSystem();
        values.put(NoteColumns.TITLE, r.getString(android.R.string.untitled));
    }

    if (values.containsKey(NoteColumns.NOTE) == false) {
        values.put(NoteColumns.NOTE, "");
    }

    SQLiteDatabase db = mOpenHelper.getWritableDatabase();
    long rowId = db.insert(NOTES_TABLE_NAME, NoteColumns.NOTE, values);
    if (rowId > 0) {
        Uri noteUri = ContentUris.withAppendedId(NoteColumns.CONTENT_URI, rowId);
        getContext().getContentResolver().notifyChange(noteUri, null);
        return noteUri;
    }

    throw new SQLException("Failed to insert row into " + uri);
}