sql/sqlite/sqlite3 Ïò±íÖвåÈëÊý¾Ý

#include <iostream>
#include <string>
#include <tchar.h>
#include "sqlite3\\sqlite3.h"
#pragma comment (lib, "sqlite3\\sqlite3.lib")

static const char* data = "Callback function called";
static int Callback(void *data, int argc, char **argv, char **pszColName){
 printf("%s: \n", (const char*)data);
 for(int i=0; i<argc; i++){
  printf("%s = %s\n", pszColName[i], argv[i] ? argv[i] : "NULL");
 }
 printf("\n");
 return 0;
}

int main(int argc, char* argv[])
{
 sqlite3 *pDataBase = NULL;
 char *pErrMsg = 0;
 int   iResult = 0;
 char *pszSql = NULL;

 /* Open database */
 iResult = sqlite3_open("test.db", &pDataBase);
 if( iResult != SQLITE_OK ){
  printf( "Can't open database: %s\n", sqlite3_errmsg(pDataBase));
  exit(0);
 }else{
  printf( "Opened database successfully\n");
 }

 /* Create SQL statement */
 pszSql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) "  \
  "VALUES (1, 'Zhao', 32, 'BeiJing', 10000.00 ); " \
  "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) "  \
  "VALUES (2, 'Qian', 25, 'ShangHai', 20000.00 ); "     \
  "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" \
  "VALUES (3, 'Sun', 23, 'GuangZhou', 20000.00 );" \
  "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" \
  "VALUES (4, 'Li', 25, 'WuHan', 9000.00 );";

 /* Execute SQL statement */
 iResult = sqlite3_exec(pDataBase, pszSql, Callback, 0, &pErrMsg);
 if( iResult != SQLITE_OK )
 {
  printf( "SQL error: %s\n", pErrMsg);
  sqlite3_free(pErrMsg);
 }else{
  printf( "Records created successfully\n");
 }
 sqlite3_close(pDataBase);
 return 0;
}