int main(int argc,char **argv)
{
sqlite3 *db;
int res = 0;
char *zErr;
sqlite3_stmt *stmt;
res = sqlite3_open("user.db", &db);
if (res)
{
fprintf(stdout, "open db error");
sqlite3_close(db);
exit(1);
}
const char *sql = "create table user_info(id int,name text);";
res = sqlite3_exec(db, sql, NULL, NULL, &zErr); //准备模板
if (res != SQLITE_OK)
{
fprintf(stdout, "sqlite3 exec faild");
}
sqlite3_free(zErr);
///测试绑定bind。
sql = "insert into user_info(id,name)values(?,?)";
res = sqlite3_prepare_v2(db, sql, strlen(sql), &stmt, NULL);
if (res != SQLITE_OK)
{
fprintf(stdout, "prepare is faild");
}
const char *name = "mgl";
for(int i=0;i<10;i++)
{
sqlite3_bind_int(stmt, 1, i);
sqlite3_bind_text(stmt, 2, name, strlen(name), SQLITE_STATIC);
sqlite3_step(stmt);
sqlite3_reset(stmt);
}
sqlite3_finalize(stmt);
sqlite3_close(db);
return 0;
}
执行结果