search.c

int res_title[81];int res_content[501];void search(char* key,char *title,char* content){int i=0,j=0,k=0,t=0,c=0;int len_k,len_t,len_c;len_k=strlen(key);len_t=strlen(title);len_c=strlen(content);for(i=0;i<len_k;i++){for(j=0;j<len_t;j++){if(key[i]==title[j]){res_title[t]=j;}}for(k=0;k<len_c;k++){if(key[i]==content[k]){res_content[c]=k;}}}}

zhujiemian1.c：

//#include <gdk/gdkkeysyms>#include <gtk/gtk.h>#include <stdio.h>#include <string.h>#include<stdlib.h>#include<sys/socket.h>#include<netinet/in.h>#include<arpa/inet.h>#include<netdb.h>#define i 10/*全局变量****************************************************************************************/char* host_name="127.0.0.1";//"192.168.100.1";int port=8888;GtkWidget *entry1;//收件人ggGtkWidget *entry11;//密送ggGtkWidget *entry2;//主题ggchar *text;static GtkWidget *window_color;static GdkColor color;static GtkWidget *drawarea;GtkWidget *view;//编辑窗口char name[20]="hjlhsa";//邮件地址ggggggggggggggggggconst char *nickname="guosiyu";const char *weidu_number="3";//char weidu_number[10];/*函数声明*****************************************************************************************/int change_color ( );//改变颜色void on_ok_clicked  (GtkButton* button, gpointer data);//改变颜色void cleanup();//清空重新编辑int change_ziti();//改变字体void on_font_select_ok (GtkWidget *button,GtkFontSelectionDialog *fs);void on_button_clicked (GtkWidget *button,gpointer userdata);/*得到收件人内容**********************************************************************gg*/void get_recer(char* re_name){strcpy(re_name,gtk_entry_get_text(GTK_ENTRY(entry1)));}/*得到密送内容************************************************************************gg*/void get_misong(char* misong_name){char misong[100];int k;int j=0;strcpy(misong,gtk_entry_get_text(GTK_ENTRY(entry11)));for(k=0;misong[k]!='\0';k++){if(misong[k]==';'){misong_name[j]='*';j++;misong_name[j]=';';j++;}else{misong_name[j]=misong[k];j++;}}misong_name[j]='\0';}/*得到信得主题************************************************************************gg*/void get_title(char* title){strcpy(title,gtk_entry_get_text(GTK_ENTRY(entry2)));}/*得到信主题内容**********************************************************************gg*/void get_text(){GtkTextBuffer *pTextBuffer ;GtkTextIter iterStart;GtkTextIter iterEnd;pTextBuffer=gtk_text_view_get_buffer(view);gtk_text_buffer_get_start_iter(pTextBuffer,&iterStart);gtk_text_buffer_get_end_iter(pTextBuffer,&iterEnd);text=(gchar *)gtk_text_buffer_get_text(pTextBuffer,&iterStart,&iterEnd,FALSE);printf("aaaaaaa\n");printf("%s\n",text);}/*得到本地时间***********************************************************************gg*/void get_time(char* time){time=" ";}/*发送写信页面发送所有内容********************************************************************gggggggggggggggggggggg*/int xiexin_cbd(){printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);char buf[1024];memset(buf,0,sizeof(buf));/*传入数据库的各个字符串的拼接*********************************************************/char str[1024];//str表示拼接后的字符串memset(str,' ',sizeof(str));char time[10]="fdf";char re_name[100];char misong_name[100];char title[100];//char text[200];int count=0;int k,j;int status=2;get_recer(re_name);get_misong(misong_name);get_title(title);get_text();printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);printf("%s",text);printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);//get_time(time);//printf("str0:%s\n",str);str[0]='s';str[1]=(char)status;str[2]=(char)strlen(name);//放发件人printf("name:%s\nstrlen(name):%d\n",name,strlen(name));//printf("char c:%c\n",str[2]);printf("sender:%s\n",name);printf("sender:");for(k=0;name[k]!='\0';k++){str[k+3]=name[k];printf("str[k+3]:%c",str[k+3]);}printf("\n");//printf("str:%s\n",str);str[15]=(char)strlen(time);//放本地时间for(k=0;time[k]!='\0';k++){str[k+16]=time[k];}//printf("str:%s\n",str);str[42]=(char)strlen(title);//放标题for(k=0;title[k]!='\0';k++){str[k+43]=title[k];}printf("content:%s\n",text);printf("content:");str[123]=(char)strlen(text);//放信的内容for(k=0;text[k]!='\0';k++){str[k+124]=text[k];printf("str[k+124]:%c",str[k+124]);}printf("\n");printf("str:%s\n",str);strcat(re_name,misong_name);for(k=0;re_name[k]!='\0';k++){if(re_name[k]==';')count++;}str[624]=(char)count;//收件人和密送人的总个数for(k=0;re_name[k]!='\0';k++){str[k+625]=re_name[k];}printf("str:%s\n",str);printf("%d",count);//printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);/*传入数据库的各个字符串的拼接结束*********************************************************/int socket_descriptor;int temp_sock_descriptor;int size_of_addr;struct sockaddr_in sin;struct sockaddr_in pin;struct hostent * server_host_name;bzero(&pin, sizeof(pin));pin.sin_family=AF_INET;pin.sin_addr.s_addr = inet_addr("127.0.0.1");pin.sin_port=htons(port);//printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);if((socket_descriptor=socket(AF_INET, SOCK_STREAM, 0))==-1){perror("error opening socket\n");        exit(1);}//printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);if(connect(socket_descriptor, (void*)&pin, sizeof(pin))==-1){ perror("can not connecting to server\n");        exit(1);}if(send(socket_descriptor, str, strlen(str), 0)==-1){perror("can not send message\n");exit(1);}//printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);memset(buf, 0, 1024);if(recv(socket_descriptor, buf, sizeof(buf), 0)<0)//==-1){perror("can not receive response\n");        exit(1);}else{printf("message received from server:%s\n",buf);}close(socket_descriptor);return 0;}/*草稿箱************************************************************************************/int caogao_cbd(){printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);char buf[1024];memset(buf,0,sizeof(buf));/*传入数据库的各个字符串的拼接*********************************************************/char str[1024];//str表示拼接后的字符串memset(str,' ',sizeof(str));char time[10]="fdf";char re_name[100];char misong_name[100];char title[100];//char text[200];int count=0;int k,j;get_recer(re_name);get_misong(misong_name);get_title(title);get_text();printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);printf("%s",text);printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);//get_time(time);//printf("str0:%s\n",str);str[0]='s';str[1]='1';//赋值1表示在草稿箱str[2]=(char)strlen(name);//放发件人//printf("char c:%c\n",str[2]);for(k=0;name[k]!='\0';k++){str[k+3]=name[k];}//printf("str:%s\n",str);str[15]=(char)strlen(time);//放本地时间for(k=0;time[k]!='\0';k++){str[k+16]=time[k];}//printf("str:%s\n",str);str[42]=(char)strlen(title);//放标题for(k=0;title[k]!='\0';k++){str[k+43]=title[k];}printf("str:%s\n",text);str[123]=(char)strlen(text);//放信的内容for(k=0;text[k]!='\0';k++){str[k+124]=text[k];}printf("str:%s\n",str);strcat(re_name,misong_name);for(k=0;re_name[k]!='\0';k++){if(re_name[k]==';')count++;}str[624]=(char)count;//收件人和密送人的总个数for(k=0;re_name[k]!='\0';k++){str[k+625]=re_name[k];}printf("str:%s\n",str);printf("%d",count);//printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);/*传入数据库的各个字符串的拼接结束*********************************************************//*if(argc < 2){printf("send default string.\n");}else{str=argv[1];}if((server_host_name=gethostbyname(host_name))==0){herror("can not resoving localhost\n");exit(1);}*/int socket_descriptor;int temp_sock_descriptor;int size_of_addr;struct sockaddr_in sin;struct sockaddr_in pin;struct hostent * server_host_name;bzero(&pin, sizeof(pin));pin.sin_family=AF_INET;pin.sin_addr.s_addr = inet_addr("127.0.0.1");pin.sin_port=htons(port);//printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);if((socket_descriptor=socket(AF_INET, SOCK_STREAM, 0))==-1){perror("error opening socket\n");        exit(1);}//printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);if(connect(socket_descriptor, (void*)&pin, sizeof(pin))==-1){ perror("can not connecting to server\n");        exit(1);}if(send(socket_descriptor, str, strlen(str), 0)==-1){perror("can not send message\n");exit(1);}//printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);memset(buf, 0, 1024);if(recv(socket_descriptor, buf, sizeof(buf), 0)<0)//==-1){perror("can not receive response\n");        exit(1);}else{printf("message received from server:%s\n",buf);}close(socket_descriptor);return 0;}/*改变颜色*****************************************************************************/int change_color ( ){GtkWidget *vbox;GtkWidget *frame;GtkWidget *button;color.red = 0;color.blue = 65535;color.green = 0;window_color = gtk_window_new(GTK_WINDOW_TOPLEVEL);g_signal_connect(G_OBJECT(window_color),"delete_event",G_CALLBACK(gtk_main_quit),NULL);gtk_window_set_title(GTK_WINDOW(window_color),"选择颜色");gtk_window_set_position(GTK_WINDOW(window_color),GTK_WIN_POS_CENTER);gtk_container_set_border_width(GTK_CONTAINER(window_color),20);vbox = gtk_vbox_new(FALSE,0);gtk_container_add(GTK_CONTAINER(window_color),vbox);frame = gtk_frame_new(NULL);gtk_frame_set_shadow_type(GTK_FRAME(frame),GTK_SHADOW_IN);gtk_box_pack_start(GTK_BOX(vbox),frame,TRUE,TRUE,5);drawarea = gtk_drawing_area_new();gtk_widget_set_size_request(drawarea,200,200);//kongjian daxiaogtk_widget_modify_bg (drawarea, GTK_STATE_NORMAL,&color);//kongjian beijinggtk_container_add(GTK_CONTAINER(frame),drawarea);button = gtk_button_new_from_stock(GTK_STOCK_SELECT_COLOR);gtk_box_pack_start(GTK_BOX(vbox),button,FALSE,FALSE,5);g_signal_connect(G_OBJECT(button),"clicked",G_CALLBACK(on_ok_clicked),NULL);gtk_widget_show_all(window_color);gtk_main();return FALSE;}void on_ok_clicked  (GtkButton* button, gpointer data){GtkWidget *dialog;GtkColorSelection *colorsel;gint response;dialog = gtk_color_selection_dialog_new("选择颜色");gtk_window_set_transient_for (GTK_WINDOW (dialog),GTK_WINDOW (window_color));//注意:转换颜色选择对话框的颜色选择子控件colorsel = GTK_COLOR_SELECTION(GTK_COLOR_SELECTION_DIALOG(dialog)->colorsel);gtk_color_selection_set_has_opacity_control(colorsel,TRUE);gtk_color_selection_set_has_palette(colorsel,TRUE);gtk_signal_connect(GTK_OBJECT(dialog),"destroy",GTK_SIGNAL_FUNC(gtk_widget_destroy),&dialog);gtk_color_selection_set_previous_color (colorsel, &color);gtk_color_selection_set_current_color (colorsel, &color);response = gtk_dialog_run(GTK_DIALOG(dialog));//注意:此处需要用戶判断对话框的运行结果,如果是确定按钮则改变颜色if(response == GTK_RESPONSE_OK){gtk_color_selection_get_current_color (colorsel, &color);gtk_widget_modify_bg (drawarea, GTK_STATE_NORMAL, &color);GtkTextBuffer *pTextBuffer ;GtkTextIter iterStart;GtkTextIter iterEnd;pTextBuffer=gtk_text_view_get_buffer(view);gtk_text_buffer_get_start_iter(pTextBuffer,&iterStart);gtk_text_buffer_get_end_iter(pTextBuffer,&iterEnd);gtk_widget_modify_text(GTK_WIDGET(view),GTK_STATE_NORMAL,&color);//改变编辑框内文本颜色}gtk_widget_destroy(dialog);}/*****************************************************************************//*改变字体******************************************************************************/void on_font_select_ok (GtkWidget *button,GtkFontSelectionDialog *fs){PangoFontDescription *font_desc;///////////////GtkWidget *dialog;gchar message[1024];gchar* ziti = gtk_font_selection_dialog_get_font_name(fs);font_desc = pango_font_description_from_string(ziti);sprintf(message,"你选择的字体是:%s \n",ziti);dialog = gtk_message_dialog_new(NULL,GTK_DIALOG_DESTROY_WITH_PARENT,GTK_MESSAGE_INFO,GTK_BUTTONS_OK,message,NULL);gtk_widget_destroy(GTK_WIDGET(fs));gtk_dialog_run(GTK_DIALOG(dialog));gtk_widget_destroy(dialog);GtkTextBuffer *pTextBuffer ;GtkTextIter iterStart;GtkTextIter iterEnd;pTextBuffer=gtk_text_view_get_buffer(view);gtk_text_buffer_get_start_iter(pTextBuffer,&iterStart);gtk_text_buffer_get_end_iter(pTextBuffer,&iterEnd);        gtk_widget_modify_font(GTK_WIDGET(view), font_desc);/////////////*/g_free(ziti);}void on_button_clicked (GtkWidget *button,gpointer userdata){GtkWidget* dialog;dialog = gtk_font_selection_dialog_new("请选择一种字体:");gtk_window_set_position(GTK_WINDOW(dialog),GTK_WIN_POS_CENTER);gtk_signal_connect(GTK_OBJECT(dialog),"destroy",GTK_SIGNAL_FUNC(gtk_widget_destroy),&dialog);gtk_signal_connect(GTK_OBJECT(GTK_FONT_SELECTION_DIALOG(dialog)->ok_button),"clicked",GTK_SIGNAL_FUNC(on_font_select_ok),GTK_FONT_SELECTION_DIALOG(dialog));gtk_signal_connect_object(GTK_OBJECT(GTK_FONT_SELECTION_DIALOG(dialog)->cancel_button),"clicked",GTK_SIGNAL_FUNC(gtk_widget_destroy),GTK_OBJECT(dialog));gtk_widget_show(dialog);}int change_ziti ( ){GtkWidget *window;GtkWidget *button;window = gtk_window_new(GTK_WINDOW_TOPLEVEL);g_signal_connect(G_OBJECT(window),"delete_event",G_CALLBACK(gtk_main_quit),NULL);gtk_window_set_title(GTK_WINDOW(window),"字体选择功能实现");//gtk_window_set_default_size(GTK_WINDOW(window),500,100);gtk_window_set_position(GTK_WINDOW(window),GTK_WIN_POS_CENTER);gtk_container_set_border_width(GTK_CONTAINER(window),40);button = gtk_button_new_with_label("按下此按钮来选择字体");g_signal_connect(G_OBJECT(button),"clicked",G_CALLBACK(on_button_clicked),NULL);gtk_container_add(GTK_CONTAINER(window),button);gtk_widget_show(button);gtk_widget_show(window);gtk_main();return FALSE;}/*****************************************************************************************//*清除重新编辑****************************************************************************/void cleanup()//GtkWidget *widget, gpointer view1){char *text;/////////////////////////////////////////////////////////传递到数据库时使用GtkTextBuffer *pTextBuffer ;GtkTextIter iterStart;GtkTextIter iterEnd;pTextBuffer=gtk_text_view_get_buffer(view);gtk_text_buffer_get_start_iter(pTextBuffer,&iterStart);gtk_text_buffer_get_end_iter(pTextBuffer,&iterEnd);/*text=(gchar *)gtk_text_buffer_get_text(pTextBuffer,&iterStart,&iterEnd,FALSE);printf("%s\n",text);*/gtk_text_buffer_set_text(pTextBuffer,"\0",-1);}/*发送，存草稿，关闭的横盒******************************************************************/GtkWidget *make_box1( gboolean homogeneous,                     gint     spacing,                     gboolean expand,                     gboolean fill,                     guint    padding ) {    GtkWidget *box;    GtkWidget *button;    char padstr[80];     /* 以合适的 homogeneous 和 spacing 设置创建一个新的横向盒 */    box = gtk_hbox_new (homogeneous, spacing);        /* 以合适的设置创建一系列的按钮 */    button = gtk_button_new_with_label ("发送");    gtk_box_pack_start (GTK_BOX (box), button, expand, fill, padding);    gtk_widget_show (button);    g_signal_connect(G_OBJECT(button),"clicked",G_CALLBACK(xiexin_cbd),NULL);        button = gtk_button_new_with_label ("存草稿");    gtk_box_pack_start (GTK_BOX (box), button, expand, fill, padding);    gtk_widget_show (button);    g_signal_connect(G_OBJECT(button),"clicked",G_CALLBACK(caogao_cbd),NULL);        button = gtk_button_new_with_label ("关閉");    gtk_box_pack_start (GTK_BOX (box), button, expand, fill, padding);    gtk_widget_show (button);        return box;} /*notebook部分函数**********************************************************************/void tabsborder_book( GtkButton   *button,                      GtkNotebook *notebook ){    gint bval = FALSE;    if (notebook->show_border == 0)            bval = TRUE;     gtk_notebook_set_show_border (notebook, bval);}void delete(GtkWidget *widget,GtkWidget *event,gpointer data){    gtk_main_quit();}/*工具栏的函数******************************************************************/static void onDestroy( GtkWidget *widget, gpointer user_data){gtk_main_quit();}// tianjia kucun ID gongju anniuGtkWidget * addStockToolItem(GtkWidget *toolbar, const gchar *stockid, const gchar *tooltip){GtkToolItem *toolitem;toolitem = gtk_tool_button_new_from_stock(stockid);gtk_tool_item_set_tooltip_text(toolitem,tooltip);//jiang gong ju xiang cha ru gongju lan wei bu gtk_toolbar_insert(GTK_TOOLBAR(toolbar),toolitem,-1);gtk_widget_show(GTK_WIDGET(toolitem));return GTK_WIDGET(toolitem);}//tian jia fen ge gong ju xiang GtkWidget *addSeparatorToolItem(GtkWidget* toolbar){GtkToolItem *toolitem;//chuang jian fen ge gong ju xiangtoolitem = gtk_separator_tool_item_new();gtk_toolbar_insert(GTK_TOOLBAR(toolbar),toolitem,-1);gtk_widget_show(GTK_WIDGET(toolitem));return GTK_WIDGET(toolitem);}//tian jia gong ju xiangGtkWidget * addToolItem(GtkWidget* toolbar, const gchar *pLabel, const gchar *tooltip, const gchar *pImageFile){GtkWidget *image = NULL;GtkToolItem *toolitem = NULL;//chuang jian tu pian gou jian image = gtk_image_new_from_file(pImageFile);gtk_widget_show(image);//chuang jian gong ju an niutoolitem = gtk_tool_button_new(image,pLabel);gtk_tool_item_set_tooltip_text(toolitem,tooltip);gtk_toolbar_insert(GTK_TOOLBAR(toolbar),toolitem,-1);gtk_widget_show(GTK_WIDGET(toolitem));return GTK_WIDGET(toolitem);}int main(int argc, char*argv[]){GtkWidget *window;GtkWidget *button;        GtkWidget *notebook;        GtkWidget *label;        GtkWidget *checkbutton;        char bufferf[32];        char bufferl[32];GtkWidget *vbox0;//整个窗口纵盒GtkWidget *vbox;//整个窗口纵盒GtkWidget *vbox2;//整个窗口纵盒GtkWidget *vbox3;//整个窗口纵盒GtkWidget *vbox4;//整个窗口纵盒GtkWidget *vbox5;//整个窗口纵盒GtkWidget *vbox6;//整个窗口纵盒GtkWidget *vbox7;//整个窗口纵盒GtkWidget *bbox1;//收件人横盒GtkWidget *bbox11;//密送横盒GtkWidget *bbox2;//主题横盒GtkWidget *bbox3;//正文标签横盒GtkWidget *label1;GtkWidget *label11;//密送GtkWidget *label2;GtkWidget *label3;GtkWidget *box1;//发送，存草稿，关闭的横盒//GtkWidget *entry1;//收件人//GtkWidget *entry11;//密送//GtkWidget *entry2;//主题GtkWidget *toolbar;GtkWidget *toolitem;GtkWidget *handlebox;GtkWidget *frame;GtkWidget *tvbox;/////GtkWidget *shouyehbox1;GtkWidget *shouyehbox2;GtkWidget *nullbox1;GtkWidget *nullbox2;GtkWidget *nullbox3;GtkWidget *weidu_eventbox;GtkWidget *shouye_label1;//标签晚上好GtkWidget *shouye_label2;//标签昵称GtkWidget *shouye_label3;//标签您有GtkWidget *shouye_label4;//标签未读邮件个数GtkWidget *shouye_label5;//封未读邮件//char greeting1[50];//char greeting2[50];        char *greeting1="   晚上好,";        char *greeting2="   您有";        char* greeting3="封未读邮件";       // strcpy(greeting1,"晚上好,");        //strcpy(greeting2,"晚上好,");gtk_init(&argc, &argv);window = gtk_window_new(GTK_WINDOW_TOPLEVEL);gtk_widget_set_size_request(GTK_WIDGET(window),550,500); gtk_window_set_resizable(GTK_WINDOW(window),FALSE);g_signal_connect(G_OBJECT(window),"delete_event",G_CALLBACK(gtk_main_quit),NULL);gtk_window_set_title(GTK_WINDOW(window),"写信");vbox0 = gtk_vbox_new(FALSE,0);vbox = gtk_vbox_new(FALSE,0);vbox2 = gtk_vbox_new(FALSE,0);vbox3 = gtk_vbox_new(FALSE,0);vbox4= gtk_vbox_new(FALSE,0);vbox5 = gtk_vbox_new(FALSE,0);vbox6 = gtk_vbox_new(FALSE,0);vbox7 = gtk_vbox_new(FALSE,0);box1 = make_box1(FALSE,0,FALSE,FALSE,3);gtk_box_pack_start(GTK_BOX(vbox),box1,FALSE,FALSE,2);bbox1 = gtk_hbox_new(FALSE,0);bbox11 = gtk_hbox_new(FALSE,0);bbox2 = gtk_hbox_new(FALSE,0);bbox3 = gtk_hbox_new(FALSE,0);label1 = gtk_label_new("收件人");//gtk_misc_set_alignment(GTK_MISC(label1),0,0);/////////?????label11 = gtk_label_new("密送  ");label2 = gtk_label_new("主题  ");entry1 = gtk_entry_new();entry11 = gtk_entry_new();entry2 = gtk_entry_new();shouyehbox1=gtk_hbox_new(FALSE,0);shouyehbox2=gtk_hbox_new(FALSE,0);nullbox1=gtk_hbox_new(FALSE,10);nullbox2=gtk_hbox_new(FALSE,10);nullbox3=gtk_hbox_new(FALSE,10);        weidu_eventbox= gtk_event_box_new();//sprintf(greeting1,nickname);//strcat(nickname,greeting1);//sprintf(greeting2,weidu_number);view = gtk_text_view_new();//涉及全局变量和环境变量gtk_text_view_set_wrap_mode(GTK_TEXT_VIEW(view),GTK_WRAP_WORD_CHAR);/*首页盒子的排列************************************************************************************************/PangoFontDescription *font_desc = pango_font_description_from_string ("Serif 20");shouye_label1= gtk_label_new(greeting1);gtk_widget_modify_font(GTK_WIDGET(shouye_label1),font_desc );//gtk_label_set_markup(GTK_LABEL(shouye_label1),"<span foreground='black'font_desc='59'>(&greeting1) </span>");///////shouye_label2= gtk_label_new(nickname);gtk_widget_modify_font(GTK_WIDGET(shouye_label2),font_desc );shouye_label3= gtk_label_new(greeting2);gtk_widget_modify_font(GTK_WIDGET(shouye_label3),font_desc );shouye_label4= gtk_label_new(weidu_number);gtk_widget_modify_font(GTK_WIDGET(shouye_label4),font_desc );shouye_label5= gtk_label_new(greeting3);gtk_widget_modify_font(GTK_WIDGET(shouye_label5),font_desc );/****************************************************************************************************************/gtk_container_add (GTK_CONTAINER (weidu_eventbox), shouye_label4);gtk_widget_set_events (weidu_eventbox, GDK_BUTTON_PRESS_MASK); //g_signal_connect(G_OBJECT (weidu_eventbox), "button_press_event",         //  G_CALLBACK (), vbox0 ); /////////////////////////////// //gtk_widget_realize (weidu_eventbox); gdk_window_set_cursor (weidu_eventbox->window, gdk_cursor_new (GDK_HAND1)); gtk_box_pack_start(GTK_BOX(bbox1),label1,FALSE,FALSE,0);//2gtk_box_pack_start(GTK_BOX(bbox1),entry1,TRUE,TRUE,0);gtk_box_pack_start(GTK_BOX(bbox11),label11,FALSE,FALSE,2);//3gtk_box_pack_start(GTK_BOX(bbox11),entry11,TRUE,TRUE,2);gtk_box_pack_start(GTK_BOX(vbox),bbox1,FALSE,FALSE,2);//2fangru zonghegtk_box_pack_start(GTK_BOX(vbox),bbox11,FALSE,FALSE,2);//3fangru zonghegtk_box_pack_start(GTK_BOX(bbox2),label2,FALSE,FALSE,2);//4gtk_box_pack_start(GTK_BOX(bbox2),entry2,TRUE,TRUE,2);gtk_box_pack_start(GTK_BOX(vbox),bbox2,FALSE,FALSE,2);//4fangru zonghe/*首页盒子的排列************************************************************************************************/gtk_box_pack_start(GTK_BOX(shouyehbox1),shouye_label1,FALSE,FALSE,2);//晚上好 昵称放横盒gtk_box_pack_start(GTK_BOX(shouyehbox1),shouye_label2,FALSE,FALSE,2);gtk_box_pack_start(GTK_BOX(shouyehbox2),shouye_label3,FALSE,FALSE,2);//您有n封未读邮件放横盒gtk_box_pack_start(GTK_BOX(shouyehbox2),weidu_eventbox,FALSE,FALSE,2);//数字n放事件盒gtk_box_pack_start(GTK_BOX(shouyehbox2),shouye_label5,FALSE,FALSE,2);gtk_box_pack_start(GTK_BOX(vbox0),nullbox1,FALSE,FALSE,10);gtk_box_pack_start(GTK_BOX(vbox0),nullbox2,FALSE,FALSE,10);gtk_box_pack_start(GTK_BOX(vbox0),nullbox3,FALSE,FALSE,10);gtk_box_pack_start(GTK_BOX(vbox0),shouyehbox1,FALSE,FALSE,2);//两个横盒放纵盒gtk_box_pack_start(GTK_BOX(vbox0),shouyehbox2,FALSE,FALSE,2);/***********************************************************************************************************/toolbar = gtk_toolbar_new();//shezhi gongju lan feng ge gtk_toolbar_set_style(GTK_TOOLBAR(toolbar),GTK_TOOLBAR_ICONS);//shezhi gongjulan tubiao daxiaogtk_toolbar_set_icon_size(GTK_TOOLBAR(toolbar),GTK_ICON_SIZE_SMALL_TOOLBAR);handlebox = gtk_handle_box_new();gtk_container_add(GTK_CONTAINER(handlebox),toolbar);        toolitem = addToolItem(toolbar, "font","清空重新编辑","xinjian.bmp");g_signal_connect(toolitem,"clicked",G_CALLBACK(cleanup),NULL);toolitem = addToolItem(toolbar, "font","附件","fujian.bmp");//g_signal_connect(toolitem,"clicked",G_CALLBACK(onCommand),(gpointer)CMD_OPEN);toolitem = addToolItem(toolbar, "font","字体","ziti.bmp");g_signal_connect(toolitem,"clicked",G_CALLBACK(change_ziti),NULL);toolitem = addToolItem(toolbar, "color","顏色","yanse.bmp");g_signal_connect(toolitem,"clicked",G_CALLBACK(change_color),NULL);toolitem = addToolItem(toolbar, "paper","信纸","xinzhi.bmp");//g_signal_connect(toolitem,"clicked",G_CALLBACK(onCommand),(gpointer)CMD_QUIT);//GtkWidget *vbox;//整个窗口纵盒frame = gtk_frame_new("正文");gtk_widget_set_size_request(frame,50,500);tvbox = gtk_vbox_new(FALSE,0);gtk_box_pack_start(GTK_BOX(vbox),handlebox,FALSE,FALSE,0);gtk_box_pack_start(GTK_BOX(vbox),frame,TRUE,TRUE,0);gtk_container_add(GTK_CONTAINER(frame),view);gtk_box_pack_start(GTK_BOX(vbox),tvbox,FALSE,FALSE,2);// gongjulan fang zonghe999999gtk_box_pack_start(GTK_BOX(vbox),bbox3,TRUE,TRUE,2);//zhengwen henghe fang zonghe//gtk_container_add(GTK_CONTAINER(window),vbox);//gtk_widget_show_all(vbox);//初始化GTKgtk_init(&argc,&argv);//创建最上层主窗口window = gtk_window_new(GTK_WINDOW_TOPLEVEL);//连接信号"delete_event",使得窗口关闭时发生g_signal_connect(G_OBJECT(window),"delete_event",GTK_SIGNAL_FUNC(delete),NULL);//设置窗口标题gtk_window_set_title(GTK_WINDOW(window),"wingmail");//设定窗口的默认宽高gtk_window_set_default_size(GTK_WINDOW(window),800,400);//设定窗口的位置,让窗口总在最前端gtk_window_set_position(GTK_WINDOW(window),GTK_WIN_POS_CENTER);//设定容器边框的宽度gtk_container_set_border_width(GTK_CONTAINER(window),15);        notebook = gtk_notebook_new();        gtk_notebook_set_tab_pos(GTK_NOTEBOOK(notebook),GTK_POS_LEFT);gtk_container_add(GTK_CONTAINER(window),notebook);        gtk_widget_show(notebook);sprintf(bufferl,"已删除");        label = gtk_label_new(bufferl);        gtk_notebook_prepend_page(GTK_NOTEBOOK(notebook),vbox7,label);sprintf(bufferl,"已发送");        label = gtk_label_new(bufferl);        gtk_notebook_prepend_page(GTK_NOTEBOOK(notebook),vbox6,label);sprintf(bufferl,"草稿箱(%d)",i);        label = gtk_label_new(bufferl);        gtk_notebook_prepend_page(GTK_NOTEBOOK(notebook),vbox5,label);sprintf(bufferl,"收件箱(%d)",i);        label = gtk_label_new(bufferl);        gtk_notebook_prepend_page(GTK_NOTEBOOK(notebook),vbox4,label);sprintf(bufferl,"通讯录");        label = gtk_label_new(bufferl);        gtk_notebook_prepend_page(GTK_NOTEBOOK(notebook),vbox3,label);        sprintf(bufferl,"收信");        label = gtk_label_new(bufferl);        gtk_notebook_prepend_page(GTK_NOTEBOOK(notebook),vbox2,label);sprintf(bufferl,"写信");        label = gtk_label_new(bufferl);        gtk_notebook_prepend_page(GTK_NOTEBOOK(notebook),vbox,label);sprintf(bufferl,"首页");        label = gtk_label_new(bufferl);        gtk_notebook_prepend_page(GTK_NOTEBOOK(notebook),vbox0,label);    gtk_notebook_set_page(GTK_NOTEBOOK(notebook),0);    gtk_widget_show(notebook);gtk_widget_show_all(window);gtk_main();return FALSE;}

server_less.c:

#include<stdio.h>#include<stdlib.h>#include<string.h>#include<sys/socket.h>#include<netinet/in.h>#include<netdb.h>#include<string.h>#include "sqlite3.h"char s_callback[1024] = {0};int callback_flag=0;int legal_user_flag=1;int callback(void* p ,int nCount,char** pValue,char** pName);int port=8888;int main(){    struct sockaddr_in sin;    struct sockaddr_in pin;    int sock_descriptor;    int temp_sock_descriptor;    int size_of_addr;    char buf[1024]={0};    int i, length;        sock_descriptor=socket(AF_INET, SOCK_STREAM, 0);    if(sock_descriptor == -1)    {        perror("socket error!");        exit(1);    }    bzero(&sin, sizeof(sin));    sin.sin_family=AF_INET;    sin.sin_addr.s_addr = INADDR_ANY;    sin.sin_port=htons(port);    if(bind(sock_descriptor, (struct sockaddr*)&sin, sizeof(sin)) == -1)    {        perror("bind error");        exit(1);    }    if(listen(sock_descriptor, 20) == -1)    {        perror("listen1 error");        exit(1);    }    printf("waiting for accepting!\n");    while(1)    {        temp_sock_descriptor = accept(sock_descriptor, (struct sockaddr*)&pin, &size_of_addr);        if(temp_sock_descriptor == -1)        {            perror("accept error!");            exit(1);        }else{       printf("accept client request\n");}memset(buf, ' ', sizeof(buf));        if(recv(temp_sock_descriptor, buf, sizeof(buf), 0) == -1)        {            perror("recv()!");            exit(1);        }  else{/**********************************打开mail数据库*********************************/printf("%c,%c,%c,%c\n",buf[3],buf[16],buf[33],buf[54]);printf("message received from client: %s\n", buf);sqlite3 *db = NULL;        char *zErrMsg = 0;        int rc;        rc = sqlite3_open ("mail.db", &db);if (rc){ fprintf (stderr, "Can't open database: %s\n", sqlite3_errmsg (db)); sqlite3_close (db); exit (EXIT_FAILURE);        }else{     printf ("You have opened a sqlite3 database named mail.db successfully!\n");        }char sql[600]={0};/**********************************打开mail数据库*********************************//**插入user表的内容**/char username[13];char password[17];char nickname[21];char telnum[12];int user_num=0;char* new_usr_check_msg='\0';/**插入user表的内容**//**插入send表的内容**/int status_sender=0;char sender[13];char date_time[27];char title[81];char content[501];/**插入send表的内容**//**插入receive表的内容**/char receiver[13]={'\0'};int status_recer=0;int secret=0;/**插入receive表的内容**//**插入contact表中的内容**/char usrname[13];char contactor[13];/**插入contact表中的内容**/int j=0,k=0;int recer_st=0;int tmp_recer_st;char tmp_sender[13];char tmp_date_time[27];switch (buf[0]){//确定要进行数据操作的表/**********************************************************向user表插入数据**********************************************************/case 'u':/*向user表插入数据*/{      memset(username,0,sizeof(username));      memset(password, 0, sizeof(password));      memset(nickname, 0, sizeof(nickname));      memset(telnum, 0, sizeof(telnum));printf("in case1");printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);      memcpy(username,buf+3,(int)buf[2]);printf("username:%s\n",username);printf("password_c:");      for(i=16;i<(int)buf[15]+16;i++){printf("%c",buf[i]);      }printf("\n");              memcpy(password,buf+16,(int)buf[15]);printf("password:%s\n",password);              if(buf[1]=='1'){//检查用户登录信息是否正确callback_flag=0;sprintf(sql,"SELECT usrname,password FROM user WHERE usrname='%s' AND password='%s';",username,password);sqlite3_exec (db, sql, callback, 0, &zErrMsg);memset(sql,'\0',sizeof(sql));if(callback_flag==1){new_usr_check_msg="login_success";printf("login_success\n");legal_user_flag=1;if(send(temp_sock_descriptor, new_usr_check_msg, strlen(new_usr_check_msg), 0)==-1)           {        perror("can not send message\n");        exit(1);    }}if(callback_flag==0){new_usr_check_msg="login_error";printf("login_error\n");if(send(temp_sock_descriptor, new_usr_check_msg, strlen(new_usr_check_msg), 0)==-1)           {printf("send()\n");        perror("can not send message\n");        exit(1);    }}      }      if(buf[1]=='0'){//检验新注册用户是否重名printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);sprintf(sql, "SELECT usrname FROM user WHERE usrname = '%s'", username);memset(s_callback,0,sizeof(s_callback));sqlite3_exec(db,sql,callback,0,&zErrMsg);   if(strcmp(s_callback,username)==0){printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__); new_usr_check_msg="usrname_repeat";if(send(temp_sock_descriptor, new_usr_check_msg, strlen(new_usr_check_msg), 0)==-1)           {printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);        perror("can not send message\n");        exit(1);    }else{printf("send success!\n");}}else{printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);memcpy(nickname,buf+33,(int)buf[32]);printf("nickname:%s\n",nickname);memcpy(telnum,buf+54,11);printf("telnum:%s\n",telnum);sprintf(sql,"INSERT INTO user(ID_U,usrname,password,nickname,telnum) VALUES(NULL,'%s','%s','%s','%s');",username,password,nickname,telnum);printf("sql:%s\n",sql);if(sqlite3_exec(db, sql, 0, 0, &zErrMsg)==0){printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);user_num++;printf("usernum:%d\n",user_num);memset(sql,'\0',sizeof(sql));}new_usr_check_msg="insert_newuser_success";//向user表插入新用户成功printf("new_usr_check_msg:%s\n",new_usr_check_msg);printf("sock_descriptor:%d",sock_descriptor); if(send(temp_sock_descriptor, new_usr_check_msg, strlen(new_usr_check_msg), 0)<0)//==-1)           {printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);        perror("can not send message\n");        exit(1);    }else{printf("send success!\n");}    }printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);memset(s_callback,'\0',sizeof(s_callback));memset(sql,'\0',sizeof(sql));      }memset(buf, 0, 1024);memset(username,0,sizeof(username));memset(password, 0, sizeof(password));memset(nickname, 0, sizeof(nickname));memset(telnum, 0, sizeof(telnum));new_usr_check_msg="0";break;}/**********************************************************向user表插入数据**********************************************************//**********************************************************向send表插入数据**********************************************************/       case 's':               {printf("in case2");printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);    if(legal_user_flag==1){printf("legal_user_flag:%d\n",legal_user_flag);printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);status_sender=(int)buf[1];printf("status_sender:%d\n",status_sender);memset(sender,0,sizeof(sender));memcpy(sender,buf+3,(int)buf[2]);printf("sender:%s\n(int)buf[2]:%d\n",sender,(int)buf[2]);memset(date_time,0,sizeof(date_time));memcpy(date_time,buf+16,(int)buf[15]);printf("date_time:%s\n",date_time);memset(title,0,sizeof(title));memcpy(title,buf+43,(int)buf[42]);printf("title:%s\n",title);memset(content,0,sizeof(content));memcpy(content,buf+124,(int)buf[123]);printf("content:%s\n(int)buf[123]:%d\n",content,(int)buf[123]);printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);sprintf(sql,"INSERT INTO send(ID_M,status_sender,sender,date_time,title,content) VALUES(NULL,%d,'%s','%s','%s','%s');",status_sender,sender,date_time,title,content);printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);if(sqlite3_exec(db, sql, 0, 0, &zErrMsg)<0){perror("insert send error!\n");memset(sql,'\0',sizeof(sql));}else{printf("insert into send success\n");}memset(sql,'\0',sizeof(sql));if(status_sender==2||status_sender==5||status_sender==8){//信件在发信人发件箱中时，可以向receive表中插入数据printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);printf("(int)buf[624]:%d\n",(int)buf[624]);     recer_st=625;     tmp_recer_st=625;     for(i=0;i<(int)buf[624];i++){     j=0;secret=0;     recer_st=tmp_recer_st+1;printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);     memset(receiver,0,sizeof(receiver));printf("k:%d\nbuf[k]:%c",recer_st,buf[recer_st]);     for(k=recer_st;buf[k]!=';';k++){printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);printf("k:%d\nbuf[k]:%c\n",k,buf[k]);if(buf[k]=='*'){secret=1;}else{   receiver[j]=buf[k];           j++;}printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);printf("tmp_recer_st:%d\n",tmp_recer_st);tmp_recer_st++;     }printf("tmp_recer_st:%d\n",tmp_recer_st);printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);sprintf(sql,"INSERT INTO receive(sender,receiver,date_time,status_recer,secret) VALUES('%s','%s','%s',%d,%d);",sender,receiver,date_time,status_recer,secret);sqlite3_exec(db,sql,0,0,&zErrMsg);memset(sql,'\0',sizeof(sql));sprintf(sql,"INSERT INTO contact(usrname,contactor) VALUES('%s','%s');",sender,receiver);sqlite3_exec(db,sql,0,0,&zErrMsg);memset(sql,'\0',sizeof(sql));memset(receiver, 0, sizeof(receiver));             }}memset(buf, 0, 1024);memset(sender,0,sizeof(sender));memset(date_time,0,sizeof(date_time));memset(title, 0, sizeof(title));memset(content, 0, sizeof(content));memset(receiver, 0, sizeof(receiver));      }      break;                 }/**********************************************************向send表插入数据**********************************************************//*****************************************收件箱标为已读、标为未读、删除已读、删除未读、彻底删除********************************************/      case 'r':       {printf("in case3");printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);     if(legal_user_flag==1){if(buf[1]=='9'){//彻底删除memcpy(tmp_sender,buf+2,(int)buf[2]);        memcpy(tmp_date_time,buf+15,(int)buf[15]);/*sqlite3_exec(db,"SELECT sender FROM receiver WHERE status_recer=4 OR status_recer=7;",callback,0,&zErrMsg);memset(sql,'\0',sizeof(sql));strcpy(tmp_sender,s_callback);memset(s_callback,'\0',sizeof(s_callback));sqlite3_exec(db,"SELECT date_time FROM receiver WHERE status_recer=4 OR status_recer=7;",callback,0,&zErrMsg);memset(sql,'\0',sizeof(sql));strcpy(tmp_date_time,s_callback);memset(s_callback,'\0',sizeof(s_callback));*/sprintf(sql,"DELETE FROM receive WHERE sender='%s' AND date_time='%s' AND status_recer=4 OR status_recer=7;",tmp_sender,tmp_date_time);sqlite3_exec(db,sql,0,0,&zErrMsg);memset(sql,'\0',sizeof(sql));sprintf(sql,"DELETE FROM send WHERE sender='%s' AND date_time='%s';",tmp_sender,tmp_date_time);sqlite3_exec(db,sql,0,0,&zErrMsg);memset(sql,'\0',sizeof(sql));}memcpy(sender,buf+2,(int)buf[2]);memcpy(date_time,buf+15,(int)buf[15]);sprintf(sql,"UPDATE receive SET status_receiver='%d' WHERE sender='%s' AND date_time='%s';",(int)buf[1],sender,date_time);sqlite3_exec(db,sql,0,0,&zErrMsg);memset(sql,'\0',sizeof(sql));memset(buf, 0, 1024);memset(sender,0,sizeof(sender));status_recer=0;      }break;       }/*****************************************收件箱标为已读、标为未读、删除已读、删除未读、彻底删除********************************************//*****************************************************向contact表中插入新数据********************************************************/           case 'c':/*向contact表中插入新数据*/       {printf("in case4");printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);     memcpy(usrname,buf+2,buf[2]);     memcpy(contactor,buf+15,buf[15]);     if(buf[1]=='1'){ sprintf(sql,"INSERT INTO contact(usrname,contactor) VALUES(%s,%s);",usrname,contactor);sqlite3_exec(db,sql,0,0,&zErrMsg);memset(sql,'\0',sizeof(sql));             }     if(buf[1]=='2'){        sprintf(sql,"UPDATE contact SET usrname='%s',contactor='%s';",usrname,contactor);sqlite3_exec(db,sql,0,0,&zErrMsg);memset(sql,'\0',sizeof(sql));     }     if(buf[1]=='3'){sprintf(sql,"DELETE FROM contact WHERE usrname='%s',contactor='%s';",usrname,contactor);     }     memset(buf, 0, 1024);     memset(usrname,0,sizeof(usrname));     memset(usrname,0,sizeof(usrname));     break;       }/*****************************************************向contact表中插入新数据****************************************************//******************************************************向客户端发"草稿箱"内容******************************************************/           /*case '2':{printf("in case2");printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);     if(buf[2]=='0'){ sqlite3_exec(db,"SELECT * FROM sender WHERE sender_status=1;")          }     sqlite3_exec(db,sql,callback,0,&zErrMsg);     break;}*//******************************************************向客户端发"草稿箱"内容******************************************************/ }}memset(buf, 0, 1024);/*      length = strlen(buf);        for(i  = 0 ; i < length; i++)        {            buf[i] = toupper(buf[i]);`        }        if(send(temp_sock_descriptor, buf, length, 0) == -1)        {            perror("send()!");            exit(1);        }*/        close(temp_sock_descriptor);    }}int callback(void* p ,int nCount,char** pValue,char** pName){printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);    int i = 0;callback_flag=1;    for(i=0;i<nCount;i++)    {strcat(s_callback, pValue[i]);    }    printf("s_callback:%s\n", s_callback);printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);    return 0;}

server.c:

#include<stdio.h>#include<stdlib.h>#include<string.h>#include<sys/socket.h>#include<netinet/in.h>#include<netdb.h>#include<string.h>#include "sqlite3.h"char s_callback1[1024] = {0};char s_callback2[100][1024];int record_num=0;memset(s_callback2,' ',sizeof(s_callback2));int callback1_flag=0;int legal_user_flag=0;int port=7878;int callback1(void* p ,int nCount,char** pValue,char** pName);int callback2(void* p ,int nCount,char** pValue,char** pName);int main(){    struct sockaddr_in sin;    struct sockaddr_in pin;    int sock_descriptor;    int temp_sock_descriptor;    int size_of_addr;    char buf[1024]={0};    int i, length;        sock_descriptor=socket(AF_INET, SOCK_STREAM, 0);    if(sock_descriptor == -1)    {        perror("socket error!");        exit(1);    }    bzero(&sin, sizeof(sin));    sin.sin_family=AF_INET;    sin.sin_addr.s_addr = INADDR_ANY;    sin.sin_port=htons(port);    if(bind(sock_descriptor, (struct sockaddr*)&sin, sizeof(sin)) == -1)    {        perror("bind error");        exit(1);    }    if(listen(sock_descriptor, 20) == -1)    {        perror("listen1 error");        exit(1);    }    printf("waiting for accepting!\n");    while(1)    {        temp_sock_descriptor = accept(sock_descriptor, (struct sockaddr*)&pin, &size_of_addr);        if(temp_sock_descriptor == -1)        {            perror("accept error!");            exit(1);        }else{       printf("accept client request\n");}memset(buf, ' ', sizeof(buf));        if(recv(temp_sock_descriptor, buf, sizeof(buf), 0) == -1)        {            perror("recv()!");            exit(1);        }  else{/**********************************打开mail数据库*********************************/printf("message received from client: %s\n", buf);sqlite3 *db = NULL;        char *ErrMsg = 0;        int rc;        rc = sqlite3_open ("mail.db", &db);if (rc){ fprintf (stderr, "Can't open database: %s\n", sqlite3_errmsg (db)); sqlite3_close (db); exit (EXIT_FAILURE);        }else{     printf ("You have opened a sqlite3 database named mail.db successfully!\n");        }char sql[600]={0};/**********************************打开mail数据库*********************************//**插入user表的内容**/char username[13];char password[17];char nickname[21];char telnum[12];int user_num=0;char* new_usr_check_msg='\0';/**插入user表的内容**//**插入send表的内容**/int status_sender=0;char sender[13];char date_time[27];char title[81];char content[501];/**插入send表的内容**//**插入receive表的内容**/char receiver[13]={'\0'};int status_recer=0;int secret=0;/**插入receive表的内容**//**插入contact表中的内容**/char usrname[13];char contactor[13];/**插入contact表中的内容**/int j=0,k=0,st=0;char tmp_sender[13];char tmp_date_time[27];int col_num=0;int line_num=0;char line_num_buf[10];memset(line_num_buf,' ',sizeof(line_num_buf));switch (buf[0]){//确定要进行数据操作的表/**********************************************************向user表插入数据**********************************************************/case 'u':/*向user表插入数据*/{      memset(username,0,sizeof(username));      memset(password, 0, sizeof(password));      memset(nickname, 0, sizeof(nickname));      memset(telnum, 0, sizeof(telnum));printf("in case1");printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);      memcpy(username,buf+3,(int)buf[2]);printf("username:%s\n",username);printf("password_c:");      for(i=16;i<(int)buf[15]+16;i++){printf("%c",buf[i]);      }printf("\n");              memcpy(password,buf+16,(int)buf[15]);printf("password:%s\n",password);              if(buf[1]=='1'){//检查用户登录信息是否正确callback1_flag=0;sprintf(sql,"SELECT usrname,password FROM user WHERE usrname='%s' AND password='%s';",username,password);sqlite3_exec (db, sql, callback1, 0, &ErrMsg);memset(sql,'\0',sizeof(sql));if(callback1_flag==1){new_usr_check_msg="login_success";printf("login_success\n");legal_user_flag=1;if(send(temp_sock_descriptor, new_usr_check_msg, strlen(new_usr_check_msg), 0)==-1)           {        perror("can not send message\n");        exit(1);    }}if(callback1_flag==0){new_usr_check_msg="login_error";printf("login_error\n");if(send(temp_sock_descriptor, new_usr_check_msg, strlen(new_usr_check_msg), 0)==-1)           {printf("send()\n");        perror("can not send message\n");        exit(1);    }}      }      if(buf[1]=='0'){//检验新注册用户是否重名printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);sprintf(sql, "SELECT usrname FROM user WHERE usrname = '%s'", username);memset(s_callback1,0,sizeof(s_callback1));sqlite3_exec(db,sql,callback1,0,&ErrMsg);   if(strcmp(s_callback1,username)==0){printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__); new_usr_check_msg="usrname_repeat";if(send(temp_sock_descriptor, new_usr_check_msg, strlen(new_usr_check_msg), 0)==-1)           {printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);        perror("can not send message\n");        exit(1);    }else{printf("send success!\n");}}else{printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);memcpy(nickname,buf+33,(int)buf[32]);printf("nickname:%s\n",nickname);memcpy(telnum,buf+54,11);printf("telnum:%s\n",telnum);sprintf(sql,"INSERT INTO user(ID_U,usrname,password,nickname,telnum) VALUES(NULL,'%s','%s','%s','%s');",username,password,nickname,telnum);printf("sql:%s\n",sql);if(sqlite3_exec(db, sql, 0, 0, &ErrMsg)==0){printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);user_num++;printf("usernum:%d\n",user_num);memset(sql,'\0',sizeof(sql));}new_usr_check_msg="insert_newuser_success";//向user表插入新用户成功printf("new_usr_check_msg:%s\n",new_usr_check_msg);printf("sock_descriptor:%d",sock_descriptor); if(send(temp_sock_descriptor, new_usr_check_msg, strlen(new_usr_check_msg), 0)<0)//==-1)           {printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);        perror("can not send message\n");        exit(1);    }else{printf("send success!\n");}    }printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);memset(s_callback1,'\0',sizeof(s_callback1));memset(sql,'\0',sizeof(sql));      }memset(buf, 0, 1024);memset(username,0,sizeof(username));memset(password, 0, sizeof(password));memset(nickname, 0, sizeof(nickname));memset(telnum, 0, sizeof(telnum));new_usr_check_msg="0";break;}/**********************************************************向user表插入数据**********************************************************//**********************************************************向send表插入数据**********************************************************/       case 's':               {printf("in case2");printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);    if(legal_user_flag==1){memcpy(status_sender,buf+1,1);memcpy(sender,buf+2,(int)buf[2]);memcpy(date_time,buf+15,(int)buf[15]);memcpy(title,buf+42,(int)buf[42]);memcpy(content,buf+123,(int)buf[123]);sprintf(sql,"INSERT INTO send(ID_M,status_sender,sender,date_time,title,content) VALUES(NULL,%d,%s,%s,%s,%s);",status_sender,sender,date_time,title,content);if(sqlite3_exec (db, sql, 0, 0, &ErrMsg)<0){perror("insert send error!\n");memset(sql,'\0',sizeof(sql));}memset(sql,'\0',sizeof(sql));if(status_sender==2||status_sender==5||status_sender==8){//信件在发信人发件箱中时，可以向receive表中插入数据     for(i=0;i<(int)buf[624];i++){     j=0;secret=0;st=625;     for(k=st;buf[k]!=';';k++){if(buf[k]!='*'){   receiver[j]=buf[k];   j++;}else{        secret=1;}     }     st=k+1;sprintf(sql,"INSERT INTO receive(sender,receiver,date_time,status_recer,secret) VALUES(%s,%s,%s,%d.%d);",sender,receiver,date_time,status_recer,secret);sqlite3_exec(db,sql,0,0,&ErrMsg);memset(sql,'\0',sizeof(sql));sprintf(sql,"INSERT INTO contact(usrname,contactor) VALUES(%s,%s);",sender,receiver);sqlite3_exec(db,sql,0,0,&ErrMsg);memset(sql,'\0',sizeof(sql));memset(receiver, 0, sizeof(receiver));             }}memset(buf, 0, 1024);memset(sender,0,sizeof(sender));memset(date_time,0,sizeof(date_time));memset(title, 0, sizeof(title));memset(content, 0, sizeof(content));memset(receiver, 0, sizeof(receiver));      }      break;                 }/**********************************************************向send表插入数据**********************************************************//*****************************************收件箱标为已读、标为未读、删除已读、删除未读、彻底删除********************************************/      case 'r':       {printf("in case3");printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);     if(legal_user_flag==1){if(buf[1]=='9'){//彻底删除memcpy(tmp_sender,buf+2,(int)buf[2]);        memcpy(tmp_date_time,buf+15,(int)buf[15]);/*sqlite3_exec(db,"SELECT sender FROM receiver WHERE status_recer=4 OR status_recer=7;",callback1,0,&ErrMsg);memset(sql,'\0',sizeof(sql));strcpy(tmp_sender,s_callback1);memset(s_callback1,'\0',sizeof(s_callback1));sqlite3_exec(db,"SELECT date_time FROM receiver WHERE status_recer=4 OR status_recer=7;",callback1,0,&ErrMsg);memset(sql,'\0',sizeof(sql));strcpy(tmp_date_time,s_callback1);memset(s_callback1,'\0',sizeof(s_callback1));*/sprintf(sql,"DELETE FROM receive WHERE sender='%s' AND date_time='%s' AND status_recer=4 OR status_recer=7;",tmp_sender,tmp_date_time);sqlite3_exec(db,sql,0,0,&ErrMsg);memset(sql,'\0',sizeof(sql));sprintf(sql,"DELETE FROM send WHERE sender='%s' AND date_time='%s';",tmp_sender,tmp_date_time);sqlite3_exec(db,sql,0,0,&ErrMsg);memset(sql,'\0',sizeof(sql));}memcpy(sender,buf+2,(int)buf[2]);memcpy(date_time,buf+15,(int)buf[15]);sprintf(sql,"UPDATE receive SET status_receiver='%d' WHERE sender='%s' AND date_time='%s';",(int)buf[1],sender,date_time);sqlite3_exec(db,sql,0,0,&ErrMsg);memset(sql,'\0',sizeof(sql));memset(buf, 0, 1024);memset(sender,0,sizeof(sender));status_recer=0;      }break;       }/*****************************************收件箱标为已读、标为未读、删除已读、删除未读、彻底删除********************************************//*****************************************************向contact表中插入新数据********************************************************/           case 'c':/*向contact表中插入新数据*/       {printf("in case4");printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);     memcpy(usrname,buf+2,buf[2]);     memcpy(contactor,buf+15,buf[15]);     if(buf[1]=='1'){ sprintf(sql,"INSERT INTO contact(usrname,contactor) VALUES(%s,%s);",usrname,contactor);sqlite3_exec(db,sql,0,0,&ErrMsg);memset(sql,'\0',sizeof(sql));             }     if(buf[1]=='2'){        sprintf(sql,"UPDATE contact SET usrname='%s',contactor='%s';",usrname,contactor);sqlite3_exec(db,sql,0,0,&ErrMsg);memset(sql,'\0',sizeof(sql));     }     if(buf[1]=='3'){sprintf(sql,"DELETE FROM contact WHERE usrname='%s',contactor='%s';",usrname,contactor);     }     memset(buf, 0, 1024);     memset(usrname,0,sizeof(usrname));     memset(usrname,0,sizeof(usrname));     break;       }/*****************************************************向contact表中插入新数据****************************************************/         case '2':{printf("in case2");printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);     if(buf[1]=='0'){//向客户端发"草稿箱"内容memset(sender,0,sizeof(sender));//客户端传sender字段给服务器        memcpy(sender,buf+3,(int)buf[2]);memset(sql,'\0',sizeof(sql));sprintf(sql,"SELECT title,date_time FROM sender WHERE sender_status=1 AND sender='%s'LIMIT 1;",sender);sqlite3_exec(db,sql,callback2,0,&ErrMsg);line_num=record_num/col_num;line_num_buf[0]=(char)line_num;if(send(temp_sock_descriptor, ine_num_buf, strlen(ine_num_buf), 0)<0)   {printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);        perror("can not send message\n");        exit(1);    }else{printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);printf("send success!\n");}for(i=0;i<record_num;i++){if(send(temp_sock_descriptor,s_callback2[i],strlen(s_callback2[i]),0)<0)          {              perror("write");              return 1;          }else{printf("send s_callback2[%d] success\n",i);}}record_num=0;          }        if(buf[1]=='1'){//向客户端发送"已发送"内容memset(sender,0,sizeof(sender));memcpy(sender,buf+3,(int)buf[2]);memset(sql,0,sizeof(sql));memset(s_callback2,0,sizeof(s_callback2));sprintf(sql,"SELECT title,date_time FROM send WHERE sender='%s'AND status_sender=2 OR status_sender=5 OR status_sender=8;",sender);col_num=2;sqlite3_exec(db,sql,callback2,0,&ErrMsg);line_num=record_num/col_num;line_num_buf[0]=(char)line_num;if(send(temp_sock_descriptor, ine_num_buf, strlen(ine_num_buf), 0)<0)   {printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);        perror("can not send message\n");        exit(1);    }else{printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);printf("send success!\n");}for(i=0;i<record_num;i++){if(send(temp_sock_descriptor,s_callback2[i],strlen(s_callback2[i]),0)<0)          {              perror("write");              return 1;          }else{printf("send s_callback2[%d] success\n",i);}}record_num=0;}if(buf[1]=='2'){//向客户端发送一封邮件的具体内容memset(sender,0,sizeof(sender));memcpy(sender,buf+3,(int)buf[2]);memset(date_time,0,sizeof(date_time));memcpy(date_time,buf+15,(int)buf[14]);memset(recer,0,sizeof(recer));memcpy(recer,buf+42,(int)buf[41]);memset(sql,0,sizeof(sql));memset(s_callback2,0,sizeof(s_callback2));sprintf(sql,"SELECT content FROM send WHERE date_time='%s' AND sender IN (SELECT sender FROM receive WHERE sender='%s' AND date_time='%s' AND recer='%s');",date_time,sender,date_time,recer);col_num=1;sqlite3_exec(db,sql,callback2,0,&ErrMsg);if(send(temp_sock_descriptor,s_callback2[0],strlen(s_callback2[0]),0)<0)          {              perror("write");              return 1;          }else{printf("send s_callback2[0] success\n");}record_num=0;}if(buf[1]=='3'){//向客户端发送一封草稿的内容，若有收信人写在content内memset(sender,0,sizeof(sender));memcpy(sender,buf+3,(int)buf[2]);memset(date_time,0,sizeof(date_time));memcpy(date_time,buf+15,(int)buf[14]);memset(sql,0,sizeof(sql));memset(s_callback2,0,sizeof(s_callback2));sprintf(sql,"SELECT content FROM send WHERE sender='%s' AND date_time='%s';",sender,date_time);colnum=1;sqlite3_exec(db,sql,callback2,0,&ErrMsg);if(send(temp_sock_descriptor,s_callback2[0],strlen(s_callback2[0]),0)<0)          {              perror("write");              return 1;          }else{printf("send s_callback2[0] success\n");}record_num=0;}break;}case '3':{if(buf[1]=='0'){//向客户端发收信箱内容memset(recer,0,sizeof(recer));memcpy(recer,buf+3,(int)buf[2]);memset(sql,0,sizeof(sql));memset(s_callback2,0,sizeof(s_callback2));sprintf(sql,"SELECT s.sender,s.title,s.date_time FROM send s,receive r WHERE s.sender=r.sender AND s.date_time=r.date_time AND recer='%d' AND status_recer=3;",recer);sqlite3_exec(db,sql,callback2,0,&ErrMsg);line_num=record_num/col_num;line_num_buf[0]=(char)line_num;if(send(temp_sock_descriptor, ine_num_buf, strlen(ine_num_buf), 0)<0)   {printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);        perror("can not send message\n");        exit(1);    }else{printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);printf("send success!\n");}for(i=0;i<record_num;i++){if(send(temp_sock_descriptor,s_callback2[i],strlen(s_callback2[0]),0)<0)          {              perror("write");              return 1;          }else{printf("send s_callback2[%d] success\n",i);}}record_num=0;}if(buf[1]=='1'){//向客户端发收件箱内容memset(rec,0,sizeof(recer));memcpy(recer,buf+3,(int)buf[2]);memset(sql,0,sizeof(sql));memset(s_callback2,0,sizeof(s_callback2));sprintf(sql,"SELECT s.sender,s.title,s.date_time FROM send s,receive r WHERE s.sender=r.sender AND s.date_time=r.date_time AND recer='%d' AND status_recer=3 OR status_recer=6;",recer);sqlite3_exec(db,sql,callback2,0,&ErrMsg);line_num=record_num/col_num;line_num_buf[0]=(char)line_num;if(send(temp_sock_descriptor, ine_num_buf, strlen(ine_num_buf), 0)<0)   {printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);        perror("can not send message\n");        exit(1);    }else{printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);printf("send success!\n");}for(i=0;i<record_num;i++){if(send(temp_sock_descriptor,s_callback2[i],strlen(s_callback2[0]),0)<0)          {              perror("write");              return 1;          }else{printf("send s_callback2[%d] success\n",i);}}record_num=0;}if(buf[1]=='2'){//向客户端发已删除箱内容memset(rec,0,sizeof(recer));memcpy(recer,buf+3,(int)buf[2]);memset(sql,0,sizeof(sql));memset(s_callback2,0,sizeof(s_callback2));sprintf(sql,"SELECT s.sender,s.title,s.date_time FROM send s,receive r WHERE s.sender=r.sender AND s.date_time=r.date_time AND recer='%d' AND status_recer=4 OR status_recer=7;",recer);sqlite3_exec(db,sql,callback2,0,&ErrMsg);line_num=record_num/col_num;line_num_buf[0]=(char)line_num;if(send(temp_sock_descriptor, ine_num_buf, strlen(ine_num_buf), 0)<0)   {printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);        perror("can not send message\n");        exit(1);    }else{printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);printf("send success!\n");}for(i=0;i<record_num;i++){if(send(temp_sock_descriptor,s_callback2[i],strlen(s_callback2[i]),0)<0)          {              perror("write");              return 1;          }else{printf("send s_callback2[%d] success\n",i);}}record_num=0;}break;}case '4':{if(buf[1]=='0'){memset(usrname,0,sizeof(usrname));memcpy(usrname,buf[3],(int)buf[2]);memset(sql,0,sizeof(sql));memset(s_callback2,0,sizeof(s_callback2));sprintf(sql,"SELECT contactor FROM contact WHERE uarname='%s';",usrname);sqlite3_exec(db,sql,callback2,0,&ErrMsg);line_num=record_num/col_num;line_num_buf[0]=(char)line_num;if(send(temp_sock_descriptor, ine_num_buf, strlen(ine_num_buf), 0)<0)   {printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);        perror("can not send message\n");        exit(1);    }else{printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);printf("send success!\n");}for(i=0;i<record_num;i++){if(send(temp_sock_descriptor,s_callback2[i],strlen(s_callback2[i]),0)<0)          {              perror("write");              return 1;          }else{printf("send s_callback2[%d] success\n",i);}}record_num=0;}break;}}}memset(buf, 0, 1024);/*      length = strlen(buf);        for(i  = 0 ; i < length; i++)        {            buf[i] = toupper(buf[i]);`        }        if(send(temp_sock_descriptor, buf, length, 0) == -1)        {            perror("send()!");            exit(1);        }*/        close(temp_sock_descriptor);    }}int callback1(void* p ,int nCount,char** pValue,char** pName){printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);    int i = 0;callback1_flag=1;    for(i=0;i<nCount;i++)    {strcat(s_callback1, pValue[i]);    }    printf("s_callback1:%s\n", s_callback1);printf("[%s, %s, %d]\n", __FILE__, __FUNCTION__, __LINE__);    return 0;}static int callback2(void *NotUsed, int argc, char **argv, char **azColName) {      int i=0,k=0;      record_num=argc;     for(i=0; i<argc; i++){        strcpy(s_callback2[i],argv[i] ? argv[i] : "NULL");     }      printf("\n");     return 0; }