SQLite Transactions

最新推荐文章于 2025-05-24 13:49:21 发布

kamaliang

最新推荐文章于 2025-05-24 13:49:21 发布

阅读量908

点赞数

分类专栏： DB 文章标签： sqlite transactions integer null callback include

本文链接：https://blog.youkuaiyun.com/kamaliang/article/details/7044954

版权

DB 专栏收录该内容

2 篇文章

订阅专栏

本文介绍如何使用SQLite3库进行大规模数据插入和选择操作，包括创建表、插入数据和选择查询，以及如何通过事务优化操作效率。

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

#include "../SQLite3/sqlite3.h"

#include <iostream>
#include <tchar.h>
#include <windows.h>
#include <MMSystem.h>

#pragma comment(lib,"winmm.lib")

#define  TEST_TIMES 10000
#define  ONE_M      1048576

#define  TEST_SELECT
//#define  USE_TRANSACTION


typedef int(*sqlite3_callback)(void*,int,char**,char**);

char Name[4][32] = {"david","boluns","guanzhongdaoke","wangba"};

char Sex[2][8]  = {"boy","girl"};

int SleectCB(void* para,int n_column,char** column_value,char** column_name )
{
	printf("记录包含%d个字段\n", n_column );

	for(int i = 0 ; i < n_column; i ++ )
	{
		printf("字段名:%s  字段值:%s\n", column_name[i], column_value[i] );
	}

	printf("------------------\n");   
	return 0;

}

int sqlite_main()
{
	sqlite3 * db = 0;
	int result = 0;
	char * errmsg = 0;

#ifdef TEST_SELECT

	remove("test.db");

	result = sqlite3_open("test.db", &db );

	if( result !=SQLITE_OK)
		return -1;

	result = sqlite3_exec( db,"create table Info( ID integer , name nvarchar(32) ,sex integer,age integer)", NULL, NULL, &errmsg );  /* primary key*/

	if(result !=SQLITE_OK)
		printf("创建表失败，错误码:%d，错误原因:%s\n", result, errmsg );

#ifdef USE_TRANSACTION
	result = sqlite3_exec( db,"begin;", 0, 0, &errmsg );  
#endif

	char sSQL[128] = {0};

	for (int i=0;i<TEST_TIMES;i++)
	{
		memset(sSQL,0,128);
		sprintf(sSQL,"insert into Info values (%d,'%s','%s',%d)",i,Name[rand()%4],Sex[rand()%2],rand()%50+1);

		result = sqlite3_exec( db,sSQL, 0, 0, &errmsg );

		if(result !=SQLITE_OK)
			printf("插入记录失败，错误码:%d，错误原因:%s\n", result, errmsg );
	}

#ifdef USE_TRANSACTION
	result = sqlite3_exec( db,"commit;", 0, 0, &errmsg );
#endif

#else

	result = sqlite3_open("test.db", &db );

	if( result !=SQLITE_OK)
		return -1;

	result = sqlite3_exec( db,"select * from Info", SleectCB, NULL, &errmsg );

#endif

	sqlite3_close( db );

	return 0;
}

int _tmain(int argc, _TCHAR* argv[])
{
	DWORD dwNow = timeGetTime();

	sqlite_main();

	printf("数据库初始化用时:%dms\r\n",timeGetTime()-dwNow);


	return 0;
}