初入sqlite（2）

//c语言获取数据表
//sql :select ruleid,rulename,key1,key2,key3,key4 from kwmrule  where taskid = 1  
char **result2;
                int row2=0,column2=0;
                int temprow2 = 0;
                rc =sqlite3_get_table(ppdb,sql,&result2,&row2,&column2,&zErrMsg);
                for(temprow2 = 0;temprow2<row2;temprow2++)
                {
                    int a=0;
                    for(a=0;a<(row2+1)*column2;a++)
                    {
                        if (a== column2 + column2 * temprow2)
                        {
                            printf("ruleid:%s,rulename:%s,key1:%s,key2:%s,key3:%s,key4:%s \n", result2[a],result2[a+1],result2[a+2],result2[a+3],result2[a+4],result2[a+5]);

                        }
                    }
                }

结果：

ruleid:1,rulename:规则1-1,key1:十月,key2:下雪,key3:路滑,key4:小心
ruleid:2,rulename:规则1-2,key1:北京,key2:雾霾,key3:严重,key4:超标
ruleid:3,rulename:规则1-3,key1:下雪,key2:路滑,key3:小心,key4:0
ruleid:4,rulename:规则1-4,key1:飞机,key2:歼击机,key3:战斗机,key4:中国
ruleid:5,rulename:规则1-5,key1:南海,key2:越南,key3:0,key4:0

 

所以只需关心最后要获取的数据字段列的字段名与其顺序，就可以很轻松的拿到对应的数据。