MadSqlite 可通过 CocoaPods 获得。要安装它,只需将以下行添加到 Podfile 中
pod 'MadSqlite', '~> 0.2.3'
或者最新版
pod 'MadSqlite', :git => 'https://github.com/manimaul/madsqlite-ios-objc.git', :submodules => true
// Open / create database
id <MADDatabase> md = [MADSqliteFactory databaseNamed:@"mydb"];
[md exec:@"CREATE TABLE location_table(name TEXT, latitude REAL, longitude REAL, image BLOB);"];
// Insert into database
id <MADContentValues> cv = [MADSqliteFactory contentValues];
[cv putString:@"name" withValue:@"Cheshire Cat"];
[cv putReal:@"latitude" withValue:@(51.2414945)];
[cv putReal:@"longitude" withValue:@(-0.6354629)];
NSData *data = UIImagePNGRepresentation([UIImage imageNamed:@"Cheshire Cat"]);
[cv putBlob:@"image" withValue:data];
[md insert:@"location_table" withValues:cv];
// Query database
id <MADQuery> query = [md query:@"SELECT name, latitude, longitude FROM location_table WHERE name=?"
withArgs:@[@"Cheshire Cat"]];
if ([query moveToFirst]) {
while (![query isAfterLast]) {
NSString *name = [query getString:0];
NSNumber *latitude = [query getReal:1];
NSNumber *longitude = [query getReal:2];
NSLog(@"name:%@ latitude:%@ longitude:%@", name, latitude, longitude);
[query moveToNext];
}
}