include/AbsSqlStatement.h

Go to the documentation of this file.

/***************************************************************************
 *   Copyright (C) 2007 by Prabakaran Thirumalai   *
 *   praba_tuty@yahoo.com   *
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 *   This program is distributed in the hope that it will be useful,       *
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of        *
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *
 *   GNU General Public License for more details.                          *
 *                                                                         *
 *   You should have received a copy of the GNU General Public License     *
 *   along with this program; if not, write to the                         *
 *   Free Software Foundation, Inc.,                                       *
 *   59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             *
 ***************************************************************************/
#ifndef ABSSQLSTATEMENT_H
#define ABSSQLSTATEMENT_H
//#include <SqlConnection.h>
//#include "Statement.h"
//#include<CSql.h>
#include<AbsSqlConnection.h>
//#include <SqlStatement.h>
class Statement;
class ParsedData;

class AbsSqlStatement
{
    protected:
    AbsSqlStatement(){}
    AbsSqlStatement *innerStmt;
    AbsSqlConnection *con;
    public:
    void setInnerStatement(AbsSqlStatement *stmt) { innerStmt = stmt; }
    virtual void setConnection(AbsSqlConnection *conn) { con = conn; }

    virtual DbRetVal prepare(char *stmt) = 0;

    virtual char* getTableName(){ return NULL; }

    virtual DbRetVal execute(int &rowsAffect) =0;

    virtual void* fetch() = 0;
    

    virtual void* fetchAndPrint(bool SQL) = 0;


    virtual DbRetVal bindParam(int pos, void*) = 0;

    virtual DbRetVal bindField(int pos, void* val) = 0;

    virtual void* next() = 0;

    virtual DbRetVal close() = 0;

    virtual void* getFieldValuePtr( int pos )  = 0;

    virtual DbRetVal free() = 0;

    virtual int noOfProjFields() = 0;

    virtual int noOfParamFields() = 0;

    virtual DbRetVal getProjFldInfo(int projPos, FieldInfo *&info) = 0;

    virtual DbRetVal getParamFldInfo(int paramPos, FieldInfo *&info) = 0;

    virtual void setShortParam(int paramPos, short value) = 0;
    virtual void setIntParam(int paramPos, int value) = 0;
    virtual void setLongParam(int paramPos, long value)  =0;
    virtual void setLongLongParam(int paramPos, long long value)  =0;
    virtual void setByteIntParam(int paramPos, ByteInt value) = 0;
    virtual void setFloatParam(int paramPos, float value)  = 0;
    virtual void setDoubleParam(int paramPos, double value) = 0;
    virtual void setStringParam(int paramPos, char *value) = 0;
    virtual void setDateParam(int paramPos, Date value) = 0;
    virtual void setTimeParam(int paramPos, Time value) = 0;
    virtual void setTimeStampParam(int paramPos, TimeStamp value)  = 0;

    virtual bool isSelect() = 0;
    
    virtual ~AbsSqlStatement(){}
};

//used to store the binded field values and parameters from derived clases of
//AbsSqlStatement class
class BindSqlField
{
    public:
    DataType type;
    int length;
    void *value;
    void *targetvalue;
    BindSqlField(){ value = NULL; targetvalue = NULL; }
};

class BindSqlProjectField
{
    public:
    char fName[IDENTIFIER_LENGTH];
    DataType type;
    int length;
    void *value;
    void *targetvalue;
    BindSqlProjectField(){ value = NULL; targetvalue = NULL; }
};

#endif

---