#include <iostream>
#include <stdio.h>
#include <stdlib.h>
#include "./sqlite3_lib/sqlite3.h"
static int _callback_exec(void * notused,int argc, char ** argv, char ** aszColName)
{
int i;
for ( i=0; i<argc; i++ )
{
printf( "%s = %s/n", aszColName[i], argv[i] == 0 ? "NUL" : argv[i] );
}
return 0;
}
void main(int argc,char *argv[])
{
const char * sSQL = "select * from animal;";
const char * sSQL1 = "insert into animal(id) values('233');";
char * pErrMsg = 0;
int ret = 0;
sqlite3 * db = 0;
ret = sqlite3_open("demo.sqb", &db);
printf("%d/n",ret);
if ( ret != SQLITE_OK )
{
fprintf(stderr, "Could not open database: %s", sqlite3_errmsg(db));
exit(1);
}
printf("Successfully connected to database/n");
sqlite3_exec( db, sSQL, _callback_exec, 0, &pErrMsg );
if ( ret != SQLITE_OK )
{
fprintf(stderr, "SQL error: %s/n", pErrMsg);
sqlite3_free(pErrMsg);
}
sqlite3_exec( db, sSQL1, _callback_exec, 0, &pErrMsg );
if ( ret != SQLITE_OK )
{
fprintf(stderr, "SQL error: %s/n", pErrMsg);
sqlite3_free(pErrMsg);
}
sqlite3_exec( db, sSQL, _callback_exec, 0, &pErrMsg );
if ( ret != SQLITE_OK )
{
fprintf(stderr, "SQL error: %s/n", pErrMsg);
sqlite3_free(pErrMsg);
}
sqlite3_close(db);
db = 0;
getchar();
}