Ãæ°ü»áÓеÄ

bool CMyDataBase::DeleteUserOfSelected(CString UserID)
{
 
 CString strSql;
 _variant_t RecordsAffected;

 strSql.Format("DELETE FROM users WHERE UserID = %d",atoi(UserID)); // strSql="DELETE FROM users WHERE UserID = 10";
 //AfxMessageBox(strSql);
 m_pConnection->Execute((_bstr_t)strSql,&RecordsAffected,adCmdText);
 AfxMessageBox(strSql);
 return TRUE;
}

void CMyDataBase::SaveNewUserToDataBase()
{
 //ʵ¼Ê´Ëº¯ÊýÓ¦²ÉÓÃÒ»¸ö½á¹¹Ìå´«Èë²ÎÊý

// InitDataBase();//ÕâÊDZØÐëµÄ

 CString strSql;

 _variant_t RecordsAffected;
 CString m_1,m_2,m_3;
 m_1="ÁÖÃÃÃÃ";
 m_2="13579";
 m_3="СÁÖ";

 strSql.Format("INSERT INTO users(UserName,LoginPassWord,DisplayName) VALUES ('%s','%s','%s')",m_1,m_2,m_3);
 m_pConnection->Execute((_bstr_t)strSql,&RecordsAffected,adCmdText);

}

bool CMyDataBase::InitDataBase()
{
 //³õʼ»¯Êý¾Ý¿âÁ¬½Ó

 HRESULT hr;
 try
 {
  hr = m_pConnection.CreateInstance("ADODB.Connection");//´´½¨Connection¶ÔÏó
  if(SUCCEEDED(hr))
  {
   hr = m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DataBase.mdb","","",adModeUnknown);///Á¬½ÓÊý¾Ý¿â
   //hr = m_pConnection->Open("studb","","",adModeUnknown);
  }
 }
 catch(_com_error e)///²¶×½Òì³£
 {
  CString errormessage;
  errormessage.Format("Á¬½ÓÊý¾Ý¿âʧ°Ü!\r\n´íÎóÐÅÏ¢:%s",e.ErrorMessage());
  AfxMessageBox(errormessage);///ÏÔʾ´íÎóÐÅÏ¢
 }
 _variant_t RecordsAffected;
 //m_pConnection->Execute("CREATE TABLE studentinfo(stuNo TEXT,stuname TEXT,stuaddress TEXT,stuphone TEXT)",&RecordsAffected,adCmdText);
// CString strSQL;

// CString s1,s2;

// strSQL.Format("INSERT INTO users(UserName,PassWord) VALUES ('%s','%s')","abc","123456");
// strSQL.Format("INSERT INTO users(UserName,LoginPassWord,DisplayName) VALUES ('%s','%s','%s')","¶«·½²»°Ü","123456","¶«·½ÃÃÃÃ");

// m_pConnection->Execute((_bstr_t)strSQL,&RecordsAffected,adCmdText);
 return TRUE;
}

//°Ñ»áÒéÊÒÁбíµÄ³õʼ»¯´ò°üµ½Õâ¶ù
void CMyDataBase::InitConfListCtrl(CListCtrl* pListCtrl)
{

 /*Ö±½Ó²åÈëÐвâÊÔÖ¸Õë
 pListCtrl->InsertItem(0, 0);//²åÈëÐÐ
 pListCtrl->SetItemText(0, 1, "¹«¹²ÁÄÌìÊÒ");//ÉèÖÃÊý¾Ý
 pListCtrl->SetItemText(0, 2, "50");
 pListCtrl->SetItemText(0, 3, "5");
 pListCtrl->SetItemText(0, 4, "2010-12-1");
 pListCtrl->SetItemText(0, 5, "2010-12-1");
 */

 InitDataBase();//ÕâÊDZØÐëµÄ

 //ÉèÖ÷ç¸ñ
 LONG lStyle;
 lStyle = GetWindowLong(pListCtrl->m_hWnd, GWL_STYLE);//»ñÈ¡µ±Ç°´°¿Ústyle
 lStyle &= ~LVS_TYPEMASK; //Çå³ýÏÔʾ·½Ê½Î»
 lStyle |= LVS_REPORT; //ÉèÖÃstyle
 SetWindowLong(pListCtrl->m_hWnd, GWL_STYLE, lStyle);//ÉèÖÃstyle

 DWORD dwStyle = pListCtrl->GetExtendedStyle();
 dwStyle |= LVS_EX_FULLROWSELECT;//Ñ¡ÖÐijÐÐʹÕûÐиßÁÁ£¨Ö»ÊÊÓÃÓëreport·ç¸ñµÄlistctrl£©
 dwStyle |= LVS_EX_GRIDLINES;//Íø¸ñÏߣ¨Ö»ÊÊÓÃÓëreport·ç¸ñµÄlistctrl£©
 //dwStyle |= LVS_EX_CHECKBOXES;//itemÇ°Éú³Écheckbox¿Ø¼þ
 pListCtrl->SetExtendedStyle(dwStyle); //ÉèÖÃÀ©Õ¹·ç¸ñ

 pListCtrl->InsertColumn( 0, "ID", LVCFMT_LEFT, 0 );//²åÈëÁУ¬½«¿í¶ÈÉèÖóÉ0£¬ÔÚÍâ¹ÛÉϾͿ´²»µ½´ËÁУ¬ÓÃÀ´´æ·Å»áÔ±ºÅ
 pListCtrl->InsertColumn( 1, "ID", LVCFMT_LEFT, 60 );
 pListCtrl->InsertColumn( 2, "»áÒéÊÒÃû³Æ", LVCFMT_LEFT, 100 );
 pListCtrl->InsertColumn( 3, "ÈÝÁ¿", LVCFMT_LEFT, 60 );
 pListCtrl->InsertColumn( 4, "ÔÚÏß", LVCFMT_LEFT, 60 );
 pListCtrl->InsertColumn( 5, "¿ªÊ¼", LVCFMT_LEFT, 140 ); 
 pListCtrl->InsertColumn( 6, "½áÊø", LVCFMT_LEFT, 140 ); 

 HRESULT hr;
 _RecordsetPtr pRentRecordset;
    hr=pRentRecordset.CreateInstance(__uuidof(Recordset));
 if(FAILED(hr))
 {
  AfxMessageBox("createinstance of Recordset failed!\n can`t initiate List control!");
  return;
 }

 CString strSql;
 _variant_t var;
 CString strValue;
 int curItem=0;
 strSql="SELECT * FROM Conf";

 try
 {
  hr=pRentRecordset->Open(_variant_t(strSql),
                    m_pConnection.GetInterfacePtr(), 
                    adOpenDynamic,
                    adLockOptimistic,
                    adCmdText);
  if(SUCCEEDED(hr))
  {
   while(!pRentRecordset->adoEOF)
   {
 
    var = pRentRecordset->GetCollect((long)0);
    if(var.vt != VT_NULL)
     strValue = (LPCSTR)_bstr_t(var);
    pListCtrl->InsertItem(curItem,strValue);

    var = pRentRecordset->GetCollect("ConfID");
    if(var.vt != VT_NULL)
     strValue = (LPCSTR)_bstr_t(var);
    pListCtrl->SetItemText(curItem,1,strValue);

    var = pRentRecordset->GetCollect("ConfName");
    if(var.vt != VT_NULL)
     strValue = (LPCSTR)_bstr_t(var);
    pListCtrl->SetItemText(curItem,2,strValue);

    var = pRentRecordset->GetCollect("MaxNum");
    if(var.vt != VT_NULL)
     strValue = (LPCSTR)_bstr_t(var);
    pListCtrl->SetItemText(curItem,3,strValue);
    
    var = pRentRecordset->GetCollect("OnlineNum");
    if(var.vt != VT_NULL)
     strValue = (LPCSTR)_bstr_t(var);
    pListCtrl->SetItemText(curItem,4,strValue);

    var = pRentRecordset->GetCollect("StartTime");
    if(var.vt != VT_NULL)
     strValue = (LPCSTR)_bstr_t(var);
    pListCtrl->SetItemText(curItem,5,strValue);

    var = pRentRecordset->GetCollect("EndTime");
    if(var.vt != VT_NULL)
     strValue = (LPCSTR)_bstr_t(var);
    pListCtrl->SetItemText(curItem,6,strValue);

    pRentRecordset->MoveNext();
    curItem++;
   }
  }
  else
  {
   AfxMessageBox("Open recordset fail!");
  }
 }
 catch(_com_error *e)
 {
  AfxMessageBox(e->ErrorMessage());
  return;
 }   

 
    pRentRecordset->Close();
 pRentRecordset=NULL;

}