dbc.c~

来自「这是我用QT和TTS写的一个电话本管理系统」· C~ 代码 · 共 56 行

#include <sys/types.h>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <db.h>
#define    DATABASE "demo.db"

int main()
{
	DB *dbp;
	DBT key, data;
	int ret,t_ret;
	if ((ret = db_create(&dbp, NULL, 0)) != 0) 
	{
		fprintf(stderr, "db_create: %s\n", db_strerror(ret));
		exit (1);
	}
	if ((ret = dbp->open(dbp,NULL, DATABASE, NULL, DB_BTREE, DB_CREATE, 0664)) != 0)
	{
		dbp->err(dbp, ret, "%s", DATABASE);
		exit (1);
	}
	//insert data
	memset(&key, 0, sizeof(key));
	memset(&data, 0, sizeof(data));
	key.data = "sport";
	key.size = sizeof("sport");
	data.data = "football";
	data.size = sizeof("football");
	if ((ret = dbp->put(dbp, NULL, &key, &data, 0)) == 0)
		printf("db: %s: key stored.\n", (char *)key.data);
	else
		dbp->err(dbp, ret, "DB->put");
	//select data
	memset(&key, 0, sizeof(key));
	memset(&data, 0, sizeof(data));
	key.data = "sport";
	key.size = sizeof("sport");
	if ((ret = dbp->get(dbp, NULL, &key, &data, 0)) == 0)
		printf("db: %s: key retrieved: data was %s.\n",(char *)key.data, (char *)data.data);
	else
		dbp->err(dbp, ret, "DB->get");
	//delete data
	memset(&key, 0, sizeof(key));
	key.data = "sport";
	key.size = sizeof("sport");
	if ((ret = dbp->del(dbp, NULL, &key, 0)) == 0)
		printf("db: %s: key was deleted.\n", (char *)key.data);
	else
		dbp->err(dbp, ret, "DB->del");
	//close database
	if ((t_ret = dbp->close(dbp, 0)) != 0 && ret == 0)
		ret = t_ret; 
	exit(ret);
}