iOS資料庫操作fmdb1： FMDB資料庫使用

iOS資料庫操作fmdb1： FMDB資料庫使用
FMDatabase 資料庫
1.下載FMDatabase 匯入下載裡面的src檔案，刪了fmdb.m檔案2.引入framework:libsqlite3.dylib3.引入標頭檔 #import "FMDatabase.h” 資料庫檔案要相容iPhone4和iPhone5需要放在Document或Library目錄中,先判斷Document/Library中資料庫檔案(一般是.sqlite尾碼)是否存在,如果不存在則從工程(bundle)中把資料庫檔案拷貝到Document中或Library中。
以下是我是我工程中用過的一個資料庫作業碼，記下來，免得忘記了：[cpp] view plaincopyprint?

1. //資料庫操作，1代表增減，2代表刪除，3，代表查詢，4，代表修改
2. -(void)operateDB:(NSInteger)num andRow:(NSInteger)row status:(NSInteger)status{
3. self.deleteOld = YES;
4. self.dbFile = @"shopCar_db.sqlite";
5. NSFileManager *manager = [NSFileManager defaultManager];
6. NSString *dbPath = [Utilities documentsPath:self.dbFile];
8. //沒存在則拷貝到document
9. if (![manager fileExistsAtPath:dbPath]) {
10. NSString *bundlePath = [Utilities bundlePath:self.dbFile];
11. if ([manager copyItemAtPath:bundlePath toPath:dbPath error:nil]) {
12. NSLog(@"copy ok...");
13. }
14. else
15. {
16. NSLog(@"copy error...");
17. }
18. }
19. else{
20. if (self.deleteOld) {
21. NSLog(@"delete old and create new..");
22. NSString *bundlePath = [Utilities bundlePath:self.dbFile];
23. [manager removeItemAtPath:dbPath error:nil];
24. [manager copyItemAtPath:bundlePath toPath:dbPath error:nil];
25. }
26. else
27. {
28. NSLog(@"do nothing...");
29. }
31. }
34. FMDatabase *db = [FMDatabase databaseWithPath:dbPath];
35. NSLog(@"begin to db...");
36. if ([db open]) {
37. if(status == 1){
38. NSLog(@"增減.......");
39. }
40. if(status == 2){
41. NSString *sql = [NSString stringWithFormat:@"delete from shopCar_tb where id = %i",row];
42. [db executeUpdate:sql];
43. }
44. if(status == 3){
45. NSLog(@"查詢........");
46. }
47. if(status == 4){
48. NSString *sql = [NSString stringWithFormat:@"UPDATE shopCar_tb SET num = '%d' WHERE id = %d",num,row];
49. [db executeUpdate:sql];
50. }
51. NSString *sql = @"select * from shopCar_tb";
52. FMResultSet *result = [db executeQuery:sql];
53. _mutableArrayData = [[NSMutableArray alloc] init];
54. [_mutableArrayData removeAllObjects];
55. [_mutableDictionayData removeAllObjects];
56. while ([result next]) {
57. _mutableDictionayData = [[NSMutableDictionary alloc] init];
58. NSString *sid = [result stringForColumn:@"id"];
59. [_mutableDictionayData setObject:sid forKey:@"id"];
61. NSString *name = [result stringForColumn:@"name"];
62. [_mutableDictionayData setObject:name forKey:@"name"];
64. NSString *gid = [result stringForColumn:@"gid"];
65. [_mutableDictionayData setObject:gid forKey:@"gid"];
67. NSString *num = [result stringForColumn:@"num"];
68. [_mutableDictionayData setObject:num forKey:@"num"];
69. NSLog(@"num = %i",[num intValue]);
71. NSString *price = [result stringForColumn:@"price"];
72. [_mutableDictionayData setObject:price forKey:@"price"];
74. NSString *path = [result stringForColumn:@"path"];
75. [_mutableDictionayData setObject:path forKey:@"path"];
77. [_mutableArrayData addObject:_mutableDictionayData];
78. }
80. }
81. [db close];
83. NSLog(@"end db...");
86. }