{"id":582,"date":"2018-02-23T23:40:11","date_gmt":"2018-02-23T15:40:11","guid":{"rendered":"http:\/\/60.205.208.74\/2018\/02\/23\/ios-sqlite%e6%95%b0%e6%8d%ae%e5%ba%93\/"},"modified":"2018-02-23T23:40:11","modified_gmt":"2018-02-23T15:40:11","slug":"ios-sqlite%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/www.puzi7.net\/?p=582","title":{"rendered":"iOS SQLite\u6570\u636e\u5e93"},"content":{"rendered":"
\n
\n

IOS SQLite\u6570\u636e\u5e93<\/h1>\n
\n

\u7b80\u4ecb<\/h2>\n

\u5728IOS\u4e2d\u4f7f\u7528Sqlite\u6765\u5904\u7406\u6570\u636e\u3002\u5982\u679c\u4f60\u5df2\u7ecf\u4e86\u89e3\u4e86SQL\uff0c\u90a3\u4f60\u53ef\u4ee5\u5f88\u5bb9\u6613\u7684\u638c\u63e1SQLite\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u3002<\/p>\n

\u5b9e\u4f8b\u6b65\u9aa4<\/h3>\n

1\u3001\u521b\u5efa\u4e00\u4e2a\u7b80\u5355\u7684View based application<\/p>\n

2\u3001\u9009\u62e9\u9879\u76ee\u6587\u4ef6\uff0c\u7136\u540e\u9009\u62e9\u76ee\u6807\uff0c\u6dfb\u52a0libsqlite3.dylib\u5e93\u5230\u9009\u62e9\u6846\u67b6<\/p>\n

3\u3001\u901a\u8fc7\u9009\u62e9” File-> New -> File… -> “\u9009\u62e9 Objective C class \u521b\u5efa\u65b0\u6587\u4ef6\uff0c\u5355\u51fb\u4e0b\u4e00\u6b65<\/p>\n

4\u3001”sub class of”\u4e3aNSObject”\uff0c\u7c7b\u547d\u540d\u4e3aDBManager<\/p>\n

5\u3001\u9009\u62e9\u521b\u5efa<\/p>\n

6\u3001\u66f4\u65b0DBManager.h,\u5982\u4e0b\u6240\u793a<\/p>\n

\n#import <Foundation\/Foundation.h>\n#import <sqlite3.h>\n\n@interface DBManager : NSObject\n{\n    NSString *databasePath;\n}\n\n+(DBManager*)getSharedInstance;\n-(BOOL)createDB;\n-(BOOL) saveData:(NSString*)registerNumber name:(NSString*)name \n  department:(NSString*)department year:(NSString*)year;\n-(NSArray*) findByRegisterNumber:(NSString*)registerNumber;\n\n@end\n<\/pre>\n
7\u3001\u66f4\u65b0DBManager.m,\u5982\u4e0b\u6240\u793a<\/p>\n
\n#import \"DBManager.h\"\nstatic DBManager *sharedInstance = nil;\nstatic sqlite3 *database = nil;\nstatic sqlite3_stmt *statement = nil;\n\n@implementation DBManager\n\n+(DBManager*)getSharedInstance{\n    if (!sharedInstance) {\n        sharedInstance = [[super allocWithZone:NULL]init];\n        [sharedInstance createDB];\n    }\n    return sharedInstance;\n}\n\n-(BOOL)createDB{\n    NSString *docsDir;\n    NSArray *dirPaths;    \n    \/\/ Get the documents directory\n    dirPaths = NSSearchPathForDirectoriesInDomains\n    (NSDocumentDirectory, NSUserDomainMask, YES);    \n    docsDir = dirPaths[0];\n    \/\/ Build the path to the database file\n    databasePath = [[NSString alloc] initWithString: \n    [docsDir stringByAppendingPathComponent: @\"student.db\"]];\n    BOOL isSuccess = YES;\n    NSFileManager *filemgr = [NSFileManager defaultManager];    \n    if ([filemgr fileExistsAtPath: databasePath ] == NO)\n    {\n        const char *dbpath = [databasePath UTF8String];        \n        if (sqlite3_open(dbpath, &database) == SQLITE_OK)\n        {\n            char *errMsg;\n            const char *sql_stmt =\n            \"create table if not exists studentsDetail (regno integer \n            primary key, name text, department text, year text)\";            \n            if (sqlite3_exec(database, sql_stmt, NULL, NULL, &errMsg) \n               != SQLITE_OK)\n            {\n                isSuccess = NO;\n                NSLog(@\"Failed to create table\");\n            }\n            sqlite3_close(database);\n            return  isSuccess;\n        }\n        else {\n            isSuccess = NO;\n            NSLog(@\"Failed to open\/create database\");\n        }\n    }    \n    return isSuccess;\n}\n\n- (BOOL) saveData:(NSString*)registerNumber name:(NSString*)name \n  department:(NSString*)department year:(NSString*)year;\n{\n    const char *dbpath = [databasePath UTF8String];    \n    if (sqlite3_open(dbpath, &database) == SQLITE_OK)\n    {        \n        NSString *insertSQL = [NSString stringWithFormat:@\"insert into\n        studentsDetail (regno,name, department, year) values\n        (\\\"%d\\\",\\\"%@\\\", \\\"%@\\\", \\\"%@\\\")\",[registerNumber integerValue],\n        name, department, year];        \n        const char *insert_stmt = [insertSQL UTF8String];\n        sqlite3_prepare_v2(database, insert_stmt,-1, &statement, NULL);\n        if (sqlite3_step(statement) == SQLITE_DONE)\n        {\n            return YES;\n        } \n        else {\n            return NO;\n        }\n        sqlite3_reset(statement);\n    }\n    return NO;\n}\n\n- (NSArray*) findByRegisterNumber:(NSString*)registerNumber\n{\n    const char *dbpath = [databasePath UTF8String];    \n    if (sqlite3_open(dbpath, &database) == SQLITE_OK)\n    {\n        NSString *querySQL = [NSString stringWithFormat:\n        @\"select name, department, year from studentsDetail where \n        regno=\\\"%@\\\"\",registerNumber];        \n        const char *query_stmt = [querySQL UTF8String];\n        NSMutableArray *resultArray = [[NSMutableArray alloc]init];\n        if (sqlite3_prepare_v2(database,\n           query_stmt, -1, &statement, NULL) == SQLITE_OK)\n        {\n            if (sqlite3_step(statement) == SQLITE_ROW)\n            {                \n                NSString *name = [[NSString alloc] initWithUTF8String:\n                 (const char *) sqlite3_column_text(statement, 0)];\n                [resultArray addObject:name];\n                NSString *department = [[NSString alloc] initWithUTF8String:\n                (const char *) sqlite3_column_text(statement, 1)];\n                [resultArray addObject:department];\n                NSString *year = [[NSString alloc]initWithUTF8String:\n                (const char *) sqlite3_column_text(statement, 2)];\n                [resultArray addObject:year];\n                return resultArray;\n            }\n            else{\n                NSLog(@\"Not found\");\n                return nil;\n            }\n            sqlite3_reset(statement);\n        }\n    }\n    return nil;\n}\n<\/pre>\n
8\u3001\u5982\u56fe\u6240\u793a\uff0c\u66f4\u65b0ViewController.xib\u6587\u4ef6<\/p>\n
\"Sqlite_Interface\"<\/p>\n
9\u3001\u4e3a\u4e0a\u8ff0\u6587\u672c\u5b57\u6bb5\u521b\u5efaIBOutlets<\/p>\n
10\u3001\u4e3a\u4e0a\u8ff0\u6309\u94ae\u521b\u5efaIBAction<\/p>\n
11\u3001\u5982\u4e0b\u6240\u793a\uff0c\u66f4\u65b0ViewController.h<\/p>\n
\n#import <UIKit\/UIKit.h>\n#import \"DBManager.h\"\n\n@interface ViewController : UIViewController<UITextFieldDelegate>\n{\n    IBOutlet UITextField *regNoTextField;\n    IBOutlet UITextField *nameTextField;\n    IBOutlet UITextField *departmentTextField;\n    IBOutlet UITextField *yearTextField;\n    IBOutlet UITextField *findByRegisterNumberTextField;\n    IBOutlet UIScrollView *myScrollView;\n}\n\n-(IBAction)saveData:(id)sender;\n-(IBAction)findData:(id)sender;\n\n@end\n<\/pre>\n
12\u3001\u66f4\u65b0ViewController.m,\u5982\u4e0b\u6240\u793a<\/p>\n
\n#import \"ViewController.h\"\n\n@interface ViewController ()\n\n@end\n\n@implementation ViewController\n\n- (id)initWithNibName:(NSString *)nibNameOrNil bundle:(NSBundle *)\n  nibBundleOrNil\n{\n    self = [super initWithNibName:nibNameOrNil bundle:nibBundleOrNil];\n    if (self) {\n        \/\/ Custom initialization\n    }\n    return self;\n}\n\n- (void)viewDidLoad\n{\n    [super viewDidLoad];\n    \/\/ Do any additional setup after loading the view from its nib.\n}\n\n- (void)didReceiveMemoryWarning\n{\n    [super didReceiveMemoryWarning];\n    \/\/ Dispose of any resources that can be recreated.\n}\n\n-(IBAction)saveData:(id)sender{\n    BOOL success = NO;\n    NSString *alertString = @\"Data Insertion failed\";\n    if (regNoTextField.text.length>0 &&nameTextField.text.length>0 &&\n    departmentTextField.text.length>0 &&yearTextField.text.length>0 )\n    {\n        success = [[DBManager getSharedInstance]saveData:\n        regNoTextField.text name:nameTextField.text department:\n        departmentTextField.text year:yearTextField.text];\n    }\n    else{\n        alertString = @\"Enter all fields\";\n    }     \n    if (success == NO) {\n        UIAlertView *alert = [[UIAlertView alloc]initWithTitle:\n        alertString message:nil\n        delegate:nil cancelButtonTitle:@\"OK\" otherButtonTitles:nil];\n        [alert show];\n    }\n}\n\n-(IBAction)findData:(id)sender{\n    NSArray *data = [[DBManager getSharedInstance]findByRegisterNumber:\n    findByRegisterNumberTextField.text];\n    if (data == nil) {\n        UIAlertView *alert = [[UIAlertView alloc]initWithTitle:\n        @\"Data not found\" message:nil delegate:nil cancelButtonTitle:\n        @\"OK\" otherButtonTitles:nil];\n        [alert show];\n        regNoTextField.text = @\"\";\n        nameTextField.text =@\"\";\n        departmentTextField.text = @\"\";\n        yearTextField.text =@\"\";\n    }\n    else{\n        regNoTextField.text = findByRegisterNumberTextField.text;\n        nameTextField.text =[data objectAtIndex:0];\n        departmentTextField.text = [data objectAtIndex:1];\n        yearTextField.text =[data objectAtIndex:2];\n    }\n}\n\n#pragma mark - Text field delegate\n-(void)textFieldDidBeginEditing:(UITextField *)textField{\n    [myScrollView setFrame:CGRectMake(10, 50, 300, 200)];\n    [myScrollView setContentSize:CGSizeMake(300, 350)];\n}\n-(void)textFieldDidEndEditing:(UITextField *)textField{\n    [myScrollView setFrame:CGRectMake(10, 50, 300, 350)];\n\n}\n-(BOOL) textFieldShouldReturn:(UITextField *)textField{\n    \n    [textField resignFirstResponder];\n    return YES;\n}\n@end\n<\/pre>\n
\u8f93\u51fa<\/h3>\n
\u73b0\u5728\u5f53\u6211\u4eec\u8fd0\u884c\u5e94\u7528\u7a0b\u5e8f\u65f6\uff0c\u6211\u4eec\u5c31\u4f1a\u83b7\u5f97\u4e0b\u9762\u7684\u8f93\u51fa\uff0c\u6211\u4eec\u53ef\u4ee5\u5728\u5176\u4e2d\u6dfb\u52a0\u53ca\u67e5\u627e\u5b66\u751f\u7684\u8be6\u7ec6\u4fe1\u606f<\/p>\n
\"Sqlite_Output\"<\/p>\n<\/p><\/div>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"
IOS SQLite\u6570\u636e\u5e93 \u7b80\u4ecb \u5728IOS\u4e2d\u4f7f\u7528Sqlite\u6765\u5904\u7406\u6570\u636e\u3002\u5982\u679c\u4f60\u5df2\u7ecf\u4e86\u89e3\u4e86S…<\/span><\/p>\n
Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,26],"tags":[74,93],"class_list":["post-582","post","type-post","status-publish","format-standard","hentry","category-ios","category-mobile","tag-ios","tag-mobile","zoom-theme-has-thumb"],"yoast_head":"\niOS SQLite\u6570\u636e\u5e93 - \u8c31\u5b50\u68cb - Puzi7<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.puzi7.net\/?p=582\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"iOS SQLite\u6570\u636e\u5e93 - \u8c31\u5b50\u68cb - Puzi7\" \/>\n<meta property=\"og:description\" content=\"IOS SQLite\u6570\u636e\u5e93 \u7b80\u4ecb \u5728IOS\u4e2d\u4f7f\u7528Sqlite\u6765\u5904\u7406\u6570\u636e\u3002\u5982\u679c\u4f60\u5df2\u7ecf\u4e86\u89e3\u4e86S…Read More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.puzi7.net\/?p=582\" \/>\n<meta property=\"og:site_name\" content=\"\u8c31\u5b50\u68cb - Puzi7\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-23T15:40:11+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.runoob.com\/wp-content\/uploads\/2013\/11\/Sqlite_Interface.jpg\" \/>\n<meta name=\"author\" content=\"\u77f3\u8863\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u77f3\u8863\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/?p=582#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/?p=582\"},\"author\":{\"name\":\"\u77f3\u8863\",\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/#\\\/schema\\\/person\\\/87dd4941c8ec260c1350b7f41980a190\"},\"headline\":\"iOS SQLite\u6570\u636e\u5e93\",\"datePublished\":\"2018-02-23T15:40:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/?p=582\"},\"wordCount\":41,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/?p=582#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.runoob.com\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/Sqlite_Interface.jpg\",\"keywords\":[\"iOS\",\"Mobile\"],\"articleSection\":[\"iOS\",\"Mobile\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.puzi7.net\\\/?p=582#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/?p=582\",\"url\":\"https:\\\/\\\/www.puzi7.net\\\/?p=582\",\"name\":\"iOS SQLite\u6570\u636e\u5e93 - \u8c31\u5b50\u68cb - Puzi7\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/?p=582#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/?p=582#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.runoob.com\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/Sqlite_Interface.jpg\",\"datePublished\":\"2018-02-23T15:40:11+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/#\\\/schema\\\/person\\\/87dd4941c8ec260c1350b7f41980a190\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/?p=582#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.puzi7.net\\\/?p=582\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/?p=582#primaryimage\",\"url\":\"http:\\\/\\\/www.runoob.com\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/Sqlite_Interface.jpg\",\"contentUrl\":\"http:\\\/\\\/www.runoob.com\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/Sqlite_Interface.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/?p=582#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\\\/\\\/www.puzi7.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u6280\u672f\",\"item\":\"https:\\\/\\\/www.puzi7.net\\\/?cat=9\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Mobile\",\"item\":\"https:\\\/\\\/www.puzi7.net\\\/?cat=26\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"iOS\",\"item\":\"https:\\\/\\\/www.puzi7.net\\\/?cat=38\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"iOS SQLite\u6570\u636e\u5e93\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/#website\",\"url\":\"https:\\\/\\\/www.puzi7.net\\\/\",\"name\":\"\u8c31\u5b50\u68cb - Puzi7\",\"description\":\"\u5206\u4eab\uff0c\u6210\u957f\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.puzi7.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.puzi7.net\\\/#\\\/schema\\\/person\\\/87dd4941c8ec260c1350b7f41980a190\",\"name\":\"\u77f3\u8863\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c52c3a64b447af78e58cfa1c73ddd53952049afcf934cd702d71eee91f9907bd?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c52c3a64b447af78e58cfa1c73ddd53952049afcf934cd702d71eee91f9907bd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c52c3a64b447af78e58cfa1c73ddd53952049afcf934cd702d71eee91f9907bd?s=96&d=mm&r=g\",\"caption\":\"\u77f3\u8863\"},\"sameAs\":[\"https:\\\/\\\/www.puzi7.net\"],\"url\":\"https:\\\/\\\/www.puzi7.net\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"iOS SQLite\u6570\u636e\u5e93 - \u8c31\u5b50\u68cb - Puzi7","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.puzi7.net\/?p=582","og_locale":"zh_CN","og_type":"article","og_title":"iOS SQLite\u6570\u636e\u5e93 - \u8c31\u5b50\u68cb - Puzi7","og_description":"IOS SQLite\u6570\u636e\u5e93 \u7b80\u4ecb \u5728IOS\u4e2d\u4f7f\u7528Sqlite\u6765\u5904\u7406\u6570\u636e\u3002\u5982\u679c\u4f60\u5df2\u7ecf\u4e86\u89e3\u4e86S…Read More","og_url":"https:\/\/www.puzi7.net\/?p=582","og_site_name":"\u8c31\u5b50\u68cb - Puzi7","article_published_time":"2018-02-23T15:40:11+00:00","og_image":[{"url":"http:\/\/www.runoob.com\/wp-content\/uploads\/2013\/11\/Sqlite_Interface.jpg","type":"","width":"","height":""}],"author":"\u77f3\u8863","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u77f3\u8863","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.puzi7.net\/?p=582#article","isPartOf":{"@id":"https:\/\/www.puzi7.net\/?p=582"},"author":{"name":"\u77f3\u8863","@id":"https:\/\/www.puzi7.net\/#\/schema\/person\/87dd4941c8ec260c1350b7f41980a190"},"headline":"iOS SQLite\u6570\u636e\u5e93","datePublished":"2018-02-23T15:40:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.puzi7.net\/?p=582"},"wordCount":41,"commentCount":0,"image":{"@id":"https:\/\/www.puzi7.net\/?p=582#primaryimage"},"thumbnailUrl":"http:\/\/www.runoob.com\/wp-content\/uploads\/2013\/11\/Sqlite_Interface.jpg","keywords":["iOS","Mobile"],"articleSection":["iOS","Mobile"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.puzi7.net\/?p=582#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.puzi7.net\/?p=582","url":"https:\/\/www.puzi7.net\/?p=582","name":"iOS SQLite\u6570\u636e\u5e93 - \u8c31\u5b50\u68cb - Puzi7","isPartOf":{"@id":"https:\/\/www.puzi7.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.puzi7.net\/?p=582#primaryimage"},"image":{"@id":"https:\/\/www.puzi7.net\/?p=582#primaryimage"},"thumbnailUrl":"http:\/\/www.runoob.com\/wp-content\/uploads\/2013\/11\/Sqlite_Interface.jpg","datePublished":"2018-02-23T15:40:11+00:00","author":{"@id":"https:\/\/www.puzi7.net\/#\/schema\/person\/87dd4941c8ec260c1350b7f41980a190"},"breadcrumb":{"@id":"https:\/\/www.puzi7.net\/?p=582#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.puzi7.net\/?p=582"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.puzi7.net\/?p=582#primaryimage","url":"http:\/\/www.runoob.com\/wp-content\/uploads\/2013\/11\/Sqlite_Interface.jpg","contentUrl":"http:\/\/www.runoob.com\/wp-content\/uploads\/2013\/11\/Sqlite_Interface.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.puzi7.net\/?p=582#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.puzi7.net\/"},{"@type":"ListItem","position":2,"name":"\u6280\u672f","item":"https:\/\/www.puzi7.net\/?cat=9"},{"@type":"ListItem","position":3,"name":"Mobile","item":"https:\/\/www.puzi7.net\/?cat=26"},{"@type":"ListItem","position":4,"name":"iOS","item":"https:\/\/www.puzi7.net\/?cat=38"},{"@type":"ListItem","position":5,"name":"iOS SQLite\u6570\u636e\u5e93"}]},{"@type":"WebSite","@id":"https:\/\/www.puzi7.net\/#website","url":"https:\/\/www.puzi7.net\/","name":"\u8c31\u5b50\u68cb - Puzi7","description":"\u5206\u4eab\uff0c\u6210\u957f","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.puzi7.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.puzi7.net\/#\/schema\/person\/87dd4941c8ec260c1350b7f41980a190","name":"\u77f3\u8863","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/secure.gravatar.com\/avatar\/c52c3a64b447af78e58cfa1c73ddd53952049afcf934cd702d71eee91f9907bd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c52c3a64b447af78e58cfa1c73ddd53952049afcf934cd702d71eee91f9907bd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c52c3a64b447af78e58cfa1c73ddd53952049afcf934cd702d71eee91f9907bd?s=96&d=mm&r=g","caption":"\u77f3\u8863"},"sameAs":["https:\/\/www.puzi7.net"],"url":"https:\/\/www.puzi7.net\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.puzi7.net\/index.php?rest_route=\/wp\/v2\/posts\/582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.puzi7.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.puzi7.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.puzi7.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.puzi7.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=582"}],"version-history":[{"count":0,"href":"https:\/\/www.puzi7.net\/index.php?rest_route=\/wp\/v2\/posts\/582\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.puzi7.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.puzi7.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.puzi7.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}