今天做了一个小例子
使用sqlite进行数据保存
-(IBAction)saveClick:(id)sender
{
NSArray *path = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
NSString *paths = [path objectAtIndex:0];
NSString *file = [paths stringByAppendingPathComponent:@"User.db"];
//NSLog(@"file:%@",file);
char *errMsg;
sqlite3_stmt *stmt;
if(sqlite3_open([file UTF8String],&database) != SQLITE_OK)
{
NSLog(@"Failed to open Database.");
}else
{
NSString *insertSQL = [NSString stringWithFormat:@"Insert into UserName (id,names) values (9,%@",userName.text];
NSLog(@"insert SQL:%@",insertSQL);
if(sqlite3_exec(database, [insertSQL UTF8String], NULL, NULL, &errMsg) != SQLITE_OK)
{
NSLog(@"insert ERR:%s",errMsg);
}else {
NSLog(@"Insert OK");
}
}
sqlite3_finalize(stmt);
NSLog(@"SaveClick");
}
标记一下。。。