sql/sqlite/sqlite3 从表中选择数据

最新推荐文章于 2024-02-23 09:15:42 发布

原创最新推荐文章于 2024-02-23 09:15:42 发布 · 901 阅读

0 ·

CC 4.0 BY-SA版权

sqlite 专栏收录该内容

4 篇文章

订阅专栏

本文提供了一个使用C++和SQLite进行数据库查询的示例代码，展示了如何打开数据库、执行SQL查询并使用回调函数处理结果集。

#include <iostream>
#include <string>
#include <tchar.h>
#include "sqlite3\\sqlite3.h"
#pragma comment (lib, "sqlite3\\sqlite3.lib")


static const char* data = "Callback function called";
static int Callback(void *data, int argc, char **argv, char **pszColName){
	printf( "%s: \n", (const char*)data);
	for(int i=0; i<argc; i++){
		printf("%s = %s\n", pszColName[i], argv[i] ? argv[i] : "NULL");
	}
	printf("\n");

	return 0;
}

int main(int argc, char* argv[])
{
   sqlite3 *pDataBase = NULL;
   char *errorMsg = 0;
   int iResult = 0;
   char *pszSql = NULL;
   const char* data = "Callback function called";

   /* Open database */
   iResult = sqlite3_open("test.db", &pDataBase);
   if( iResult != SQLITE_OK)
   {
      printf( "Can't open database: %s\n", sqlite3_errmsg(pDataBase));
      exit(0);
   }else{
      printf( "Opened database successfully\n");
   }

   /* Create SQL statement */
   pszSql = "SELECT * from COMPANY";

   /* Execute SQL statement */
   iResult = sqlite3_exec(pDataBase, pszSql, Callback, (void*)data, &errorMsg);
   if( iResult != SQLITE_OK )
   {
      printf( "SQL error: %s\n", errorMsg);
      sqlite3_free(errorMsg);
   }else{
      printf( "Operation done successfully\n");
   }
   sqlite3_close(pDataBase);
   return 0;
}