插入数据

    //插入数据
-(void)insertData{
    sqlite3 *sqlite = nil;
    sqlite3_stmt *stmt = nil;
    //打开数据库
    NSString *filepth = [NSHomeDirectory() stringByAppendingFormat:@"/Documents/data.sqlite"];
    
    int result = sqlite3_open([filepth UTF8String], &sqlite);
    if (result !=SQLITE_OK) {
        NSLog(@"打开数据库失败");
        return;
    }
    //创建SQL语句
    NSString *sql = @"INSERT INTO User(username,password,email) VALUES (?,?,?)";
   
    
    //编译SQL 语句；
    sqlite3_prepare_v2(sqlite, [sql UTF8String], -1, &stmt, NULL);
  
    //设置绑定数据    
    NSString *username = @"jack";
    NSString *password = @"666666";
    NSString *email = @"lceboy";
    //往SQL语句上绑定数据
    sqlite3_bind_text(stmt, 1, [username UTF8String], -1, NULL);
    sqlite3_bind_text(stmt, 2, [password UTF8String], -1, NULL);
    sqlite3_bind_text(stmt, 3, [email UTF8String], -1, NULL);
    result = sqlite3_step(stmt);
    if (result == SQLITE_ERROR||result == SQLITE_MISUSE) {
        NSLog(@"执行SQL语句失败");
        return;
    }
    //关闭数据库句抦
    sqlite3_finalize(stmt);
    sqlite3_close(sqlite);
    NSLog(@"数据插入成功");
}