嵌入式数据库

#include <stdio.h>#include <sqlite3.h>#include <string.h>#include <stdlib.h>int print(void* para, int columnCount, char **columnValue, char **columnName) //由用户处理查询的结果{    int j;    for (j = 0; j < columnCount; j++)    {        printf("%s = %s ", columnName[j], columnValue[j]);    }    printf("\n");    return 0;}int main(){    sqlite3 *ppdb;    int ret, i;    char sql[100] = {0};    char name[20] = {0};    int id;    char sex;    ret = sqlite3_open("student.db", &ppdb);  //打开一个数据库；若该数据库文件不存在，则自动创建。打开或者创建数据库的命令会被缓存，直到这个数据库真正被调用的时候才会被执行    if (ret != SQLITE_OK)    {        perror("sqlite3_open");        exit(1);    }    sprintf(sql, "create table if not exists student (name text, id integer, sex text);");    //把格式化的数据写入sql字符串缓冲区    ret = sqlite3_exec(ppdb, sql, NULL, NULL, NULL); //编译和执行零个或多个SQL 语句    if (ret != SQLITE_OK)    {        perror("sqlite3_exec1");        exit(1);    }    for (i = 0; i < 3; i++)    {        memset(sql, 0, sizeof(sql));  //数组清零        scanf("%s %d %c", name, &id, &sex);        sprintf(sql, "insert into student (name, id, sex) values ('%s', %d, '%c');", name, id, sex);        ret = sqlite3_exec(ppdb, sql, NULL, NULL, NULL);        if (ret != SQLITE_OK)        {            perror("sqlite3_exec2");            exit(1);        }        memset(name, 0, sizeof(name));    }    sprintf(sql, "select * from student;");    ret = sqlite3_exec(ppdb, sql, print, NULL, NULL);    if (ret != SQLITE_OK)    {        perror("sqlite3_exec3");        exit(1);    }    return 0;}