数据库版联系人C语言电子通讯录

你的名字 2022-09-30 06:04 214阅读 0赞

/*****************************************************
    copyright (C), 2014-2015, Lighting Studio. Co.,     Ltd. 
    File name：
    Author：Jerey_Jobs    Version:0.1    Date: 
    Description：
    Funcion List: 
    *****************************************************/
    
    #include <stdio.h>
    #include <stdlib.h>
    #include <sqlite3.h>
    int flag = 0;
    
    void create_table(sqlite3 *db)
    {
    	char *sql = NULL;
    	char *errmsg= NULL;
    	int ret;
    
    	sql = "create table if not exists mytable(姓名 text,电话 text,地址 text,邮箱 text);";
    	ret = sqlite3_exec(db,sql,NULL,NULL,&errmsg);
    	
    	if(SQLITE_OK != ret)
    	{
    		printf("create table fail:%s\n",errmsg);
    		exit(-1);
    	}
    }
    void insert_record(sqlite3 *db)
    {
    
    	char sql[100];
    	char *errmsg = NULL;
    	int ret;
    	int id;
    	char name[20];
    	char addr[20];
    	char Email[20];
    	char tel[20];
    
    
    	printf("请输入姓名:");
    	scanf("%s",name);
    	printf("请输入手机号码:");
    	scanf("%s",tel);
    	printf("请输入邮箱:");
    	scanf("%s",Email);
    	printf("请输入地址:");
    	scanf("%s",addr);
    	sprintf(sql,"insert into mytable(姓名,电话,地址,邮箱) values('%s','%s','%s','%s');",name,tel,addr,Email);
    
    	ret = sqlite3_exec(db,sql,NULL,NULL,&errmsg);
    
    	if(SQLITE_OK != ret)
    	{
    		printf("insert record fail:%s\n",errmsg);
    		exit(-1);
    	}
    printf("保存成功!\n");
    }
    
    void delete_record(sqlite3 *db,char *name)
    {
    
    	char sql[100];
    	char *errmsg = NULL;
    	int ret;
    	int id;
        
    	sprintf(sql,"delete from mytable where 姓名 = '%s';",name);
    	ret = sqlite3_exec(db,sql,NULL,NULL,&errmsg);
    	
    	if(ret != SQLITE_OK)
    	{
    
    		printf("delete faile:%s",errmsg);
    		exit(0);
    	}
    
    	printf("删除成功!\n");
    }
    
    void look_name(sqlite3 *db,char *name)
    {
    	char sql[100];
    	char **presult = NULL;
    	char *errmsg;
    	int n_row,n_col;
    	int ret;
    	int i;
    
    	sprintf(sql,"select * from mytable where 姓名 like '%s';",name);
        ret = sqlite3_get_table(db,sql,&presult,&n_row,&n_col,&errmsg);
    	if(SQLITE_OK != ret)
    	{
    		printf("get table fail:%s\n",errmsg);
    		exit(-1);
    	}
    	printf("联系人信息为:\n");
    
    	for(i = 0;i < (n_row + 1)*n_col;i++)
    	{
            if(i<=3)
    		{
    		printf("%-17s",presult[i]);
    		if(i==3)printf("\n");
    		}
    		else
    		{
    
    		printf("%-15s",presult[i]);
    		
    		if((i+1)%n_col == 0)
    			printf("\n");
    		if((i+1) == n_col)
    			printf("---------------------------------------------\n");
               }
    		}
    sqlite3_free_table(presult);
    }
    void inquire_nocb(sqlite3 *db)
    {
    
    	char *sql = NULL;
    	char **presult = NULL;
    	char *errmsg;
    	int n_row,n_col;
    	int ret;
    	int i;
    
    	sql = "select * from mytable;";
    	ret = sqlite3_get_table(db,sql,&presult,&n_row,&n_col,&errmsg);
    	if(SQLITE_OK != ret)
    	{
    
    		printf("get table fail:%s\n",errmsg);
    		exit(-1);
    	}
    	for(i = 0;i < (n_row + 1)*n_col;i++)
    	{
            if(i<=3)
    		{
    		printf("%-17s",presult[i]);
    		if(i==3)printf("\n");
    		}
    		else
    		{
    
    
    		printf("%-15s",presult[i]);
    			if((i+1)%n_col == 0)
    		{
    
    			printf("\n");
    		}
    		}
    	}
    	sqlite3_free_table(presult);
    }
    
    int check(sqlite3 *db,char *to_name)
    {
    
    	char *sql;
    	char **presult = NULL;
    	char *errmsg;
    	int n_row,n_col;
    	int ret;
    	int i;
       int k=0;
    	sql = "select * from mytable;";
    
    	ret = sqlite3_get_table(db,sql,&presult,&n_row,&n_col,&errmsg);
    	if(ret != SQLITE_OK)
    	{
    		printf("check get table fail:%s\n",errmsg);
    		exit(-1);
    	}
    	
    	for(i = 0;i < (n_row + 1)*n_col;i++)
    	{
            if(strcmp(to_name,presult[i])==0)
    		{
    			k=1;
    		}
    	
    	//	printf("%15s",presult[i]);
    	
    	}
    	if(k == 0)
    	{
    		printf("联系人不存在!\n");
    		return 1;
    	}
    return 0;
    }
    void update_new(sqlite3 *db,char *from_name,char *new,int num)
    {
    
    	char sql[100];
    	char * errmsg;
    	char name[10];
    	int ret;
    
    		if(num == 1)
    			sprintf(sql,"update mytable set 姓名 = '%s' where 姓名 = '%s';",new,from_name);
    		else if(num == 2)
    			sprintf(sql,"update mytable set 地址 = '%s' where 姓名 = '%s';",new,from_name);
    
    		else if(num == 3)
    			sprintf(sql,"update mytable set 邮箱 = '%s' where 姓名 = '%s';",new,from_name);
    
    		else if(num == 4)
    			sprintf(sql,"update mytable set 电话 = '%s' where 姓名 = '%s';",new,from_name);
    		ret = sqlite3_exec(db,sql,NULL,NULL,&errmsg);
    		if(ret != SQLITE_OK)
    		{
    
    			printf("update fail:%s",errmsg);
    			exit(-1);
    		}
    }
    
    
    
    int main()
    {
    	sqlite3 *db=NULL;
    	char fullname[20];
    	char new[20];
    	char from_name[20];
    	int ret;
    	int num1,num;
    	int tel,i=1,a;
    
    	ret=sqlite3_open("mydatabase.db",&db);
    
    	if(SQLITE_OK != ret)
    	{
    		perror("open fail!");
    		exit(EXIT_FAILURE);
    	}
    	else
    	{
    		printf("open table successfull!\n");
    	}
    
        create_table(db);
    	while(1)
    	{
    
    		printf("___________________________________\n");
    		printf("       ******主菜单*********\n");
    		printf("[1]查看联系人       [2]新建联系人\n");
    		printf("[3]删除联系         [4]修改联系人\n");
    		printf("[5]显示所有联系人   [6]退出\n");
    		printf("***若没联系人需要先添加***\n");
    		printf("___________________________________\n");
    		scanf("%d",&num1);
    
    		switch(num1)
    		{
    			case 1:
    				{ //查找联系人
    
    					printf("请输入查找姓名: ");
    					scanf("%s",fullname);
                           a = check(db,fullname);
    					  if(a==1)
    					  {
    						  break;
    					  }
    					look_name(db,fullname);
    					printf("\n按回车键回到主菜单。");
    					getchar();getchar();
    					break;
    				}
    
    
    			case 2:{   //新建联系人
    					   insert_record(db);
    					   printf("\n按回车键回到主菜单。");
    					   getchar();getchar();
    					   break;
    
    				   }
    			case 3:{
    
    					   //删除
    					   printf("\n输入你所要删除的人的姓名:");
    					   scanf("%s",fullname);
                           a = check(db,fullname);
    					  if(a==1)
    					  {
    						  break;
    					  }
    	                     delete_record(db,fullname);
    					   printf("\n按回车键回到主菜单。");
    					   getchar();getchar();
    					   break;
    				   }
    			case 4:{
    
    					   printf("请输入姓名: ");
    					   scanf("%s",from_name);
                          a = check(db,from_name);
    					  if(a==1)
    					  {
    						  break;
    					  }
                           
    					   look_name(db,from_name);
    					   printf("----------------------\n");
    					   //修改
    					   while(1)
    					   {
    						   printf("***************************\n");
    						   printf("[1]修改姓名 [2]修改地址\n");
    						   printf("[3]修改邮箱 [4]修改电话\n");
    						   printf("[5]返回上一级\n");
    						   printf("***************************\n");
    
    						   printf("请选择更改的选项:");
    						   scanf("%d",&num);
    						   switch(num)
    						   {
    							   case 1:
    								   {
    									   printf("请输入新的名字:");
    									   scanf("%s",new);
    									   update_new(db,from_name,new,num);
    									   break;
    								   }
    							   case 2:
    
    								   {
    									   printf("请输入新的地址:");
    									   scanf("%s",new);
    									   update_new(db,from_name,new,num);
    									   break;
    								   }
    							   case 3:
    								   {
    									   printf("请输入新的邮箱:");
    									   scanf("%s",new);
    									   update_new(db,from_name,new,num);
    									   break;
    								   }
    							   case 4:
    
    								   {
    									   printf("请输入新的电话:");
    									   scanf("%s",new);
    									   update_new(db,from_name,new,num);
    									   break;
    								   }
    							   case 5:goto end;
    						   }
    					   }
                            end:break;
    				   }
    			case 5:{
    
    					   inquire_nocb(db);
    					   printf("\n按回车键回到主菜单。");
    					   getchar();getchar();
    					   break;
    				   }
    			case 6: exit(-1);
    					break;
    		}
    	}
    
    	sqlite3_close(db);
    	return 0;
    }