action \u2013 \u30dc\u30bf\u30f3\u304c\u62bc\u3055\u308c\u305f\u6642\u306b\u547c\u3070\u308c\u308b\u30e1\u30bd\u30c3\u30c9\u3067\u3059\u3002@selector \u3092\u4f7f\u3044\u3001\u547c\u3073\u3060\u3059\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3\u540d\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/li>\n<\/ul>\n\u6700\u5f8c\u306b\u3001rightBarButtonItem \u306b\u3053\u306e\u30dc\u30bf\u30f3\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u72b6\u614b\u3067\u306f\u3001\u30ca\u30d3\u30b2\u30fc\u30b7\u30e7\u30f3\u306b\u30dc\u30bf\u30f3\u3092\u8ffd\u52a0\u3057\u305f\u3060\u3051\u3067\u3059\u306e\u3067\u3001\u30af\u30ea\u30c3\u30af\u3055\u308c\u305f\u6642\u306e\u30a2\u30af\u30b7\u30e7\u30f3\u306f\u672a\u8a2d\u5b9a\u3067\u3059\u3002\u306a\u306e\u3067\u3001\u3053\u306e\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n
\u305d\u308c\u3067\u306f\u3001Todo\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u5185\u306b\u30e1\u30bd\u30c3\u30c9\u3092\u4f5c\u6210\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n
Todo.h<\/strong>\u3092\u958b\u304d\u3001\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n– (void<\/span>)deleteFromDatabase;<\/p>\n+ (NSInteger)insertNewTodoIntoDatabase:(sqlite3 *)database<\/span>;<\/p>\n<\/blockquote>\ninsertNewTodoIntoDatabase<\/strong>\u30e1\u30bd\u30c3\u30c9\u3092\u8ffd\u52a0\u3057\u307e\u3057\u305f\u3002\u540c\u6642\u306b\u3001deleteFromDatabase\u3082\u8ffd\u52a0\u3057\u3066\u3044\u307e\u3059\u306d\u3002\u3053\u308c\u306b\u3064\u3044\u3066\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u306e\u30c7\u30fc\u30bf\u306e\u524a\u9664\u3092\u6271\u3046\u6642\u306b\u5b9f\u88c5\u3057\u307e\u3059\u3002<\/p>\ninsertNewTodoIntoDatabase<\/strong>\u30e1\u30bd\u30c3\u30c9\u306e\u5148\u982d\u306b\u3064\u3044\u3066\u3044\u308b\u201d\uff0b\u201d\u306f\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30e1\u30bd\u30c3\u30c9\u3067\u306f\u306a\u304f\u3001\u30af\u30e9\u30b9\u30e1\u30bd\u30c3\u30c9\u3092\u8868\u3057\u3066\u3044\u307e\u3059\u3002\u30af\u30e9\u30b9\u30e1\u30bd\u30c3\u30c9\u306a\u306e\u3067\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u5316\u305b\u305a\u306b\u3001\u547c\u3073\u51fa\u3059\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n\u3053\u306e\u30e1\u30bd\u30c3\u30c9\u3092\u5b9f\u88c5\u3059\u308b\u524d\u306b\u3001\u9759\u7684\u306asqlite3_statement \u3092\u3044\u304f\u3064\u304b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
Todo.m <\/strong>\u306b\u4ee5\u4e0b\u3092\u8ffd\u52a0\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\nstatic<\/span> sqlite3_stmt *delete_statment = nil<\/span>;<\/p>\nstatic<\/span> sqlite3_stmt *insert_statement = nil<\/span>;<\/p>\n<\/blockquote>\n\u305d\u308c\u3067\u306f\u3001insertNewTodoIntoDatabase<\/strong>\u3092\u5b9f\u88c5\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n+ (NSInteger)insertNewTodoIntoDatabase:(sqlite3 *)database<\/span> {<\/p>\n\n
<\/span>if<\/span> (<\/span>insert_statement == <\/span>nil<\/span>) {<\/span><\/p>\n <\/span>static<\/span> <\/span>char<\/span> *sql = <\/span>“INSERT INTO todo (text,priority,complete) VALUES(‘\u65b0\u898f\u30a2\u30a4\u30c6\u30e0’,’3′,’0′)”;<\/span><\/p>\nif<\/span> (sqlite3_prepare_v2(database<\/span>, sql, –1<\/span>, &insert_statement<\/span>, NULL<\/span>) != SQLITE_OK) {<\/p>\n NSAssert1(<\/span>0<\/span>, <\/span>@”Error: failed to prepare statement with message ‘%s’.”, sqlite3_errmsg(<\/span>database<\/span>));<\/span><\/p>\n}<\/p>\n
}<\/p>\n
int<\/span> success = sqlite3_step(insert_statement<\/span>);<\/p>\n\n
sqlite3_reset(insert_statement<\/span>);<\/p>\nif<\/span> (success != SQLITE_ERROR) {<\/p>\nreturn<\/span> sqlite3_last_insert_rowid(database<\/span>);<\/p>\n}<\/p>\n
NSAssert1(<\/span>0<\/span>, <\/span>@”Error: failed to insert into the database with message ‘%s’.”, sqlite3_errmsg(<\/span>database<\/span>));<\/span><\/p>\nreturn<\/span> –1<\/span>;<\/p>\n\n
}<\/p>\n<\/blockquote>\n
\u66f4\u65b0\u3059\u308b\u6642\u306e\u30e1\u30bd\u30c3\u30c9\u306b\u4f3c\u3066\u3044\u307e\u3059\u306d\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3092\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u633f\u5165\u3057\u3066\u3044\u308b\u3053\u3068\u306b\u6ce8\u76ee\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u3046\u3059\u308b\u3053\u3068\u3067\u3001null\u3084nil\u3092\u542b\u3080\u30c8\u30e9\u30d6\u30eb\u3092\u907f\u3051\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n
\u3053\u306e\u30e1\u30bd\u30c3\u30c9\u3067\u6700\u3082\u5927\u5207\u306a\u3053\u3068\u306f\u3001\u65b0\u3057\u304f\u4f5c\u6210\u3055\u308c\u305ftodo\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30d7\u30e9\u30a4\u30de\u30ea\u30fc\u30ad\u30fc\u3092\u8fd4\u3059\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<\/p>\n
\u3053\u308c\u306f\u3001\u201dAdd\u201d\u30dc\u30bf\u30f3\u304c\u62bc\u3055\u308c\u305f\u6642\u306b\u3001\u5373\u5ea7\u306btodo\u306b\u5909\u9077\u3059\u308b\u305f\u3081\u306b\u3001\u4f7f\u308f\u308c\u307e\u3059\u3002<\/p>\n
todo\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u5bfe\u3057\u3066\u884c\u3046\u6700\u5f8c\u306e\u4f5c\u696d\u306f\u3001todo\u30c6\u30ad\u30b9\u30c8\u304c\u5909\u66f4\u3055\u308c\u305f\u6642\u306b\u4fdd\u5b58\u3055\u308c\u308b\u3088\u3046\u306bdehydrate\u30e1\u30bd\u30c3\u30c9\u3092\u66f4\u65b0\u3059\u308b\u3053\u3068\u3067\u3059\u3002<\/p>\n
dehydrate\u30e1\u30bd\u30c3\u30c9\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u7de8\u96c6\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\n– (void<\/span>) dehydrate {<\/p>\n <\/span>if<\/span>(dirty<\/span>) {<\/p>\n <\/span><\/p>\n <\/span><\/span>if<\/span> (<\/span>dehydrate_statment == <\/span>nil<\/span>) {<\/span><\/p>\n <\/span><\/span>const<\/span> <\/span>char<\/span> *sql = <\/span>“UPDATE todo SET text = ? , priority = ?,complete = ? WHERE pk=?”;<\/span><\/p>\n <\/span>if<\/span> (sqlite3_prepare_v2(database<\/span>, sql, –1<\/span>, &dehydrate_statment<\/span>, NULL<\/span>) != SQLITE_OK) {<\/p>\n <\/span><\/span>NSAssert1<\/span>(<\/span>0<\/span>, <\/span>@”Error: failed to prepare statement with message ‘%s’.”, sqlite3_errmsg(<\/span>database<\/span>));<\/span><\/p>\n <\/span>}<\/p>\n <\/span>}<\/p>\n <\/span><\/p>\n <\/span>sqlite3_bind_int(<\/span>dehydrate_statment, <\/span>4<\/span>, <\/span>self<\/span>.<\/span>primaryKey);<\/span><\/p>\n <\/span>sqlite3_bind_int(dehydrate_statment<\/span>, 3<\/span>, self<\/span>.status<\/span>);<\/p>\n <\/span>sqlite3_bind_int(dehydrate_statment<\/span>, 2<\/span>, self<\/span>.priority<\/span>);<\/p>\n <\/span>sqlite3_bind_text(dehydrate_statment<\/span>, 1<\/span>, [self<\/span>.text<\/span> UTF8String<\/span>], –1<\/span>, SQLITE_TRANSIENT);<\/p>\n <\/span>int<\/span> success = sqlite3_step(dehydrate_statment<\/span>);<\/p>\n <\/span><\/p>\n <\/span>if<\/span> (success != SQLITE_DONE) {<\/p>\n <\/span><\/span>NSAssert1<\/span>(<\/span>0<\/span>, <\/span>@”Error: failed to save priority with message ‘%s’.”, sqlite3_errmsg(<\/span>database<\/span>));<\/span><\/p>\n <\/span>}<\/p>\n <\/span><\/p>\n <\/span>sqlite3_reset(dehydrate_statment<\/span>);<\/p>\n <\/span>dirty<\/span> = NO<\/span>;<\/p>\n <\/span>}<\/p>\n <\/span><\/p>\n}<\/p>\n<\/blockquote>\n
\u7d30\u304b\u3044\u5909\u66f4\u304c\u3044\u304f\u3064\u304b\u3042\u308a\u307e\u3059\u3002\u307e\u305a\u3001\u201ctext = ?\u201d\u3068\u3044\u3046\u8a18\u8ff0\u304csql\u6587\u306b\u8ffd\u52a0\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u306f\u5358\u7d14\u306btodo\u30c6\u30ad\u30b9\u30c8\u3092\u66f4\u65b0\u3059\u308b\u3082\u306e\u3067\u3059\u3002<\/p>\n
\u4ed6\u306e\u5909\u66f4\u70b9\u3068\u3057\u3066\u3001self.text property \u3092sql\u6587\u5185\u306e\u6700\u521d\u306e\u201d\uff1f\u201d\u306b\u95a2\u9023\u3065\u3051\u3066\u3044\u307e\u3059\u3002<\/p>\n
[self.text UTF8String] \u306b\u6ce8\u76ee\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u308c\u306f\u3001sqlite3_bind_text\u304c\u3001char\u578b\u3092\u3068\u308b\u306e\u3067\u3001NSString \u3092\u8a31\u5bb9\u53ef\u80fd\u306a\u5f62\u5f0f\u306b\u5909\u63db\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n
todo\u3092\u8ffd\u52a0\u3059\u308b\u305f\u3081\u306b\u3001RootViewController\u5185\u306b\u30e1\u30bd\u30c3\u30c9\u3092\u8ffd\u52a0\u3057\u3066\u304d\u307e\u3059\u3002<\/p>\n
\u30e6\u30fc\u30b6\u304c\u3001”Add”\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u305f\u6642\u306b\u547c\u3070\u308c\u308b\u30e1\u30bd\u30c3\u30c9\u3067\u3059\u3002<\/p>\n
RootViewController.m<\/strong> \u5185\u306b\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n– (void<\/span>) addTodo:(id<\/span>)sender {<\/p>\n <\/span>todoAppDelegate<\/span> *appDelegate = (todoAppDelegate<\/span> *)[[UIApplication<\/span> sharedApplication<\/span>] delegate];<\/p>\n <\/span><\/p>\n <\/span>if<\/span>(self<\/span>.todoView<\/span> == nil<\/span>) {<\/p>\n <\/span><\/span>TodoViewController *viewController = [[<\/span>TodoViewController <\/span>alloc<\/span>] <\/span><\/p>\n <\/span> initWithNibName<\/span>:@”TodoViewController”<\/span>
![\"812-1\"](\"http:\/\/yamazon.org\/wp-content\/uploads\/2010\/12\/812-1-160x300.png\" "\\"812-1\\"")
<\/a><\/p>\n