sqlite3 读取表数据

先上一段 sample

#include <stdio.h>
#include <string.h>
#include "sqlite3.h"

int main()
{
	sqlite3 *db;
	char *zErrMsg = 0;
	int rc;
	char **result;
	int row, column;
	int i, j;
	
	rc = sqlite3_open("gt_db.db", &db);
	if( rc ){
		fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
		sqlite3_close(db);
		return -1;
	}	


	rc = sqlite3_get_table(db, "SELECT * FROM DeviceMap", &result, &row, &column, &zErrMsg);

	if (rc == SQLITE_OK) {
		printf("row = %d, column = %d\n", row, column);
		printf(result[0]);
		for (i = 0; i <= row; i++) {
			printf("----------- %d -------------\n", i);
			for (j = 0; j < column; j++) {
				printf("%s  ",  result[i*column + j]);
			}
		}
	}
	
	sqlite3_free_table(result);


	sqlite3_close(db);

	return 0;
}
#include <stdio.h>
#include <