Á¦°¡ ÀüȹøÈ£¸¦ ÀÔ·Â¹Þ¾Æ db¿¡ insert¸¦ ÇÏ°í Á¶È¸ ¹öÆ°À» ´©¸£¸é select ¹®À¸·Î °ªÀ» °¡Á®¿Í¼ Textview¿¡ »Ñ·ÁÁÖ´Â°É ±¸ÇöÇߴµ¥¿ä.
°¢°¢ ¹öÆ°À¸·Î insert, delete, select ±¸ÇöÇؼ case ¹®À¸·Î ÀÏ´Ü ±¸ÇöÀ» ÇسõÀº »óÅÂÀε¥..
¿©±â¿¡ Ãß°¡·Î ´Ù¸¥ Ŭ·¡½º¿¡¼ db °ªÀ» ÀÐ¾î¼ ¹®ÀÚ¿ ¹è¿¿¡ ÀúÀå ÇÒ·Á°í ÇÕ´Ï´Ù..ÀÏ´Ü ÄÚµå ÀÛ¼ºÀº Çغôµ¥ Àß ¾ÈµÇ³×¿ä¤Ì
¾îµð°¡ Ʋ·È´ÂÁö Ʋ¸° ºÎºÐ Âó¾îÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù¤Ì¤Ì
<< µ¥ÀÌÅÍ º£À̽º°¡ Àִ Ŭ·¡½º >>
public String[] select_db(SQLiteDatabase get_db, String sql) {
String[] data={};
int i = 0;
get_db = dbHelper.getReadableDatabase();
sql = "SELECT * FROM person;";
Cursor cursor = get_db.rawQuery(sql, null);
if (cursor.getCount() > 0) {
while (cursor.moveToNext()) {
data[i] = cursor.getString(1);
i++;
}
cursor.close();
}
return data;
}
<<<<< È£Ãâ ÇÒ Å¬·¡½º >>>>>>>>
SQLiteDatabase get_db = null;
String sql = "SELECT * FROM person;";
String[] data = {};
Addr_Add Get_Db = new Addr_Add();
data = Get_Db.select_db(get_db, sql); | |
|