#include "sqlite3.h"
#include <stdio.h>
#include <string.h>
#include <errno.h>
#define DEMO_DB "/tmp/demo.db"
#define DEMO_TABLE "bb"
struct employee_s {
int empno;
char ename[32];
char job[16];
int deptno;
};
int sqlite3_db_blob_insert()
{
sqlite3 *db = NULL;
sqlite3_stmt *stmt = NULL;
char sql[1024];
int ret = 0;
struct employee_s emp = {1, "tom", "programmer", 1035};
ret = sqlite3_open(DEMO_DB, &db);
if (ret != SQLITE_OK) {
fprintf(stderr, "db open fail, errcode[%d], errmsg[%s]\n", ret, sqlite3_errmsg(db));
sqlite3_close(db);
return -1;
}
memset(sql, 0, sizeof(sql));
sprintf(sql, "insert into %s values(?, ?)", DEMO_TABLE);
printf("sql select: \"%s\"\n", sql);
ret = sqlite3_prepare(db, sql, strlen(sql), &stmt, NULL);
if (ret != SQLITE_OK) {
fprintf(stderr, "db prepare fail, errcode[%d], errmsg[%s]\n", ret, sqlite3_errm
sqlite3编程—处理二进制blob
最新推荐文章于 2025-06-21 13:39:47 发布