12.21
来源:互联网 发布:iphone视频拼接软件 编辑:程序博客网 时间:2024/05/30 04:48
#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
- 12.21
- 12.21
- 12.21
- 12.21
- 12.21
- 12.21入驻CSDN
- 12.21未消化文章
- 总结(12.11-12.21)
- 12.21培训日记
- 12.21日学习内容
- 复习杂谈12.21
- 今日观察 12.21 观看想法
- week plan: 2014.12.15-12.21
- python 函数 课堂笔记 12.21
- 2014.6.15~12.21 重新写日志
- py的函数及练习 12.21
- 12.21 python的函数介绍及其应用
- 第三十四次(北京)软件测试交流会12.21号
- centos6.7 mini 安装hadoop2.7.3完全分布式
- c语言小游戏,推箱子
- new delete
- C++迎娶C的聘礼
- 初级汇编程序(一)
- 12.21
- const修饰符
- #ifndef
- HBaseAPI使用,分布式搭建,多Master
- 微信小程序开发之扫码 扫一扫 wx.scanCode()
- java 环境变量原理
- 35-1-1
- Linux shell判断文件和文件夹是否存在
- 欧拉计划 38