分类导航

HTML5 发布时间：2022-04-27 发布网站：大佬教程 code.js-code.com

大佬教程收集整理的这篇文章主要介绍了ios – i386的未定义符号：“_sqlite3_open”,引用来自：error，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

我已经创建了一个数据库类并打包了一些方法.但是,一旦建立项目…

Undefined symbols for architecture i386:
"_sqlite3_open",referenced from:
  -[MyDataBase openOrCreateDatabase:] in MyDataBase.o
"_sqlite3_exec",referenced from:
  -[MyDataBase createTable:] in MyDataBase.o
  -[MyDataBase InsertTable:] in MyDataBase.o
  -[MyDataBase updataTable:] in MyDataBase.o
  -[MyDataBase querryTableByCallBACk:] in MyDataBase.o
"_sqlite3_close",referenced from:
  -[MyDataBase closeDatabase] in MyDataBase.o
"_sqlite3_get_table",referenced from:
  -[MyDataBase querryTable:] in MyDataBase.o
ld: symbol(s) not found for architecture i386
clang: error: linker command Failed with exit code 1 (use -v to see invocation)

这里有一些关键的方法：@H_262_5@

创建数据库：@H_262_5@

-(BOOL)openOrCreateDatabase:(NSString*)dbName 
{ 
self.m_dbname = dbName; 
NSArray *path =NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask,YES); 
NSString *documentsDirectory = [path objectATindex:0]; 
if(sqlite3_open([[documentsDirectory StringByAppendingPathComponent:dbName]   UTF8String],&m_sql) !=sqlITE_OK) 
{ 
NSLog(@"创建数据库失败"); 
return NO; 
} 
return YES; 
}

创建表：@H_262_5@

-(BOOL)createTable:(NSString*)sqlCreateTable  
{  
if (![self openOrCreateDatabase:self.m_dbName]) {  
    return NO;  
}  
char *errorMsg;  
if (sqlite3_exec (self.m_sql,[sqlCreateTable UTF8String],NULL,&errorMsg) != 
sqlITE_OK)  
{  
    NSLog(@"创建数据表失败:%s",errorMsg);  
    return NO;  
}  
[self closeDatabase];  
return YES;  
}

关闭数据库：@H_262_5@

-(void)closeDatabase  
{  
sqlite3_close(self.m_sql);   
}  

//insert  

-(BOOL)InsertTable:(NSString*)sqlInsert  
{  
if (![self openOrCreateDatabase:self.m_dbName]) {  
    return NO;  
}  
char* errorMsg = NULL;  
if(sqlite3_exec(self.m_sql,[sqlInsert UTF8String],&errorMsg) ==sqlITE_OK)  
{  [self closeDatabase];  
    return YES;}  
else {  
    printf("更新表失败:%s",errorMsg);  
    [self closeDatabase];  
    return NO;  
}  
return YES;  
}

更新表：@H_262_5@

-(BOOL)updataTable:(NSString*)sqlupdata{  
if (![self openOrCreateDatabase:self.m_dbName]) {  
    return NO;  
}  
char *errorMsg;  
if (sqlite3_exec (self.m_sql,[sqlupdata UTF8String],&errorMsg) !=sqlITE_OK)  
{  
    [self closeDatabase];  
    return YES;  
}else {  
    return NO;  
}  

return YES;  
}

选择记录：@H_262_5@

-(NSArray*)querryTable:(NSString*)sqlQuerry  
{  
if (![self openOrCreateDatabase:self.m_dbName]) {  
    return nil;  
}  
int row = 0;  
int column = 0;  
char*    errorMsg = NULL;  
char**    dbResult = NULL;  
NSMutableArray*    array = [[NSMutableArray alloc] init];  
if(sqlite3_get_table(m_sql,[sqlQuerry UTF8String],&dbResult,&row,&column,&errorMsg )   == sqlITE_OK)  
{  
    if (0 == row) {  
        [self closeDatabase];  
        return nil;  
    }  
    int index = column;  
    for(int i =0; i < row ; i++ ) {    
        NSMutableDictionary*    Dic = [[NSMutableDictionary alloc] init];  
        for(int j =0 ; j < column; j++ ) {  
            if (dbresult[index]) {  
                NSString*    value = [[NSString alloc]   initWithUTF8String:dbresult[index]];  
                NSString*    key = [[NSString alloc] initWithUTF8String:dbresult[j]];  
                [Dic setObject:value forKey:key];  
                [value release];  
                [key release];  
            }  
            index ++;  
        }   
        [array addObject:Dic];  
        [Dic release];  
    }  
   }else {  
    printf("%s",errorMsg);  
    [self closeDatabase];  
    return nil;  
   }  
   [self closeDatabase];  
   return [array autorelease];  
}