数据库通讯录

最新推荐文章于 2024-05-02 18:25:30 发布
最新推荐文章于 2024-05-02 18:25:30 发布
阅读量390 收藏 2
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Jijiahao95/article/details/53178369
版权
/*****************************************************
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>

#define NAME_MAX 20
#define GENDER_MAX 10
#define STR_MAX 20
#define TEL_MAX 20
#define COUNT_MAX 20
#define AGE_MAX 5
int create_table(sqlite3 *db);
int menu(sqlite3 *db);
int enter(sqlite3 *db);
int quit(sqlite3 *db);
int add(sqlite3 *db);
int find(sqlite3 *db);
int find_count(sqlite3 *db);
int find_name(sqlite3 *db);
int find_tel(sqlite3 *db);
int display_all(sqlite3 *db);
int displaycb(void *para,int n_column,char **col_name,char **col_value);
int delete(sqlite3 *db);
int del_count(sqlite3 *db);
int del_name(sqlite3 *db);
int del_tel(sqlite3 *db);
int revise(sqlite3 *db);
int rev_count(sqlite3 *db);
int rev_name(sqlite3 *db);
int rev_tel(sqlite3 *db);

int main()
{
 sqlite3 *db;
 int ret;

 ret = sqlite3_open("mydatabase.db",&db);
 if(ret != SQLITE_OK)
 {
  perror("open error!\n");
  exit(0);
 }
 else
 {
  printf("you have already opened a qulite3 database successfully!\n");
 }

 create_table(db);
 menu(db);

    return 0;
}

int create_table(sqlite3 *db)
{
 char *errmsg = NULL;
 char *sql;

 sql = "create table if not exists tongxunlu(count integer primary key,name txt,gender txt,age integer,tel txt,strict txt);";
   
 if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
 {
  printf("create error : %s\n",errmsg);
  exit(0);
 }
}

int menu(sqlite3 *db)
{
 int select;
 printf("\n");
 printf("//*********************************************************\\\\\n");
 printf("//*********************************************************\\\\\n");
    printf("//                  南京工程学院班级通讯录                 \\\\\n");
 printf("//                       Version 1.0                       \\\\\n");
 printf("//                                                         \\\\\n");
 printf("//                                                         \\\\\n");
 printf("//                       (1)登录                           \\\\\n");
 printf("//                                                         \\\\\n");
 printf("//                       (2)退出                           \\\\\n");
 printf("//                                                         \\\\\n");
 printf("//*********************************************************\\\\\n");
 printf("\n");
 printf("请输入您的选择...\n");
 scanf("%d",&select);
 switch(select)
 {
  case 1 :enter(db);break;
  case 2 :quit(db);break;
  default : {
       printf("您的输入有误...\n");
       menu(db);
      };break;
 }
}

int enter(sqlite3 *db)
{
 int select;
 printf("//*********************************************************\\\\\n");
 printf("//*********************************************************\\\\\n");
    printf("//                    南京工程学院通讯录                   \\\\\n");
 printf("//                       Version 1.0                       \\\\\n");
 printf("//                                                         \\\\\n");
 printf("//                                                         \\\\\n");
 printf("//                       (1)查询                           \\\\\n");
 printf("//                       (2)添加信息                       \\\\\n");
 printf("//                       (3)删除信息                       \\\\\n");
 printf("//                       (4)修改信息                       \\\\\n");
 printf("//                       (5)退出                           \\\\\n");
 printf("//                                                         \\\\\n");
 printf("//*********************************************************\\\\\n");
 printf("//*********************************************************\\\\\n");
 printf("\n");
 printf("请输入您的选择...\n");
 scanf("%d",&select);
 switch(select)
 {
  case 1 :find(db);break;
  case 2 :add(db);break;
  case 3 :delete(db);break;
  case 4 :revise(db);break;
  case 5 :quit(db);break;
  default : {
       printf("您的输入有误...\n");
                      menu(db);
      };break;
 }
 return;

}

int quit(sqlite3 *db)
{
    printf("\n");
 printf("//*********************************************************\\\\\n");
 printf("//*********************************************************\\\\\n");
    printf("//                    南京工程学院通讯录                   \\\\\n");
 printf("//                       Version 1.0                       \\\\\n");
 printf("//                                                         \\\\\n");
 printf("//                                                         \\\\\n");
 printf("//                         谢谢使用                        \\\\\n");
 printf("//                                                         \\\\\n");
 printf("//*********************************************************\\\\\n");
 printf("//*********************************************************\\\\\n");
 printf("\n");
}

int add(sqlite3 *db)
{
 char *errmsg = NULL;
 char sql[100];
 char count[COUNT_MAX];
 char name[NAME_MAX];
 char gender[GENDER_MAX];
 char age[AGE_MAX];
 char tel[TEL_MAX];
 char strict[STR_MAX];
 printf("\n");
 printf("//*********************************************************\\\\\n");
 printf("//**********************添加信息界面***********************\\\\\n");
 printf("//                                                         \\\\\n");
 printf("//                                                         \\\\\n");
 printf("//                       请输入用户学号:");
 scanf("%s",count);
 printf("//                       请输入用户姓名:");
 scanf("%s",name);
 printf("//                       请输入用户性别:");
 scanf("%s",gender);
 printf("//                       请输入用户年龄:");
 scanf("%s",age);
 printf("//                       请输入用户电话:");
 scanf("%s",tel);
 printf("//                       请输入用户地区:");
 scanf("%s",strict);
 printf("//                                                         \\\\\n");
 printf("//*********************************************************\\\\\n");
 printf("//*********************************************************\\\\\n");

 sprintf(sql,"insert into tongxunlu(count,name,gender,age,tel,strict) values('%s','%s','%s','%s','%s','%s');",count,name,gender,age,tel,strict);
 if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
 {
  printf("add error : %s\n",errmsg);
  exit(0);
 }
 enter(db);
 return;
}

int find(sqlite3 *db)
{
 int select;
 printf("\n");
 printf("//*********************************************************\\\\\n");
 printf("//**********************查询信息界面***********************\\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                      (1)按学号查找                      \\\\\n");
    printf("//                      (2)按姓名查找                      \\\\\n");
    printf("//                      (3)按电话号码查找                  \\\\\n");
    printf("//                      (4)全部显示                        \\\\\n");
    printf("//                      (5)返回主菜单                      \\\\\n");
 printf("//                                                         \\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("\n");
 printf("请输入您的选择...\n");
 scanf("%d",&select);
 switch(select)
 {
  case 1 :find_count(db);break;
  case 2 :find_name(db);break;
  case 3 :find_tel(db);break;
  case 4 :display_all(db);break;
  case 5 :enter(db);break;
  default :{
      printf("您的输入有误!请重新输入...\n");
      find(db);
     };break;
 }
 return;
}

int find_count(sqlite3 *db)
{
 char count[COUNT_MAX];
    char sql[100];
    char *errmsg = NULL;
 printf("输入要查询的学号...\n");
 scanf("%s",count);

 sprintf(sql,"select * from tongxunlu where count = %s",count);
    if(SQLITE_OK != sqlite3_exec(db,sql,displaycb,NULL,&errmsg))
 {
  printf("find_count error : %s\n",errmsg);
  exit(0);
 }

    find(db);
}

int displaycb(void *para,int n_column,char **col_value,char **col_name)
{
 int i;
 for(i = 0;i < n_column;i++)
 {
  printf("%10s : %10s\n",col_name[i],col_value[i]);
 }
 printf("===============================================\n");
 return 0;
}

int find_name(sqlite3 *db)
{
 char name[NAME_MAX];
    char sql[100];
    char *errmsg = NULL;
 printf("输入要查询的姓名...\n");
 scanf("%s",name);

 sprintf(sql,"select * from tongxunlu where name = '%s'",name);
    if(SQLITE_OK != sqlite3_exec(db,sql,displaycb,NULL,&errmsg))
 {
  printf("find_name error : %s\n",errmsg);
  exit(0);
 }
    find(db);
}

int find_tel(sqlite3 *db)
{
 char tel[TEL_MAX];
    char sql[100];
    char *errmsg = NULL;
 printf("输入要查询的电话号码...\n");
 scanf("%s",tel);

 sprintf(sql,"select * from tongxunlu where tel = %s",tel);
    if(SQLITE_OK != sqlite3_exec(db,sql,displaycb,NULL,&errmsg))
 {
  printf("find_tel error : %s\n",errmsg);
  exit(0);
 }
    find(db);
}

int display_all(sqlite3 *db)
{
 char *errmsg = NULL;
 char *sql;
    sql = "select * from tongxunlu;";
 if(SQLITE_OK != sqlite3_exec(db,sql,displaycb,NULL,&errmsg))
 {
  printf("display_all error :%s\n",errmsg);
//  exit(0);
 }
 find(db);
}

int delete(sqlite3 *db)
{
 int select;
 printf("//*********************************************************\\\\\n");
 printf("//**********************删除信息界面***********************\\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                      (1)按学号查找删除                  \\\\\n");
    printf("//                      (2)按姓名查找删除                  \\\\\n");
    printf("//                      (3)按电话号码查找删除              \\\\\n");
    printf("//                      (4)返回主菜单                      \\\\\n");
 printf("//                                                         \\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("\n");
 printf("请输入您的选择...\n");
 scanf("%d",&select);
 switch(select)
 {
  case 1 :del_count(db);break;
  case 2 :del_name(db);break;
  case 3 :del_tel(db);break;
  case 4 :enter(db);break;
  default :{
      printf("您的输入有误!请重新输入...\n");
      delete(db);
     };break;
 }
}

int del_count(sqlite3 *db)
{
 char sql[100];
 char *errmsg = NULL;
 char count[COUNT_MAX];
    printf("enter the count :\n");
 scanf("%s",count);
 sprintf(sql,"delete from tongxunlu where count = %s;",count);
 if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
 {
  printf("del_count error : %s\n",errmsg);
  exit(0);
 }
 else
 {
  printf("delete succcess!\n");
 }
  delete(db);

}

int del_name(sqlite3 *db)
{
 char sql[100];
 char *errmsg = NULL;
 char name[NAME_MAX];
    printf("enter the name :\n");
 scanf("%s",name);

 sprintf(sql,"delete from tongxunlu where name = '%s';",name);
 if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
 {
  printf("del_name error : %s\n",errmsg);
  exit(0);
 }
 else
 {
  printf("delete succcess!\n");
 }
  delete(db);
}


int del_tel(sqlite3 *db)
{
 char sql[100];
 char *errmsg = NULL;
 char tel[TEL_MAX];
    printf("enter the tel :\n");
 scanf("%s",tel);

 sprintf(sql,"delete from tongxunlu where tel = %s;",tel);
 if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
 {
  printf("del_tel error : %s\n",errmsg);
  exit(0);
 }
 else
 {
  printf("delete succcess!\n");
 }
  delete(db);
}

int revise(sqlite3 *db)
{
 int select;
 printf("//*********************************************************\\\\\n");
 printf("//**********************修改信息界面***********************\\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                      (1)按学号查找修改                  \\\\\n");
    printf("//                      (2)按姓名查找修改                  \\\\\n");
    printf("//                      (3)按电话号码查找修改              \\\\\n");
    printf("//                      (4)返回主菜单                      \\\\\n");
 printf("//                                                         \\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("\n");
 printf("请输入您的选择...\n");
 scanf("%d",&select);
 switch(select)
 {
  case 1 :rev_count(db);break;
  case 2 :rev_name(db);break;
  case 3 :rev_tel(db);break;
  case 4 :enter(db);break;
  default : {
       printf("enter fail!\n");
       revise(db);
      };break;
 }
}

int rev_count(sqlite3 *db)
{
 char sql[100];
 char *errmsg = NULL;
 char cou[COUNT_MAX];
 char count[COUNT_MAX];
 char name[NAME_MAX];
 char gender[GENDER_MAX];
 char age[AGE_MAX];
 char tel[TEL_MAX];
 char strict[STR_MAX];
    printf("enter the count you want to revise\n");
 scanf("%s",cou);
 int select;
 printf("//*********************************************************\\\\\n");
 printf("//**********************修改信息界面***********************\\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                      (1)修改学号                        \\\\\n");
    printf("//                      (2)修改姓名                        \\\\\n");
    printf("//                      (3)修改性别                        \\\\\n");
    printf("//                      (4)修改年龄                        \\\\\n");
    printf("//                      (5)修改电话号码                    \\\\\n");
    printf("//                      (6)修改地区                        \\\\\n");
    printf("//                      (7)返回主菜单                      \\\\\n");
 printf("//                                                         \\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("\n");
 printf("请输入您的选择...\n");
 scanf("%d",&select);
 switch(select)
 {
  case 1 :{
     printf("enter the count \n");
     scanf("%s",count);
                    sprintf(sql,"update tongxunlu set count = %s where count = %s;",count,cou);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_count1 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 2 :{
     printf("enter the name \n");
     scanf("%s",name);
                    sprintf(sql,"update tongxunlu set name = '%s' where count = %s;",name,cou);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_count2 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 3 :{
     printf("enter the gender \n");
     scanf("%s",gender);
                    sprintf(sql,"update tongxunlu set gender = '%s' where count = %s;",gender,cou);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_count3 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 4 :{
     printf("enter the age \n");
     scanf("%s",age);
                    sprintf(sql,"update tongxunlu set age = %s where count = %s;",age,cou);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_count4 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 5 :{
     printf("enter the tel \n");
     scanf("%s",tel);
                    sprintf(sql,"update tongxunlu set tel = %s where count = %s;",tel,cou);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_count5 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 6 :{
     printf("enter the strict \n");
     scanf("%s",strict);
                    sprintf(sql,"update tongxunlu set strict = '%s' where count = %s;",strict,cou);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_count6 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 7 :enter(db);break;
  default : {
       printf("enter fail!\n");
       revise(db);
      };break;
 }
 enter(db);
}

int rev_name(sqlite3 *db)
{
 char sql[100];
 char *errmsg = NULL;
 char na[NAME_MAX];
 char count[COUNT_MAX];
 char name[NAME_MAX];
 char gender[GENDER_MAX];
 char age[AGE_MAX];
 char tel[TEL_MAX];
 char strict[STR_MAX];
    printf("enter the name you want to revise\n");
 scanf("%s",na);
 int select;
 printf("//*********************************************************\\\\\n");
 printf("//**********************修改信息界面***********************\\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                      (1)修改学号                        \\\\\n");
    printf("//                      (2)修改姓名                        \\\\\n");
    printf("//                      (3)修改性别                        \\\\\n");
    printf("//                      (4)修改年龄                        \\\\\n");
    printf("//                      (5)修改电话号码                    \\\\\n");
    printf("//                      (6)修改地区                        \\\\\n");
    printf("//                      (7)返回主菜单                      \\\\\n");
 printf("//                                                         \\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("\n");
 printf("请输入您的选择...\n");
 scanf("%d",&select);
 switch(select)
 {
  case 1 :{
     printf("enter the count \n");
     scanf("%s",count);
                    sprintf(sql,"update tongxunlu set count = %s where name = '%s';",count,na);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_name1 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 2 :{
     printf("enter the name \n");
     scanf("%s",name);
                    sprintf(sql,"update tongxunlu set name = '%s' where name = '%s';",name,na);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_name2 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 3 :{
     printf("enter the gender \n");
     scanf("%s",gender);
                    sprintf(sql,"update tongxunlu set gender = '%s' where name = '%s';",gender,na);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_name3 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 4 :{
     printf("enter the age \n");
     scanf("%s",age);
                    sprintf(sql,"update tongxunlu set age = %s where name = '%s';",age,na);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_name4 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 5 :{
     printf("enter the tel \n");
     scanf("%s",tel);
                    sprintf(sql,"update tongxunlu set tel = %s where name = '%s';",tel,na);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_name5 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 6 :{
     printf("enter the strict \n");
     scanf("%s",strict);
                    sprintf(sql,"update tongxunlu set strict = '%s' where name = '%s';",strict,na);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_name6 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 7 :enter(db);break;
  default : {
       printf("enter fail!\n");
       revise(db);
      };break;
 }
 enter(db);
}

int rev_tel(sqlite3 *db)
{
 char sql[100];
 char *errmsg = NULL;
 char t[TEL_MAX];
 char count[COUNT_MAX];
 char name[NAME_MAX];
 char gender[GENDER_MAX];
 char age[AGE_MAX];
 char tel[TEL_MAX];
 char strict[STR_MAX];
    printf("enter the tel you want to revise\n");
 scanf("%s",t);
 int select;
 printf("//*********************************************************\\\\\n");
 printf("//**********************修改信息界面***********************\\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                                                         \\\\\n");
    printf("//                      (1)修改学号                        \\\\\n");
    printf("//                      (2)修改姓名                        \\\\\n");
    printf("//                      (3)修改性别                        \\\\\n");
    printf("//                      (4)修改年龄                        \\\\\n");
    printf("//                      (5)修改电话号码                    \\\\\n");
    printf("//                      (6)修改地区                        \\\\\n");
    printf("//                      (7)返回主菜单                      \\\\\n");
 printf("//                                                         \\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("//*********************************************************\\\\\n");
    printf("\n");
 printf("请输入您的选择...\n");
 scanf("%d",&select);
 switch(select)
 {
  case 1 :{
     printf("enter the count \n");
     scanf("%s",count);
                    sprintf(sql,"update tongxunlu set count = %s where tel = %s;",count,t);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_tel1 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 2 :{
     printf("enter the name \n");
     scanf("%s",name);
                    sprintf(sql,"update tongxunlu set name = '%s' where tel = %s;",name,t);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_tel2 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 3 :{
     printf("enter the gender \n");
     scanf("%s",gender);
                    sprintf(sql,"update tongxunlu set gender = '%s' where tel = %s;",gender,t);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_tel3 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 4 :{
     printf("enter the age \n");
     scanf("%s",age);
                    sprintf(sql,"update tongxunlu set age = %s where tel = '%s';",age,t);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_tel4 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 5 :{
     printf("enter the tel \n");
     scanf("%s",tel);
                    sprintf(sql,"update tongxunlu set tel = %s where tel = %s;",tel,t);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_tel5 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 6 :{
     printf("enter the strict \n");
     scanf("%s",strict);
                    sprintf(sql,"update tongxunlu set strict = '%s' where tel = %s;",strict,t);
     if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
     {
      printf("rev_tel6 error :\n",errmsg);
                        exit(0);
     }
    };break;
  case 7 :enter(db);break;
  default : {
       printf("enter fail!\n");
       revise(db);
      };break;
 }
 enter(db);
}
Jjh449027368
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
数据库操作（通讯录）
08-11
一个数据库操作的实例，有兴趣的可以下载看看。
android数据库通讯录管理
05-12
本教程将通过一个简单的“android数据库通讯录管理”实例，来教你如何在Android中实现对数据库的CRUD（创建、读取、更新、删除）操作，并了解集合与数据库之间的交互。 首先，我们需要创建一个SQLite数据库。SQLite...
数据库写通讯录
Allureyou的博客
11-17 791
写的一个简单的通讯录，主要自己比较low，感谢给我找错的亲们！ #include #include #include #include void create_table(sqlite3 *db); void insert_record(sqlite3 *db); void contact_list(sqlite3 *db); //int displaycd(void
Android通讯录数据库介绍与基本操作（增删改查）(1)
最新发布
2401_84408267的博客
05-02 32
愿你有一天，真爱自己，善待自己。《Android学习笔记总结+移动架构视频+大厂面试真题+项目实战源码》点击传送门，即可获取！
数据库版通讯录（上周作业）
u011910350的博客
11-20 269
/***************************************************** copyright (C), 2014-2015, Lighting Studio. Co.,     Ltd.  File name： Author：Jerey_Jobs    Version:0.1    Date:  Description： Funcion List: 
通讯录（数据库）
weixin_43794611的博客
03-29 1971
这个感觉比较简单些，因为直接调用sql语句就好了，我看着别人的代码理解了一遍，自己敲了一遍 参考 -----> https://blog.csdn.net/jiaqi_327/article/details/20799277 #include <stdio.h> #include <stdlib.h> #include <sqlite3.h>...
xiaoyoulu.rar_数据库通讯录_通讯录 mdb
09-24
《数据库通讯录_通讯录 mdb》是一个基于Access数据库的应用程序，用于实现类似同学录的功能，包括学校查找、学校建立、通讯录管理和留言管理等。在深入探讨这些功能之前，我们首先需要了解Access数据库的基本概念。 ...
tongxunlu.rar_tongxunlu_数据库 通讯录_通讯录_通讯录 数据库
09-21
《构建与管理通讯录数据库系统》 通讯录作为日常生活中不可或缺的一部分，对于个人和企业来说都有着重要的作用。本文将深入探讨如何利用数据库系统构建和管理一个高效、实用的通讯录，以此来满足不同用户的需求。 ...
易语言EDB数据库通讯录软件源码-易语言
06-12
edb数据库，如果删除了会自动创建一个空白的数据库，调用了超级列表框排序模块，一并打包了 这个源码调用了“超级列表框排序.ec”模块，排序的部分是“部门”列，是在“备注”后面添加了“序号”作为排序依据，如果...
数据库通讯录系统实验报告.doc
06-08
数据库通讯录系统实验报告
通讯录数据库系统（完整项目，连接Sql可运行）
07-01
使用java实现了通讯录系统，具有可视化界面，实现对数据的增删改查功能。
个人通讯录-（数据库底层操作版）
07-29
＜个人通讯录＞程序使用说明： 1. 说明： ============= 本程序使用Windows SDK + OLDDB SDK完成，而不是VC + ATL完成。 2. 功能： ============= 本程序实现了添加，删除，修改，查询等基本功能。由于本程序只是本人的一个习作，程序可能没有实用价值。 所有的功能都在工具条上实现，根据工具条的提示即可操作。 3. 使用前的准备： ================= 本程序是在WIN98 + VC 6.0 + SQL SERVER 7.0下调试通过，因此，需要建立一个数据库AddrList,为此提供了三个sql script(在sql文件夹), 在SQL Server Query Analyzer中依次执行Create_DataBase.sql, Create_Table.sql,Insert_Data.sql这三个script即可。 4.其它说明： =============== 1.在文件夹中已提供一个Release版本的可执行文件。如果提供的源文件不能通过编译，可使用此可执行文件,看一下程序的各功能。 2.程序需要include一个sqloledb.h，这个文件在SQL SERVER的安装目录下，你可搜索后，将其copy到VC的include目录下。或copy到源文件目录中(源代码中也提供了一个)，并在源程序中将 #include <sqloledb.h> 改为 #include "sqloledb.h" 3.本来还想写一个教程，无奈本人太懒了，只好作罢。可E_MAIL与本人联系，旨在互相探讨。 E_mail: wlz_21951@sina.com
qt的连接数据库通讯录.rar
10-09
总之，"qt的连接数据库通讯录.rar"项目展示了如何使用QT和C++构建一个简单的通讯录管理应用，通过SQLite数据库存储和操作联系人信息。项目涉及到面向对象编程、数据库连接、SQL操作以及QT的信号和槽机制，这些都是...
vc++和数据库通讯录系统
07-12
【VC++与数据库通讯录系统】是一个利用Microsoft Visual C++（简称VC++）编程环境，结合Access数据库技术开发的应用程序。这个系统设计的目标是提供一个用户友好的界面，用于存储、管理和检索联系人信息，具备良好的...
ACCESS数据库通讯录
11-02
用access做的通讯录，就是乱传的，没必要下载。空的文件
通讯录（数据库版）
xyw_1122的博客
11-16 395
#include #include #include #include #define N 1024 void menu() { printf("＊＊＊＊＊＊＊＊＊＊欢迎使用通讯录＊＊＊＊＊＊＊＊＊＊\n"); printf("＊ ＊\n"); printf("＊1.
数据库编程之通讯录
CY_612的博客
05-26 229
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

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值