sqlite3 命令行其实也不错

1.Mesa sqlite确实有问题，不好用，容易crash

2.大家多说sqlite manager firefox plugin好用。对了，昨天刚安装了firefox，可以试用一下哦。没有试用firefox浏览器是无法安装的

3.用

／／复制到document上以后，我们就可以bakcup，甚至cloud backup

copy it into your"Supporting Files" or "Resources" folder. From there we will transfer the database file to the iPhone "Documents" folder. The advantage of copying the database into Documents folder is that it will be backed up whenever the iPhone is backed up. For iOS5 cloud enabled devices this means your database will be available on the cloud.

／／为了文件可操作一定要复制到document目录的，抽取到DBOperation 或filemanager

- (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions
{
 self.databaseName = @"Customers.db";
 
 NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask,YES);
 NSString *documentDir = [documentPaths objectAtIndex:0];
 self.databasePath = [documentDir stringByAppendingPathComponent:self.databaseName];
 
 [self createAndCheckDatabase];

 // Override point for customization after application launch.
 return YES;
}
  
-(void) createAndCheckDatabase
{
 BOOL success; 
 
 NSFileManager *fileManager = [NSFileManager defaultManager];
 success = [fileManager fileExistsAtPath:databasePath];
 
 if(success) return; 
 
 NSString *databasePathFromApp = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:self.databaseName];
 
 [fileManager copyItemAtPath:databasePathFromApp toPath:databasePath error:nil];
}

#import <Foundation/Foundation.h>
#import "FMDatabase.h" 
#import "FMResultSet.h" 
#import "Utility.h" 
#import "Customer.h" 

@interface FMDBDataAccess : NSObject
{
 
}

-(NSMutableArray *) getCustomers; 
-(BOOL) insertCustomer:(Customer *) customer; 
-(BOOL) updateCustomer:(Customer *) customer; 

@end

-(NSMutableArray *) getCustomers
{
 NSMutableArray *customers = ［[[NSMutableArray alloc] init] autorelease］;
 
 FMDatabase *db = [FMDatabase databaseWithPath:[Utility getDatabasePath]];
 
 [db open];
 
 FMResultSet *results = [db executeQuery:@"SELECT * FROM customers"];
 
 while([results next]) 
 {
 Customer *customer = [[Customer alloc] init];
 
 customer.customerId = [results intForColumn:@"id"];
 customer.firstName = [results stringForColumn:@"firstname"];
 customer.lastName = [results stringForColumn:@"lastname"];
 
 [customers addObject:customer];
 
 }
 
 [db close];
 
 return customers; 

}

／／插入用户信息，inert into customers（）values（？，？），数组，以nil为结束标识 。

-(BOOL) insertCustomer:(Customer *) customer 
{
    // insert customer into database
    
    FMDatabase *db = [FMDatabase databaseWithPath:[Utility getDatabasePath]];
    
    [db open];
    
    BOOL success =  [db executeUpdate:@"INSERT INTO customers (firstname,lastname) VALUES (?,?);",customer.firstName,customer.lastName,nil];
    
    [db close];
    
    return success; 
    
}

好多人遇到的一个问题就是 如何也写不进入，因为咩有copy文件到document 需要提醒的是document下并不是所有文件目录多有的，有些例如resource／support 就需要自己建立的。

The directories returned byNSSearchPathForDirectoriesInDomainsare not guaranteed to exist; you need to create them yourself,if necessary (seethe documentation). NSFileManager'screateDirectoryAtPath:withIntermediateDirectories:attributes:error:can help with that.

下面这段代码就假设了 目录support director已经存在！！！

NSString* appSupportDir = [NSFileManager appSupportDir];    tuningsPath [appSupportDir stringByAppendingPathComponent:@"tunings.txt"NSBundle bundle NSBundle mainBundle origTuningsPath bundle pathForResource"tuningsOriginal"                         ofType"txt"NSFileManager fileManager  defaultManagerNSError error  nil; 

／／

.databases List names and files of attached databases

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!