ä¸éè¦ï¼å¦æsqliteæ¥è¯¢å¾èæ¶çè¯å¯ä»¥ä½¿ç¨threadå¼æ¥æ¥è¯¢ã
SQLiteæ¯è½»é级åµå ¥å¼æ°æ®åºå¼æï¼å®æ¯æ SQL è¯è¨ï¼å¹¶ä¸åªå©ç¨å¾å°çå åå°±æå¾å¥½çæ§è½ãæ¤å¤å®è¿æ¯å¼æºçï¼ä»»ä½äººé½å¯ä»¥ä½¿ç¨å®ã许å¤å¼æºé¡¹ç®ï¼(Mozilla, PHP, Pythonï¼é½ä½¿ç¨äº SQLiteSQLite ç±ä»¥ä¸å 个ç»ä»¶ç»æï¼SQL ç¼è¯å¨ãå æ ¸ãå端以åé件ãSQLite éè¿å©ç¨èææºåèææ°æ®åºå¼æï¼VDBEï¼ï¼ä½¿è°è¯ãä¿®æ¹åæ©å± SQLite çå æ ¸åå¾æ´å æ¹ä¾¿ã
Android éæäº SQLite æ°æ®åº Android å¨è¿è¡æ¶ï¼run-timeï¼éæäº SQLiteï¼æ以æ¯ä¸ª Android åºç¨ç¨åºé½å¯ä»¥ä½¿ç¨ SQLite æ°æ®åºã
æ°æ®åºåå¨å¨ data/< 项ç®æ件夹 >/databases/ ä¸ã Android å¼åä¸ä½¿ç¨ SQLite æ°æ®åº Activites å¯ä»¥éè¿ Content Provider æè Service 访é®ä¸ä¸ªæ°æ®åºã
Android æä¾äº SQLiteOpenHelper å建ä¸ä¸ªæ°æ®åºï¼åªè¦ç»§æ¿ SQLiteOpenHelper ç±»ï¼å°±å¯ä»¥è½»æ¾çå建æ°æ®åºãSQLiteOpenHelper ç±»æ ¹æ®å¼ååºç¨ç¨åºçéè¦ï¼å°è£ äºå建åæ´æ°æ°æ®åºä½¿ç¨çé»è¾ã
SQLiteOpenHelper çåç±»ï¼è³å°éè¦å®ç°ä¸ä¸ªæ¹æ³ï¼
1 æé å½æ°ï¼è°ç¨ç¶ç±» SQLiteOpenHelper çæé å½æ°ãè¿ä¸ªæ¹æ³éè¦å个åæ°ï¼ä¸ä¸æç¯å¢ï¼ä¾å¦ï¼ä¸ä¸ª Activityï¼ï¼æ°æ®åºååï¼ä¸ä¸ªå¯éç游æ å·¥åï¼éå¸¸æ¯ Nullï¼ï¼ä¸ä¸ªä»£è¡¨ä½ æ£å¨ä½¿ç¨çæ°æ®åºæ¨¡åçæ¬çæ´æ°ã
2 onCreateï¼ï¼æ¹æ³ï¼å®éè¦ä¸ä¸ª SQLiteDatabase 对象ä½ä¸ºåæ°ï¼æ ¹æ®éè¦å¯¹è¿ä¸ªå¯¹è±¡å¡«å
表ååå§åæ°æ®ã
3 onUpgrage() æ¹æ³ï¼å®éè¦ä¸ä¸ªåæ°ï¼ä¸ä¸ª SQLiteDatabase 对象ï¼ä¸ä¸ªæ§ççæ¬å·åä¸ä¸ªæ°ççæ¬å·ï¼è¿æ ·å°±å¯ä»¥æ¸
æ¥å¦ä½æä¸ä¸ªæ°æ®åºä»æ§ç模å转åå°æ°ç模åã