C++编程常用模块

1(一)：连接SQL数据库一、连接数据库（SQL）：（一）直接写在程序中1、导入动态连接库在StdAfx.h中:#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace \ rename("EOF","adoEOF") rename("BOF","adoBOF")2、定义Provider宏在StdAfx.h中:#define Provider "Provider=SQLOLEDB.1;Integrated Security=SSPI;\Persist Security Info=False;Initial Catalog=HRMS"3、初始化a) .h文件中private:HDC m_hDC;DWORD m_CurrentRecord;_RecordsetPtr m_pRecordset;_ConnectionPtr m_pConnection;b) .cpp文件中CADOOperation::CADOOperation(){try{m_pConnection.CreateInstance(_uuidof(Connection));m_pConnection->Open(_bstr_t(Provider), "", "", adModeUnknown);}catch(_com_error e){AfxMessageBox(e.Description(), MB_OK);exit(0);}m_pRecordset.CreateInstance(_uuidof(Recordset));m_CurrentRecord = -1;}4、执行5、关闭CADOOperation::~CADOOperation(){m_pConnection->Close();}（二）通过login.ini文件连接void CBbbApp::IniAdo(){try{CString temp;char filepath[MAX_PATH];GetModuleFileName(NULL,filepath,MAX_PATH);temp = theApp.ExtractFilePath(filepath);//获取可执行文件的路径，也就是程序运行的.exe文件所在路径//运行后，temp的值为程序文件.exe 所在路径CString strAdoConn;char temp1[100];/*********************************************在同目录下创建login.ini文件，并在其中设置数据库连接字符串，如：[DatabaseConfig]Server=. // . 表示本机Database=BookManageUser=saPWD=sa*********************************************/GetPrivateProfileString("DatabaseConfig","Server","",temp1,100,temp+"login.ini");strserver = (TCHAR *)temp1;GetPrivateProfileString("DatabaseConfig","Database","",temp1,100,temp+"login.ini");strdbName = temp1;GetPrivateProfileString("DatabaseConfig","User","",temp1,100,temp+"login.ini");strUser = temp1;GetPrivateProfileString("DatabaseConfig","PWD","",temp1,100,temp+"login.ini");strPassword = temp1;strAdoConn.Format("driver={SQLServer};SERVER=%s;UID=%s;PWD=%s;DATABASE=%s",strserver, strUser, strPassword, strdbName);m_pCon.CreateInstance(_uuidof(Connection));m_pCon->ConnectionString = (_bstr_t)strAdoConn;m_pCon->Open("","","",NULL);m_pCom.CreateInstance("mand");m_pRs.CreateInstance(_uuidof(Recordset));m_pRs1.CreateInstance(_uuidof(Recordset));// ADOFLAG = TRUE;}catch(_com_error){//ADOFLAG = FALSE;Flag = FALSE;MessageBox(0,"请检查系统配置信息", "数据库连接失败",MB_OK);return;}catch(...){AfxMessageBox("SYS Error");return ;}}C++编程常用模块(二)：连接Access数据库二、连接数据库(Access 2000)1、在.h文件中导入动态链接库#import "C:\Program Files\Common Files\System\ado\msado15.dll"no_namespace \ rename("EOF","adoEOF")rename("BOF","adoBOF")类定义：class ADOConn{public:BOOL ExecuteSQL(_bstr_t bstrSQL);ADOConn();virtual ~ADOConn();//添加一个指向Connection对象的指针_ConnectionPtr m_pConnection;//添加一个指向Recordset对象的指针_RecordsetPtr m_pRecordset;_RecordsetPtr& GetRecordSet(_bstr_t bstrSQL);void ExitConnect();void OnInitADOConn();};2、建立连接void ADOConn::OnInitADOConn(){//初始化OLE/COM库环境::CoInitialize(NULL);try{char filepath[MAX_PATH];GetModuleFileName(NULL,filepath,MAX_PATH);CString strdb;strdb = ExtractFilePath(filepath) + "sm.mdb";strdb = "DBQ=" + strdb;//创建connection对象m_pConnection.CreateInstance("ADODB.Connection");m_pConnection->ConnectionTimeout=3;//设置连接字符串,两种都可以//_bstr_t strConnect="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=sm.mdb";_bstr_t strConnect="DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=sm;";strConnect = strConnect + strdb;//SERVER和UID,PWD的设置根据实际情况来设置m_pConnection->Open(strConnect,"","",adModeUnknown);}//捕捉异常catch(_com_error e){//显示错误信息AfxMessageBox(e.Description());}}3、执行SQL语句//仅执行，无返回BOOL ADOConn::ExecuteSQL(_bstr_t bstrSQL){try{//是否已连接数据库if(m_pConnection==NULL)OnInitADOConn();m_pConnection->Execute(bstrSQL,NULL,adCmdText);return true;}catch(_com_error e){e.Description();return false;}}//返回记录集_RecordsetPtr& ADOConn::GetRecordSet(_bstr_t bstrSQL){try{if(m_pConnection==NULL)OnInitADOConn();m_pRecordset.CreateInstance(__uuidof(Recordset));m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLo ckOptimistic,adCmdText);}catch(_com_error e){e.Description();}return m_pRecordset;}4、关闭连接void ADOConn::ExitConnect(){//关闭记录集和连接if(m_pRecordset!=NULL){m_pRecordset->Close();m_pRecordset=NULL;}if(m_pConnection!=NULL){m_pConnection->Close();m_pConnection=NULL;}//释放环境::CoUninitialize();}C++编程常用模块(三)：窗体操作三、窗体操作1、显示对话框窗体CDlgLogin login ;login.DoModal();若要处理“确定”或“取消”：int nResponse = login.DoModal();if (nResponse == IDOK){// TODO: Place code here to handle when the dialog is// dismissed with OK}else if (nResponse == IDCANCEL){// TODO: Place code here to handle when the dialog is// dismissed with Cancel}2、关闭对话框窗体EndDialog(0);或CDialog::OnCancel();或CDialog::OnOK();3、退出应用程序exit(0);4、登录：P308void CDlgLogin::OnButton1(){CString c_user,c_password;m_user.GetWindowText(c_user);m_password.GetWindowText(c_password);if (c_user.IsEmpty() || c_password.IsEmpty()){MessageBox("用户名称或密码不能为空", "用户登录信息");return;}CString sql;sql.Format("select * from tb_operator where name = '%s' and password = '%s'",c_user,c_password);m_pRs->raw_Close();m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimisti c,adCmdText);//if (m_pRs->RecordCount>0) 或者if (!myConn.m_pRecordset ->adoEOF){Flag = true; //Flag为全局变量user = m_pRs->GetCollect("name").bstrVal;password = m_pRs->GetCollect("password").bstrVal;EndDialog(0);}else{user = "";password = "";MessageBox("用户名或密码不正确.","提示",64);return;}}在程序启动初始化部分BOOL CBbbApp::InitInstance()函数里完成窗口跳转：if (Flag ==true){CBbbDlg dlg; //启动主窗体m_pMainWnd = &dlg;dlg.DoModal();}5、动态创建工具栏：P306方法(一):CToolBar m_toolbar;CImageList m_imagelist;m_imagelist.Create(24,24,ILC_COLOR24|ILC_MASK,1,1);m_imagelist.Add(AfxGetApp()->LoadIcon(IDI_ICON4));m_imagelist.Add(AfxGetApp()->LoadIcon(IDI_ICON11));m_imagelist.Add(AfxGetApp()->LoadIcon(IDI_ICON13));m_imagelist.Add(AfxGetApp()->LoadIcon(IDI_ICON5));m_imagelist.Add(AfxGetApp()->LoadIcon(IDI_ICON19));UINT array[5];for(int i=0;i<5;i++){array[i]=5000+i; //创建索引}m_toolbar.Create(this);m_toolbar.SetButtons(array,5);m_toolbar.SetButtonText(0,"图书信息");m_toolbar.SetButtonText(1,"图书入库");m_toolbar.SetButtonText(2,"销售查询");m_toolbar.SetButtonText(3,"系统配置");m_toolbar.SetButtonText(4,"系统退出");m_toolbar.GetToolBarCtrl().SetButtonWidth(60,120);m_toolbar.GetToolBarCtrl().SetImageList(&m_imagelist);m_toolbar.SetSizes(CSize(70,60),CSize(28,40));RepositionBars(AFX_IDW_CONTROLBAR_FIRST,AFX_IDW_CONTROLBAR_LAST,0);/**************************原理************************先创建索引，再在resource.h中定义控件代表的索引，如#define IDB_bookinfo 5000#define IDB_booksell 5001#define IDB_sellinfo 5002#define IDB_set 5003#define IDB_cancel 5004最后在对话框的.cpp文件中将控件与响应函数关联起来BEGIN_MESSAGE_MAP(CBbbApp, CWinApp)ON_COMMAND(IDB_bookinfo, OnBookInfo)ON_COMMAND(IDB_booksell, OnBookInput)ON_COMMAND(IDB_sellinfo, OnSaleQuery)ON_COMMAND(IDB_set, OnButton4)ON_COMMAND(IDB_cancel, OnCancel)END_MESSAGE_MAP()******************************************************/方法(二):CImageList m_ImageList;CToolBarCtrl m_ToolBar;TBBUTTON tbButton[ICONSUM] = {0};m_ImageList.Create(32, 32, ILC_COLOR32 | ILC_MASK, 0, 0);m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON4));m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON6));m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON5));m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON2));m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON3));m_ToolBar.Create(WS_CHILD | WS_VISIBLE, CRect(0, 0, 0, 0), this, 0);m_ToolBar.SetImageList(&m_ImageList);for(int j=0; j< ICONSUM; j++){tbButton[j].dwData = NULL;tbButton[j].fsState = TBSTATE_ENABLED;tbButton[j].fsStyle = (BYTE)TBSTYLE_FLAT;tbButton[j].iBitmap = j;}tbButton[0].idCommand = ID_Info;tbButton[1].idCommand = ID_MR;tbButton[2].idCommand = ID_QS;tbButton[3].idCommand = ID_XS;tbButton[4].idCommand = ID_HELP;m_ToolBar.AddButtons(ICONSUM, tbButton);m_ToolBar.AutoSize();m_ToolBar.SetStyle(TBSTYLE_FLAT | CCS_TOP);6、设置菜单有效和失效有效：m_Menu.EnableMenuItem(ID_USER_REGISTER, MF_BYCOMMAND | MF_ENABLED);失效：m_Menu.EnableMenuItem(ID_USER_REGISTER, MF_BYCOMMAND | MF_DISABLED | MF_GRAYED);7、设置状态栏CTime Time;Time = CTime::GetCurrentTime();CString Str = Time.Format("%Y-%m-%d");UINT Array[3];for(int i=0;i<3;i++){Array[i]=10000+i;}m_Statusbar.Create(this);m_Statusbar.SetIndicators(Array,3);m_Statusbar.SetPaneInfo(0,Array[0],0,150);m_Statusbar.SetPaneInfo(1,Array[1],0,450);m_Statusbar.SetPaneInfo(2,Array[2],0,150);m_Statusbar.SetPaneText(0,"用户："+erID);m_Statusbar.SetPaneText(1,"CopyRight V1.0");m_Statusbar.SetPaneText(2,"当前时间:"+Str,true);RepositionBars(AFX_IDW_CONTROLBAR_FIRST,AFX_IDW_CONTROLBAR_LAST,0);8、设置菜单栏m_Menu.LoadMenu(IDR_MainMENU);SetMenu(&m_Menu);9、获得窗口WindowDC P464CWindowDC *dc = (CWindowDC *)GetWindowDC();10、文档框架关闭时，恢复程序主窗口void CPrintFram::OnClose(){theApp.m_mainfram = NULL;CPrintView* temp = (CPrintView*)this->GetActiveView();if (! temp->ispreview)theApp.m_pMainWnd = theApp.m_main;CFrameWnd::OnClose();}11、窗体标题栏加上图标先在头文件中声明：HICON m_hIcon;在构造函数中：m_hIcon = AfxGetApp()->LoadIcon(IDI_ICON1);在OnInitDialog()中：SetIcon(m_hIcon, TRUE); // Set big iconSetIcon(m_hIcon, FALSE); // Set small icon 在OnPaint()中：void CSmDlg::OnPaint(){if (IsIconic()){CPaintDC dc(this); // device context for paintingSendMessage(WM_ICONERASEBKGND, (WPARAM)dc.GetSafeHdc(), 0);// Center icon in client rectangleint cxIcon = GetSystemMetrics(SM_CXICON);int cyIcon = GetSystemMetrics(SM_CYICON);CRect rect;GetClientRect(&rect);int x = (rect.Width() - cxIcon + 1) / 2;int y = (rect.Height() - cyIcon + 1) / 2;// Draw the icondc.DrawIcon(x, y, m_hIcon);}else{CDialog::OnPaint();}}在OnQueryDragIcon()中：HCURSOR CSmDlg::OnQueryDragIcon(){return (HCURSOR) m_hIcon;}12、设置工具栏先添加相应的图标资源再在OnInitDialog()函数中TBBUTTON tbButton[ICONSUM] = {0};m_ImageList.Create(32, 32, ILC_COLOR32 | ILC_MASK, 0, 0);m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON8));m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON4));m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON6));m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON5));m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON2));m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON3));m_ImageList.Add(::AfxGetApp()->LoadIcon(IDI_ICON7));m_ToolBar.Create(WS_CHILD | WS_VISIBLE, CRect(0, 0, 0, 0), this, 0);m_ToolBar.SetImageList(&m_ImageList);for(int j=0; j< ICONSUM; j++){tbButton[j].dwData = NULL;tbButton[j].fsState = TBSTATE_ENABLED;tbButton[j].fsStyle = (BYTE)TBSTYLE_FLAT;tbButton[j].iBitmap = j;}tbButton[0].idCommand = ID_Sw;tbButton[1].idCommand = ID_BI;tbButton[2].idCommand = ID_MR;tbButton[3].idCommand = ID_QR;tbButton[4].idCommand = ID_XR;tbButton[5].idCommand = ID_HELP;tbButton[6].idCommand = ID_Exit;m_ToolBar.AddButtons(ICONSUM, tbButton);m_ToolBar.AutoSize();m_ToolBar.SetStyle(TBSTYLE_FLAT | CCS_TOP);13、对话框的淡入淡出效果#define AW_CENTER 0x00000010 //动画#define AW_HIDE 0x00010000 //隐藏BOOL CAutoMsgDlg::OnInitDialog() //淡入{CDialog::OnInitDialog();// TODO: Add extra initialization hereCenterWindow();DWORD dwStyle = AW_CENTER;HINSTANCE hInst = LoadLibrary("User32.DLL");typedef BOOL(WINAPI MYFUNC(HWND,DWORD,DWORD));MYFUNC* AnimateWindow;AnimateWindow=(MYFUNC *)::GetProcAddress(hInst,"AnimateWindow"); AnimateWindow(this->m_hWnd,1000,dwStyle);FreeLibrary(hInst);return TRUE; // return TRUE unless you set the focus to a control// EXCEPTION: OCX Property Pages should return FALSE }void CAutoMsgDlg::OnbtnCancel() //淡出{// TODO: Add your control notification handler code hereDWORD dwStyle = AW_CENTER;HINSTANCE hInst = LoadLibrary("User32.DLL");typedef BOOL(WINAPI MYFUNC(HWND,DWORD,DWORD));MYFUNC* AnimateWindow;AnimateWindow=(MYFUNC *)::GetProcAddress(hInst,"AnimateWindow"); AnimateWindow(this->GetSafeHwnd(),700,AW_HIDE|dwStyle); FreeLibrary(hInst);CDialog::OnCancel();}C++编程常用模块(四)：组合框用法四、组合框用法1、获取控件第一种方法：在向导中添加对应的变量第二种方法：CComboBox * com = (CComboBox*)GetDlgItem(IDC_COMBO5);2、清空m_SGrade.ResetContent();3、添加内容m_S.AddString("GB");m_S.AddString("ZH");4、移动到第一条记录ado.MoveFirst();5、移动到下一条记录ado.MoveNext();6、设置选项m_Department.SetCurSel(0);7、根据内容设值第一种：if(pare("男") == 0)((CComboBox*)GetDlgItem(IDC_COMBO1))->SetCurSel(0);else((CComboBox*)GetDlgItem(IDC_COMBO1))->SetCurSel(1);第二种：m_Dept.SetCurSel(m_Dept.FindString(0, str.GetBuffer(0)));8、获取索引int curSel = fieldCom->GetCurSel();9、选择改变严重注意：组合框要设置成Drop List的样式(Styles)void CAddInfo::OnSelchangeCOMBOS(){// TODO: Add your control notification handler code hereif(m_S.GetCurSel() != 0){m_SGrade.EnableWindow(false);}elsem_SGrade.EnableWindow(true);}10、绑定数据void CDlgSaleBack2::LoadCounterInfo(){m_counter.ResetContent();//删除所有的数据CString sql;sql = "select distinct counter from tb_counterinfo";m_pRs->raw_Close();m_pRs->Open((_bstr_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,a dCmdText);while (!m_pRs->adoEOF){m_counter.AddString((TCHAR*)(_bstr_t)m_pRs->GetFields()->GetItem("counter")->Value);m_pRs->MoveNext();}}11、获取数据严重注意：组合框要设置成Drop List的样式(Styles) m_WhereIsNow.GetWindowText(strWhereIsNow);C++编程常用模块(五)：控件操作五、控件操作1、控件与变量关联起来在函数中：void CAddInfo::DoDataExchange(CDataExchange* pDX){…DDX_Control(pDX, IDC_personImage, m_personImage);DDX_Control(pDX, IDC_LIST, m_List);…}控件与动作关联起来在域中：BEGIN_MESSAGE_MAP(CAddInfo, CDialog)ON_BN_CLICKED(IDC_btnAdd, OnbtnAdd)ON_BN_CLICKED(IDC_btnModify, OnbtnModify)END_MESSAGE_MAP()2、获取控件((CDateTimeCtrl*)GetDlgItem(IDC_DATETIMEPICKER1))->GetTime(&sysTime)3、设置控件的值SetDlgItemText(IDC_EDIT1, str); //文体框CTime date = CTime::GetCurrentTime(); //时间控件m_date.SetTime(&date);((CDateTimeCtrl*)GetDlgItem(IDC_DATETIMEPICKER1))->SetTime(&sysTime);//时间控件//设置文体框属性((CEdit*)GetDlgItem(IDC_EDIT1))->SetFocus(); //定焦((CEdit*)GetDlgItem(IDC_EDIT1))->SetSel(0, -1);//设置框内容选定状态4、从控件中取值m_Name.GetWindowText(strName); //文件框m_Birthday.GetWindowText(strBirthday); //时间控件((CDateTimeCtrl*)GetDlgItem(IDC_DATETIMEPICKER1))->GetTime(&sysTime); //时间控件GetDlgItemText(IDC_COMBO1, str); //组合框5、隐藏控件GetDlgItem(IDC_SEELIST)->ShowWindow(SW_HIDE);6、设置控件有效和失效有效：GetDlgItem(IDC_COMBOSGrade)->EnableWindow(true);失效：GetDlgItem(IDC_COMBOSGrade)->EnableWindow(false);7、移动焦点到编辑框m_Edit.SetFocus();m_Edit.SetSel(0,-1);8、使Date Time Picker只显示年月CDateTimeCtrl* pCtrl = (CDateTimeCtrl*)GetDlgItem(IDC_DATETIMEPICKER1); ASSERT(pCtrl != NULL);pCtrl->SetFormat(_T("yyyy-MM"));9、用IP Adress控件编辑IP地址（1）在OnInitDialog（）函数中设置IP地址的默认值CIPAddressCtrl*m_Address=(CIPAddressCtrl*)GetDlgItem(IDC_IPADDRESS1);m_Address->SetAddress(0,0,0,0);（2）输入IP地址，并显示出来CIPAddressCtrl* m_Address=(CIPAddressCtrl*)GetDlgItem(IDC_IPADDRESS1);BYTE nField0;BYTE nField1;BYTE nField2;BYTE nField3;m_Address->GetAddress(nField0,nField1,nField2,nField3);CString str_IP;str_IP.Format("您输入的IP地址是:%d.%d.%d.%d",nField0,nField1,nField2,nField3);AfxMessageBox(str_IP);10、对编辑框输入内容进行控制(1)限制输入框的内容为数字创建一继承自CEdit类的新类，并在以后使用文本框时用该类定义，在此类中写：void COnlyNumEdit::OnChar(UINT nChar, UINT nRepCnt, UINT nFlags){// TODO: Add your message handler code here and/or call defaultif(nChar==8) //{CEdit::OnChar(nChar, nRepCnt, nFlags);return;}if((nChar<48 || nChar>57)) //Ö»ÔÊÐíÊäÈëÊý×ÖnChar = 0;elseCEdit::OnChar(nChar, nRepCnt, nFlags);}(2)对输入的身份证信息进行验证if(m_IDcard.GetLength() != 18){AfxMessageBox("ÊäÈëÉí·ÝÖ¤ºÅÂëÎÞЧ");return;}else{int num=0;char ch;for(int i=0;i<17;i++){ch = m_IDcard.GetAt(i);if(ch>47 && ch<58)num++;}if(i==17){ch = m_IDcard.GetAt(i);if((ch>47 && ch<58) || (ch==88 || ch==120))num++;}if(num != 18){AfxMessageBox("ÊäÈëÉí·ÝÖ¤ºÅÂëÎÞЧ");return;}else{CString syear = m_IDcard.Mid(6,4);int year = atoi(syear);CString smonth = m_IDcard.Mid(10,2);int month = atoi(smonth);CString sday = m_IDcard.Mid(12,2);int day = atoi(sday);BOOL leap;if(month<1||month>12){AfxMessageBox("ÊäÈëÉí·ÝÖ¤ºÅÂëÎÞЧ");return;}switch(month){case 1: case 3: case 5: case 7: case 8: case 10: case 12:if(day<0 || day>31){AfxMessageBox("ÊäÈëÉí·ÝÖ¤ºÅÂëÎÞЧ");return;}break;case 4: case 6: case 9: case 11:if(day<0 || day>30){AfxMessageBox("ÊäÈëÉí·ÝÖ¤ºÅÂëÎÞЧ");return;}break;case 2:if(year % 4 == 0){if(year % 100 != 0)leap = TRUE;else if(year % 400 == 0)leap = TRUE;elseleap = FALSE;}elseleap = FALSE;if(leap){if(day<0 || day>29){AfxMessageBox("ÊäÈëÉí·ÝÖ¤ºÅÂëÎÞЧ");return;}elseif(day<0 || day>28){AfxMessageBox("ÊäÈëÉí·ÝÖ¤ºÅÂëÎÞЧ");return;}break;}}}}C++编程常用模块(六)：文件操作六、文件操作1、查找文件CFileFind cf;if(cf.FindFile(strPictureFile)) // strPictureFile文件名{……}2、删除文件theFile.Remove(delfile); // delfile 文件名3、复制文件CopyFile(strFile,savefilename,false); // strFile源文件，savefilename目标文件4、保存到文件void PrintResult(CString &result){FILE * pFile;pFile = fopen("result.txt", "w");if(NULL == pFile){::MessageBox(NULL, "文件打开出错！", "提示", MB_OK);return ;}#ifdef _UNICODEfwrite(result.GetBuffer(0), 2, result.GetLength(), pFile);#elsefwrite(result.GetBuffer(0), 1, result.GetLength(), pFile);#endiffclose(pFile);}5、获取文件所在路径char filepath[MAX_PATH];GetModuleFileName(NULL,filepath,MAX_PATH); //可执行文件的全部路径(包括：路径＋文件名)CString strFile = ExtractFilePath(filepath) + "Image.bmp";其中：CString CBbbApp::ExtractFilePath(LPTSTR filename) //返回的仅仅是路径{CString appname;appname = AfxGetAppName(); //获取可执行文件的文件名appname = appname+".exe";CString temp;int pos;temp = filename;pos = temp.Find(appname,0);temp = temp.Left(pos);return temp;}6、获取程序所在的根目录：P388GetCurrentDirectory(MAX_PATH,path);7、文件选择对话框使用CFileDialog fileDlg(TRUE, "bmp", NULL, OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT, "位图文件(*.bmp)|*.bmp||", this);if(fileDlg.DoModal() != IDOK)return ;strPictureFile = fileDlg.GetPathName();C++编程常用模块(七)：图片操作七、图片操作1、加载图片并显示出来char filepath[MAX_PATH];GetModuleFileName(NULL,filepath,MAX_PATH);CString strFile;strFile = ExtractFilePath(filepath) +"\\Image\\" + filename;CFileFind cf;if(cf.FindFile(strFile)){m_Photo =(HBITMAP)::LoadImage(::AfxGetInstanceHandle(), strFile, IMAGE_BITMAP, 150, 200,LR_LOADFROMFILE | LR_DEFAULTCOLOR | LR_DEFAULTSIZE);m_Picture.SetBitmap(m_Photo); //设置图片控件的内容}2、保存图片将图片文件名保存到数据库，文件本身保存到指定的文件夹中void CAddInfo::saveImage(CString strTime){CFileFind cf;if(cf.FindFile(strPictureFile)){char path[MAX_PATH];GetModuleFileName(NULL,path,MAX_PATH);CString savefilename;savefilename = ExtractFilePath(path) +"\\Image\\" + strTime;CopyFile(strPictureFile,savefilename,false);}return;}3、设置按钮图片P463m_Title.LoadBitmap(IDB_BITMAP10);m_Cross.LoadBitmap(IDB_BITMAP9);m_BitmapOK = ::LoadBitmap(::AfxGetInstanceHandle(), MAKEINTRESOURCE(IDB_BITMAP7));m_BitmapCancel = ::LoadBitmap(::AfxGetInstanceHandle(), MAKEINTRESOURCE(IDB_BITMAP8));m_OK.SetBitmap(m_BitmapOK);m_Cancel.SetBitmap(m_BitmapCancel);C++编程常用模块(八)：ListView用法八、ListView用法1、初始化m_List.SetExtendedStyle(LVS_EX_FLATSB|LVS_EX_FULLROWSELECT|LVS_EX_HEADERDRAGDROP|LVS_EX_ONECLICKACTIVATE|LVS_EX_GRIDLINES);m_List.InsertColumn(0,"列一",LVCFMT_CENTER,80,0); //插入一列m_List.InsertColumn(1," 列二",LVCFMT_CENTER,80,1);m_List.InsertColumn(2," 列三",LVCFMT_CENTER,100,2);m_List.InsertColumn(3," 列四",LVCFMT_CENTER,100,3);m_List.InsertColumn(4," 列五",LVCFMT_CENTER,80,4);m_List.InsertColumn(5," 列六",LVCFMT_CENTER,80,4);2、绑定数据void CAddInfo::BindList(){m_List.DeleteAllItems(); //清空ADOConn lc;lc.OnInitADOConn();int i=0;CString strsql;strsql.Format("select * from t_stable");lc.m_pRecordset = lc.GetRecordSet((_bstr_t)strsql); //访问数据库得到数据集while(!lc.m_pRecordset->adoEOF){m_List.InsertItem(i,""); //插入一行m_List.SetItemText(i,0,(char*)(_bstr_t)lc.m_pRecordset->GetCollect("Str1"));m_List.SetItemText(i,1,(char*)(_bstr_t)lc.m_pRecordset->GetCollect("Str2"));m_List.SetItemText(i,2,(char*)(_bstr_t)lc.m_pRecordset->GetCollect("Str3"));m_List.SetItemText(i,3,(char*)(_bstr_t)lc.m_pRecordset->GetCollect("Str4"));m_List.SetItemText(i,4,(char*)(_bstr_t)lc.m_pRecordset->GetCollect("Str5"));m_List.SetItemText(i,5,(char*)(_bstr_t)lc.m_pRecordset->GetCollect("Str6"));lc.m_pRecordset->MoveNext();i++;}lc.CloseConnect();return;}3、单击void CAddInfo::OnClickList(NMHDR* pNMHDR, LRESULT* pResult){// TODO: Add your control notification handler code hereint pos = m_List.GetSelectionMark();str1 = m_List.GetItemText(pos,0);str2 = m_List.GetItemText(pos,1);……*pResult = 0;}4、双击void CDlgBookInfo1::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) {int row = m_list.GetSelectionMark(); //获取单击列表的行索引if (row !=-1){ //将选中行的信息显示在编辑框中m_bookname.SetWindowText(m_list.GetItemText(row,0));m_shortcode.SetWindowText(m_list.GetItemText(row,1));m_barcode.SetWindowText(m_list.GetItemText(row,2));m_author.SetWindowText(m_list.GetItemText(row,3));m_public.SetWindowText(m_list.GetItemText(row,4));m_price.SetWindowText(m_list.GetItemText(row,5));m_memo.SetWindowText(m_list.GetItemText(row,6));m_kinds.SetCurSel(m_kinds.FindString(0,m_list.GetItemText(row,7)));}*pResult = 0;}5、清空m_List.DeleteAllItems();6、获取指定行列的信息GetSubItemRect(row,col,LVIR_LABEL,rect);str =GetItemText(row,col);7、设置列宽P383RECT rect;m_list2.GetWindowRect(&rect);int wid = rect.right - rect.left;m_list2.SetColumnWidth(0,wid/4); //设置列宽m_list2.SetColumnWidth(1,wid/4);m_list2.SetColumnWidth(2,wid/4);m_list2.SetColumnWidth(3,wid/4);m_list2.SetExtendedStyle(LVS_EX_FULLROWSELECT); //设置列表扩展风格C++编程常用模块(九)：常用类型操作与变换九、常用类型操作与变换1、CTime 到CStringa) 第一种：CTime Time;Time = CTime::GetCurrentTime();CString Str = Time.Format("%Y-%m-%d"); //年－月－日CString strNowTime = Time.Format("%H:%M:%S"); //时：分：秒b) 第二种：CTime nowTime=CTime::GetCurrentTime();CString strTime=_T("");CString temp;temp.Format("%d",nowTime.GetYear());strTime=strTime+temp;temp.Format("%d",nowTime.GetMonth());strTime=strTime+temp;temp.Format("%d",nowTime.GetDay());strTime=strTime+temp;temp.Format("%d",nowTime.GetHour());strTime=strTime+temp;temp.Format("%d",nowTime.GetMinute());strTime=strTime+temp;temp.Format("%d",nowTime.GetSecond());strTime=strTime+temp;2、CString 到CTimeSYSTEMTIME sTime={0};ChangeToDate(str1,&sTime);m_Birthday1.SetTime(&sTime);ChangeToDate(str2,&sTime);m_ Birthday2.SetTime(&sTime);void CAddInfo::ChangeToDate(CString str,void* sTime) {LPSYSTEMTIME lpTime = (LPSYSTEMTIME)sTime;int n,i;CString d,m,y;n=str.Find("-",0);y=str.Left(n);i=str.Find("-",n+1);d=str.Right(str.GetLength()-i-1);m=str.Mid(n+1,i-n-1);lpTime->wDay = atoi(d.GetBuffer(0));lpTime->wMonth = atoi(m.GetBuffer(0));lpTime->wYear = atoi(y.GetBuffer(0));}3、int 到CStringstrsql.Format("%d”,v);4、float 到CStringstrsql.Format("%f”,f);5、CString到intt = atoi(str);6、CString 到floatm = atof(str);7、字符串格式化strsql.Format("insert into t_stable (str0, str1,str2,str3,str4,str5,str6) values (1,'%s','%s','%s','%s','%s','%s')", str11, str22, str33, str44, str55,str66);8、字符串判空if(!str1.IsEmpty())9、清除字符串中的空格str.Replace(" ", "");C++编程常用模块(十)：数据库备份和还原十、数据库备份和还原1、备份P433void CDBCopy::OnbtnLook() //浏览，选择文件夹{// TODO: Add your control notification handler code hereCString ReturnPach;TCHAR szPath[_MAX_PATH];BROWSEINFO bi;bi.hwndOwner=NULL;bi.pidlRoot=NULL;bi.lpszTitle=_T("请选择备份文件夹");bi.pszDisplayName=szPath;bi.ulFlags=BIF_RETURNONLYFSDIRS;bi.lpfn=NULL;bi.lParam=NULL;LPITEMIDLIST pItemIDList=SHBrowseForFolder(&bi);if(pItemIDList){if(SHGetPathFromIDList(pItemIDList,szPath))ReturnPach=szPath;}elseReturnPach="";m_CopyPath.SetWindowText(ReturnPach);。