5.17
来源:互联网 发布:linux暴力破解root密码 编辑:程序博客网 时间:2024/05/16 17:52
#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
- 5.17
- 5.17
- 5.17
- 5.17
- 5.17
- 5.17
- 5.17
- 5.17-5.20
- 练习5.17
- 5.17 考研日志
- 传智播客学习笔记5.17
- 5.17实验要求
- csapp2e 家庭作业 5.17
- Sample 5.17:textin2.cpp
- 书中代码 5.17
- day67(5.17struts2四)
- mysql5.5.17源码安装
- 5.17周赛总结
- Ubuntu下嵌入式Linux开发环境搭建
- 数据库like查询
- hdu-3085(双向bfs)
- Math数组Date
- codevs 1078 最小生成树
- 5.17
- 细致分析cookie、session、sessionid 与jsessionid
- 欢迎使用CSDN-markdown编辑器
- (个人)AR电子书系统创新实训第二周(1)
- 多节点安装部署kubernetes
- 华为实习生笔试题
- Golang程序配置方案小结
- Struts1框架四之文件上传
- 进度条的开发