数据库DBAPI

#ifndef _STATEMENT_H_
#define _STATEMENT_H_
#include "connection.h"
typedef struct stateBind stateBind_T ,*pStateBind;
struct stateBind
{
char name1[15];
char name2[15];
char name3[15];
char name4[15];
char name5[15];
char name6[15];
char name7[15];
int int1;
};
class StatementWithSign;
typedef void (*BindFun)(StatementWithSign *StatementWithSign1,pStateBind StateBind);
/****************************************************************************** ******************************************************************************* ********/
class Statement
{
public:
Connection *connection1;//get sqlite3(db) pointer from connection public:
Statement()
{
}
virtual void setConnection(Connection *connection);
// Statement(Connection &connection1);//copy constructor
virtual bool executeSql(char *sql) throw(SQLException);
virtual char ** executeQuery(const char *sql,int *nRow,int *nColumn) throw(SQLException);
virtual bool excuteSql(char *sql,BindFun bindFun,pStateBind StateBind) throw(SQLException)
{
}
//virtual char ** executeQuery(char *sql,BindFun bindFun,pStateBind StateBind,int len) throw(SQLException);
/*
virtual ~Statement();*/
};
/****************************************************************************** ******
锟斤拷锟绞号碉拷sql锟斤拷锟斤拷实锟斤拷
锟斤拷锟杰ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷偷陌蠖ǎ锟斤拷锟捷碉拷锟斤拷锟接ｏ拷删锟斤拷锟睫革拷
* 锟睫改硷拷录锟斤拷
* 锟斤拷锟斤拷2011-9-26 锟睫革拷锟剿ｏ拷锟斤拷锟斤拷强
* 锟斤拷锟斤拷锟斤拷
*
* 锟斤拷锟斤拷2011-9-26 锟睫革拷锟剿ｏ拷锟斤拷锟斤拷强
* 锟斤拷锟斤拷锟斤拷
******************************************************************************* ********/
class StatementWithSign :public Statement
{
public:
sqlite3_stmt *stmt;
public:
/*
StatementWithSign( sqlite3_stmt *stmt=NULL)
{
this->stmt=stmt;
}*/
bool SetText(int index,char * text);
bool SetInt(int index,int value);
bool SetFloat(int index,float value);
bool SetDouble(int index,double value);
bool excuteSql(char *sql,BindFun bindFun,pStateBind StateBind) throw(SQLException);
//char ** executeQuery(char *sql,BindFun bindFun,pStateBind StateBind,int len) throw(SQLException);
//char ** executeQuery(char *sql,int nColumn,int nRow) throw(SQLException);
};
/****************************************************************************** ******
锟斤拷锟斤拷锟绞号碉拷sql锟斤拷锟斤拷实锟斤拷
锟斤拷锟杰ｏ拷锟斤拷莸锟斤拷锟斤拷樱锟缴撅拷锟斤拷薷锟?锟酵诧拷询锟斤拷锟斤拷锟窖诧拷询锟斤拷锟斤拷锟斤拷锟斤拷锟?* 锟睫改硷拷录锟斤拷
* 锟斤拷锟斤拷2011-9-26 锟睫革拷锟剿ｏ拷锟斤拷锟斤拷强
* 锟斤拷锟斤拷锟斤拷
*
* 锟斤拷锟斤拷2011-9-26 锟睫革拷锟剿ｏ拷锟斤拷锟斤拷强
* 锟斤拷锟斤拷锟斤拷
******************************************************************************* ********/
class StatementWithoutSign :public Statement
{
public:
StatementWithoutSign()
{
}
//~StatementWithoutSign();
bool executeSql(char *sql) throw(SQLException);//锟睫革拷.锟斤拷锟斤拷.删锟斤拷
char ** executeQuery(const char *sql,int *nRow,int *nColumn) throw(SQLException);
};。