开发者

FMDatabase: perform the operation: Insert, Update, Select, Delete

I am developing iPhone application using SQLite. I decided to use fmdb. Using fmdb, how do 开发者_如何转开发I perform the following operation:-Insert, Update, Select, Delete?

As I can't develop application using FMDatabase. I downloaded FMDatabase files which contain following files namely =>

  1. FMDatabase.h
  2. FMDatabase.m
  3. FMResultSet.h
  4. FMResultSet.m
  5. FMDatabaseAdditions.h
  6. FMDatabaseAdditions.m
  7. fmdb.m

But the file fmdb.m also contains the main function. So it is conflicting with my applications MAIN function.


fmdb.m is a file that contains FMDB sample code. You should not include this file in your Xcode project. But you should review it to see how to work with FMDB. It contains a lot of well-commented examples.


to use fmdb in your code, just add the files you list to your project, except the main.m file. Here is an example of using it, when the app finish launching, a SQLite database will be created.

- (void)applicationDidFinishLaunching:(NSNotification *)aNotification {
    // Insert code here to initialize your application 


    FMDatabase* db = [FMDatabase databaseWithPath:@"/tmp/tmp.db"];
    if (![db open]) {
        NSLog(@"Could not open db.");

    }

    [db executeUpdate:@"create table test (a text, b text, c integer, d double, e double)"];

    NSLog(@"%@",[db databasePath]);
    [db beginTransaction];
    int i = 0;
    while (i++ < 20) {
        [db executeUpdate:@"insert into test (a, b, c, d, e) values (?, ?, ?, ?, ?)" ,
         @"hi'", // look!  I put in a ', and I'm not escaping it!
         [NSString stringWithFormat:@"number %d", i],
         [NSNumber numberWithInt:i],
         [NSDate date],
         [NSNumber numberWithFloat:2.2f]];
    }
    [db commit];

    [db close];


}

Notice, I'm just pasting some code from fmdb main.m file, into applicationDidFinishLaunching.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜