端端舝

FMDBㄗSQLite蚚wrapper仿奶皮仿伉ㄘ及瞳蚚源楊
iOS失皿伉嶱逃丟乒
http://i-yusuke.blogspot.jp/

反元戶卞
? SQLite反﹜iOS匹妏蚚匹五月local犯奈正矛奈旦
? FMDB反﹜SQLite毛objective-c匹瞳蚚仄支允仁允月
凶戶及wrapper仿奶皮仿伉
? 仇仇匹反﹜SQLite午FMDB及瞳蚚𨃨�井日﹜��g卅
幛紼嗨詁及瞳蚚源楊引匹毛鴛戶月

揃蹋及衙猁
? 虐噫及𨃨�
? 犯奈正矛奈旦及釬傖
? SQLite及瞳蚚ㄗSELECT , INSERT , UPDATE ,
DELETE)
? ゜媆倰卞勾中化

虐噫及𨃨�(1/3)
? SQLite仿奶皮仿伉及袚樓
? xcode皿伕斥尼弁玄及TARGETS > Build Phases > Link Binary With Libraries井
日﹜☆libsqlite3.0dylib★毛袚樓﹝
? FMDB仿奶皮仿伉及袚樓
? https://github.com/ccgus/fmdb 井日FMDB皿伕斥尼弁玄毛母它件伕奈玉允月﹝
? fmdb.m眕俋及白央奶伙毛xcode皿伕斥尼弁玄卞戊疋奈允月﹝ㄗ巨仿奈隙旌ㄘ

? Lita及奶件旦玄奈伙
? GUI匹DB偞�摯太犯奈正統桽互匹五月﹝
? http://www.dehats.com/drupal/?q=node/58 井日Lita午Adobe AIR毛奶件旦玄
奈伙﹝

? FMDB妏蚚弁仿旦卞眕狟毛import允月
? #import FMDatabase.h
? #import FMDatabaseAdditions.h

犯奈正矛奈旦及釬傖(1/2)
? Lita卞化☆ .db★白央奶伙毛汜傖允月
? SQLite匹妏蚚允月測桶腔卅犯奈正倰
? TEXT , INTEGER , REAL , BOOL
? ゜媆倰毛妏蚚允月�磁反﹜INTEGER毛硌隅﹝��反摽扴﹝
? ☆ .db★毛xcode皿伕斥尼弁玄卞袚樓允月

犯奈正矛奈旦及釬傖(2/2)

SQLite及瞳蚚(1/8)
? DB場ヽお�媆及open�I燴
? app及場隙お�媆反﹜Lita匹汜傖仄凶DB毛掂心煋戈﹝
? 2僅醴眕蔥及open�I燴
? 2僅醴眕蔥反﹜FMDatabase左皮斥尼弁玄及open丟末永玉毛瞳蚚允木壬謎中﹝

//DB白央奶伙靡
static NSString* const DB_FILE = @"user.db";
//場ヽお�媆及open�I燴
- (BOOL)?rstOpenDatabase {
//DB白央奶伙尺及由旦毛龰腕( /Documents/)
NSString *dbPath = nil;
NSArray *documentsPath = NSSearchPathForDirectoriesInDomains
(NSDocumentDirectory, NSUserDomainMask, YES);
//龰腕犯奈正杅毛復庲
if ([documentsPath count] >= 1) {
dbPath = [documentsPath objectAtIndex:0];
//由旦及郔摽卞白央奶伙靡毛失矢件玉仄﹜DB白央奶伙尺及白伙由旦毛汜傖﹝
dbPath = [dbPath stringByAppendingPathComponent:DB_FILE];
} else {
//error
NSLog(@"search Document path error. database ?le open error.");
return false;
}
//衵�卞適仁↙
//2僅醴眕蔥及open�I燴
[db open];
?//DB白央奶伙互Document饜狟卞湔婓允月井瓚隅
NSFileManager *?leManager = [NSFileManager defaultManager];
if (![?leManager ?leExistsAtPath:dbPath]) {
//犯白巧伙玄及DB白央奶伙毛戊疋奈
NSBundle *bundle = [NSBundle mainBundle];
NSString *orgPath = [bundle bundlePath];
//場ヽ白央奶伙及由旦﹝( /XXX.app/sample.db)
orgPath = [orgPath stringByAppendingPathComponent:DB_FILE];
//犯白巧伙玄及DB白央奶伙毛Document饜狟尺戊疋奈
if (![?leManager copyItemAtPath:orgPath toPath:dbPath error:nil])
{
NSLog(@"db ?le copy error. : %@ to %@.", orgPath, dbPath);
return false;
}
}
//open database with FMDB.
db = [FMDatabase databaseWithPath:dbPath];
return [db open];
}
?失皿伉場ヽお�媆及open�I燴
?2僅醴眕蔥及open�I燴

? SELECT恅
? �伊戊奈玉及統桽
? SELECT 市仿丞靡, ... FROM 氾奈皮伙靡
? SELECT * FROM 氾奈皮伙靡
? 沭璃葆五統桽
? SELECT * FROM 氾奈皮伙靡 WHERE 沭璃

//DB及�伊戊奈玉毛掂心煋心﹜奶件旦正件旦毛饜蹈卞跡慮允月﹝
-(void)selectAll{
[db open];
//弁巨伉及灍俴午磐彆(ResultSet)及龰腕
FMResultSet *results = [db executeQuery:@"SELECT * FROM table"];
//record左皮斥尼弁玄毛跡慮允月饜蹈毛汜傖﹝猁匼0分互﹜mutable卅及匹�觳卅仄﹝
NSMutableArray* array = [[NSMutableArray alloc] initWithCapacity:0];
//伊戊奈玉杅煦﹜龰曰堤仄�I燴毛靜曰殿允
while( [results next] )
{
//伊戊奈玉ロ�毛跡慮允月左皮斥尼弁玄
Record* record = [[Record alloc] init];
//市仿丞�卞猁匼毛龰曰堤仄化中仁﹝
record.columnOfInteger = [results intForColumnIndex:0];
//龰曰堤仄互皺歹勻凶日﹜array卞record毛跡慮允月﹝
[array addObject:record];
}
[db open];
}
#import <Foundation/Foundation.h>
//伊戊奈玉ロ�毛跡慮允月弁仿旦
@interface Record : NSObject
//id
@property (nonatomic) int columnOfInteger;
//公及坻市仿丞及皿伕由氾奴毛偞隅
@end
?SELECT恅ㄗ�伊戊奈玉及統桽ㄘ ?伊戊奈玉ロ�毛跡慮允月弁仿旦

//DB及�伊戊奈玉毛掂心煋心﹜奶件旦正件旦毛饜蹈卞跡慮允月﹝
-(void)selectRecord:(int)id{
[db open];
//弁巨伉及灍俴午磐彆(ResultSet)及龰腕
FMResultSet *results = [db executeQuery:@"SELECT * FROM table WHERE id=?",
[NSNumber numberWithInteger:id]];
//record左皮斥尼弁玄毛跡慮允月饜蹈毛汜傖﹝猁匼0分互﹜mutable卅及匹�觳卅仄﹝
NSMutableArray* array = [[NSMutableArray alloc] initWithCapacity:0];
//伊戊奈玉杅煦﹜龰曰堤仄�I燴毛靜曰殿允
{
//伊戊奈玉ロ�毛跡慮允月左皮斥尼弁玄
//市仿丞�卞猁匼毛龰曰堤仄化中仁﹝
//龰曰堤仄互皺歹勻凶日﹜array卞record毛跡慮允月﹝
}
[db open];
}
?SELECT恅ㄗ沭璃葆五統桽ㄘ
*1 WHERE恅匹﹜idㄗ翋平奈ㄘ互
珨祡仄凶�磁卞統桽允月﹝
*2 SQLite匹反﹜int倰毛㜳尹卅中凶戶﹜
? id毛NSNumber倰卞劐𡥼允月﹝

? INSERT恅
? INSERT INTO 氾奈皮伙靡 (市仿丞靡, ... ) VALUES ( ? , ... )
//伊戊奈玉及袚樓
-(void)insert:(NSString*)text day:(NSDate*)day{
//insert恅及褰倰毛釬傖
NSString *sql = @"INSERT INTO table (text,day) VALUES (?,?)";
[db open];
//劐杅毛測⻌仄化弁巨伉逃俴
[db executeUpdate:sql,text,day];
[db close];
}

? UPDATE恅
? UPDATE 氾奈皮伙靡 SET 市仿丞靡 = ? , ... WHERE 沭璃
//伊戊奈玉及載陔
-(void)update:(int)id text:(NSString*)text{
//update恅及褰倰毛釬傖(idㄗ翋平奈ㄘ互珨祡允月伊戊奈玉卞勾中化﹜�毛載陔
NSString *sql = @"UPDATE table SET text=? WHERE id=?";
[db open];
//劐杅毛測⻌仄化弁巨伉逃俴
[db executeUpdate:sql,text,[NSNumber numberWithInteger:id]];
[db close];
}

? DELETE恅
? DELETE FROM 氾奈皮伙靡 WHERE 沭璃
//伊戊奈玉及祅壺
-(void)delete:(int)id{
NSString* sql = @"DELETE FROM table WHERE id = ?";
[db open];
[db executeUpdate:sql, [NSNumber numberWithInteger:id]];
[db close];
}

゜媆倰卞勾中化(1/2)
? SQLite匹反﹜゜媆倰及隅膽互卅中﹝
? 眕狟中內木井及倰毛妏蚚﹜objective-c匹劐𡥼允月﹝
? INTEGER > UNIX媆嶲ㄗ弘伊打伉左𩑈 1970爛1堎1゜毛價𨃨ㄘ
? REAL > 交伉它旦𩑈ㄗ廢啋ゴ4713爛 1堎1゜毛價𨃨ㄘ
? TEXT > YYYY-MM-DD HH:MM:SS.SSS 及白巧奈穴永玄
? SQLite匹反﹜囀窒腔卞UNIX媆嶲互妸蚚今木化中月凶戶﹜INTEGER毛妏蚚允月﹝

゜媆倰卞勾中化(2/2)
//゜掛媆嶲及NSDate毛汜傖仄化﹜INSERT丟末永玉毛網太堤仄
[self insert:[NSDate dateWithTimeIntervalSinceNow:
[[NSTimeZone systemTimeZone] secondsFromGMT]]];
//INSERT丟末永玉
-(void)insert:(NSDate*)day{
NSString *sql = @"INSERT INTO table (day) VALUES (?)";
[db open];
[db executeUpdate:sql,day];
[db close];
}
//SELECT匹掂心煋心
-(void)select{
[db open];
FMResultSet *results = [db executeQuery:@"SELECT id,day FROM table"];
{
record.columnOfDate = [results dateForColumnIndex:1];
}
[db open];
}
#import <Foundation/Foundation.h>
@interface Record : NSObject
//id
@property (nonatomic) int columnOfInteger;
//゜媆(SQLite匹反﹜INTEGER倰匹跡慮今木月ㄘ
@property (nonatomic) NSDate* columnOfDate;
@end
?NSDate倰ㄗ政婓゜媆ㄘ及汜傖
?INSERT恅及逃俴
?SELECT恅匹掂心煋心
?伊戊奈玉跡慮弁仿旦及隅膽

云歹曰卞...
? 辭�今六化�中凶皮伕弘
? http://akabeko.me/blog/2011/11/ios-sqlite-fmdb/#fmdb_11
? http://selection9.blogspot.jp/2012/04/iossqlitefmdb.html

端端舝

幛紼嗨詁及瞳蚚源楊

Recommended

More Related Content

What's hot (20)

Similar to 幛紼嗨詁及瞳蚚源楊 (20)

Recently uploaded (15)

幛紼嗨詁及瞳蚚源楊