出学数据库写了个函数

本文详细介绍了一个使用C语言和SQLite数据库API进行数据库操作的例子,包括创建表、插入记录、使用回调函数查询、删除记录以及不使用回调函数的查询方法。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

#include <stdio.h>
#include <sqlite3.h>
#include <stdlib.h>

int create_table(sqlite3 *db)
{
char *sql;
char *errmsg;
int rec;

sql = "create table if not exists mytable (id integer primary key,name text);";

rec = sqlite3_exec(db,sql,NULL,NULL,&errmsg);

if(rec != SQLITE_OK)
{
	printf("create table error!\n");
	exit(-1);
}

return 0;

}

int insert_record(sqlite3 *db)
{

char sql[100];
char *errmsg;
int rec;
char name[20];
int id;

scanf("%d%s",&id,name);

sprintf(sql,"insert into mytable (id,name) values(%d,'%s');",id,name);

rec = sqlite3_exec(db,sql,NULL,NULL,&errmsg);

if(rec != SQLITE_OK)
{
	printf("insert table error:%s!\n",errmsg);
	exit(-1);
}

/* sql = “insert into mytable (id,name) values(NULL,‘wang’);”;

rec = sqlite3_exec(db,sql,NULL,NULL,&errmsg);

if(rec != SQLITE_OK)
{
	printf("insert table error!\n");
	exit(-1);
}

sql = "insert into mytable (id,name) values(NULL,'li');";

rec = sqlite3_exec(db,sql,NULL,NULL,&errmsg);

if(rec != SQLITE_OK)
{
	printf("insert table error!\n");
	exit(-1);
}*/

return 0;

}

int displaycb(void * para,int ncolumn,char **columnvalue,char **columnname)
{
int i;
printf(“total column is:%d\n”,ncolumn);

for(i = 0; i < ncolumn;i++)
{
	printf("columnname:%s---->columnvalue:%s\n",columnname[i],columnvalue[i]);
}
printf("***************************\n");

return 0;

}

int inquire_usecb(sqlite3 *db)
{

char *sql;
char *errmsg;
int rec;

sql = "select * from mytable;";

rec = sqlite3_exec(db,sql,displaycb,NULL,&errmsg);

if(rec != SQLITE_OK)
{
	printf("select error:%s!\n",errmsg);
	exit(-1);
}

return 0;

}

int delete_record(sqlite3 *db)
{
char sql[100];
char *errmsg;
int rec;
int id;

scanf("%d",&id);

sprintf(sql,"delete from mytable where id = %d;",id);

rec = sqlite3_exec(db,sql,NULL,NULL,&errmsg);

if(rec != SQLITE_OK)
{
	printf("delete error:%s!\n",errmsg);
	exit(-1);
}

}

int inquire_nocb(sqlite3 *db)
{
int nrow;
int ncolumn;
char *sql;
char *errmsg;
char **azresult;
int i;
int rec;

sql = "select * from mytable;";

rec = sqlite3_get_table(db,sql,&azresult,&nrow,&ncolumn,&errmsg);

if(rec != SQLITE_OK)
{
	printf("get table error!\n");
	exit(-1);
}

printf("row:%d  column:%d\n",nrow,ncolumn);

for(i = 0; i< (nrow + 1) * ncolumn;i++)
{
//	printf("azresult[%d]=%s\n",i,azresult[i]);
    printf("%10s",azresult[i]);
	if((i + 1) % ncolumn == 0)
	{
		printf("\n");
	}
}
sqlite3_free_table(azresult);

return 0;

}

int main()
{
sqlite3 *db;
int rec;

rec = sqlite3_open("mydatabase.db",&db);

if(rec != SQLITE_OK)
{
	printf("open error!\n");
	exit(-1);
}
else
{
	printf("open database successfully!\n");
}

create_table(db);
insert_record(db);
inquire_usecb(db);
delete_record(db);
inquire_nocb(db);

return 0;

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值