用C語言做個sqlite數(shù)據(jù)庫？
#include <stdio.h>
#include "SQLite/sqlite3.h"
int callback(void *data, int argc, char **argv, char **colName);
int main()
{
sqlite3 *db;
if (sqlite3_open("DBFile.db", &db))
{
printf("Can't open database: %s\n", sqlite3_errmsg(db)); exit(0);
}
else
{
printf("Opened database successfully\n");
const char *sql = "select * from Student";
const char* data = "callback function called";
char *errMsg;
if(SQLITE_OK == sqlite3_exec(db, sql, callback, (void*)data, &errMsg))
{
printf("Operation done successfully\n");
if (SQLITE_OK == sqlite3_exec(db, "delete from Student where id=-100", NULL, NULL, &errMsg))
{
printf("The record deleted");
}
else
{
printf("SQL error: %s\n", errMsg);
sqlite3_free(errMsg);
}
}
else
{
printf("SQL error: %s\n", errMsg);
sqlite3_free(errMsg);
}
}
sqlite3_close(db);
return 0;
}
int callback(void *data, int argc, char **argv, char **colName)
{
int i;
fprintf(stderr, "%s:\n", (const char*)data);
for(i=0; i<argc; i++)
{
printf("%s = %s\n", colName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n");
return 0;
}