Ado 实现C 对象的存取.docx

AdO实现C对象的存取Ado现实现C+对象的存取作者：江上飞鸟下载源代码其实我最厌烦写东西了,最近忙死了，呵呵，前一段时间在做一个图形程序时，须要把C+对象保存到数据库里，刚起先真让我头疼啊，琢磨了个下午，最终给做出来了，废话不说了，还是把自己的一些体会与各位同任一起共享！”！-、新建一个继承于CObjeCt的子类C1.ine；头文件：1.ine.hclassC1.ine:ublicCObject?private:1.OGPENm_IogPen;画笔C01.0RKEFm_crBackColor;CArrayCPoint,CPointmPointArray;标记类对应框ublic:intGetSizeO;CPointGetPoint(intpos);voidDraw1.ine(CDC*DC,CPointptl,CPointpt2,CRectrc);voidDrawBackGround(CDC*pDC,CRectrect);voidDrawPoint(CDC*pDC,CRectrect)：voidSetWidth(intiWidth);CO1.ORREFGetColorO；voidSetColor(CO1.ORREFcolor);CO1.ORREFGetBkColorO;voidSetBkColor(CO1.ORREFcolor);voidAddPoint(CPointpoint);voidClearO;C1.ineO;virtualC1.ine();virtualvoidSerialize(CArchivear);C1.ineoperator=(C1.inesrc)：DEC1.ARE.SERlA1.(C1.ine)?);实现文件：1.ine,cpp/1.ine,cpp:implementationoftheC1.ineclass./IlizilllllllllllllllillllllllllllllllllllllHlllllllIIIIII/Sincludestdafx.hincludeTestAdo.hinclude1.ine.httifdef_DEBUG#UndefTHIS_FI1.EstaticcharTHIS_FI1.E=_FI1.E_：»definenewDEBuG_NEW8endifIMP1.EMENT_SERIAI/C1.ine,CObject,1)C1.ine:C1.ine()ClearO；C1.ine:C1.ineO重写=C1.ineC1.ine:operator=(C1.inesrc)if(this!=src)m_IogPen=src.m_logPen;m_crBackColor=src.ra_crBackColor：return*this;?串行化操作voidC1.ine:Serialize(CArchivear)if(ar.IsStoringO)arDWORD(m_crBackColor);ar.Write(m_logPcn,Sizeof(1.OGPEN);elseDWORDdw;ardw;m_crBackColor=CO1.ORREF(dw);ar.Read(m_IogPen,Sizeof(1.OGPEN);m_PointArray.Serialize(ar);voidC1.inenClearO(m_crBackColor=RGB(255,255,255)：m_IogPen.IopnStyle=PS_SO1.ID;m_logPcn.IopnWidth.x=1;m_IogPen.IopnWidth.y=1:m_IogPen.IopnColor=RGB(O,O,O);m_PointArray.ReinoveAl1();voidC1.ine:AddPoint(CPointpoint)m_Pointrray.Add(point);voidC1.ine:SetColor(CO1.ORREFcolor)m_logPen.IopnColor=color;CO1.ORREFC1.ine:GetColorOreturnm_IogPen.IopnColor;voidC1.ine:SetBkColor(CO1.ORREFcolor)m_crBackColor=color:CO1.ORREFC1.ine:IGetBkColorOreturnm_crBackColor;)voidC1.ine:SetWidth(intiWidth)m_logPcn.IopnWidth.x=iWidth;m_logPen.IopnWidth.y=iWidth;绘线条VoidC1.ine:DrawPoint(CF)C*p)C,CRectred)(intIen=m-Pointrray.GetSizeO；if(len=0)return：CPenpen;pen.CreatePenIndirect(m_logPen)：CPen*pIdPenPDC-SelectObject(pen)：CPointpt=m-Pointrray.Gett(O)：pX-MoveTo(pt);for(inti=l;ilen：i+)(pt=m-Pointrray.GetAt(i)：pDC-1.ineTo(pt)：pDC-SelectObject(pOldPen);p01dPe11=NU1.1.;pen.DeleteObjectO；voidC1.ine:IDrawBackGround(CDC*pDC,CRectrect)CBrushbrushCtl;brushCtl.CreateSolidBrush(GetBkColorO)；PDC-ReClangle(reel);p(X?-FiIlRect(rect,brushCtl);brushCtl.DeleteObjectO；voidC1.ine:Draw1.ine(CDC*pDC,CPointptl,CPointpt2,CRectrc)CPenpen;pen.CreatePenIndirect(m_logPen);CPen*pIdPen=PDC-SeICCtObjeCt(Pen);pDC-MoveTo(ptl);pDC-1.ineTo(pt2);pDC-Select0bject(p01dPen);pOldPen=NU1.1.;pen.DeleteObjectO;CPointC1.ine:GetPoint(intpos)if(pos=0posm-Pointrray.GetSizeO)?returnm_PointArray.GetAt(pos):returnCPoint(O,O);intC1.ine:GetSizeOreturnm-Pointrray.GetSizeO：用二、用Ado接口打开数据库BOO1.CTestdoDlg:OpenDb(CStringfilename)HRESU1.Thr=S_OK：hr=m_pCon.CreateInstance(ADOr)B.Connection):if(hr!=S_OK)returnFA1.SE;try_bstr_tsCon;sCon=_bstr_t(filename);/路径名sCon=Provider=Microsoft.Jet.O1.EDB.4.O：DataSource=+sCon;hr=m_pCon-Open(sCon,HdModeUnknown);if(hr!=S_OK)returnFA1.SE;/hr=m_pSet.CreateInstanceGDO)B.Recordset);if(hr!=S_OK)returnFA1.SE;m_pSet-Cursor1.ocation=adUseClient;hr=m_pSet-Open(SE1.ECT*FROMobject_table,_variant_t(IDispatch*)m_pCon,TRUE),adOpcnStatic,ad1.ockOptimistic,adCmdText);if(hr!=S_OK)returnFA1.SE:returnTRUE;/catch(_com_errore)CStringerrorMessage;errorMessage.Format(连接数据库失败！错误信息：%s,e.ErrorMessageO)；returnFA1.SE;returnFA1.SE;(留意：在Stdfx.h中要加入:#importC:ProgramFi1esCommonFilesSYSTEM.D0msadol5.dllnonamespacerename(EO,adoEOE)来引入ado库,还有在BOO1.CTestAdoApp:InitInstanceO加入AfXOIeInit();/初始化COM库)三、C1.ine对象的保存voidCTestAdoDlg:ZOnButtonSaveO/m_1.istif(!m_bState)return;UpdateDataO：trym_pSet-AddNewO;m_pSet-PutColled(name,_variant_t(m_sName):/保存图形对象CMemFiIememFile;CArchivear(oeml7ile,CArchive:store);m_1.ine.Seria1ize(ar);ar.CloseO:DWORDdwSize=memFile.Get1.engthO;1.PBYTEIpInfo=memFile.DetachO;VARIANTvarBI.OB;SAFEARRAY*psa;SFERRYBOUNDrgsaboundl：rgsabound.I1.bound=0:FgsaboundOJ.eElements=dwSize;psaSafeArrayCreate(VT_UI1,1,rgsabound)：for(longi=O;i(long)dwSize;i+)(SafeArrayPutElement(psa,i,IpInfo+);varB1.OB.vt=VT一ARRAYVT_UU;VarB1.oB.parray=psa;m_pSet-GetFieldsO-GetItern(object)-AppendChunk(varB1.OB);m_pSet_Update();AddString(msName);catch(_com_errore)CStringstr=(char*)e.DescriptionO;McssageBox(str÷r保存数据库出问题！，提示，MBJ)QMBCONWARNING；return;四、C1.ine对象的读取voidCTestAdoDlg:OnSelchange1.istData()intiPos=m_1.ist.GetCurSel();if(iPosO)return;m-pSet-MoveFirst();inti=0;while(iiPos)m_pSet-MoveNextO：i+;longIDataSize=In-PSet-GetFieldSOfetItem(_variant_t(ObjeCt)-AetUalSize;if(IDataSize=O