db.h

oracle pro*c编程示例

#ifndef _DB_H_
#define _DB_H_


extern int g_DBConnected;
extern int g_DBConnected2;

#define MAX_TEL_ITEM_NUM 5
typedef struct _TEL_ITEM {
	char Tel[20 + 1];
	char Password[32 + 1];
	int  Status;
}TEL_ITEM, *PTEL_ITEM;

#define MAX_BILL_ITEM_NUM 10
typedef struct _BILL_ITEM {
	char Tel[20 + 1];
	char City[20 + 1];
	long FeeValue;
} BILL_ITEM, *PBILL_ITEM;

	


/* 连接数据库 */
int DBConnect(const char *DBName, const char *DBUser, const char *DBPass);

/* 重连数据库 */
int DBReconnect();

/* 断开数据库连接 */
int DBDisconnect();

/* 连接数据库2 */
int DBConnect2(const char *DBName, const char *DBUser, const char *DBPass);

/* 重连数据库2 */
int DBReconnect2();

/* 断开数据库连接2 */
int DBDisconnect2();

/* 创建并写数据库表monbill_tbl_yyyymm,调用存储过程来实现 */
int DBCreateMonBill(const char *TabName_IN, const char *DatePrefix_IN);

/* 获取需要包月计费的用户 */
int DBGetUserToBill(const char *TabName, BILL_ITEM *pbill_item_out);

/* 设置包月计费信息发送为1次 */
int DBSetMonthBillOnce(const char *TabName, const char *Tel_in, const unsigned long *Seq_in);

/* 设置报告状态码 */
int DBSetReportState(const char *TabName, const char *Tel_in, const int ReportState_in, const int ReportErrorCode_in);

int DBIsSzInfoUser(const char *Tel_in);

int DB2IsGdInfoUser(const char *Tel_in);

int DBSetIsInfoUser(const char *TabName, const char *Tel_in);

#endif /* _DB_H_ */