C++Windows下SQLite简单封装

最新推荐文章于 2024-08-15 09:28:06 发布

freeangeles

最新推荐文章于 2024-08-15 09:28:06 发布

阅读量1.5k

点赞数

分类专栏： SQLite Windows 文章标签： Windows SQLite 封装

本文链接：https://blog.csdn.net/f_r_e_e_x/article/details/50257027

版权

本文介绍如何在Windows环境下对SQLite数据库进行C++的简单封装，通过头文件SQLiteCommand.h，实现便捷的数据库命令执行和数据操作。内容包括连接数据库、执行SQL语句、事务处理等关键功能。

摘要由CSDN通过智能技术生成

SQLiteCommand.h:

#pragma once
#include <Windows.h>  
#include <map>  
#include <vector>  
#include "sqlite3.h"

class SQLiteCommand
{
    public:

        SQLiteCommand();

        ~SQLiteCommand();

        bool Connect( LPCSTR pDataBaseName );

        bool Disconnect();

        bool IsExistsTable( LPCSTR pTableName );
        //for creating table.
        /*  eg.
            SQLiteCommand SQLite;
            ......
            if( false == SQLite.IsExistsTable( "player" ) )//if table player already exists CreateTable will be returned false.
            {
                SQLite.CreateTable( "player", "id int,name varchar( 16 )" );
            }
        */
        bool CreateTable( LPCSTR pTableName, LPCSTR pFieldScript );

        //eg. SelectTable( "player", "id,name", "id > 10", "id ASC" )
        bool SelectTable( LPCSTR pTableName, LPCSTR pSelectField = "*", LPCSTR pWhere = "", LPCSTR pOrder = "" );

        /* extends select had not been implemented yet.
        bool SelectTable();//pure script version.

        bool LeftJoinTable();

        bool RightJoinTable();

        bool InnerJoinTable();
        */

        bool InsertTable( LPCSTR pTableName, LPCSTR pInsertField, LPCSTR pInsertValue );

        bool UpdateTable( LPCSTR pTableName, LPCSTR pSetField, LPCSTR pWhere = "" );

        bool DeleteTable( LPCSTR pTableName, LPCSTR pWhere = "" );

        bool DropTable( LPCSTR pTableName );

        //
        //only to provide a detailed query for the method of the select table.
        /*  eg.
            SQLiteCommand SQLite;
            ......
            SQLite.SelectTable( "player", "id,name", "id > 10" ); //select id,name from player where id > 10
            //the cursor is at the top of the default.
            while( false == SQLite.IsEOF() )
            {
                INT id = atoi( GetField( "id" ) );
                LPCSTR name = GetField( "name" );
                SQLite.MoveNext();
            }
            //or cursor position in the en