Posted By

iswear_wxp on 04/01/10

Tagged

Versions (?)

Last Edited at 04/01/10 04:59am

Statistics

Viewed 245 times

Favorited by 0 user(s)

iPhoneä¸çš„SQLiteåº”ç”¨

/ Published in: iPhone

Highlighted TextExpand

SQLiteæ˜¯åŸºäºŽCçš„APIï¼Œåœ¨iPhoneä¸çš„è¿è¡Œé€Ÿåº¦è¶…çº§å¿«ï¼ˆåœ¨è‹¹æžœç½‘ç«™ä¸Šä¹Ÿæœ‰ä¸€ä¸ªå¯¹æ¯”ï¼Œç¡®å®žåº”è¯¥æ˜¯é€Ÿåº¦æœ€å¿«çš„ï¼‰ã€‚

ç”±äºŽåœ¨iPhone3.0ä¸Šå·²ç»æ”¯æŒäº†Core Dataï¼Œæ˜¯è‹¹æžœä¸€ä¸ªæ–°çš„APIï¼Œå¹¶ä¸”æ˜¯åŸºäºŽSQliteçš„ã€‚é€Ÿåº¦ä¹Ÿæ˜¯éžå¸¸å¿«å§ï¼Œä¿¡ä¸ä¿¡ç”±ä½ ã€‚æ‰€ä»¥æˆ‘ä»¬å¯¹SQLiteä»…éœ€è¦æ‡‚ä¸€äº›å³å¯ï¼Œä»¥ä¸‹æ˜¯ä¸€äº›åŸºç¡€ä¿¡æ¯

æ‰“å¼€æ•°æ®åº“

sqlite3 *database = NULL; //å»ºç«‹ä¸€ä¸ªsqliteæ•°æ®åº“å˜é‡
 
int sqlite3_open(const char *æ–‡ä»¶å, sqlite3 **db); //é‚£ä¸ªæ–‡ä»¶åéœ€è¦æ˜¯cStringï¼Œ
                                                   //ä¹‹åŽé‚£ä¸ªdbå¯¹è±¡ä½¿ç”¨æˆ‘ä»¬å»ºç«‹çš„databaseå˜é‡
 
//ä»¥ä¸‹æ˜¯ä¸€ä¸ªå¼€æ‰“çš„ä¾‹åï¼š
NSString *fileAddress = [[NSBundle mainBundle] pathForResource:@"é¢„å˜æ–‡ä»¶çš„æ–‡ä»¶å" ofType:@"db"]; //dbæ˜¯æ‰©å±•å
 
if(sqlite3_open([fileAddress UTF8String], &amp;database) == SQLITE_OK) //UTF8Stringæ–¹æ³•è½¬æ¢NSStringä¸ºcString

æ‰§è¡Œä¸€ä¸ªSQLiteè¯å¥ï¼š

int sqlite3_exec(sqlite3 *db, const char *sql, int (*callback)(void*,int,char**,char**), void *context, char **error);

å…³é—ä¸€ä¸ªæ•°æ®åº“ï¼š

int sqlite3_close(sqlite3 *db); //è¿™ä¸ªä¸ç”¨è§£é‡Šäº†å§

ä¸€ä¸ªå“åº”å‡½æ•°çš„æ ¼å¼ï¼š

int callback(void *context, int count, char **values, char **columns);
 
å¤šäº†æš‚æ—¶å°±ä¸æ‰“äº†ï¼Œè¯•è¯•CoreDataå§ï¼Œå¾ˆé…·çš„ã€‚AppleçœŸçš„ä¼šæŠŠäººæƒ¯åçš„

URL: http://c.gzl.name/archives/195

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.