CSqlite3--连接数据库

最新推荐文章于 2025-06-26 11:59:58 发布

2020年冬

最新推荐文章于 2025-06-26 11:59:58 发布

阅读量391

点赞数

CC 4.0 BY-SA版权

文章标签： sqlite sqlite3

本文链接：https://blog.youkuaiyun.com/qq_297152562/article/details/107252564

本文详细介绍了如何使用CSqlite3库连接和操作SQLite3数据库，包括建立连接、执行SQL语句、处理结果集等核心步骤，是SQLite3数据库开发的基础教程。

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

#include"db_sqlite3.h"
CSqlite3::CSqlite3()
{
   
   
	m_pdb = NULL;
 	m_pSqliteStmt = NULL;
 	m_mapParamOut.clear();
 	m_nParamInMaxCnt = 0;
 	m_nParamOutMaxCnt = 0;
}

CSqlite3::~CSqlite3()
{
   
   
 	if (NULL != m_pdb)
 	{
   
   
  		sqlite3_close(m_pdb);
  		m_pdb = NULL;
 	}
}

int CSqlite3::OpenDB(const char* pcFileName, int nMemberFlag)
{
   
   
 	int nRet = SQLITE_OK;
 	if ((NULL == pcFileName) && (SQLITE3_UNUSE_MEMORY_DB == nMemberFlag))
 	{
   
   
  		return SQLITE3_ERROR_GENERAL_NULL;
 	}
 	if (SQLITE3_UNUSE_MEMORY_DB == nMemberFlag)
 	{
   
   
  		nRet = sqlite3_open(pcFileName, &m_pdb);
  		if (SQLITE_OK != nRet)
  		{
   
   
   			return nRet;
  		}
 	}
 	else
 	{
   
   
  		nRet = sqlite3_open(":memory;", &m_pdb);
  		if (SQLITE_OK != nRet)
  		{
   
   
   			return nRet;
  		}
  		if (NULL != pcFileName)
  		{
   
   
   		nRet = LoadOrSaveDB(pcFileName, SQLITE3_SAVE_FILE_TO_MEMORY);
  		}
 	}
 	return nRet;
}

int CSqlite3::LoadOrSaveDB(const char* pcFileName, int nIsSave, const char* pcAliNameSrc, const char* pcAliNameDst)
{
   
   
 	int nRet = SQLITE_OK;
 	sqlite3* pFileDB = NULL;
 	sqlite3_backup* pBackup = NULL;
 	sqlite3* pToDB = NULL;
 	sqlite3* pFromDB = NULL;
 	nRet = sqlite3_open(pcFileName, &pFileDB);
 	if (nRet == SQLITE_OK)
 	{
   
   
  		pFromDB = ((nIsSave == SQLITE3_SAVE_FILE_TO_MEMORY) ? pFileDB : m_pdb);
  		pToDB = ((nIsSave == SQLITE3_SAVE_FILE_TO_MEMORY) ? m_pdb : pFileDB);
  		pBackup = sqlite3_backup_init(pToDB, pcAliNameDst, pFromDB, pcAliNameSrc);
  		if (NULL != pBackup)
  		{
   
   
   			aqlite3_backup_step(pBackup, -1);
   			sqlite3_backup_finish(pBackup);
  		}
  		nRet = sqlite3_errcode(pToDB);
 	}
 	else
 	{
   
   
  		sqlite3_close(pFileDB);
 	}
 	return nRet;
}

int CSqlite3::AttachDB(const char* pcFileName, const char* pcAliName)
{
   
   
 	int nRet = SQLITE_OK;
 	char cSqlite3Sql[256] = {
   
    0 };
 	if (NULL == m_pdb || NULL == pcFileName || NULL == pcAliName)
 	{
   
   
 		return SQLITE3_ERROR_GENERAL_NULL;
 	}
 	memset(cSqlite3Sql, 0x00, sizeof(cSqlite3Sql));
 	sprintf_s(cSqlite3Sql, "ATTACH DATABASE '%s' As '%s' ", pcFileName, pcAliName);
 	nRet = sqlite3_exec(m_pdb, cSqlite3Sql, NULL, NULL, NULL);
  	if (SQLITE_OK != nRet)
 	{
   
   
  		sqlite3_close(m_pdb);
  		return nRet;