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

공중망을 이용한 애완동물 사료 공급기

db.execSQL("insert into park_state (locate,state,id) values
(\"L1\",0,\"void\");");
db.execSQL("insert into park_state (locate,state,id) values
(\"L2\",0,\"void\");");

db.execSQL("insert into park_state (locate,state,id) values
(\"L3\",0,\"void\");");
db.execSQL("insert into park_state (locate,state,id) values
(\"R1\",0,\"void\");");

db.execSQL("insert into park_state (locate,state,id) values
(\"R2\",0,\"void\");");
db.execSQL("insert into park_state (locate,state,id) values
(\"R3\",0,\"void\");");

}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
Log.w("dbUpgrade", "Upgrading database from version " + oldVersion + " to " +
newVersion
+ ", which will destroy all old data");
db.execSQL("DROP TABLE IF EXISTS park_state");

db.execSQL("DROP TABLE IF EXISTS park_log");
onCreate(db);
}

public void insertLogDb(String locate,int state,String _id,int money){
try {
SQLiteDatabase mDb = getWritableDatabase();

ContentValues values = new ContentValues();
// 키,값의 쌍으로 데이터 입력
values.put("locate", locate);
values.put("state", state);

values.put("id", _id);
values.put("money",money);
long result = mDb.insert(DATABASE_TA_LOG, null, values);
Log.e("insert 성공", money + "번째 성공");
}catch(SQLException e){

e.printStackTrace();
}

인천전자마이스터고등학교
- 826 -