ºÇ½ª¹¹¿·¡§
t_yokky2002 2011ǯ12·î08Æü(ÌÚ) 15:58:03ÍúÎò
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¶ç
¥³¥á¥ó¥È¤ò¤«¤¯