db.h

用ODBC 游标进行分页 数据源CMSTest

// DB.h: interface for the DB class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_DB_H__F8E6EBFD_5829_4C7B_ADE4_DA14FF1639B9__INCLUDED_)
#define AFX_DB_H__F8E6EBFD_5829_4C7B_ADE4_DA14FF1639B9__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#include <afxdb.h>
#include <afxtempl.h>
#include "CAreaBean.h"
class DB  
{
public:
	DB();
	virtual ~DB();
	LONG DBconnect();
	LONG Disconnect();
	LONG ExecSQL(int numberPage,int noncePage,CObArray& areaBeanList);
private:
	SQLHENV hEnv;
	SQLHDBC hConnect;
	SQLRETURN r;
	SQLHSTMT hstmt;
};

#endif // !defined(AFX_DB_H__F8E6EBFD_5829_4C7B_ADE4_DA14FF1639B9__INCLUDED_)