1.18
来源:互联网 发布:域名为什么会被墙 编辑:程序博客网 时间:2024/06/05 23:43
#include<stdio.h>
#include<stdlib.h>
#include<sqlite3.h>
void create_table(sqlite3 *db)
{
char *sql;
char *errmsg=NULL;
sql = "create table if not exists mytable (id integer primary key,name txt);";
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("operator failed :%s\n",errmsg);
exit(-1);
}
}
int delete_record(sqlite3 *db)
{
char *errmsg=NULL;
char sql[100];
int n;
}
int insert_record(sqlite3 *db)
{
char *errmsg=NULL;
char sql[100];
int n;
char str[20];
printf("input :");
scanf("%d",&n);
scanf("%s",str);
sprintf(sql,"insert into mytable (id,name) values(%d,'%s');",n,str);
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("operator failed :%s\n",errmsg);
exit(-1);
}
}
int displaycb(void *para,int n_col,char **col_value,char **col_name)
{
int i;
printf("total column is %d\n",n_col);
for(i=0;i<n_col;i++)
{
printf("col_name:%s-->col_val:%s\n",col_name[i],col_value[i]);
}
printf("=================================\n");
return 0;
}
int inquire_usecd(sqlite3 *db)
{
char *sql;
char *errmsg=NULL;
sql="select * from mytable;";
if(SQLITE_OK != sqlite3_exec(db,sql,displaycb,NULL,&errmsg))
{
printf("operator failed :%s\n",errmsg);
exit(-1);
}
}
int main()
{
sqlite3 *db = NULL;
int ret;
ret = sqlite3_open("mydatabase.db",&db);
if(ret != SQLITE_OK)
{
perror("sqlite open");
}
else
{
printf("open sqlite3 database successfully!\n");
}
create_table(db);
insert_record(db);
inquire_usecd(db);
}
#include<stdlib.h>
#include<sqlite3.h>
void create_table(sqlite3 *db)
{
char *sql;
char *errmsg=NULL;
sql = "create table if not exists mytable (id integer primary key,name txt);";
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("operator failed :%s\n",errmsg);
exit(-1);
}
}
int delete_record(sqlite3 *db)
{
char *errmsg=NULL;
char sql[100];
int n;
}
int insert_record(sqlite3 *db)
{
char *errmsg=NULL;
char sql[100];
int n;
char str[20];
printf("input :");
scanf("%d",&n);
scanf("%s",str);
sprintf(sql,"insert into mytable (id,name) values(%d,'%s');",n,str);
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("operator failed :%s\n",errmsg);
exit(-1);
}
}
int displaycb(void *para,int n_col,char **col_value,char **col_name)
{
int i;
printf("total column is %d\n",n_col);
for(i=0;i<n_col;i++)
{
printf("col_name:%s-->col_val:%s\n",col_name[i],col_value[i]);
}
printf("=================================\n");
return 0;
}
int inquire_usecd(sqlite3 *db)
{
char *sql;
char *errmsg=NULL;
sql="select * from mytable;";
if(SQLITE_OK != sqlite3_exec(db,sql,displaycb,NULL,&errmsg))
{
printf("operator failed :%s\n",errmsg);
exit(-1);
}
}
int main()
{
sqlite3 *db = NULL;
int ret;
ret = sqlite3_open("mydatabase.db",&db);
if(ret != SQLITE_OK)
{
perror("sqlite open");
}
else
{
printf("open sqlite3 database successfully!\n");
}
create_table(db);
insert_record(db);
inquire_usecd(db);
}
0 0
- 1.18
- 1.18
- 1.18
- 1.18笔记
- 练习1.18
- 习题1.18
- 随笔1.18
- IceSword 1.18 by PJF
- 练习1.18-练习1.22
- Jersey 1.18 API文档
- 总结[1.4~1.18]
- SICP 练习1.18
- 1.18 css布局
- SICP 1.17&&1.18&1.19 solution
- 1.18.2013 #Practical Programming #1
- 操作系统篇(一)1.18
- SICP 习题 (1.18) 解题总结
- 【SICP练习】12 练习1.18
- 使用hexo+github免费搭建个人博客网站超详细教程
- 不带头结点的链表大例题
- UVA 1590 IP Networks 简单模拟
- CSDN博客如何转载
- [生存志] 第117节 九章算术均徭赋
- 1.18
- (六)charper3-Extending Your Blog Application之djangoByExample阅读笔记
- spring框架学习(三)junit单元测试
- 关于在android webview上运行html5的开发经验
- [BZOJ2178]圆的面积并(辛普森积分)
- 使用poi分多级sheet生成excel
- vim如何显示行号
- HDU 1166 敌兵布阵(线段树单点更新)
- 多平台轻量级消息推送系统msgd