Android 记事本NotePad

原创于 2024-04-29 03:26:23 发布 · 266 阅读

5 ·

CC 4.0 BY-SA版权

文章标签：

#android #notepad++ #java

程序员专栏收录该内容

464 篇文章

订阅专栏

这篇文章详细描述了在Android应用中使用SQLite数据库进行便签操作的方法，包括添加新便签、获取单个便签、更新和删除便签。内容涉及onUpgrade方法升级数据库版本，以及在NoteNew活动中对数据库的CRUD操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

}

@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

// Drop older table if existed

db.execSQL("DROP TABLE IF EXISTS " + NOTE_TABLE_NAME);

// Create tables again

onCreate(db);

}

// Add new note

public int addNote(Note note) {

SQLiteDatabase db = this.getWritableDatabase();

ContentValues values = new ContentValues();

values.put(NOTE_COL_TITLE, note.getTitle());

values.put(NOTE_COL_CONTENT, note.getContent());

values.put(NOTE_COL_CREATED, note.getCreated());

values.put(NOTE_COL_MODIFIED, note.getModified());

// Insert to database

long rowId = db.insert(NOTE_TABLE_NAME, null, values);

// Close the database

db.close();

return (int) rowId;

}

// Get one note

public Note getNote(int id) {

SQLiteDatabase db = this.getReadableDatabase();

Cursor cursor = db.query(NOTE_TABLE_NAME, NOTE_COL_PROJECTION,

NOTE_COL_ID + “=?”, new String[] { String.valueOf(id) }, null,

null, null, null);

if (cursor != null)

cursor.moveToFirst();

Note note = new Note(cursor.getInt(0), cursor.getString(1),

cursor.getString(2), cursor.getLong(3), cursor.getLong(4));

return note;

}

// Get all notes

public List getAllNotes() {

List noteList = new ArrayList();

String selectQuery = "SELECT * FROM " + NOTE_TABLE_NAME;

SQLiteDatabase db = this.getWritableDatabase();

Cursor cursor = db.rawQuery(selectQuery, null);

// looping through all rows and adding to list

if (cursor.moveToFirst()) {

do {

Note note = new Note(cursor.getInt(0), cursor.getString(1),

cursor.getString(2), cursor.getLong(3),

cursor.getLong(4));

noteList.add(note);

} while (cursor.moveToNext());

}

// return contact list

return noteList;

}

public Cursor getAllNotesCursor() {

String selectQuery = "SELECT * FROM " + NOTE_TABLE_NAME;

SQLiteDatabase db = this.getReadableDatabase();

Cursor cursor = db.rawQuery(selectQuery, null);

return cursor;

}

public int updateNote(Note note) {

SQLiteDatabase db = this.getWritableDatabase();

ContentValues values = new ContentValues();

values.put(NOTE_COL_TITLE, note.getTitle());

values.put(NOTE_COL_CONTENT, note.getContent());

values.put(NOTE_COL_CREATED, note.getCreated());

values.put(NOTE_COL_MODIFIED, note.getModified());

return db.update(NOTE_TABLE_NAME, values,

NOTE_COL_ID + “=?”, new String[] { String.valueOf(note.getId()) });

}

public void deleteNote(int noteId) {

SQLiteDatabase db = this.getWritableDatabase();

db.delete(NOTE_TABLE_NAME, NOTE_COL_ID + “=?”,new String[] { String.valueOf(noteId) } );

db.close();

}

public void deleteAllNotes() {

SQLiteDatabase db = this.getWritableDatabase();

db.delete(NOTE_TABLE_NAME, null, null);

db.close();

}

新建和修改便签：

package com.zms.notepad;

import android.app.Activity;

import android.content.Intent;

import android.os.Bundle;

import android.view.Menu;

import android.view.MenuItem;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.widget.Toast;

/**

Created by AlexZhou on 2015/2/3.
11:14

public class NoteNew extends Activity {

private EditText etTitle; //便签标题

private EditText etContent; //便签内容

private Button btnCancel;

private Button btnSave;

private int _noteId; //便签ID

private NoteDbHelper _db;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.note_new);

etTitle = (EditText) findViewById(R.id.etTitle);

etContent = (EditText) findViewById(R.id.etContent);

btnCancel = (Button) findViewById(R.id.btnCancel);

btnSave = (Button) findViewById(R.id.btnSave);

btnCancel.setOnClickListener(new OnClickListenerImp());

btnSave.setOnClickListener(new OnClickListenerImp());

_db = new NoteDbHelper(this);

Intent intent = getIntent();

_noteId = intent.getIntExtra(NoteList.EXTRA_NOTE_ID, -1);

if (_noteId > 0) {

Note note = _db.getNote(_noteId);

etTitle.setText(note.getTitle());

etContent.setText(note.getContent());

}

private class OnClickListenerImp implements View.OnClickListener {

@Override

public void onClick(View v) {

if (v == btnCancel) {

Toast.makeText(NoteNew.this, “天启提示：放弃新建便签”, Toast.LENGTH_SHORT).show();

finish();

} else if (v == btnSave) {

String titleVoid = etTitle.getText().toString();

String contentVoid = etContent.getText().toString();

if (titleVoid.equals(“”) || contentVoid.equals(“”)) {

Toast.makeText(NoteNew.this, “天启提示：标题或内容为空”, Toast.LENGTH_SHORT).show();

} else {

ToDatabase(); //插入数据库

Toast.makeText(NoteNew.this, “天启提示：便签保存成功”, Toast.LENGTH_SHORT).show();

finish();

}

@Override

public boolean onCreateOptionsMenu(Menu menu) {

getMenuInflater().inflate(R.menu.note_new_menu, menu);

return true;

}

@Override

public boolean onOptionsItemSelected(MenuItem item) {

int id = item.getItemId();

if (id == R.id.action_exit) {

Intent intent = new Intent(Intent.ACTION_MAIN);

intent.addCategory(Intent.CATEGORY_HOME);

intent.setFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);

startActivity(intent);

android.os.Process.killProcess(android.os.Process.myPid());

return true;

} else if (id == R.id.action_about) {

Intent intent = new Intent(this, About.class);

startActivity(intent);

return true;

}

return super.onOptionsItemSelected(item);

}

public final int ToDatabase() {

String title = etTitle.getText().toString();

String content = etContent.getText().toString();

int newNoteId = -1;

if (_noteId > 0) {

Note note = _db.getNote(_noteId);

note.setTitle(title);

note.setContent(content);

note.setModified(Long.valueOf(System.currentTimeMillis()));

_db.updateNote(note);

} else {

Note newNote = new Note(title, content);

newNoteId = _db.addNote(newNote);

架构师筑基包括哪些内容

我花了将近半个月时间将：深入 Java 泛型.、注解深入浅出、并发编程.、数据传输与序列化、Java 虚拟机原理、反射与类加载、高效 IO、Kotlin项目实战等等Android架构师筑基必备技能整合成了一套系统知识笔记PDF，相信看完这份文档，你将会对这些Android架构师筑基必备技能有着更深入、更系统的理解。