在#include <stdio.h>
#include <sqlite3.h>
#include <stdlib.h>
#include <sys/types.h>
#include <sys/stat.h>
#include <fcntl.h>
#include <string.h>
int main(int argc, const char *argv[])
{
//打开要导入的文件
FILE* fd=fopen("./dict.txt","r");
if(fd<0){
perror("open");
return 0;
}
printf("打开文件成功\n");
//打开数据库
sqlite3 *db=NULL;
if(sqlite3_open("./sq.db",&db)!=0){
fprintf(stderr,"line:%d sqlite3_open:%s\n",__LINE__,sqlite3_errmsg(db));
fprintf(stderr,"line:%d sqlite3_open:%d\n",__LINE__,sqlite3_errcode(db));
return 0;
}
printf("打开数据库成功\n");
//创建一张表格
char c[128]="create table if not exists stu3(name char,chinese char)";
char *errmsg=NULL;
if(sqlite3_exec(db,c,NULL,NULL,&errmsg)){
fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,sqlite3_errmsg(db));
fprintf(stderr,"line:%d sqlite3_exec:%d\n",__LINE__,sqlite3_errcode(db));
return 0;
}
printf("创建成功\n");
char chinese[200]="";
char name[60]="";
char buf[300]="";
char d[128]="";
//将文件中的数据储存到name和chinese中;
while(fgets(buf,sizeof(buf),fd)!=NULL){
char* p=buf;
while(1){
if(*p!=' ' || (*p != ' ' && *(p+1) != ' ')){
p++;
}else {
break;
}
}
*p='\0';
p++;
strcpy(name,buf);
while(*p==' '){
p++;
}
strcpy(chinese,p);
//循环存入到数据库中
sprintf(d,"insert into stu3 values(\"%s\",\"%s\");",name,chinese);
if(sqlite3_exec(db,d,NULL,NULL,&errmsg)!=0){
fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,sqlite3_errmsg(db));
fprintf(stderr,"line:%d sqlite3_exec:%d\n",__LINE__,sqlite3_errcode(db));
return 0;
}
bzero(d,sizeof(d));
bzero(buf,sizeof(buf));
}
return 0;
}
这里插入代码片