iPhone中的Sqlite3数据库操作

最新推荐文章于 2022-10-12 23:16:56 发布

zlwonder

最新推荐文章于 2022-10-12 23:16:56 发布

阅读量121

点赞数

分类专栏： iPhone开发文章标签： SQLite C C++ C#

本文链接：https://blog.csdn.net/zlwonder/article/details/83802421

版权

iPhone开发专栏收录该内容

25 篇文章 0 订阅

订阅专栏

可将数据库操作写入一个类，这样用起来也很方便。例如：


#import <Foundation/Foundation.h>
#import <sqlite3.h>

@interface DBOperation : NSObject {
	sqlite3 *readableDB;
	sqlite3 *writableDB;
	NSString *dbName;
}

- (void)openDB;
- (void)closeDB;

@end


@implementation DBOperation

static sqlite3_stmt *insert_statement=nil;
static sqlite3_stmt *select_statement=nil;
static sqlite3_stmt *delete_statement=nil;


-(void) openDB {//打开DB
	NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *documentsDirectory = [paths objectAtIndex:0];
	NSString *writableDBPath= [documentsDirectory stringByAppendingPathComponent:dbName];
	if (sqlite3_open([writableDBPath UTF8String], &writableDB) != SQLITE_OK) {
        sqlite3_close(writableDB);
        NSAssert1(0, @"Failed to open database with message '%s'.", sqlite3_errmsg(writableDB));
    }
	else
	{
		NSLog(@"DB Opened");
	}
}

- (void)closeDB {//关闭DB
	if (select_statement)
		sqlite3_finalize(select_statement);

	if (insert_statement)
		sqlite3_finalize(insert_statement);

	if (delete_statement)
		sqlite3_finalize(delete_statement);

	if(sqlite3_close(writableDB) != SQLITE_OK)
		NSAssert1(0, @"Error while closing the connection to the writableDB. %s", sqlite3_errmsg(writableDB));	
}

- (void)dealloc
{
	[self closeDB];
	[super dealloc];
}