cord(int nRecordPosition);
//以下五个函数将带出一条记录的五个值
CString GetZTNRvalue(); //得到正题内容字段值
long GetNDXSvalue();     //得到难度系数字段值
double GetFZvalue();       //得到分值字段值
CString GetDAvalue();   //得到答案字段值
CString GetBZvalue();   //得到备注字段值
bool MoveFirst();
bool MoveLast();
bool MovePrev();
bool MoveNext();
};
#endif // !defined(AFX_DATABASEOPERATE_H__90468D61_8978_11D3_BA46_000021ECD4C4__INCLUDED_)
// DataBaseOperate.cpp: implementation of the CDataBaseOperate class.
//////////////////////////////////////////////////////////////////////
#include "stdafx.h"
#include "NewCai.h"
#include "DataBaseOperate.h"
#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE=__FILE__;
#define new DEBUG_NEW
#endif
#define SQL_DATABASE _T("ODBC;DSN=sql-database;UID=sa;PWD="";")
//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////
CDataBaseOperate::CDataBaseOperate()
{ loc_pDataBase=new CDaoDatabase;
CString m_strFieldvalue;
}

CDataBaseOperate::~CDataBaseOperate()
{ delete loc_pDataBase;
}

bool CDataBaseOperate::OpenDataBase()
{ if (!loc_pDataBase->IsOpen())
loc_pDataBase->Open( NULL, FALSE, FALSE, SQL_DATABASE );
    return TRUE;
}

bool CDataBaseOperate::CloseTable()
{ if (loc_pRecordset.IsOpen())
{ loc_pRecordset.Close();
  delete loc_pQueryDef;    
  delete loc_pTable; }
return TRUE;
}
bool CDataBaseOperate::MoveFirst()
{ loc_pRecordset.MoveFirst();
m_nNumberPosition=1;
GetRecord(m_nNumberPosition);
return TRUE;
}

bool CDataBaseOperate::MoveLast()
{ loc_pRecordset.MoveLast();
m_nNumberPosition=m_nRecordNumber;
GetRecord(m_nNumberPosition);
return TRUE;
}

bool CDataBaseOperate::MovePrev()
{ loc_pRecordset.MovePrev();
m_nNumberPosition--;
if(loc_pRecordset.IsBOF())
{ loc_pRecordset.MoveFirst();
  m_nNumberPosition=1; }
GetRecord(m_nNumberPosition);
return TRUE;
}

bool CDataBaseOperate::MoveNext()
{ m_nNumberPosition++;
loc_pRecordset.MoveNext();
if(loc_pRecordset.IsEOF())
{ loc_pRecordset.MoveLast();
  m_nNumberPosition=m_nRecordNumber; }
GetRecord(m_nNumberPosition);
return TRUE;
}

bool CDataBaseOperate::OpenTable(CString strTableName)
{ CString strFieldNumber;
loc_pTable=new CDaoTableDef(loc_pDataBase);
if (!loc_pTable->IsOpen())
  loc_pTable->Open(strTableName); //打开指定的表名
strFieldNumber.Format("%d",loc_pTable->GetFieldCount());    //得到字段数
CString Sqlstr;                                       //得到查询集和记录集
loc_pQueryDef=new CDaoQueryDef(loc_pDataBase);
Sqlstr=_T("SELEC