안드로이드 개발 질문/답변
(글 수 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을 동적으로 가져오려면 어떻게 해야할까요?



