sqlite3 callback

/* * test.c * *  Created on: 2012-6-28 *      Author: xy */#include <sqlite3.h>#include <stdio.h>static int callback(void *NotUsed, int argc, char **argv, char **azColName){int i;for(i=0; i<argc; i++)printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");printf("\n");return 0;}int main(int argc, char *argv[]){sqlite3 *db;char *zErrMsg = 0;int rc = sqlite3_open("test.db", &db);if( rc ){fprintf(stderr, "Can't open database: %s/n", sqlite3_errmsg(db));sqlite3_close(db);return -1;}rc = sqlite3_exec(db, "\ PRAGMA foreign_keys = ON;\", 0, 0, &zErrMsg);if( rc!=SQLITE_OK ){fprintf(stderr, "1SQL error: %s\n", zErrMsg);sqlite3_free(zErrMsg);}/*rc = sqlite3_exec(db, "\INSERT INTO Students(TeacherId) VALUES(5);\", 0, 0, &zErrMsg);if( rc!=SQLITE_OK ){fprintf(stderr, "2SQL error: %s\n", zErrMsg);sqlite3_free(zErrMsg);}*/rc = sqlite3_exec(db, "\ select * from TEACHERs;\", callback, 0, &zErrMsg);if( rc!=SQLITE_OK ){fprintf(stderr, "2SQL error: %s\n", zErrMsg);sqlite3_free(zErrMsg);}sqlite3_close(db);}