四、对笔记进行增删查改CRUD.javapackage com.example.biji_1;
import android.annotation.SuppressLint; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper;
import java.util.ArrayList; import java.util.List;
public class CRUD { SQLiteOpenHelper dbHandler; SQLiteDatabase db;
private static final String[] columns = {
NoteDatabase.ID,
NoteDatabase.CONTENT,
NoteDatabase.TIME,
NoteDatabase.MODE
};
public CRUD(Context context){
dbHandler = new NoteDatabase(context);
}
public void open(){
db = dbHandler.getWritableDatabase();
}
public void close(){
dbHandler.close();
}
五、演示效果5.1 登录界面哈哈界面随自己走各位别喷5.2笔记界面之前自己写的5.3 增加记录5.4删除记录在主界面那个删除是删除全部会提示你然后你点击进去之后还有一个删除那条记录的删除键这里就不做演示了5.5 查找记录哈哈 ##5.6 改记录 改之前 改之后可以看到时间变化