1 /***************************************************************************
2 * Copyright (C) 2007 by Prabakaran Thirumalai *
3 * praba_tuty@yahoo.com *
5 * This program is free software; you can redistribute it and/or modify *
6 * it under the terms of the GNU General Public License as published by *
7 * the Free Software Foundation; either version 2 of the License, or *
8 * (at your option) any later version. *
10 * This program is distributed in the hope that it will be useful, *
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
13 * GNU General Public License for more details. *
15 * You should have received a copy of the GNU General Public License *
16 * along with this program; if not, write to the *
17 * Free Software Foundation, Inc., *
18 * 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. *
19 ***************************************************************************/
20 #ifndef SQLNWSTATEMENT_H
21 #define SQLNWSTATEMENT_H
22 #include <AbsSqlStatement.h>
23 #include <SqlNwConnection.h>
24 #include <SqlFactory.h>
26 class SqlNwStatement
: public AbsSqlStatement
29 SqlNwStatement(){innerStmt
= NULL
; con
= NULL
; isPrepared
=false; isSel
= true; nullInfoDml
= NULL
; nullInfoSel
= NULL
; }
30 void setConnection(AbsSqlConnection
*conn
)
32 if (innerStmt
) innerStmt
->setConnection(conn
->getInnerConnection());
35 ~SqlNwStatement() { if (isPrepared
) free(); }
36 DbRetVal
prepare(char *stmt
);
38 DbRetVal
execute(int &rowsAffect
);
39 DbRetVal
bindParam(int pos
, void*);
41 DbRetVal
bindField(int pos
, void* val
);
44 void* fetch(DbRetVal
&rv
);
45 void* fetchAndPrint(bool SQL
);
50 void* getFieldValuePtr( int pos
);
51 void* getFieldValuePtr( char *name
){}
55 int noOfParamFields();
57 DbRetVal
getProjFldInfo(int projPos
, FieldInfo
*&info
);
59 DbRetVal
getParamFldInfo(int paramPos
, FieldInfo
*&info
);
61 void setShortParam(int paramPos
, short value
);
62 void setIntParam(int paramPos
, int value
);
63 void setLongParam(int paramPos
, long value
);
64 void setLongLongParam(int paramPos
, long long value
);
65 void setByteIntParam(int paramPos
, ByteInt value
);
66 void setFloatParam(int paramPos
, float value
);
67 void setDoubleParam(int paramPos
, double value
);
68 void setStringParam(int paramPos
, char *value
);
69 void setDateParam(int paramPos
, Date value
);
70 void setTimeParam(int paramPos
, Time value
);
71 void setTimeStampParam(int paramPos
, TimeStamp value
);
72 void setBinaryParam(int paramPos
, void *value
, int length
);
73 bool isSelect(){return isSel
;}
74 void getPrimaryKeyFieldName(char *tablename
, char *pkfieldname
);
75 int getStmtID() { return stmtID
; }
76 bool isFldNull(int pos
);
77 bool isFldNull(char *name
);
78 void setNull(int pos
);
79 void setStmtID(int id
) { stmtID
= id
; }
80 int getFldPos(char *name
){}
81 List
getAllTableNames(DbRetVal
&ret
);
91 char *nullInfoSel
; // for nullinfo in fetch
92 char *nullInfoDml
; // for nullinfo in insert and update
93 friend class SqlFactory
;