Sqlite3源码部署

2024年3月12日发(作者：)

int main()

{

sqlite3 *db = NULL;

int result;

result = sqlite3_open("", &db);

if (SQLITE_OK != result)

{

printf("Create/Open error! n");

}

printf("Create/Open success!! n");

const char *sqlStr1 = "create table table2(sid integer primary key not null,age string);";

result = sqlite3_exec(db, sqlStr1, 0, 0, 0);

if (SQLITE_OK != result)

{

printf("create table table1 error! n");

return 0;

}

printf("create table table1 success! n");

const char* sqlStr2 = "insert into table1() values(1,'name1');";

result = sqlite3_exec(db, sqlStr2, 0, 0, 0);

if (SQLITE_OK != result)

{

printf("insert table table1 error! n");

return 0;

}

printf("insert table table1 success! n");

sqlite3_close(db);

return 0;

}