数据库显示

int inquire_nocb(sqlite3 *db)
{
int nrow,ncolumn;
char **azresult;
char *sql;
char *errmsg = NULL;


int i;
sql = "select * from mytable;";


if(sqlite3_get_table(db,sql,&azresult,&nrow,&ncolumn,&errmsg) != SQLITE_OK)
{
printf("遍历失败!%s\n",errmsg);
exit(-1);
}


printf("row: %d   column: %d\n",nrow,ncolumn);


for(i = 0;i < (nrow + 1) * ncolumn;i++)
{
printf("%10s",azresult[i]);


if((i+1) % ncolumn ==0)
printf("\n");
}

sqlite3_free_table(azresult);
}