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;//收件人gg
	GtkWidget *entry11;//密送gg
	GtkWidget *entry2;//主题gg

	char *text;
static GtkWidget *window_color;
static GdkColor color;
static GtkWidget *drawarea;
GtkWidget *view;//编辑窗口
char name[20]="hjlhsa";//邮件地址gggggggggggggggggg
const 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 daxiao
	gtk_widget_modify_bg (drawarea, GTK_STATE_NORMAL,&color);//kongjian beijing
	gtk_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 anniu
GtkWidget * 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 xiang
	toolitem = 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 xiang
GtkWidget * 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 niu
	toolitem = 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);//2
	gtk_box_pack_start(GTK_BOX(bbox1),entry1,TRUE,TRUE,0);
	gtk_box_pack_start(GTK_BOX(bbox11),label11,FALSE,FALSE,2);//3
	gtk_box_pack_start(GTK_BOX(bbox11),entry11,TRUE,TRUE,2);
	gtk_box_pack_start(GTK_BOX(vbox),bbox1,FALSE,FALSE,2);//2fangru zonghe
	gtk_box_pack_start(GTK_BOX(vbox),bbox11,FALSE,FALSE,2);//3fangru zonghe
	gtk_box_pack_start(GTK_BOX(bbox2),label2,FALSE,FALSE,2);//4
	gtk_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 daxiao
	gtk_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 zonghe999999

	gtk_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);
	//初始化GTK
	gtk_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; 
}