使用sqlite3创建数据库
发布时间:2020-12-12 19:23:40 所属栏目:百科 来源:网络整理
导读:创建数据库 #include stdio.h #include stdlib.h #include sqlite3.h static int callback( void *NotUsed, int argc, char **argv, char **azColName){ int i; for (i= 0 ; iargc; i++){ printf ( "%s = %sn" ,azColName[i],argv[i] ? argv[i] : "NULL" );
创建数据库#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>
static int callback(void *NotUsed,int argc,char **argv,char **azColName){
int i;
for(i=0; i<argc; i++){
printf("%s = %sn",azColName[i],argv[i] ? argv[i] : "NULL");
}
printf("n");
return 0;
}
int main(int argc,char* argv[])
{
sqlite3 *db;
char *zErrMsg = 0;
int rc;
char *sql;
/* Open database */
rc = sqlite3_open("test.db",&db);
if( rc ){
fprintf(stderr,"Can't open database: %sn",sqlite3_errmsg(db));
exit(0);
}else{
fprintf(stdout,"Opened database successfullyn");
}
/* Create SQL statement */
sql = "CREATE TABLE COMPANY("
"ID INT PRIMARY KEY NOT NULL,"
"NAME TEXT NOT NULL,"
"AGE INT NOT NULL,"
"ADDRESS CHAR(50),"
"SALARY REAL );";
/* Execute SQL statement */
rc = sqlite3_exec(db,sql,callback,0,&zErrMsg);
if( rc != SQLITE_OK ){
fprintf(stderr,"SQL error: %sn",zErrMsg);
sqlite3_free(zErrMsg);
}else{
fprintf(stdout,"Table created successfullyn");
}
sqlite3_close(db);
return 0;
}
编译gcc -o main test.c -l sqlite3
// * 链接 sqlite3 库
输出
参考创建数据库: www.runoob.com/sqlite/sqlite-c-cpp.html Makefile: blog.csdn.net/haoel/article/details/2887 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |