main.cpp

能够运行的c调用sqlite的程序1

#include <stddef.h>
#include <stdlib.h>
#include <stdio.h>
#include <sqlite3.h>
#include <string.h>

int main (int argc, char **argv)
{
sqlite3 *db;
int rc, len, i, cols, type;
const char *next;
sqlite3_stmt *st;

if (argc != 3) {
fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
exit(EXIT_FAILURE);
}
rc = sqlite3_open(argv[1], &db);
if (rc != SQLITE_OK) {
fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
sqlite3_close(db);
exit(EXIT_FAILURE);
}
len = strlen(argv[2]);
rc = sqlite3_prepare(db, argv[2], len, &st, &next);
if (rc != SQLITE_OK) {
fprintf(stderr, "Error on sqlite3_prepare: %s\n", sqlite3_errmsg(db));
sqlite3_close(db);
exit(EXIT_FAILURE);
}
for (;;) {
rc = sqlite3_step(st);
if (rc == SQLITE_ROW) {
cols = sqlite3_column_count(st);
for (i = 0; i < cols; i++) {
type = sqlite3_column_type(st, i);
switch (type) {
case SQLITE_INTEGER:
printf("%s[%d] = %d\n", sqlite3_column_name(st, i),i, sqlite3_column_int(st, i));
break;
case SQLITE_FLOAT:
printf("%s[%d] = %f\n", sqlite3_column_name(st, i),i, sqlite3_column_double(st, i));
break;
case SQLITE_TEXT:
printf("%s[%d] = '%s'\n", sqlite3_column_name(st, i),i, sqlite3_column_text(st, i));
break;
case SQLITE_BLOB:
printf("%s[%d] = BLOB[%d bytes]\n",sqlite3_column_name(st, i),i, sqlite3_column_bytes(st, i));
break;
case SQLITE_NULL:
printf("%s[%d] = NULL\n", sqlite3_column_name(st, i),i);
break;
default:
printf("UNDEFINED Column[%d]\n", i);
break;
}
}
printf("\n");
} else if (rc == SQLITE_DONE) {
break;
} else {
fprintf(stderr, "Error on sqlite3_step: %s\n", sqlite3_errmsg(db));
sqlite3_close(db);
exit(EXIT_FAILURE);
}
}
rc = sqlite3_finalize(st);
if (rc != SQLITE_OK) {
fprintf(stderr, "Error on sqlite3_finalize: %s\n", sqlite3_errmsg(db));
sqlite3_close(db);
exit(EXIT_FAILURE);
}
sqlite3_close(db);
exit(EXIT_SUCCESS);
return 0;
}