#include "myhead.h"
int main(int argc, const char *argv[])
{
//打开数据库
sqlite3 *db;
if(sqlite3_open("./sq.db",&db)!=SQLITE_OK)
{
fprintf(stderr,"sqlite3_open:%s %d __%d__\n",\
sqlite3_errmsg(db),sqlite3_errcode(db),__LINE__);
return -1;
}
printf("sqlite3_open success\n");
FILE *fp=fopen("./dict.txt","r");
if(fp==NULL)
{
fprintf(stderr,"line:%d ",__LINE__);
perror("fopen");
return -1;
}
//创建一个表格,sql怎么写代码就怎么写
//char *ptr="create table stu(id int ,name char ,score float)";
char str[]="create table if not exists dict(word char,meaning char)";
char *errmsg=NULL;
if(sqlite3_exec(db,str,NULL,NULL,&errmsg)!=SQLITE_OK)
{
fprintf(stderr,"sqlite3_exec:%s __%d__\n",errmsg,__LINE__);
return -1;
}
printf("create table stu success\n");
char buf1[128]="";
char buf2[128]="";
ssize_t res=0;
while(1)
{
if(fgets(buf1, sizeof(buf1), fp) == NULL)
{
break;
}
buf1[strlen(buf1)-1] = 0;
char *word=buf1;
char *meaning=buf1;
char* p = word;
while(*p++ != ' ');
p--;
char* q = p;
if(*(++p) == ' ')
{
*q = 0;
while(*p++ == ' ');
p--;
meaning = p;
}
else
{
p++;
while(*p++ != ' ');
q = p;
*q = 0;
while(*p++ == ' ');
p--;
meaning = p;
}
//插入数据
sprintf(buf2, "insert into dict values (\"%s\",\"%s\");", word, meaning);
char *errmsg2 = NULL;
if(sqlite3_exec(db, buf2, NULL, NULL, &errmsg2) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg2);
return -1;
}
}
//关闭数据库
if(sqlite3_close(db)!=SQLITE_OK)
{
fprintf(stderr,"sqlite3_close:%s %d __%d__\n",\
sqlite3_errmsg(db),sqlite3_errcode(db),__LINE__);
return -1;
}
printf("sqlite3_close success\n");
fclose(fp);
return 0;
}
05-07
196
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
09-23
297
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
07-12
5764
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
06-26
9404
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交