IOS database operation fmdb1: used by the FMDB Database

IOS database operation fmdb1: used by the FMDB Database
FMDatabase
1. download the src file in the FMDatabase import and download and delete the fmdb. m file 2. introduce framework: libsqlite3.dylib3. introduce the header file # import "FMDatabase. h "database files must be compatible with iPhone 4 and iPhone 5 in the Document or Library directory. First, judge the database files in Document/Library (generally. sqlite suffix). If not, copy the database file from the project (bundle) to the Document or Library.
The following is a database operation code I used in my project. Write it down to avoid forgetting it:[Cpp]View plaincopyprint?

1. // Database operation. 1 indicates increase or decrease, 2 indicates deletion, 3 indicates query, 4 indicates modification.
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 defamanager manager];
6. NSString * dbPath = [Utilities documentsPath: self. dbFile];
8. // Copy the object to the document if it does not exist
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 (@ "add or remove .......");
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 (@ "query ........");
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. }