服务器
#include<myy.h>
#include<sqlite3.h>
#define err(msg) do{printf("__%d__",__LINE__);perror(msg);return -1;}while(0)
#define PORT 8888
#define IP "192.168.125.51"
typedef void (*sighandler_t)(int);
typedef struct
{
char flag;
char name[20];
char text[128];
}msg;
char mean[32]="";
int do_register(msg *usr,int afd,sqlite3* db)
{
char sql[256] = "" ;
sprintf(sql,"insert into usr values('%s','%s');",usr->name,usr->text);
char* errmsg = NULL;
if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != SQLITE_OK)
fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
strcpy(usr->text,"usr name already exist");
printf("usr name already exist\n");
}
else
{
printf("registeration is ok\n");
strcpy(usr->text,"usr name registeration successed");
}
if(send(afd,usr,sizeof(msg),0)<0)err("send");
if(recv(afd,usr,sizeof(msg),0)<0)err("recv");
return 0;
}
int do_login(msg *usr,int afd,sqlite3* db)
{
sqlite3* db_delete= NULL;
char sql[256] ="";
char* errmsg = NULL;
char **pres=NULL;
int row,column;
sprintf(sql,"select * from usr where name='%s' and password='%s';",usr->name,usr->text);
if(sqlite3_get_table(db, sql,&pres,&row,&column, &errmsg) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_get_table:%s\n", __LINE__, errmsg);
return -1;
}
if(row==1)
{
printf("login is ok\n");
bzero(usr->text,sizeof(usr->text));
strcpy(usr->text,"ok");
}
else{
printf("login is failed\n");
strcpy(usr->text,"usr name or password inputs error!");
}
if(send(afd,usr,sizeof(msg),0)<0)err("send");
if(recv(afd,usr,sizeof(msg),0)<0)err("recv");
return 0;
}
int callback_s(void* arg ,int columns, char** column_text, char** column_name)
{
for(int i=1; i<columns; i+=2)
{
strcpy(mean,*(column_text+i));
}
printf("\n");
return 0; }
int do_search(msg *usr,int afd,sqlite3* db)
{
char sql[256] ="",sql_h[256]="",word[64]="",TIME[32]="";
time_t t;
struct tm *info = NULL;
int flag=0;
strcpy(word,usr->text);
t =time(NULL);
info =localtime(&t);
sprintf(TIME,"%d-%02d-%02d %02d:%02d:%02d",info->tm_year+1900, info->tm_mon+1, info->tm_mday,info->tm_hour, info->tm_min, info->tm_sec);
sprintf(sql,"select * from dict where word='%s';",usr->text);
char* errmsg = NULL;
if(sqlite3_exec(db, sql,callback_s,&flag, &errmsg) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
return -1;
}
bzero(usr->text,sizeof(usr->text));
strcpy(usr->text,mean);
sprintf(sql_h,"insert into history values('%s','%s','%s',\'%s\');",usr->name,word,mean,TIME);
bzero(mean,sizeof(mean));
bzero(word,sizeof(word));
if(sqlite3_exec(db,sql_h,NULL,NULL,&errmsg) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
}
if(send(afd,usr,sizeof(msg),0)<0)err("send");
if(recv(afd,usr,sizeof(msg),0)<0)err("recv");
return 0;
}
int callback_h(void* arg ,int columns, char** column_text, char** column_name)
{
int afd=*(int *)arg;
msg usr;
char word[64]="",TIME[32]="";
bzero(usr.text,sizeof(usr.text));
bzero(usr.name,sizeof(usr.name));
for(int i=0; i<columns; i++)
{
switch(i)
{
case 0: {strcpy(usr.name,*(column_text));}break;
case 1: {strcpy(word,*(column_text+1));}break;
case 2: {strcpy(mean,*(column_text+2));}break;
case 3: {strcpy(TIME,*(column_text+3));}break;
}
}
sprintf(usr.text,"%s:%s\t%s\t%s",usr.name,word,mean,TIME);
printf("%s\n",usr.text);
if(s waitpidend(afd,&usr,sizeof(msg),0)<0)err("send");
return 0; }
int do_history(msg* usr,int afd,sqlite3* db)
{
char sql[256]="";
sprintf(sql,"select * from history where name='%s';",usr->name);
char* errmsg = NULL;
if(sqlite3_exec(db, sql,callback_h,&afd, &errmsg) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_get_table:%s\n", __LINE__, errmsg);
return -1;
}
printf("this is all\n");
usr->text[0]='\0';
if(send(afd,usr,sizeof(msg),0)<0)err("send");
exit(0);
}
void handler(int sig)
{
while(waitpid(-1,NULL,WNOHANG)>0);
}
int main(int argc, const char *argv[])
{
int afd,sfd=socket(AF_INET,SOCK_STREAM,0);
if(sfd<0)err("socket");
int reuse = 1;
if(setsockopt(sfd, SOL_SOCKET, SO_REUSEADDR, &reuse, sizeof(reuse)) < 0)err("setsockopt");
struct sockaddr_in sin;
sin.sin_family=AF_INET;
sin.sin_port=htons(PORT);
sin.sin_addr.s_addr=inet_addr(IP);
if(bind(sfd,(struct sockaddr*)&sin,sizeof(sin))<0)err("bind");
if(listen(sfd,10)<0)err("listen");
struct sockaddr_in cin;
socklen_t addrlen=sizeof(cin);
if(SIG_ERR==signal(SIGCHLD,handler))err("signal");
sqlite3* db = NULL;
if(sqlite3_open("./my.db", &db) != SQLITE_OK)
{
printf("err_code:%d\n", sqlite3_errcode(db));
printf("errmsg:%s\n", sqlite3_errmsg(db));
fprintf(stderr, "__%d__ sqlite3_open failed\n", __LINE__);
return -1;
}
char* sql_dict = "create table if not exists dict (word char,mean char);" ;
char* sql_usr = "create table if not exists usr (name char primary key,password char);" ;
char* sql_history = "create table if not exists history (name char,word char,mean char,time char);" ;
char* errmsg = NULL;
if(sqlite3_exec(db, sql_usr, NULL, NULL, &errmsg) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
return -1;
}
if(sqlite3_exec(db, sql_history, NULL, NULL, &errmsg) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
return -1;
}
if(sqlite3_exec(db, sql_dict, NULL, NULL, &errmsg) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
return -1;
}
msg usr;
char choose = 0;
int res=0,pid;
while(1)
{
if((afd=accept(sfd,(struct sockaddr*)&sin,&addrlen))<0)err("accept");
pid=fork();
if(pid>0)
{
close(afd);
}
else if(pid==0)
{
memset(&usr,0,sizeof(msg));
res=recv(afd,&usr,sizeof(usr),0);
if(res<0)err("recv");
printf("flag=%c\n",usr.flag);
while(res>0)
{
switch(usr.flag)
{
case 'R':do_register(&usr,afd,db);break;
case 'L':do_login(&usr,afd,db);break;
case 'S':do_search(&usr,afd,db);break;
case 'H':do_history(&usr,afd,db);break;
default:printf("error\t261\n");
}
}
}
}
return 0;
}
客户端文章来源：https://www.toymoban.com/news/detail-619358.html
#include <sqlite3.h>
#include<myy.h>
#define err(msg) do{printf("__%d__",__LINE__);perror(msg);return -1;}while(0)
#define PORT 8888
#define IP "192.168.125.51"
typedef struct
{
char flag;
char name[20];
char text[128];//密码或单词
}msg;
int do_register(msg *usr,int sfd)
{
printf("注册中\n");
ssize_t res;
usr->flag='R';
printf("用户名：");
scanf("%s",usr->name);
printf("密码:");
scanf("%s",usr->text);
if(send(sfd,usr,sizeof(msg),0)<0)err("send");
res = recv(sfd,usr, sizeof(msg), 0);
if(res < 0)err("recv");
else if(0 == res)
{
printf("server is off-line\n");
}
printf("%s\n",usr->text);
return 0;
}
int do_login(msg *usr,int sfd)
{
printf("登录...\n");
ssize_t res;
usr->flag='L';
printf("用户名：");
scanf("%s",usr->name);
printf("密码:");
scanf("%s",usr->text);
if(send(sfd,usr,sizeof(msg),0)<0)err("send");
res = recv(sfd,usr,sizeof(msg),0);
if(res < 0)err("recv");
if(strncmp(usr->text,"ok",3)==0)
{
printf("%s : log_in successfully\n",usr->name);
return 1;
}
else{
printf("%s\n",usr->text);
}
return 0;
}
int do_search(msg *usr,int sfd)
{
printf("#退出\n");
ssize_t res;
usr->flag='S';
while(1)
{
printf("查询的单词：");
scanf("%s",usr->text);
if(strcmp(usr->text,"#")==0)break;
if(send(sfd,usr,sizeof(msg),0)<0)err("send");
res=recv(sfd,usr, sizeof(msg), 0);
if(res<0)err("recv");
printf("mean:%s\n",usr->text);
}
}
int do_history(msg *usr,int sfd)
{
usr->flag='H';
ssize_t res;
if(send(sfd,usr,sizeof(msg),0)<0)err("send");
printf("the following is history:\n");
while(1)
{
res = recv(sfd,usr, sizeof(msg), 0);
if(res<0)err("recv");
else if(res>0)
{
printf("%s\n",usr->text);
}
else
{
printf("this is all history\n");
break;
}
}
return 0;
}
int main(int argc, const char *argv[])
{ int sfd=socket(AF_INET,SOCK_STREAM,0);
if(sfd<0)err("msg");
int reuse = 1;
if(setsockopt(sfd, SOL_SOCKET, SO_REUSEADDR, &reuse, sizeof(reuse)) < 0)err("setsockopt");
struct sockaddr_in sin;
sin.sin_family=AF_INET;
sin.sin_port=htons(PORT);
sin.sin_addr.s_addr=inet_addr(IP);
if(connect(sfd,(struct sockaddr*)&sin,sizeof(sin))<0)err("connect");
msg usr;
char choose = 0;
int choice=0;//不初始化
while(1)
{
memset(&usr,0,sizeof(msg));
system("clear");
puts("1. 注册");
puts("2. 登录");
puts("3. 退出");
printf("请输入选项>>>");
scanf("%c",&choose);
switch(choose)
{
case '1':
do_register(&usr,sfd);
break;
case '2':
if(do_login(&usr,sfd)>0)
{
goto log_in;
}
break;
case '3':
close(sfd);
exit(0);
break;
default:
printf("错误，重新输入\n");
}
printf("清屏>>>\n");
while(getchar()!=10);
}
log_in:
while(1)
{
printf("1.查询单词");
printf("2. 历史记录");
printf("3. 退出");
printf("输入选项>>>");
scanf("%d",&choice);
getchar();
switch(choice)
{
case 1:
do_search(&usr,sfd);
break;
case 2:
do_history(&usr,sfd);
break;
case 3:
close(sfd);
exit(0);
break;
default:
printf("输入错误，请重新输入\n");
}
}
return 0;
}
导入文章来源地址https://www.toymoban.com/news/detail-619358.html
#include <stdio.h>
#include <sqlite3.h>
#include <string.h>
int main(int argc, const char *argv[])
{
//打开数据库
sqlite3* db = NULL;
if(sqlite3_open("./my.db", &db) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_open:%s\n", __LINE__, sqlite3_errmsg(db));
return -1;
}
char sql[400] = "create table if not exists dict (word char, mean char)";
char* errmsg = NULL;
if(sqlite3_exec(db, sql, NULL, NULL, &errmsg) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__,errmsg);
return -1;
}
FILE* fp = fopen("./dict.txt", "r");
if(NULL == fp)
{
perror("fopen");
return -1;
}
char buf[300] = "";
char word[50]="", mean[300]="";
int i = 0;
while(fgets(buf, sizeof(buf), fp) != NULL)
{
buf[strlen(buf)-1] = 0;
for(i=0; i<strlen(buf)-2; i++)
{
if(buf[i]!=' ' && buf[i+1]==' ' && buf[i+2]==' ')
{
strncpy(word, buf, i+1);
}
else if(buf[i]==' '&& buf[i+1]==' ' && buf[i+2]!=' ')
{
strcpy(mean, (buf+i+2));
break;
}
}
sprintf(sql, "insert into dict values(\"%s\", \"%s\");", word, mean);
if(sqlite3_exec(db, sql, NULL, NULL, &errmsg) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__,errmsg);
return -1;
}
bzero(word, sizeof(word));
bzero(mean, sizeof(mean));
}
return 0;
}
到了这里，关于电子词典项目（有借鉴）的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！
