DBhelper

vinegarstar

于 2022-05-30 22:31:09 发布

阅读量708

点赞数 1

文章标签：数据库 linq c#

本文链接：https://blog.csdn.net/qq_57395890/article/details/125055419

版权

SQLite 数据库 ContentValues Cursor 增删改查

关键词由CSDN通过智能技术生成

public class DBhelper {//增删改查
    SQLiteOpenHelper dbHandler;
    SQLiteDatabase db;
    private static final String[] colums={
            NoteDatabase.ID,
            NoteDatabase.CONTENT,
            NoteDatabase.TIME,
            NoteDatabase.MODE
    };
    public DBhelper(Context context){
        dbHandler=new NoteDatabase(context);
    }
    public void open(){
        db=dbHandler.getWritableDatabase();
    }
    public void close(){
        dbHandler.close();
    }
    public Note addNote(Note note){//把Note加入到Database——插入
        ContentValues contentValues=new ContentValues();
        contentValues.put(NoteDatabase.CONTENT,note.getContent());
        contentValues.put(NoteDatabase.TIME,note.getTime());
        contentValues.put(NoteDatabase.MODE,note.getTag());
        long insertID=db.insert(NoteDatabase.TABLE_NAME,null,contentValues);
        note.setId(insertID);
        return note;
    }

    public Note getNote(long id){//获取一条笔记
        Cursor cursor=db.query(NoteDatabase.TABLE_NAME,colums,NoteDatabase.ID+"=?",
                new String[]{String.valueOf(id)},null,null,null,null);
        if (cursor!=null){
            cursor.moveToFirst();
        }
        Note e=new Note(cursor.getString(1),cursor.getString(2),cursor.getInt(3));
        return e;
    }
    public List<Note> getAllNotes(){
        Cursor cursor=db.query(NoteDatabase.TABLE_NAME,colums,null,null,null,null,null);
        List<Note> notes=new ArrayList<>();
        if (cursor.getCount()>0){
            while (cursor.moveToNext()){
                Note note=new Note();
                note.setId(cursor.getLong(cursor.getColumnIndex(NoteDatabase.ID)));
                note.setContent(cursor.getString(cursor.getColumnIndex(NoteDatabase.CONTENT)));
                note.setTime(cursor.getString(cursor.getColumnIndex(NoteDatabase.TIME)));
                note.setTag(cursor.getInt(cursor.getColumnIndex(NoteDatabase.MODE)));
                notes.add(note);
            }
        }
        return notes;
    }
    public int updateNote(Note note){
        ContentValues values=new ContentValues();
        values.put(NoteDatabase.CONTENT,note.getContent());
        values.put(NoteDatabase.TIME,note.getTime());
        values.put(NoteDatabase.MODE,note.getTag());
        return db.update(NoteDatabase.TABLE_NAME,values,NoteDatabase.ID+"=?",new String[]{String.valueOf(note.getId())});
    }
    public void removeNote(Note note){
        db.delete(NoteDatabase.TABLE_NAME,NoteDatabase.ID+"="+note.getId(),null);
    }

}