c++ SQLite 特别好用的库使用实例-查询（2）

最新推荐文章于 2023-07-27 20:56:47 发布

依梦_728297725

最新推荐文章于 2023-07-27 20:56:47 发布

阅读量731

点赞数

分类专栏： c++ MFC 文章标签：数据库 sqlite c++

本文链接：https://blog.csdn.net/chunleixiahe/article/details/126449073

版权

c++ 同时被 2 个专栏收录

314 篇文章 4 订阅

订阅专栏

MFC

261 篇文章 10 订阅

订阅专栏

void _QueryDB()
{
Kompex::SQLiteDatabase *pDatabase = new Kompex::SQLiteDatabase("test.db", SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, 0);
Kompex::SQLiteStatement *pStmt = new Kompex::SQLiteStatement(pDatabase);

   {
       double d1 = pStmt->SqlAggregateFuncResult("SELECT COUNT(*) FROM user WHERE lastName = 'Lehmann';");
       double d2 = pStmt->SqlAggregateFuncResult("SELECT COUNT(weight) FROM user;");
       double d3 = pStmt->SqlAggregateFuncResult("SELECT MAX(age) FROM user;");
       double d4 = pStmt->SqlAggregateFuncResult("SELECT MIN(age) FROM user;");
       double d5 = pStmt->SqlAggregateFuncResult("SELECT AVG(age) FROM user;");
       double d6 = pStmt->SqlAggregateFuncResult("SELECT SUM(age) FROM user;");
       double d7 = pStmt->SqlAggregateFuncResult("SELECT TOTAL(age) FROM user;");
   }

   {
       pStmt->Sql("SELECT firstName FROM user WHERE lastName = 'Lehmann';");
       const char* strName = pStmt->GetColumnName(0);
       int nCount = pStmt->GetColumnCount();
       const char* strDataBaseName = pStmt->GetColumnDatabaseName(0);
       const char* strTableName = pStmt->GetColumnTableName(0);
       const char* strOriginName = pStmt->GetColumnOriginName(0);
       pStmt->FreeQuery();
   }

   {
       pStmt->Sql("SELECT * FROM user");
       while (pStmt->FetchRow())
       {
           double db1 = pStmt->GetColumnDouble(0);
           std::string str1 = pStmt->GetColumnString(1);
           std::string str2 = pStmt->GetColumnString(2);
           std::string str3 = pStmt->GetColumnString(3);
           std::string str4 = pStmt->GetColumnString(4);
           int Type1 = pStmt->GetColumnType(0);
           int Type2 = pStmt->GetColumnType(1);
           int Type3 = pStmt->GetColumnType(2);
           int Type4 = pStmt->GetColumnType(3);
           int Type5 = pStmt->GetColumnType(4);
       }
       pStmt->FreeQuery();
   }

   {
       //获取数据表的列数列名
       pStmt->Sql("SELECT * FROM user");
       int nCount = pStmt->GetColumnCount();
       for (int i = 0; i < nCount;i++)
       {
           const char* strName = pStmt->GetColumnName(i);
       }
       pStmt->FreeQuery();
   }

   {
       //获取所有的表
       pStmt->Sql("SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY name");
       while (pStmt->FetchRow())
       {
           std::string str1 = pStmt->GetColumnString(0);
           int yyyy = 66;
       }

       pStmt->FreeQuery();
   }
   pDatabase->Close();
}