【文件属性】:
文件名称:c程序控制sqlite
文件大小:4KB
文件格式:RAR
更新时间:2015-09-10 12:47:22
c程序 表 增删改查 sqlite
用c程序控制sqlite的增删改查
#include
#include
#include
#include
#include "insert.h"
#include "delet.h"
#include "serch.h"
#include "change.h"
#include "print.h"
int main(int argc,char *argv[])
{
sqlite3 * db = NULL;
int result;
char *errmsg = NULL;
char **dbResult;
int nRow, nColumn;
int i , j;
int index;
char temp1[50];
char temp2[50];
//errmsg = NULL;
//result = sqlite3_open("./test.db",&db;);
//result = sqlite3_exec(db,"create table student(num,name,age);",NULL,NULL,&errmsg;);
while(1)
{
printf("----------SQLITE3------------\n");
printf("Insert please input 1 \n");
printf("Delete data please input 2\n");
printf("Serch data please input 3\n");
printf("Change data please input 4\n");
printf("Print all please input 5\n");
printf("-----------------------------\n");
printf("Input your choise :");
scanf("%d",&i);
switch (i)
{
case 1:
Insert();
break;
case 2:
Delet();
break;
case 3:
Serch();
break;
case 4:
Change();
break;
case 5:
Print();
break;
}
}
return 0;
}
【文件预览】:
zdq
----change.h(2KB)
----print.h(1KB)
----sqlit.c(1KB)
----delet.h(2KB)
----Makefile(123B)
----insert.h(1KB)
----serch.h(3KB)