static int callback(void *p, int argc, char **argv, char **azColName)
{
int i = 0;
[(NSMutableArray*)p addObject:[NSString stringWithUTF8String:argv[i] ? argv[i] : "NULL"]];
return 0;
}
void sqlite3_superquery(NSString* filename, NSString* sql, NSMutableArray* array)
{
sqlite3 *db;
char* error = 0;
int rc;
rc = sqlite3_open(filename.UTF8String, &db);
if (rc)
NSLog(@"ERROR: cannot open database");
else
{
rc = sqlite3_exec(db, sql.UTF8String, callback, array, &error);
if (rc != SQLITE_OK)
{
NSLog(@"ERROR: sql error");
printf("ERROR: %s", error);
sqlite3_free(error);
}
}
sqlite3_close(db);
}
iphone中使用SQLITE3数据库
最新推荐文章于 2022-10-12 23:16:56 发布