第一步：插入libsqlite3.tbd
插入libsqlite3.tbd
第二步：viewController.m全部代碼
//
// ViewController.m
// FMDataBase數(shù)據(jù)庫(kù)
//
// Created by qianfeng on 16/9/25.
// Copyright ? 2016年 qianfeng. All rights reserved.
//
#import "ViewController.h"
#import "FMDB.h"
@interface ViewController ()
@end
/*
FMDB的簡(jiǎn)單使用：
*/
@implementation ViewController
/*
NSSearchPathForDirectoriesInDomains:查找路徑，在（cache，user）下載
NSCachesDirectory:library 的caches 快速存儲(chǔ)目錄路徑
NSUserDomainMask：用戶安裝目錄
YES：表示完整路徑
*/
-(NSString *)databasePath
{
NSString *cachepath = NSSearchPathForDirectoriesInDomains
(NSCachesDirectory,
NSUserDomainMask, YES)[0];
return [cachepath stringByAppendingPathComponent:@"data.db"];
}
- (void)viewDidLoad {
[super viewDidLoad];
/*
1.創(chuàng)建/打開(kāi)數(shù)據(jù)庫(kù)
*/
FMDatabase *database = [FMDatabase databaseWithPath:
[self databasePath] ];
[database open];
NSLog(@"cachePath == %@",[self databasePath]);
/*
2.創(chuàng)建表
*/
NSString *sql_createTable = @"create table if not exists
book(id integer primary key autoincrement,name text ,price double)";
[database executeUpdate:sql_createTable];
/*
3.插入數(shù)據(jù)
*/
NSString *sql_insert = @"insert into book (name , price)
values (?, ?)";
for (int i = 0; i < 10;i ++ ){
[database executeUpdate:sql_insert,
[NSString stringWithFormat:@"name%d",i+1], @(20+i)];
}
/*
4.查詢
*/
NSString *sql_select = @"select * from book";
FMResultSet *resultSet = [database executeQuery:sql_select];
while (resultSet.next) {
NSString *name = [resultSet stringForColumn:@"name"];
NSLog(@"name == %@",name);
}
}
@end
第三步：運(yùn)行即可绊序。。。
運(yùn)行結(jié)果
|
|
微云網(wǎng)盤：
FMDB簡(jiǎn)單使用
FMDB二次封裝
