db_operate.h

SQILTE3的一些基本函数的封装,包括文件的创建,打开,添加记录,查询记录,删除记录,计算记录条数和总数

#ifndef _DB_OPERATE_H_
#define _DB_OPERATE_H_
#include <sqlite3.h>

#define		OPENNED	1
#define		UNOPEN		0

#define		SELECTED	1
#define		UNSELECT	0

//#define		DEBUG_SQLITE

typedef struct 
{
	int		fd;		//this used by lock the file
	int		opened;
	int		selected;
	sqlite3 	*db;
	sqlite3_stmt *stmt;
}T_DbOper;

int DbOpen (T_DbOper *pDb, char *file);
int DbClose (T_DbOper *pDb);
int DbExecute (T_DbOper *pDb, char *sql, ...);
int DbBeginSelect (T_DbOper *pDb, char *sql, ...);
int DbQureyNext (T_DbOper *pDb);
int DbEndSelect (T_DbOper *pDb);
int DbCell2Txt (T_DbOper *pDb, char *cellName, char *value, int size);
int DbCell2Int (T_DbOper *pDb, char *cellName, int *retvalue);
int DbCount(T_DbOper *pDB, char *tablename, char *where, ...);
int DbSum(T_DbOper *pDB, char *tablename, char *sum, char *where, ...);
int DbUpdate(T_DbOper *pDB, char *sql, ...);
int DbOnerecord(T_DbOper *pDB, char *sql, ...);
int DbLastInsertId(T_DbOper *pDB);
 



#endif