Page 834 - 완) I MDP 프로젝트 작품 보고서(전체과 1학년)1.6

Ⅳ. CodeVision Source Code

}

public ParkStation getCurrent(){
SQLiteDatabase db = getReadableDatabase();

Cursor c = db.rawQuery("SELECT * FROM park_state order by num desc",null);

c.moveToNext();

return new ParkStation(c.getInt(0),c.getString(1),c.getInt(2),c.getString(3));

}

public void resetStatus(){

SQLiteDatabase mDb = getWritableDatabase();
ContentValues values = new ContentValues();
values.put("state", 0); // 바꿀값
values.put("id", "void"); // 바꿀값

int result = mDb.update(DATABASE_TABLE,values,"num>0",null);
}

public void deleteLogDb(long num){
SQLiteDatabase mDb = getWritableDatabase();
int result = mDb.delete(DATABASE_TA_LOG,"num>"+num,null);
mDb.execSQL("UPDATE SQLITE_SEQUENCE SET seq = 0 WHERE name =
'park_log'");
}

public Cursor selectStateDb(){

SQLiteDatabase mDb = getReadableDatabase();
return mDb.query(DATABASE_TABLE, null, null, null, null, null, null);
}

public ArrayList<ParkStation> selectLogDb(){
ArrayList<ParkStation> vector = new ArrayList<ParkStation>();
SQLiteDatabase db = getReadableDatabase();

Cursor c = db.rawQuery("SELECT * FROM park_log order by num desc",null);

정보통신기기과
- 827 -