数据库2
来源:互联网 发布:施耐德plc仿真软件 编辑:程序博客网 时间:2024/05/21 10:58
/*****************************************************
copyright (C), 2014-2015, Lighting Studio. Co., Ltd.
File name:
Author:Jerey_Jobs Version:0.1 Date:
Description:
Funcion List:
*****************************************************/
#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>
int create_db(sqlite3 *db)
{
char * errmsg;
char *sql;
sql = "create table if not exists mytable (id integer primary key,name text);";
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("create table error!: %s\n",errmsg);
exit (-1);
}
return 0;
}
int insert_db(sqlite3 *db)
{
char * errmsg = NULL;
char sql[100];
int id;
char name[10];
int i;
// sql = "insert into mytable (id,name)values(NULL,'huang');";
for(i = 0;i < 3;i++)
{
printf("please input id:\n");
scanf("%d",&id);
printf("please input name:\n");
scanf("%s",name);
sprintf(sql,"insert into mytable (id,name)values(%d,'%s');",id,name);
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))//执行sql
{
printf("insert table error! : %s",errmsg);
exit(-1);
}
}
/* sql = "insert into mytable (id,name)values(NULL,'li');";
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("insert table error! : %s",errmsg);
exit(-1);
}
sql = "insert into mytable (id,name)values(NULL,'zhan');";
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("insert table error! : %s",errmsg):;
exit(-1);
}*/
}
int displaydb(void * para,int col_cnt,char ** col_value,char ** col_name)
{
int i;
printf("total column is %d\n",col_cnt);
for(i = 0;i < col_cnt;i++)
{
printf("col_name : %s--> col_value : %s\n",col_name[i],col_value[i]);
}
printf("----------------------------\n");
return 0;
}
int insquire_cb(sqlite3 *db)
{
char *errmsg = NULL;
char *sql;
sql = "select * from mytable;";
if(SQLITE_OK != sqlite3_exec(db,sql,displaydb,NULL,&errmsg))
{
printf("insquire table error! : %s\n",&errmsg);
exit(-1);
}
}
int main()
{
int ret;
sqlite3 *db = NULL;
ret =sqlite3_open("mydatabase.db",&db);
if(SQLITE_OK != ret)
{
perror("sqlite open");
exit(-1);
}
else
{
printf("open database successfully!\n");
}
create_db(db);
insert_db(db);
insquire_cb(db);
sqlite3_close(db);
return 0;
}
copyright (C), 2014-2015, Lighting Studio. Co., Ltd.
File name:
Author:Jerey_Jobs Version:0.1 Date:
Description:
Funcion List:
*****************************************************/
#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>
int create_db(sqlite3 *db)
{
char * errmsg;
char *sql;
sql = "create table if not exists mytable (id integer primary key,name text);";
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("create table error!: %s\n",errmsg);
exit (-1);
}
return 0;
}
int insert_db(sqlite3 *db)
{
char * errmsg = NULL;
char sql[100];
int id;
char name[10];
int i;
// sql = "insert into mytable (id,name)values(NULL,'huang');";
for(i = 0;i < 3;i++)
{
printf("please input id:\n");
scanf("%d",&id);
printf("please input name:\n");
scanf("%s",name);
sprintf(sql,"insert into mytable (id,name)values(%d,'%s');",id,name);
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))//执行sql
{
printf("insert table error! : %s",errmsg);
exit(-1);
}
}
/* sql = "insert into mytable (id,name)values(NULL,'li');";
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("insert table error! : %s",errmsg);
exit(-1);
}
sql = "insert into mytable (id,name)values(NULL,'zhan');";
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("insert table error! : %s",errmsg):;
exit(-1);
}*/
}
int displaydb(void * para,int col_cnt,char ** col_value,char ** col_name)
{
int i;
printf("total column is %d\n",col_cnt);
for(i = 0;i < col_cnt;i++)
{
printf("col_name : %s--> col_value : %s\n",col_name[i],col_value[i]);
}
printf("----------------------------\n");
return 0;
}
int insquire_cb(sqlite3 *db)
{
char *errmsg = NULL;
char *sql;
sql = "select * from mytable;";
if(SQLITE_OK != sqlite3_exec(db,sql,displaydb,NULL,&errmsg))
{
printf("insquire table error! : %s\n",&errmsg);
exit(-1);
}
}
int main()
{
int ret;
sqlite3 *db = NULL;
ret =sqlite3_open("mydatabase.db",&db);
if(SQLITE_OK != ret)
{
perror("sqlite open");
exit(-1);
}
else
{
printf("open database successfully!\n");
}
create_db(db);
insert_db(db);
insquire_cb(db);
sqlite3_close(db);
return 0;
}
0 0
- 数据库-2
- 数据库2
- 数据库2
- 数据库2
- 数据库2
- 数据库2
- 数据库2
- 数据库2
- 数据库2
- 数据库2
- 数据库2
- 数据库2
- 数据库<2>
- 数据库2
- 数据库系统-- 2 关系数据库
- 数据库知识补充(2)---数据库查询优化
- 数据库战略高度解析(2) 数据库驱动程序
- 数据库学习笔记2-oracle 数据库锁
- SpannableString与SpannableStringBuilder使用
- Android app fundamentals
- 【转】Oracle表与索引的分析及索引重建
- 总结
- 利用Docker创建hadoop集群
- 数据库2
- javaweb基于struct2使用POI修改excel表格某处的信息
- ldap网络账号(轻量目录访问协议)
- cookie本地信息记录访问次数
- Tomcat启动报错,增加配置查看错误详情
- Hibernate基本原理(一)
- redis和memcache的区别
- scanf的注意
- 田忌赛马