在线词典--（一、流程分析）

在线词典实现框架

 应用综合项目：

1、在线英英词典

2、项目功能描述

3、用户注册和登录验证

4、服务器端将用户信息和历史记录保存在数据库中，客户端输入用户名和密码，服务器端在数据库中查找、匹配，返回结果

5、单次在线翻译

6、根据客户端输入的单次在字典文件中搜索

7、历史记录查询

8、项目分析

项目流程框架：

客户端

服务器端：

实现：

在终端，创建数据库，dic.db

创建记录table

create table user  (name char , passwd  char , date char);

create table record (name char , date char , word char);

在原有基础上增加实现

1、在搭建的框架中实现并发，实现多客户端的注册登录
2、同时支持管理员（用户名：root,密码：1）和普通用户
3、管理员可以查询所有用户的使用记录

#include <stdio.h>
#include <stdlib.h>
#include <sys/types.h>      
#include <sys/socket.h>
#include <sys/socket.h>
#include <netinet/in.h>
#include <arpa/inet.h>
#include <string.h>

#define N 32

#define R 1  //usr--register
#define L 2  //usr--login
#define Q 3  //usr--query
#define H 4  //root--history
#define Y 5  //root--login
#define X 6  //root--user record

//定义通信双方的MSG信息结构体
typedef struct {
    int type;
    char name[N];
    char data[256];
}MSG;

int do_regiser(int sockfd, MSG *msg);
int do_login(int sockfd, MSG *msg);
int do_login_root(int sockfd, MSG *msg);
int do_query(int sockfd, MSG *msg);
int do_history(int sockfd, MSG *msg);
int do_user_record(int sockfd, MSG *msg);


int main(int argc, const char *argv[])
{
    int sockfd;
    struct sockaddr_in serveraddr;
    int num;
    MSG msg;

    if(argc != 3)
    {
        printf("Usage :%s serverip port.
", argv[0]);
        return -1;
    }

    if((sockfd = socket(AF_INET, SOCK_STREAM, 0)) < 0)
    {
        perror("fail to socket!
");
        return -1;
    }

    bzero(&serveraddr, sizeof(serveraddr));
    serveraddr.sin_family = AF_INET;
    serveraddr.sin_addr.s_addr = inet_addr(argv[1]);    //点分形式转为二进制数据
    serveraddr.sin_port = htons(atoi(argv[2]));  //先将字符型转为int型数据，再HBD->NBD 

    if(connect(sockfd, (struct sockaddr *)&serveraddr, sizeof(serveraddr)) < 0)
    {
        perror("connect error!
");
        return -1;
    }

    printf("Client starting...
");

    while(1)
    {
        printf("***************************************************
");
        printf("*     1.regiser  2.login  3.root login  4.quit    *
");
        printf("***************************************************
");
        printf("Please choose:");

        scanf("%d",&num);
        getchar();  //每次输入完毕会产生垃圾字符，清除

        switch(num)
        {
            case 1:
                do_regiser(sockfd, &msg);
                break;
            case 2:
                if(do_login(sockfd,&msg) == 1)
                {
                    goto next; //登录成功，跳到二级菜单
                }
                break;
            case 3:
                if(do_login_root(sockfd, &msg) == 1)
                {
                    goto next_root;
                }
            case 4:
                close(sockfd);
                exit(0);
                break;
            default:
                printf("Invalid data cmd.
");
        }
    }

next:   //二级菜单
    while(1)
    {
        printf("***************************************************
");
        printf("*        1.query word     2.quit        
");
        printf("***************************************************
");
        printf("Please choose:");

        scanf("%d",&num);
        getchar();  //每次输入完毕会产生垃圾字符，清除

        switch(num)
        {
            case 1:
                do_query(sockfd, &msg);
                break;
            case 2:
                close(sockfd);
                exit(1);
                break;
            default:
                printf("Invalid data cmd.
");
        }

    }


next_root:   //管理员二级菜单
    while(1)
    {
        printf("***************************************************
");
        printf("*    1.query word   2.history  3.user record  4.quit    *
");
        printf("***************************************************
");
        printf("Please choose:");

        scanf("%d",&num);
        getchar();  //每次输入完毕会产生垃圾字符，清除

        switch(num)
        {
            case 1:
                do_query(sockfd, &msg);
                break;
            case 2:
                do_history(sockfd, &msg);
                break;
            case 3:
                do_user_record(sockfd, &msg);
                break;
            case 4:
                close(sockfd);
                exit(1);
                break;
            default:
                printf("Invalid data cmd.
");
        }

    }
    return 0;
}

int do_regiser(int sockfd, MSG *msg)
{
    msg->type = R;
    printf("Intput name:");
    scanf("%s",msg->name);
    getchar();

    printf("Intput password:");
    scanf("%s",msg->data);

    if(send(sockfd, msg, sizeof(MSG), 0) < 0)
    {
        printf("fail to send.
");
        return -1;
    }

    if(recv(sockfd, msg, sizeof(MSG), 0) < 0)
    {
        printf("fail to recv.
");
        exit(1);
    }
    
    //ok! or usr already exist
    printf("%s
",msg->data);

    return 0;

}

int do_login(int sockfd, MSG *msg)
{
    msg->type = L;

    printf("Intput name:");
    scanf("%s",msg->name);
    getchar();

    printf("Intput password:");
    scanf("%s",msg->data);

    if(send(sockfd, msg, sizeof(MSG), 0) < 0)
    {
        printf("fail to send.
");
        exit(1);
    }

    if(recv(sockfd, msg, sizeof(MSG), 0) < 0)
    {
        printf("fail to recv.
");
        return -1;
    }

    if(strncmp(msg->data, "ok", 3) == 0)
    {
        printf("Login ok!
");
        return 1;
    }
    else
    {
        printf("%s
",msg->data);
    }


    return 0;
}


int do_login_root(int sockfd, MSG *msg)
{
    msg->type = Y;

    printf("name: root");
    sprintf(msg->name,"root");
    getchar();

    printf("Intput password:");
    scanf("%s",msg->data);

    if(send(sockfd, msg, sizeof(MSG), 0) < 0)
    {
        printf("fail to send.
");
        exit(1);
    }

    if(recv(sockfd, msg, sizeof(MSG), 0) < 0)
    {
        printf("fail to recv.
");
        return -1;
    }

    if(strncmp(msg->data, "ok", 3) == 0)
    {
        printf("ROOT Login ok!
");
        return 1;
    }
    else
    {
        printf("%s
",msg->data);
    }


    return 0;
}

int do_query(int sockfd, MSG *msg)
{
    msg->type = Q;
    puts("--------------------------
");

    while(1)
    {
        printf("Intput word:");
        scanf("%s",msg->data);

        //客户端输入结束并返回上一层
        if(strncmp(msg->data,"#",1) == 0) //比较前1个字符，相同返0
            break;
    
        //将要查询的单词发送给服务器
        if(send(sockfd, msg, sizeof(MSG), 0) < 0)
        {
            printf("file to send.
");
            return -1;
        }
        
        //等待接收服务器传递回来的注释单词信息
        if(recv(sockfd, msg, sizeof(MSG),0) < 0)
        {
            printf("file to recv.
");
            return -1;
        }
        printf("%s
",msg->data);
    }

    return 0;
}

int do_history(int sockfd, MSG *msg)
{
    msg->type = H;
    
    printf("Intput the user name:
");
    printf("** name * query date * word **
");
    scanf("%s",msg->name);
    send(sockfd, msg, sizeof(MSG), 0);

    //接收服务器传递回来的历史记录
    while(1)
    {
        recv(sockfd, msg, sizeof(MSG), 0);

        if(msg->data[0] == '')
            break;
        
        //输出历史记录信息
        printf("%s
", msg->data);
    }
    return 0;
}

//查询用户的登录与密码记录
int do_user_record(int sockfd, MSG *msg)
{
    msg->type = X;
    printf("Intput the user name:
");
    printf("** name * password * register date **
");
    scanf("%s",msg->name);
    send(sockfd, msg, sizeof(MSG), 0);

    //接收服务器传递回来的历史记录
    while(1)
    {
        recv(sockfd, msg, sizeof(MSG), 0);

        if(msg->data[0] == '')
            break;
        
        //输出历史记录信息
        printf("%s
", msg->data);
    }
    return 0;

}

#include <stdio.h>
#include <stdlib.h>
#include <sys/types.h>      
#include <sys/socket.h>
#include <sys/socket.h>
#include <netinet/in.h>
#include <arpa/inet.h>
#include <string.h>
#include <unistd.h>
#include <sqlite3.h>
#include <signal.h>
#include <time.h>

#define N 32
#define DATABASE "dic.db"

#define R 1  //usr--register
#define L 2  //usr--login
#define Q 3  //usr--query
#define H 4  //root--history
#define Y 5  //root--login
#define X 6  //root--user record

//定义通信双方的MSG信息结构体
typedef struct {
    int type;
    char name[N];
    char data[256];
}MSG;

int do_client(int acceptfd, sqlite3 *db);
void do_regiser(int acceptfd, MSG *msg, sqlite3 *db);
int do_login(int acceptfd, MSG *msg, sqlite3 *db);
int do_login_root(int acceptfd, MSG *msg, sqlite3 *db);
int do_query(int acceptfd, MSG *msg, sqlite3 *db);
int do_history(int acceptfd, MSG *msg, sqlite3 *db);
int history_callback(void *arg, int f_num,char** f_value ,char** f_name);
int do_searchword(int acceptfd,MSG *msg, char word[]);
int get_date(char *date);
int do_user_record(int acceptfd, MSG *msg, sqlite3 *db);
int user_record_callback(void *arg, int f_num,char** f_value ,char** f_name);


// ./server 192.168.31.123 5001
int main(int argc, const char *argv[])
{
    int sockfd;
    int acceptfd;
    struct sockaddr_in serveraddr;
    int num;
    MSG msg; 
    sqlite3 *db;
    pid_t pid;
    char *errmsg;
    char sql[128];

    if(argc != 3)
    {
        printf("Usage :%s server ip port.
", argv[0]);
        return -1;
    }

    /*打开数据库 */
    if(sqlite3_open(DATABASE, &db) != SQLITE_OK)
    {
        printf("%s
", sqlite3_errmsg(db));
        return -1;
    }
    else
    {
        printf("open DATABASE success.
");
    }
    
    //在dic,db 里面创建表格用户密码 user 与单词记录表 record      
    //创建套接字
    if((sockfd = socket(AF_INET, SOCK_STREAM, 0)) < 0)
    {
        perror("fail to socket!
");
        return -1;
    }

    bzero(&serveraddr, sizeof(serveraddr));
    serveraddr.sin_family = AF_INET;
    serveraddr.sin_addr.s_addr = inet_addr(argv[1]);    //点分形式转为二进制数据
    serveraddr.sin_port = htons(atoi(argv[2]));  //先将字符型转为int型数据，再HBD->NBD 

    /*地址快速重用 */
    int b_reuse = -1;
    setsockopt(sockfd, SOL_SOCKET, SO_REUSEADDR, &b_reuse, sizeof(int));

    /*绑定 */
    if(bind(sockfd, (struct sockaddr *)&serveraddr, sizeof(serveraddr)) < 0)
    {
        perror("file to bind.
");
        return -1;
    }
    
    /*将套接字设置为监听模式*/
    if(listen(sockfd, 5) < 0)
    {
        perror("fail to listen.
");
        return -1;
    }

    //处理僵尸进程
    signal(SIGCHLD, SIG_IGN);
    //SIG_IGN,信号处理方式设置为忽略，内核就会将僵尸子进程交给init处理

    printf("Server starting ... OK!
");

    while(1)
    {
        if((acceptfd = accept(sockfd, NULL, NULL)) < 0)
        {
            perror("fail to accept.
");
            return -1;
        }
        
        printf("Connect success!
");

        if((pid = fork()) < 0)
        {
            perror("fail to fork.");
            return -1;
        }
        else if(pid == 0) //子进程
        {
            //处理客户端的具体消息
            close(sockfd);  //关闭不需要的文件描述符，节省资源
            do_client(acceptfd, db);
            return 0;
        }
        else  //父进程，用来接收客户端的请求
        {
             close(acceptfd);
        }
    }
    close(acceptfd);
    return 0;
}

int do_client(int acceptfd, sqlite3 *db)
{
    MSG msg;
    //客户端关闭也会关闭套接字，进而跳出while循环
    while(recv(acceptfd, &msg, sizeof(msg), 0) > 0) //接收成功
    {
        printf("type:%d
", msg.type);
        switch(msg.type)
        {
            case R:
                do_regiser(acceptfd, &msg, db);
                break;
            case L:
                do_login(acceptfd, &msg, db);
                break;
            case Y:
                do_login_root(acceptfd, &msg, db);
                break;
            case Q:
                do_query(acceptfd, &msg, db);
                break;
            case H:
                do_history(acceptfd, &msg, db);
                break;
            case X:
                do_user_record(acceptfd, &msg, db);
            default:
                printf("Invalid data msg.
");
        }
    }

    printf("client exit.
");
    close(acceptfd);
    exit(0);

    return 0;
}

void do_regiser(int acceptfd, MSG *msg, sqlite3 *db)
{
    char *errmsg;
    char sql[128];
    char date[128];
    //获取系统时间
    get_date(date);

    sprintf(sql,"insert into user values('%s','%s' ,'%s');", msg->name, msg->data, date);
    printf("%s
",sql);

    if(sqlite3_exec(db, sql, NULL, NULL, &errmsg) != SQLITE_OK)
    {
        printf("%s
",errmsg);
        strcpy(msg->data, "user name already exit.");
    }
    else
    {
        printf("client register ok!
");
        strcpy(msg->data, "ok"); //将OK拷到data中，发给client
    }
    
    if(send(acceptfd, msg, sizeof(MSG), 0)<0)
    {
        perror("fail to send");
        return;
    }

    return;
}

int do_login(int acceptfd, MSG *msg, sqlite3 *db)
{
    char sql[128];
    char *errmsg;
    int nrow;
    int ncloumn;
    char **resultp;

    sprintf(sql,"select * from user where name = '%s' and passwd ='%s';",msg->name, msg->data);
    printf("%s
",sql);

    if(sqlite3_get_table(db, sql,&resultp, &nrow, &ncloumn, &errmsg) != SQLITE_OK)
    {
        printf("%s
", errmsg);
        return -1;
    }
    else
    {
        printf("get_table ok!
");
    }

    //查询成功，数据库拥有此用户
    if(nrow == 1)
    {
        strcpy(msg->data, "ok");
        send(acceptfd, msg, sizeof(MSG),0);
        return 1;
    }
    else  //密码或用户名错误
    {
        strcpy(msg->data,"usr/passwd wrong.");
        send(acceptfd, msg, sizeof(MSG),0);
    }
    return 0;
}

int do_login_root(int acceptfd, MSG *msg, sqlite3 *db)
{
    char sql[128];
    char *errmsg;
    int nrow;
    int ncloumn;
    char **resultp;

    sprintf(sql,"select * from user where name = 'root' and passwd = '%s';", msg->data);
    printf("%s
",sql);

    if(sqlite3_get_table(db, sql,&resultp, &nrow, &ncloumn, &errmsg) != SQLITE_OK)
    {
        printf("%s
", errmsg);
        return -1;
    }
    else
    {
        printf("get_table ok!
");
    }

    //查询成功，数据库拥有此用户
    if(nrow == 1)
    {
        strcpy(msg->data, "ok");
        send(acceptfd, msg, sizeof(MSG),0);
        return 1;
    }
    else  //密码或用户名错误
    {
        strcpy(msg->data,"passwd wrong.");
        send(acceptfd, msg, sizeof(MSG),0);
    }

    return 0;
}

int do_query(int acceptfd, MSG *msg, sqlite3 *db)
{
    char word[64];
    int found = 0;
    char date[128];
    char sql[128];
    char *errmsg;

    //拿出msg结构体中，要查询的单词
    strcpy(word, msg->data);

    found = do_searchword(acceptfd,msg, word);

    //表找到了单词，此时应将 name/date/word 插入history.text
    if(found == 1) 
    {
        //获取系统时间
        get_date(date);

        //添加历史记录
        sprintf(sql,"insert into record values('%s','%s','%s')", msg->name, date, word);
    

        if(sqlite3_exec(db, sql, NULL, NULL, &errmsg) != SQLITE_OK)
        {
            printf("%s
",errmsg);
            return -1;
        }
        else
        {
            printf("Insert record done.
");
        }
    }
    else //未找到
    {
        strcpy(msg->data,"Not found!");    
    }

    //将查询的结果，发送给客户端
    send(acceptfd, msg, sizeof(MSG), 0);

    return 0;
}

int do_history(int acceptfd, MSG *msg, sqlite3 *db)
{
    char sql[128];
    char *errmsg;

    
    sprintf(sql, "select * from record where name = '%s';",msg->name);

    //查询数据库
    if(sqlite3_exec(db, sql, history_callback, (void *)&acceptfd, &errmsg) != SQLITE_OK)
    {
        printf("%s
",errmsg);
    }
    else
    {
        printf("Query record done.
");
    }

    //所有记录查询发送完毕，给客户端发送结束信息
    msg->data[0] = '';

    send(acceptfd, msg, sizeof(MSG),0);

    return 0;
}

int history_callback(void *arg, int f_num,char** f_value ,char** f_name)
{
    //record , name , date , word
    int acceptfd;
    MSG msg; //声明结构体变量
    acceptfd = *((int *)arg);

    sprintf(msg.data,"%s, %s , %s",f_value[0], f_value[1], f_value[2]); //不是msg->data

    send(acceptfd, &msg, sizeof(MSG), 0);

    return 0;
}

int do_searchword(int acceptfd,MSG *msg, char word[])
{
    FILE * fp;
    int len = 0;
    char temp[512] = {};
    int result;
    char *p;
    
    //打开文件，读取文件，进行对比
    if((fp = fopen("dict.txt", "r")) == NULL)
    {
        perror("fail to fopen.
");
        strcpy(msg->data,"Failed to open dict.txt");
        send(acceptfd, msg, sizeof(MSG), 0);
        return -1;
    }

    //打印出，客户端要查询的单词
    len = strlen(word);
    printf("%s, len = %d
", word, len);

    //读文件，来查询单词
    while(fgets(temp,512,fp) != NULL)
    {
    
    //    printf("temp:%s
", temp); //打印从dict.txt获取的字符
        result = strncmp(temp ,word, len);

        if(result < 0) //eg:查询Apple，app<apple,appble<pple
        {
            continue;
        }
        if(result > 0 || ((result == 0) && (temp[len] != ' ')))
        {
            break;
        }

        //表示找到查询的单词
        p = temp + len; //指针移动到单词的末尾
        while(*p == ' ')
        {
            p++;
        }

        //找到了注释，跳跃过所有的空格
        strcpy(msg->data, p);
        printf("found word:%s
",msg->data);

        //注释拷贝完毕，关闭文件
        fclose(fp);
        
        return 1;
    }

    fclose(fp);

    return 0;
}

int get_date(char *date)
{
    time_t t;
    struct tm *tp;

    time(&t);

    //进行时间格式转换
    tp = localtime(&t);

    sprintf(date, "%d-%d-%d %d:%d:%d",tp->tm_year+1900, tp->tm_mon+1, tp->tm_mday, 
            tp->tm_hour, tp->tm_min, tp->tm_sec);


    return 0;
}


//查询用户的注册时间与账户及密码
int do_user_record(int acceptfd, MSG *msg, sqlite3 *db)
{
    char sql[128];
    char *errmsg;

    
    sprintf(sql, "select * from user where name = '%s';",msg->name);

    //查询数据库
    if(sqlite3_exec(db, sql, user_record_callback, (void *)&acceptfd, &errmsg) != SQLITE_OK)
    {
        printf("%s
",errmsg);
    }
    else
    {
        printf("Query user record done.
");
    }

    //所有记录查询发送完毕，给客户端发送结束信息
    msg->data[0] = '';

    send(acceptfd, msg, sizeof(MSG),0);

    return 0;
}

int user_record_callback(void *arg, int f_num,char** f_value ,char** f_name)
{
    //record , name , passwd , date
    int acceptfd;
    MSG msg; //声明结构体变量
    acceptfd = *((int *)arg);

    sprintf(msg.data,"%s, %s , %s",f_value[0], f_value[1], f_value[2]); //不是msg->data

    send(acceptfd, &msg, sizeof(MSG), 0);

    return 0;
}