简单的C语言和数据库连接小程序

#include <stdio.h>

#include <sqlite3.h>

#include <stdlib.h>

#include <string.h>

 

int print(void *para, intcolumnCount,char** columnValue, char** columnName)

{

    int i;

        for (i=0 ;i< columnCount; i++)

        {

               printf ("%s =%s",columnName[i],columnValue[i]);

    }

    

        printf ("\n");

        return 0;

 

 }

 

 

int main ()

{

    int ret,i;

    sqlite3 *ppdb;

    char sql[100] ={0};

     char name [10] ={0};

     char sex;

    int age ;

 

        ret =sqlite3_open ("student.db",&ppdb);  //创建一个数据库//

        if (ret != SQLITE_OK )

        {

               perror ("sqlite_open");