C++ 操作sqlite3数据库

最新推荐文章于 2025-06-28 10:15:23 发布

原创最新推荐文章于 2025-06-28 10:15:23 发布 · 1.4k 阅读

1 ·

CC 4.0 BY-SA版权

C++ 专栏收录该内容

31 篇文章

订阅专栏

本文介绍如何使用C++语言操作SQLite数据库，包括创建表格、插入数据及查询等基本操作，并提供完整的代码示例。

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

C++ 操作sqlite3数据库
参考：
http://www.cnblogs.com/BoyXiao/archive/2012/03/31/2426495.html
http://blog.youkuaiyun.com/harry_lyc/article/details/6663176
http://www.sqlite.org/download.html
http://www.th7.cn/Program/cp/201209/91677.shtml

#include "stdafx.h"
#include "sqlite3.h" 
#include <iostream> 
#include <sstream> 

using namespace std; 
sqlite3 * pDB; 
int createTable() 
{ 
        char* errMsg; 
        std::string dropTab = "drop table test_tab;"; 
        string strSQL= "create table test_tab (f1 int, f2 long);"; 
    
        int res= sqlite3_exec(pDB , dropTab.c_str() , 0 , 0 , &errMsg); 
    
        if (res != SQLITE_OK) 
        { 
                std::cout << "执行SQL 出错." << errMsg << std::endl; 
                return -1; 
        } 
        res = sqlite3_exec(pDB , strSQL.c_str() ,0 ,0, &errMsg); 
    
        if (res != SQLITE_OK) 
        { 
                std::cout << "执行创建table的SQL 出错." << errMsg << std::endl; 
                return -1; 
        } 
        else 
        { 
                std::cout << "创建table的SQL成功执行."<< std::endl; 
        } 
    
        return 0; 
} 
    
int insert1() 
{ 
        char* errMsg; 
    
        int res = sqlite3_exec(pDB,"begin transaction;",0,0, &errMsg); 
    
        for (int i= 1; i < 10; ++i) 
        { 
                std::stringstream strsql; 
                strsql << "insert into test_tab    values("; 
                strsql    << i << ","<< (i+10) << ");"; 
                std::string str = strsql.str(); 
                res = sqlite3_exec(pDB,str.c_str(),0,0, &errMsg); 
                if (res != SQLITE_OK) 
                { 
                        std::cout << "执行插入SQL 出错." << errMsg << std::endl; 
                        return -1; 
                } 
        } 
    
        res = sqlite3_exec(pDB,"commit transaction;",0,0, &errMsg); 
    
        std::cout << "插入SQL成功执行."<< std::endl; 
    
    
        return 0; 
} 
    
static int callback(void *NotUsed, int argc, char **argv, char **azColName) 
{ 
        
        for(int i = 0 ; i < argc ; i++) 
        { 
                std::cout << azColName[i] << " = " << (argv[i] ? argv[i] : "NULL") << ", " ; 
        } 
    
        std::cout<< "\n"; 
        return 0; 
} 
    
int select1() 
{ 
        char* errMsg; 
        string strSQL= "select * from test_tab;"; 
    
        int res = sqlite3_exec(pDB, strSQL.c_str(), callback , 0 , &errMsg); 
    
        if (res != SQLITE_OK) 
        { 
                std::cout << "执行查询SQL 出错." << errMsg << std::endl; 
                return -1; 
        } 
        else 
        { 
                std::cout << "SQL查询成功执行."<< std::endl; 
        } 
    
        return 0; 
} 
    
int main() 
{ 
        int res = sqlite3_open("D:\\sql.db", &pDB); 
    
        if( res ){ 
                std::cout << "Can't open database: "<< sqlite3_errmsg(pDB); 
                sqlite3_close(pDB); 
                return -1; 
        } 
        res = createTable(); 
        if (res != 0) 
        { 
                return 0; 
        } 
        res = insert1(); 
        if (res != 0) 
        { 
                return 0; 
        } 
        select1(); 

        return 0; 
}