数据库编程之通讯录

Database.c

#include "Database.h"

int Add(char* name, char* number)
{
	//初始化，绑定
	sqlite3 *db;
	int ret = sqlite3_open("/home/ben/0524/text.db", &db);
	if(ret != SQLITE_OK)
	{
		perror("open error!");
		exit(1);
	}

	//sql语句
	char *error;
	char sql[1024];
	sprintf(sql, "insert into Address values('%s', '%s')", name, number);

	//执行sql语句
	ret  = sqlite3_exec(db, sql, NULL, NULL, &error);
	if(ret != SQLITE_OK)
	{
		perror("Add_insert_error");
		sqlite3_close(db);
		return 0;
	}
	sqlite3_close(db);
	return 1;
}

int Delete(char* name)
{
	//初始化，绑定
	sqlite3 *db;
	int ret = sqlite3_open("/home/ben/0524/text.db", &db);
	if(ret != SQLITE_OK)
	{
		perror("open error!");
		exit(1);
	}
	//sql语句
	char *error;
	char sql[1024];
	sprintf(sql, "delete from Address where name = '%s'", name);

	//执行sql语句
	ret  = sqlite3_exec(db, sql, NULL, NULL, &error);
	if(ret != SQLITE_OK)
	{
		perror("Delete__error");
		sqlite3_close(db);
		return 0;
	}
	sqlite3_close(db);
	return 1;

}

int Update(char* name, char* number)
{
	//初始化，绑定
	sqlite3 *db;
	int ret = sqlite3_open("/home/ben/0524/text.db", &db);
	if(ret != SQLITE_OK)
	{
		perror("open error!");
		exit(1);
	}
	//sql语句
	char *error;
	char sql[1024];
	sprintf(sql, "update Address set number = '%s' where name = '%s'",number, name);

	//执行sql语句
	ret  = sqlite3_exec(db, sql, NULL, NULL, &error);
	if(ret != SQLITE_OK)
	{
		perror("Update__error");
		sqlite3_close(db);
		return 0;
	}
	sqlite3_close(db);
	return 1;
}

char** Select(char* name)
{
	//初始化，绑定
	sqlite3 *db;
	int ret = sqlite3_open("/home/ben/0524/text.db", &db);
	if(ret != SQLITE_OK)
	{
		perror("open error!");
		exit(1);
	}

	int row, col;
	char ** result = (char** )malloc(1024*sizeof(char));
	char *error;
	char sql[1024];
	sprintf(sql,"select number from Address where name = '%s'",name);

	ret = sqlite3_get_table(db, sql, &result, &row, &col, &error);
	if(ret != SQLITE_OK)
	{
		perror("Select_Select error");
		sqlite3_close(db);
		return 0;
	}

	sqlite3_close(db);

	return result;

	
}

Database.h

#include <sqlite3.h>
#include <stdlib.h>
#include <stdio.h>

//添加
int Add(char* name, char* number);

//删除
int Delete(char* name);

//修改
int Update(char* name, char* number);

//查看
char** Select(char *name);

mian.c

#include <stdio.h>
#include <stdlib.h>
#include "Database.h"

int main(void)
{
	int choose;

	while(1)
	{
		printf("1.添加 2.删除 3.查询 4.修改 0.退出\n");
		scanf("%d",&choose);
		switch(choose)
		{
		case 1:
		{
			char data[12];
			char name[10];
			char buf[1024];

			printf("输入名字： ");
			scanf("%s",name);
			printf("输入电话： ");
			scanf("%s",data);

			Add(name, data);
			printf("----------------\n");
			break;
		}
		case 2:
		{
			char name[10];
			printf("选择删除的人： ");
			scanf("%s",name);
			
			Delete(name);
			printf("----------------\n");
			break;
		}
		case 3:
		{
			/*char** result = Select();
			int i,j;
			int row = sizeof(result)/sizeof(result[0]);
			int col = sizeof(result[0])/sizeof(result[0][0]);
			printf("2---- %d, %d,%s\n",row,col,result[3]);
			for(i=0;i<row;i++)
			{
				for(j=0;j<col;j++)
				{
					printf("%s ", result[j]);
				}
				printf("\n");
			}*/
			char name[16];
			printf("输入名字：\n");
			scanf("%s",name);
			char **result = Select(name);
			printf("%s\n",result[1]);
			printf("----------------\n");
			break;
		}
		case 4:
		{
			char name[10];
			char data[12];
			printf("输入你要修改的人： ");
			scanf("%s",name);
			printf("输入修改后的电话号：");
			scanf("%s",data);
		
			Update(name, data);
			printf("----------------\n");
			break;
		}
		case 0:
		{
			printf("----------------\n");
			exit(0);
		}

		}
	}
	return 0;
}