数据库技术是信息资源开发、管理和服务的重要手段，数据库 

ar<

m_rsClerkSet.Close(); }

（2）“数据恢复”模块部分实现代码如下：

CFileDialog filedlg(1, // 1-文件打开, 0-文件另存为 \ NULL, OFN_OVERWRITEPROMPT | OFN_NOREADONLYRETURN , \ NULL); if(filedlg.DoModal()==IDOK) { fileName = filedlg.GetPathName(); CLibrarySet m_rsClerkSet; m_rsClerkSet.Open(); CFile file; file.Open(fileName,CFile::modeRead); CArchive ar(&file,CArchive::load); int n1; n10; while(!m_rsClerkSet.IsEOF()) { m_rsClerkSet.Delete(); m_rsClerkSet.MoveNext(); } m_rsClerkSet.Requery(); ar>>n1; while(n1>0) { m_rsClerkSet.AddNew(); m_rsClerkSet.Update(); m_rsClerkSet.Requery(); m_rsClerkSet.AddNew(); ar>>m_rsClerkSet.m_CLERK_ID; ar>>m_rsClerkSet.m_NAME; ar>>m_rsClerkSet.m_ID_CARD; ar>>m_rsClerkSet.m_SEX; ar>>m_rsClerkSet.m_PASSWORD; m_rsClerkSet.Update();

}

m_rsClerkSet.Requery(); n1--; }

m_rsClerkSet.Close();

“用户登录”模块实现代码如下：

if (m_strName.IsEmpty()) /*判断用户名信息是否为空*/ {

AfxMessageBox(\请输入用户名！\ return; }

mSqlStr = \ mSqlStr = mSqlStr + m_strName;

mSqlStr = mSqlStr + \ mSqlStr = mSqlStr + m_strPassword; mSqlStr = mSqlStr + \

if (!mrsDataSet.Open(AFX_DB_USE_DEFAULT_TYPE, mSqlStr)) {

AfxMessageBox(\表打开失败！\ return; }

//CString strSQL;

//strSQL.Format(\* from CLERK where NAME='%s' AND PASSWORD='%s' \

//mrsDataSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);

if(mrsDataSet.GetRecordCount()==0) {

if(count<3) {

AfxMessageBox(\用户名或密码不正确!\ count++; } else {

AfxMessageBox(\用户名或密码不正确！！您错过了三次机会！！\ m_database.Close(); ExitProcess(0); } }