创建数据库

    // 创建数据库
-(void)creatTable{
    sqlite3 *sqlite = nil;
    NSString *filepth = [NSHomeDirectory() stringByAppendingFormat:@"/Documents/data.sqlite"];
    
    int result = sqlite3_open([filepth UTF8String], &sqlite);
    if (result !=SQLITE_OK) {
        NSLog(@"打开数据库失败");
        return;
    }
    //创建SQL语句
    NSString *sql =@"CREAT　TABLE IF NOT EXISTS User(username TEXT primary key,password TEXT ,email TEXT)";
    char *error;
    //编译数据
    sqlite3_exec(sqlite, [sql UTF8String], NULL, NULL, &error);
    if (result != SQLITE_OK) {
        NSLog(@"执行数据库失败:%s",error);
        return;
    }
    //关闭数据
    sqlite3_close(sqlite);
    
    
}