通讯录
#include <stdio.h>
#include <sqlite3.h>
#include <stdlib.h>
void menu() //菜单
{
printf("******************* welcome *********************\n");
printf("******************* 菜单 *********************\n");
printf("******* 1--添加联系人 ***********\n");
printf("******* 2--查找联系人 ***********\n");
printf("******* 3--显示全部联系人 ***********\n");
printf("******* 4--删除联系人 ***********\n");
printf("******* 5--清空联系人 ***********\n");
printf("******* 0--退出通讯录 ***********\n");
printf("****************************************************\n");
}
void create_table(sqlite3 * db)
{
char *sql;
char *errmsg;
int rec;
sql = "create table if not exists mytable(name text,sex text,age integer,address text,tel text primary key,qq text);";
rec = sqlite3_exec(db,sql,NULL,NULL,&errmsg);
if(rec != SQLITE_OK)
{
printf("create error! %s\n",errmsg);
exit(-1);
}
}
void insert_book(sqlite3 *db) //添加联系人
{
char name[20];
char sex[5];
char address[50];
char tel[15];
char qq[15];
int age;
char sql[200];
char *errmsg;
int rec;
char c = 0;
do
{
printf("请输入姓名,性别,年龄,地址,电话,qq:\n");
scanf("%s%s%d%s%s%s",name,sex,&age,address,tel,qq);
sprintf(sql,"insert into