#include "stdafx.h" #include <stdio.h> #include "sqlite3.h" #include <process.h> #pragma comment(lib,"sqlite3.lib") 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 _tmain(int argc, char* argv[]) { sqlite3 *db; char *zErrMsg = 0; int rc; if( argc!=2 ){ fprintf(stderr, "Usage: %s DATABASE\n", argv[0]); system("pause"); return(1); } rc = sqlite3_open(argv[1], &db); if( rc ){ fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db)); sqlite3_close(db); return(1); } //char* sqlstatement = "create table test(int id,varchar name);"; //char* sqlstatement = "insert into test values(1,'hello');"; char* sqlstatement = "select * from test;"; rc = sqlite3_exec(db, sqlstatement, callback, 0, &zErrMsg); if( rc!=SQLITE_OK ){ printf("%s\n",argv[2]); fprintf(stderr, "SQL error: %s\n", zErrMsg); sqlite3_free(zErrMsg); } sqlite3_close(db); system("pause"); return 0; }
|