公布一个IOS上线程安全的sqlite库

我也是在网络上找的，自己加了锁，支持线程安全

.h文件

#import <Foundation/Foundation.h>
#import "sqlite3.h"
@interface DatabaseOperation : NSObject {
    sqlite3 *m_sql;
    NSString *m_dbName;
    NSLock*  m_lcok;
}
@property(nonatomic)sqlite3*            m_sql;
@property(nonatomic,retain)NSString*    m_dbName;

-(id)initWithDbName:(NSString*)dbname;
-(BOOL)openOrCreateDatabase:(NSString*)DbName;
-(BOOL)createTable:(NSString*)sqlCreateTable;
-(void)closeDatabase;
-(BOOL)InsertTable:(NSString*)sqlInsert;
-(BOOL)UpdataTable:(NSString*)sqlUpdata;
-(BOOL)DeldeteTable:(NSString*)sqlDelete;
-(NSArray*)querryTable:(NSString*)sqlQuerry;
-(NSArray*)querryTableByCallBack:(NSString*)sqlQuerry;
@end

 

.m文件

#import "DatabaseOperation.h"

struct lockhelp
{
    lockhelp(NSLock* p):lock_((NSLock*)p)   {[lock_ lock];}
    ~lockhelp()                             {[lock_ unlock];}
private:
    NSLock* lock_;
};

@implementation DatabaseOperation
@synthesize m_sql;
@synthesize m_dbName;
- (id) initWithDbName:(NSString*)dbname
{
    self = [super init];
    if (self != nil) {
        
        m_lcok = [[NSLock alloc] init];
        
        if ([self openOrCreateDatabase:dbname]) {
            [self closeDatabase];
        }
        
    }
    return self;
}
- (id) init
{
    NSAssert(0,@"Never Use this.Please Call Use initWithDbName:(NSString*)");
    return nil;
}
- (void) dealloc
{
    [m_lcok unlock];
    [m_lcok release];
    
    self.m_sql = nil;
    self.m_dbName =nil;
    [super dealloc];
}
//-------------------创建数据库-------------------------
-(BOOL)openOrCreateDatabase:(NSString*)dbName
{
    lockhelp lock(m_lcok);
    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;
}
//------------------创建表----------------------
-(BOOL)createTable:(NSString*)sqlCreateTable
{
    if (![self openOrCreateDatabase:self.m_dbName]) {
        return NO;
    }
    
    {
        lockhelp lock(m_lcok);
        char *errorMsg;
        if (sqlite3_exec (self.m_sql, [sqlCreateTable UTF8String],NULL,NULL, &errorMsg) != SQLITE_OK)
        {
            NSLog(@"创建数据表失败:%s",errorMsg);
            return NO;
        }
    }
    
    [self closeDatabase];
    return YES;
}
//----------------------关闭数据库-----------------
-(void)closeDatabase
{
    sqlite3_close(self.m_sql); 
}
//------------------insert-------------------
-(BOOL)InsertTable:(NSString*)sqlInsert
{
    if (![self openOrCreateDatabase:self.m_dbName]) {
        return NO;
    }
    
    lockhelp lock(m_lcok);
    
    char* errorMsg = NULL;
    if(sqlite3_exec(self.m_sql, [sqlInsert UTF8String],0,NULL, &errorMsg) ==SQLITE_OK)
    {  [self closeDatabase];
        return YES;}
    else {
        printf("更新表失败:%s",errorMsg);
        [self closeDatabase];
        return NO;
    }   
    return YES;
}
//--------------updata-------------
-(BOOL)UpdataTable:(NSString*)sqlUpdata{
    if (![self openOrCreateDatabase:self.m_dbName]) {
        return NO;
    }
    
    lockhelp lock(m_lcok);
    char *errorMsg;
    if (sqlite3_exec (self.m_sql, [sqlUpdata UTF8String],0,NULL, &errorMsg) !=SQLITE_OK)
    {
        [self closeDatabase];
        return YES;
    }else {
        return NO;
    }
    return YES;
}
//--------------delete--------------
-(BOOL)DeldeteTable:(NSString*)sqlDelete
{
    if (![self openOrCreateDatabase:self.m_dbName]) {
        return NO;
    }
    
    lockhelp lock(m_lcok);
    char *errorMsg;
    if (sqlite3_exec (self.m_sql, [sqlDelete UTF8String],0,NULL, &errorMsg) !=SQLITE_OK)
    {
        [self closeDatabase];
        return YES;
    }else {
        return NO;
    }
    return YES;
}
//--------------select---------------------
-(NSArray*)querryTable:(NSString*)sqlQuerry
{
    if (![self openOrCreateDatabase:self.m_dbName]) {
        return nil;
    }
    
    lockhelp lock(m_lcok);
    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];
}
//----------------------select--------------------
int processData(void* arrayResult,int columnCount,char** columnValue,char** columnName)
{
    int i; 
    NSMutableDictionary* dic = [[NSMutableDictionary alloc]init];
    for( i = 0 ; i < columnCount; i ++ ) 
    { 
        if (columnValue[i]) {
            NSString* key = [[NSString alloc]initWithUTF8String:columnName[i]];
            NSString* value = [[NSString alloc]initWithUTF8String:columnValue[i]];
            [dic setObject:value forKey:key];   
        }  
    } 
    [(NSMutableArray*)arrayResult addObject:dic];
    [dic release];   
    return 0; 
}
//---------------------select-----------------------
-(NSArray*)querryTableByCallBack:(NSString*)sqlQuerry
{
    if (![self openOrCreateDatabase:self.m_dbName]) {
        return nil;
    }
    lockhelp lock(m_lcok);
    char*    errorMsg = NULL;
    NSMutableArray* arrayResult = [[NSMutableArray alloc]init];
    if (sqlite3_exec(self.m_sql,[sqlQuerry UTF8String],processData,(void*)arrayResult,&errorMsg) !=SQLITE_OK) {
        printf("查询出错:%s",errorMsg);
    }
    [self closeDatabase];   
    return [arrayResult autorelease];
}
@end

有问题的可以留言！