C++Windows下SQLite简单封装

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
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值