使用资料库的第一件事,就是建立一个资料库。要注意的是,在iOS环境下,只有document directory 是可以进行读写的。在写程式时用的那个Resource资料夹底下的东西都是read-only。因此,建立的资料库要放在document 资料夹下。方法如下:
1 | NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES); |
3 | NSString *dbPath = [documentDirectory stringByAppendingPathComponent:@ "MyDatabase.db" ]; |
<div alt1"="" style="margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; background-image: none !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; line-height: 1.5em !important; min-height: inherit !important;">
3 | NSString *address = [db stringForQuery:@ "SELECT Address FROM PersonList WHERE Name = ?" ,@"John”]; |
7 | int age = [db intForQuery:@ "SELECT Age FROM PersonList WHERE Name = ?" ,@"John”]; |