通讯录3

一 address.h中内容

二 main.c中内容

三 address.c中内容

#include “address.h”

void Menu_Face()
{
printf (“\n");
printf (" address book \n");
printf ("\n”);
printf ("* 1)add \n");
printf (" 2)display \n");
printf (" 3)search \n");
printf (" 4)delete \n");
printf (" 5)update \n");
printf (" 0)exit \n");
printf ("\n");
printf ("*\n\n");
printf (“input \n”);

}

void Menu(sqlite3 *db)
{
int ret;
int order;
system(“clear”);
Menu_Face();
scanf("%d", &order);
getchar();
switch(order)
{
case 1:
{
insert_record(db);
printf(“insert success!”);
getchar();
Menu(db);
break;
}
case 2:
{
contact_list(db);
getchar();
Menu(db);
break;
}
case 3:
{
search_contact(db);
printf(“search success!”);
getchar();
Menu(db);
break;
}
case 4:
{
delete_contact(db);
printf(“delete success!”);
getchar();
Menu(db);
break;
}
case 5:
{
update_contact(db);
printf(“updata success!”);
getchar();
Menu(db);
break;
}
case 0:
{
printf(“Exit success!\n”);
exit(0);
break;
}
default:
{
printf(“Please input right order!\n\n”);
sleep(1);
break;
}
}
}

void create_table(sqlite3 *db)
{
char *errmsg = NULL;
char *sql = NULL;
int ret;
sql = “create table if not exists mytable (id integer primary key, name text, phone text, addr text);”;
ret = sqlite3_exec(db, sql, NULL, NULL, &errmsg);
if(ret != SQLITE_OK)
{
printf(“insert table error: %s\n”, errmsg);
}
}

void insert_record(sqlite3 *db)
{
char sql[100];
char *errmsg = NULL;
int id;
char name[20];
char phone[15];
char addr[30];
system(“clear”);
printf(“insert Contact\n”);
printf(“please insert id\n”);
scanf("%d",&id);
getchar();
printf(“please insert name\n”);
scanf("%s",name);
getchar();
printf(“please insert phone\n”);
scanf("%s",phone);
getchar();
printf(“please insert addr\n”);
scanf("%s",addr);
getchar();
sprintf(sql, “insert into mytable values (%d, ‘%s’, ‘%s’, ‘%s’ );”, id, name, phone, addr);
if(SQLITE_OK != sqlite3_exec(db, sql, NULL, NULL, &errmsg))
{
printf(“insert record error: %s\n”, errmsg);
}
}

void contact_list(sqlite3 *db)
{
int nrow,ncolumn;
char **azresult;
char *sql;
char *errmsg = NULL;
int i;
sql = “select * from mytable;”;
if(SQLITE_OK != sqlite3_get_table(db,sql,&azresult,&nrow,&ncolumn,&errmsg))
{
printf(“contact failed: %s\n”,errmsg);
exit(-1);
}
printf(“row:%d\n column: %d\n”,nrow,ncolumn);
printf(“the result of querying is:\n”);
for(i = 0; i < (nrow + 1) *ncolumn; i++)
{
printf("%10s",azresult[i]);
if((i + 1) % ncolumn == 0)
{
printf("\n");
}
}
sqlite3_free_table(azresult);
}

void search_contact(sqlite3 *db)
{
char name[20];
char sql[100];
char *errmsg;
int nrow,ncolumn;
char **azresult;
int i;
int ret;
system(“clear”);
printf(“search contact\n”);
printf(“search name\n”);
scanf("%s", name);
getchar();
sprintf(sql, “select * from mytable where name = ‘%s’”,name);
if(SQLITE_OK != sqlite3_get_table(db, sql, &azresult, &nrow, &ncolumn, &errmsg))
{
printf(“serach failed: %s\n”, errmsg);
exit(0);
}
for(i = 0; i < (nrow + 1) * ncolumn; i++)
{
printf("%10s", azresult[i]);
if((i + 1) % ncolumn == 0)
{
printf("\n");
}
}
}

void delete_contact(sqlite3 *db)
{
char sql[100];
int id;
char *errmsg;
int ret;
system(“clear”);
printf(“Delect id\n”);
scanf("%d", &id);
getchar();
sprintf(sql, “delete from mytable where id = %d”, id);
ret = sqlite3_exec(db, sql, NULL, NULL, &errmsg);
if(ret != SQLITE_OK)
{
printf(“delete contact error: %s\n”, errmsg);
exit(-1);
}
}

void update_contact(sqlite3 *db)
{
int id;
char sql[100];
char name[20];
char phone[15];
char addr[30];
char *errmsg = NULL;
int ret;
system(“clear”);
printf(“Update contact\n”);
printf(“id: “);
scanf(”%d”,&id);
getchar();
sprintf(sql, “select *from mytable where id = %d”,id);
ret = sqlite3_exec(db, sql, NULL, NULL, &errmsg);
if(ret != SQLITE_OK)
{
printf(“select is error: %s\n”, errmsg);
}
printf(“new phone:”);
scanf("%s", phone);
getchar();
sprintf(sql, “update mytable set phone = ‘%s’ where id = %d;”,phone,id);
ret = sqlite3_exec(db, sql, NULL, NULL, &errmsg);//删除
printf(“new addr:”);
scanf("%s",addr);
getchar();
sprintf(sql, “update mytable set addr = ‘%s’ where id = %d;”,addr,id);
ret = sqlite3_exec(db, sql, NULL, NULL, &errmsg);
if(ret != SQLITE_OK)
{
printf(“updata table error: %s\n”, errmsg);
exit(-1);
}
}