经过不断摸索，我发现直接调用mysql C API更好，出了错也容易把握。以下是部分代码，贴出来给大家参考参考

 

-(NSInteger)getHistoryRecordwithStockID:(NSString*)stockID LeaderName:(NSString*)leaderName dataSource:(NSInteger)dataSource{
    
    using MySQL C API 
    MYSQL *conn;
    MYSQL_RES *res;
    MYSQL_ROW row;
    
    char *server = "localhost";
    char *user = "root";
    char *password = "123456"; 
    char *database = "stockinfo";
    
    conn = mysql_init(NULL);

    
    if (!mysql_real_connect(conn, server,
                            user, password, database, 0, NULL, 0)) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
    }
    if (!mysql_set_character_set(conn, "gbk")) 
    {
        printf("New client character set: %s\\n", mysql_character_set_name(conn));        
    }

    if (dataSourceType==ShangeHaiMainBoard) {
        tableName=@"shzb";
    }else if (dataSourceType==ShenzhenMainBoard) {
        tableName=@"szzb";
    }else if (dataSourceType==ShenzhenSmallBoard) {
        tableName=@"szzxb";
    }else if (dataSourceType==HongKongMainBoard) {
        tableName=@"hkzb";
    }

    NSString  *queryString=[NSString stringWithFormat: @"SELECT * FROM %@ ",tableName];
    NSString  *newQueryString=NULL;

    
    if (!(stockID==nil||[stockID isEqualToString:@""])&& ([leaderName