本文共 1472 字,大约阅读时间需要 4 分钟。
#import "RootViewController.h"#import "FMDatabase.h"@interface RootViewController (){ FMDatabase *_dataBase;}@end@implementation RootViewController- (id)initWithNibName:(NSString *)nibNameOrNil bundle:(NSBundle *)nibBundleOrNil{ self = [super initWithNibName:nibNameOrNil bundle:nibBundleOrNil]; if (self) { // Custom initialization } return self;}- (void)viewDidLoad{ [super viewDidLoad]; NSString *dbPath = [NSHomeDirectory() stringByAppendingFormat:@"/Documents/test.db"]; //初始化 _dataBase = [[FMDatabase alloc] initWithPath:dbPath]; if ([_dataBase open]) { //创建表 NSString *createSql = @"create table if not exists student(id integer,name varchar(256))"; if (![_dataBase executeUpdate:createSql]) { NSLog(@"create error:%@",_dataBase.lastErrorMessage); } } //NSDate 时间类 NSDate *date1 = [NSDate date];//获取系统当前时间 [self insertDataWithCount:1000 isUseTransaction:NO]; NSDate *date2 = [NSDate date]; //取到时间的差值 (timeIntervalSinceDate 两个时间的差值,单位是秒) //NSTimeInterval 时间差变量,秒 NSTimeInterval time = [date2 timeIntervalSinceDate:date1]; NSLog(@"time:%f",time); // Do any additional setup after loading the view.}//插入批量数据,是否手动启用事务- (void)insertDataWithCount:(NSInteger)count isUseTransaction:(BOOL)isUse{ if (isUse) { //手动启用事务 BOOL isError = NO; @try { //写可能出现异常的代码 [_dataBase beginTransaction];//手动开启一个事务 for (int i=0; i
转载地址:http://jeyni.baihongyu.com/