include/SqlStatement.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 SQLSTATEMENT_H
#define SQLSTATEMENT_H
#include <AbsSqlStatement.h>
#include <SqlConnection.h>
#include <SqlFactory.h>
#include "Statement.h"
//#include<CSql.h>
class Statement;
class ParsedData;

class SqlStatement: public AbsSqlStatement
{
    public:
    SqlStatement();
    void setConnection(AbsSqlConnection *con);
    void setSqlConnection(SqlConnection *con);

    DbRetVal prepare(char *stmt);

    char* getTableName();

    DbRetVal execute(int &rowsAffect);

    void* fetch();
    void* fetch(DbRetVal &rv);
    

    void* fetchAndPrint(bool SQL);


    DbRetVal bindParam(int pos, void*);

    DbRetVal bindField(int pos, void* val);

    void* next();

    DbRetVal close();

    void* getFieldValuePtr( int pos );

    DbRetVal free();

    int noOfProjFields();

     void* getParamValuePtr( int pos );

     DataType getFieldType( int pos );

     int getFieldLength( int pos );

     char* getFieldName ( int pos );

    int noOfParamFields();

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

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

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

    bool isSelect();
    
    bool isPrepared();

    private:
    SqlConnection *sqlCon;
    Statement *stmt;
    ParsedData pData;
    bool isPrepd;
    friend class SqlFactory;
};

#endif

---