ExamApp总结（四）将数据从数据库中进行存取

CrimeLab.java

private static ContentValues getContentValues(Crime crime){
        ContentValues values=new ContentValues();
        values.put(CrimeTable.Cols.UUID,crime.getmID().toString());
        values.put(CrimeTable.Cols.TITLE,crime.getmTitle());
        values.put(CrimeTable.Cols.DATE,crime.getDate().getTime());
        values.put(CrimeTable.Cols.SOLVED,crime.getmSolved()?1:0);
        values.put(CrimeTable.Cols.SUSPECT,crime.getmSuspect());
        return values;
    }

这个方法负责数据库的写入和更新。

更新信息

public void updateCrime(Crime crime){
        String uuidString=crime.getmID().toString();
        ContentValues values=getContentValues(crime);
        mDatebase.update(CrimeTable.NAME,values,CrimeTable.Cols.UUID+"=?",new String[]{uuidString});
    }

查询信息

private CrimeCursorWrapper queryCrimes(String whereClause,String[] whereArgs){
        Cursor cursor=mDatebase.query(
                CrimeTable.NAME,
                null,
                whereClause,
                whereArgs,
                null,
                null,
                null

        );
        return new CrimeCursorWrapper(cursor);
    }