用C語言做個sqlite資料庫~

#include &ltstdio.h>

#include "SQLite/sqlite3.h"

int callback(void *data， int argc， char **argv， char **colName)

int main()

{

sqlite3 *db

if (sqlite3_open(""， &db))

{

printf("Can't open database: %sn"， sqlite3_errmsg(db)) exit(0)

}

else

{

printf("Opened database successfullyn")

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 successfullyn")

if (SQLITE_OK == sqlite3_exec(db， "delete from Student where id=-100"， NULL， NULL， &errMsg))

{

printf("The record deleted")

}

else

{

printf("SQL error: %sn"， errMsg)

sqlite3_free(errMsg)

}

}

else

{

printf("SQL error: %sn"， 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 = %sn"， colName[i]， argv[i] ? argv[i] : "NULL")

}

printf("n")

return 0

}