안드로이드 개발 질문/답변
(글 수 45,052)
helper = new ccmap_db(this, null, null, 0); import com.skcc.ccmaptest3.*; public ArrayList<String> getCards(){ SQLiteDatabase db = helper.getReadableDatabase(); Cursor cursor = db.rawQuery("select * from store_info where store_no=7", null); Cursor cursor1 = db.rawQuery("select * from card_info where card_no=7", null); Cursor cursor2 = db.rawQuery("select * from benefit_1 where pk_no in (select distinct(pk_no.PK_NO) from store_info,pk_no where " + " pk_no.PK_NO in(select pk_no.PK_NO from store_info,pk_no where store_info.store_no=pk_no.store_no" + " and pk_no.card_no=14 and pk_no.store_no=7))", null); ArrayList<String> list = new ArrayList<String>(); while (cursor.moveToNext()){ list.add(cursor.getString(1)); } while (cursor1.moveToNext()){ list.add(cursor1.getString(1)); } while (cursor2.moveToNext()){ list.add(cursor2.getString(1)); } return list; }
위에서
가게,카드 정보가 담긴 DB에서 Data을 동적으로 가져오려면 어떻게 해야할까요?