Android¤Ë¤Ï¡¢SQLite¤È¤¤¤¦¥Ç¡¼¥¿¥Ù¡¼¥¹´ÉÍý¥·¥¹¥Æ¥à(Database Management System)¤¬É¸½à¤ÇÅëºÜ¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
SQLite¤ò»È¤¨¤Ð¡¢ÂçÎ̥ǡ¼¥¿¤ÎÊݸ¤ä¸¡º÷¤¬´Êñ¤Ë¹Ô¤¨¤Þ¤¹¡£
¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÊݸÀè¤Ï¡¢¼¡¤Î¥Ç¥£¥ì¥¯¥È¥ê¤Ç¤¹¡£
SQLite¤ò»È¤¨¤Ð¡¢ÂçÎ̥ǡ¼¥¿¤ÎÊݸ¤ä¸¡º÷¤¬´Êñ¤Ë¹Ô¤¨¤Þ¤¹¡£
¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÊݸÀè¤Ï¡¢¼¡¤Î¥Ç¥£¥ì¥¯¥È¥ê¤Ç¤¹¡£
/data/data/<¥Ñ¥Ã¥±¡¼¥¸Ì¾>/databases/¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾
SQLite¤ò¥¢¥×¥ê¥±¡¼¥·¥ç¥óÆâ¤Ç»ÈÍѤ¹¤ë¤¿¤á¤Ë¤Ï¡¢¡Ö¥Ç¡¼¥¿¥Ù¡¼¥¹¥Ø¥ë¥Ñ¡¼¡×(Databasehelper) ¤òºî¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£
class DatabaseHelper extends SQLiteOpenHelper { public static final String DB_NAME = "hoge.db"; public static final int DB_VERSION = 1; public DatabaseHelper(Context context) { super(context, DB_NAME, null, DB_VERSION); } @Override public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE foo (id INTEGER PRIMARY KEY AUTOINCREMENT, content TEXT)"); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL("DROP TABLE IF EXISTS hoge"); onCreate(db); } }
¥Õ¥¡¥¤¥ë̾¤ä¥Ð¡¼¥¸¥ç¥óÈÖ¹æ¤Ê¤É¤ò°ú¿ô¤Ë¤·¤Æ¡¢ SQLiteOpenHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) ¤È¤¤¤¦¥¹¡¼¥Ñ¡¼¥¯¥é¥¹¤Î¥³¥ó¥¹¥È¥é¥¯¥¿¤ò¸Æ¤Ó½Ð¤¹¤è¤¦¤ËÄêµÁ¤·¤Þ¤¹ ¡Ê3 ¸ÄÌܤΰú¿ô¤Ïnull¤Ç¤«¤Þ¤¤¤Þ¤»¤ó¡Ë¡£
¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬ºÇ½é¤ËÀ¸À®¤µ¤ì¤ë¤È¤¤Ë¸Æ¤Ó½Ð¤µ¤ì¤ë¥á¥½¥Ã¥É¤Ç¤¹¡£ ¤³¤Î¥á¥½¥Ã¥É¤Ï¡¢Ä̾¥Æ¡¼¥Ö¥ëÀ¸À®¤ò¹Ô¤¦SQL¤ò¼Â¹Ô¤·¤Þ¤¹¡£
¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥¢¥Ã¥×¥°¥ì¡¼¥É¤¬É¬Íפˤʤ俤Ȥ¤Ë¸Æ¤Ó½Ð¤µ¤ì¤ë¥á¥½¥Ã¥É¤Ç¤¹¡£
¥Ç¡¼¥¿¥Ù¡¼¥¹¥Ø¥ë¥Ñ¡¼¤òÀ¸À®¤·¡ÊDatabaseHelper helper = new DatabaseHelper(context);¡Ë ÍÑÅӤ˱þ¤¸¤Æ¡¢¼¡¤Î¤¤¤Å¤ì¤«¤Î¥á¥½¥Ã¥É¤ò»È¤Ã¤Æ¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¥ª¥Ö¥¸¥§¥¯¥È¤ò¼èÆÀ¤·¤Þ¤¹¡£
Cursor c = db.query( "capitals", new String[] { "capital" }, "prefecture=?", new String[] { "Åìµþ" }, null, null, null); c.moveToFirst(); String capital = c.getString(0);
- ¥Ñ¥é¥á¡¼¥¿¤Ë¤Ä¤¤¤Æ
- ¸¡º÷ÂоݤΥơ¼¥Ö¥ë̾
- ¼èÆÀ¤¹¤ëÃͤΥꥹ¥È
- WHERE¶ç¡Ê¥×¥ì¡¼¥¹¥Û¥ë¥À¡¼¤Ç¤Î»ØÄê²Äǽ¡Ë
- ¥×¥ì¡¼¥¹¥Û¥ë¥À¡¼¤òÃÖ´¹¤¹¤ëÃͤΥꥹ¥È
- GROUP BY¶ç
- ORDER BY¶ç
- HAVING¶ç
- ¥«¥Æ¥´¥ê¡§
- ¥¤¥ó¥¿¡¼¥Í¥Ã¥È
- Áí¹ç
¤³¤Î¥Ú¡¼¥¸¤Ø¤Î¥³¥á¥ó¥È
WnRhYO A big thank you for your blog post. Really Great.
SQLite - Android���ץ곫ȯ�ֺ� - Seesaa Wiki�ʥ������� for ���ޡ��ȥե��� モンクレール ダウン 一覧 http://www.pslcbi.com/moncler2014.html
SQLite - Android���ץ곫ȯ�ֺ� - Seesaa Wiki�ʥ������� for ���ޡ��ȥե��� モンクレール ダウン アウトレット http://www.pslcbi.com/moncler2014.html
ShcLqB <a href="http://yeqmfbtvxkji.com/">yeqmfbtvxkji</a>, [url=http://hgfhinruqxgu.com/]hgfhinruqxgu[/url], [link=http://alilmqdyfbxk.com/]alilmqdyfbxk[/link], http://fggzfjrtrsrx.com/
SLwPsA <a href="http://burmyvwanhhl.com/">burmyvwanhhl</a>, [url=http://xujfwbompvip.com/]xujfwbompvip[/url], [link=http://sbnzjctvjuiy.com/]sbnzjctvjuiy[/link], http://blvdwnpqnduo.com/
http://wthqnezmyivj.com/