本文演示了使用FMDB通过多线程来读和写数据库操作。
1.建立数据库表,我采用的是Firefox的Sqlite manager 来建立的。
建表sql如下
1.建立数据库表,我采用的是Firefox的Sqlite manager 来建立的。
建表sql如下
CREATE TABLE "tbl_user" ("_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , "name" VARCHAR(30), "password" VARCHAR(30))
2. 建立数据表的映射实体UserEntity
#import <Foundation/Foundation.h>
@interface UserEntity : NSObject{
int _id;
NSString *name;
NSString *password;
}
@property (nonatomic, assign)int ID;
@property (nonatomic, retain) NSString *name;
@property (nonatomic, retain) NSString *password;
@end
3. 建立操作数据库的dao
//
// DbDao.m
// SqliteTest
//
// Created by foxwang on 12-4-9.
// Copyright (c) 2012年 __MyCompanyName__. All rights reserved.
//
#import "DbDao.h"
#import "DbFileManager.h"
#import "FMDatabase.h"
#import "FMDatabaseAdditions.h"
#import "FMDatabasePool.h"
#import "FMDatabaseQueue.h"
#import "UserEntity.h"
static DbDao *gSharedInstance = nil;
@implementation DbDao
@synthesize dbFile;
@synthesize dbQueue;
+(DbDao *)sharedInstance
{
@synchronized(self)
{
if (gSharedInstance == nil)
gSharedInstance = [[DbDao alloc] init];
}
return gSharedInstance;
}
- (void)dealloc
{
[self.dbFile release];
self.dbQueue = nil;
[super dealloc];
}
- (id)init
{
self = [super init];
if (self)
{
self.dbFile = [DbFileManager dbFilePath];
self.dbQueue = [FMDatabaseQueue databaseQueueWithPath:self.dbFile];
}
return self;
}
- (UserEntity *)rsToUser:(FMResultSet*)rs
{
UserEntity *user = [[[UserEntity alloc] init] autorelease];
user.ID = [rs intForColumn:@"_id"];
user.name = [rs stringForColumn:@"name"];
user.password = [rs stringForColumn:@"password"];
return user;
}
- (void)addUser:(UserEntity *)user
{
[self.dbQueue inTransaction:^(FMDatabase *db, BOOL *rollback) {
[db open];
NSString *sql = @"insert into tbl_user(name, password) values (?, ?)";
[db executeUpdate:sql,user.name, user.password];
[db close];
}];
}
- (NSArray *)getUsers;
{
__block NSMutableArray *users = [[[NSMutableArray alloc] init] autorelease];
[self.dbQueue inDatabase:^(FMDatabase *db) {
[db open];
NSString *sql = @"select * from tbl_user ";
FMResultSet *rs = [db executeQuery:sql];
while ([rs next])
{
[users addObject:[self rsToUser :rs]];
}
[db close];
}];
return users;
}
@end
- (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions
{
self.window = [[[UIWindow alloc] initWithFrame:[[UIScreen mainScreen] bounds]] autorelease];
// Override point for customization after application launch.
self.viewController = [[[ViewController alloc] initWithNibName:@"ViewController" bundle:nil] autorelease];
self.window.rootViewController = self.viewController;
[self.window makeKeyAndVisible];
[NSThread detachNewThreadSelector:@selector(writeDbOne) toTarget:self withObject:nil];
[NSThread detachNewThreadSelector:@selector(readDb) toTarget:self withObject:nil];
[NSThread detachNewThreadSelector:@selector(writeDbTwo) toTarget:self withObject:nil];
return YES;
}
- (void)writeDbOne
{
DbDao *dao = [DbDao sharedInstance];
for (int i = 0; i < 500; i++)
{
@autoreleasepool
{
UserEntity *user = [[[UserEntity alloc] init] autorelease];
user.name = [NSString stringWithFormat:@"name %d", i];
user.password = [NSString stringWithFormat:@"password %d", i];
[dao addUser:user];
NSLog(@"writeDbOne %d ", i);
}
}
}
- (void)writeDbTwo
{
DbDao *dao = [DbDao sharedInstance];
for (int i = 600; i < 1200; i++)
{
@autoreleasepool
{
UserEntity *user = [[[UserEntity alloc] init] autorelease];
user.name = [NSString stringWithFormat:@"name %d", i];
user.password = [NSString stringWithFormat:@"password %d", i];
[dao addUser:user];
NSLog(@"writeDbTwo %d ", i);
}
}
}
- (void)readDb
{
DbDao *dao = [DbDao sharedInstance];
NSArray *users = [dao getUsers];
NSLog(@"%@", users);
}