To save an arbitrary object into the database

#import "SXViewController.h"#import "SXShop.h"#import "FMDB.h"@interfaceSxviewcontroller () @property (nonatomic, strong) Fmdatabase*db;@end@implementationSxviewcontroller- (void) viewdidload{[Super Viewdidload];        [Self setup]; [Self readshops];}- (void) setup{//InitializeNSString *path =@"/users/apple/desktop/shops.data"; Self.db=[Fmdatabase Databasewithpath:path];        [Self.db Open]; //2. Create a watch[Self.db executeupdate:@"CREATE TABLE IF not EXISTS t_shop (ID integer PRIMARY KEY, shop blob not NULL);"];}- (void) readshops{Fmresultset*Set= [Self.db executeQuery:@"SELECT * from T_shop LIMIT 10,10;"];  while(Set. Next) {NSData*data = [SetObjectforcolumnname:@" Shop"]; Sxshop*shop =[Nskeyedunarchiver Unarchiveobjectwithdata:data]; NSLog (@"%@", shop); }    }- (void) addshops{ for(inti =0; i< -; i++) {Sxshop*shop =[[Sxshop alloc] init]; Shop.name= [NSString stringWithFormat:@"Product--%d", I]; Shop.price= Arc4random ()%10000; NSData*data =[Nskeyedarchiver Archiveddatawithrootobject:shop]; [Self.db Executeupdatewithformat:@"INSERT into T_shop VALUES (%@);", data]; }}@end

To save an arbitrary object into the database