示例：在项目中写一个FMDB 的封装类

#import <Foundation/Foundation.h>
#import "FMDatabase.h"
@interface FMDBManager : NSObject

@property (nonatomic,retain)FMDatabase *dataBase;

//建购物车的表
- (void)createShopCarTable;
//加对象
- (BOOL)insertShopCar:(CGGoodsListBasicModel *)model;
//删对象
- (void)deletedWithGoodsId:(NSString *)commodityId;
//改对象
- (void)updateWithCGShoppingCartCellModel:(CGShoppingCartCellModel *)model;
//查表
- (NSMutableArray *)findShopCar;
@end

#import "FMDBManager.h"

@implementation FMDBManager

- (id)init {
    if (self = [super init]) {
        NSString *HomePath = [NSString stringWithFormat:@"%@/Documents/text1.db",NSHomeDirectory()];
        _dataBase = [[FMDatabase alloc]initWithPath:HomePath];
        [_dataBase open];
    }
    return self;
}

#pragma mark 建购物车列表的表
- (void)createShopCarTable {
    NSString *commodityId;
    NSString *commodityName;
    NSString *bigPic;
    NSString *specification;
    NSString *num;
    //    CREATE TABLE IF NOT EXISTS 固定部分
    //    CREATE TABLE IF NOT EXISTS +表名+参数;

    NSString *createTab = @"CREATE TABLE IF NOT EXISTS ShopCar(commodityId varchar(32),commodityName varchar(32),bigPic varchar(32),specification varchar(32),num varchar(32),price varchar(32),discountNums varchar(32),discountPrices varchar(32))";

    //增,删,改,查 都是用executeUpdate 这个方法来实现
    //把所有参数都转化成字符串 存进数据库
    BOOL isSuc = [_dataBase executeUpdate:createTab, commodityId, commodityName, bigPic, specification, num];
    if (isSuc) {
        NSLog(@"创建列表成功");
    }else{
        NSLog(@"创建列表失败");
    }
}
//加对象
- (BOOL)insertShopCar:(CGGoodsListBasicModel*)model {
    NSString *commodityId = model.commodityId;
    NSString *commodityName = model.commodityName;
    NSString *bigPic = model.bigPic;
    NSString *specification = model.specification;
    NSString *num = model.num;
    NSString *price = model.price;
    NSString *discountNums = model.discountNums;
    NSString *discountPrices = model.discountPrices;

    NSString *insertSql = @"INSERT INTO ShopCar(commodityId,commodityName,bigPic,specification,num,price,discountNums,discountPrices) values(?,?,?,?,?,?,?,?)";

    BOOL isSuc = [_dataBase executeUpdate:insertSql,commodityId,commodityName,bigPic,specification,num,price,discountNums,discountPrices];
    if (isSuc) {
        NSLog(@"加对象成功");
        return YES;
    }else{
        NSLog(@"加对象失败");
        return NO;
    }
    return YES;
}
//删对象
- (void)deletedWithGoodsId:(NSString *)commodityId {
    NSString *deleteSql = @"DELETE FROM ShopCar WHERE commodityId = ?";

    BOOL isSuc  = [_dataBase executeUpdate:deleteSql,commodityId];

    if (isSuc) {
        NSLog(@"删除成功");
    }else{
        NSLog(@"删除失败");
    }
}
//改对象
- (void)updateWithCGShoppingCartCellModel:(CGShoppingCartCellModel *)model {
    NSString *updateSql = @"UPDATE ShopCar SET num = ? WHERE commodityId = ?";

    BOOL isSuc  = [_dataBase executeUpdate:updateSql,model.basicModel.num,model.basicModel.commodityId];

    if (isSuc) {
        NSLog(@"修改成功");
    }else{
        NSLog(@"修改失败");
    }

}
//查
- (NSMutableArray *)findShopCar {
    NSMutableArray * modelArray = [NSMutableArray array];
    NSString *selectSql = @"SELECT * FROM ShopCar";
    //    executeQuery 查询方法
    FMResultSet *set =  [_dataBase executeQuery:selectSql];
    ShopCarGoodModel *model;
    while ([set next]) {
        model = [ShopCarGoodModel modelWithFMResultSet:set];
        [modelArray addObject:model];
    }
    return modelArray;
}

@end