在数据库中存储图像

软件技术国家教学资源库建设项目软件开发素材之C源代码一、功能简介在数据库中存储图像二、创建或搜集相关信息搜集单位重庆电子工程职业学院搜集时间20120805来源互联网三、适用对象学生、教师、C及ASPNET项目开发人员、相关技术人员等。四、功能简介在数据库中存储图像。五、程序代码程序名称FORM1CSUSINGSYSTEMUSINGSYSTEMCOLLECTIONSGENERICUSINGSYSTEMCOMPONENTMODELUSINGSYSTEMDATAUSINGSYSTEMDRAWINGUSINGSYSTEMTEXTUSINGSYSTEMWINDOWSFORMSUSINGSYSTEMDATAOLEDBUSINGSYSTEMIONAMESPACELOADIMAGESAPPPUBLICPARTIALCLASSFORM1FORMPUBLICFORM1INITIALIZECOMPONENTPRIVATEVOIDBUTTON1_CLICKOBJECTSENDER,EVENTARGSEOPENFILEDIALOG1FILTER“GIF图片GIF|GIF|JPG图片JPG|JPG|BMP图片BMP|BMP“OPENFILEDIALOG1INITIALDIRECTORYAPPLICATIONSTARTUPPATH/打开窗口的初始目录IFOPENFILEDIALOG1SHOWDIALOGDIALOGRESULTOKPB_IMAGEINLOADOPENFILEDIALOG1FILENAMEPRIVATEVOIDBUTTON2_CLICKOBJECTSENDER,EVENTARGSE/将图片转化为二进制流DATAIMAGEHELPERDATAIMAGEHELPERNEWDATAIMAGEHELPER/DATAIMAGEHELPER继承自ACCESSHELPER类OLEDBCONNECTIONMYCONNNEWOLEDBCONNECTIONDATAIMAGEHELPEROLEDBCONNECTIONSTRINGMYCONNOPENTRYBYTEBYTEIMAGEDATAIMAGEHELPERGETBEYTIMAGEBYPATHOPENFILEDIALOG1FILENAME/获取文件名FILEINFOFILEINFONEWFILEINFOOPENFILEDIALOG1FILENAMESTRINGFILENAMEFILEINFONAMEOLEDBCOMMANDMYCMDNEWOLEDBCOMMAND“INSERTINTOTB_IMAGEIMAGENAME,IMAGEBYTEVALUES“FILENAME“,PHOTO1“,MYCONNMYCMDCOMMANDTYPECOMMANDTYPETEXTOLEDBPARAMETERPRMPERSONIMAGETYPENEWOLEDBPARAMETER“PHOTO1“,OLEDBTYPEVARBINARY/BYTEDATAOBJFORMIMAGEBYTEPRMPERSONIMAGETYPEVALUEBYTEIMAGEMYCMDPARAMETERSADDPRMPERSONIMAGETYPEVALUEBYTEIMAGEMYCMDEXECUTENONQUERYMESSAGEBOXSHOW“图片插入成功“CATCHEXCEPTIONEXMESSAGEBOXSHOWEXMESSAGE程序名称ACCESSHELPERCSUSINGSYSTEMUSINGSYSTEMCOLLECTIONSGENERICUSINGSYSTEMTEXTUSINGSYSTEMDATAUSINGSYSTEMDATAOLEDBUSINGSYSTEMDATASQLCLIENTUSINGSYSTEMWINDOWSFORMSNAMESPACELOADIMAGESAPPPUBLICCLASSACCESSHELPER/ACCESSHELPER/PUBLICSTRINGOLEDBCONNECTIONSTRINGSETOLEDBCONNECTIONSTRINGVALUEGETRETURNOLEDBCONNECTIONSTRING/从配置文件获取定义的SQL连接字符串/PRIVATESTATICSTRINGSTRCONNECTSYSTEMCONFIGURATIONCONFIGURATIONSETTINGSAPPSETTINGS“CONNSTR“PRIVATESTRINGOLEDBCONNECTIONSTRINGPUBLICACCESSHELPER/设置连接字符串OLEDBCONNECTIONSTRING“PROVIDERMICROSOFTJETOLEDB40JETOLEDBDATABASEPASSWORD123456“OLEDBCONNECTIONSTRING“DATASOURCE“APPLICATIONSTARTUPPATH“IMAGEDATAMDBPERSISTSECURITYINFOTRUE“/OLEDBCONNECTIONSTRING“UIDADMIN“/典型连接字符串是“PROVIDERMICROSOFTJETOLEDB40DATASOURCEDATABASENAMEUSERIDUSERNAMEPASSWORDUSERPASSWORD“/WARNING此处的算法有待优化PUBLICOLEDBCONNECTIONCREATECONNECTION/返回OLEDB的一个连接RETURNNEWOLEDBCONNECTIONOLEDBCONNECTIONSTRING/在内存中建立一个表/要使用的SQL语句/要进行操作的目标表/PUBLICDATATABLEGETSQLTABLESTRINGSELECTSQL,STRINGTABLENAME/获得一个表,2个参数,一个SQL语句,一个表名DATATABLETABLENEWDATATABLETABLENAMEOLEDBCONNECTIONOLECONNECTIONTHISCREATECONNECTIONTRYOLEDBDATAADAPTEROLEDATAADAPTERNEWOLEDBDATAADAPTERSELECTSQL,OLEDBCONNECTIONSTRINGOLEDATAADAPTERFILLTABLECATCHSYSTEMDATAOLEDBOLEDBEXCEPTIONEXTHROWEXCATCHSYSTEMEXCEPTIONEXTHROWEXFINALLYIFOLECONNECTIONSTATECONNECTIONSTATECLOSEDOLECONNECTIONCLOSERETURNTABLE/执行SQL语句/SQL语句/PUBLICINTEXECUTESQLSTRINGCMDTEXT/执行SQL语句,1个参数,为所执行的语句,返回整数值为判断所影响的行数INTIVALUE1OLEDBCONNECTIONOLECONNECIONTHISCREATECONNECTIONOLECONNECIONOPENOLEDBTRANSACTIONOLETRANSACTIONOLECONNECIONBEGINTRANSACTION/新建一事务TRYOLEDBCOMMANDOLECOMMANDNEWOLEDBCOMMANDOLECOMMANDCONNECTIONOLECONNECION/使用的连接OLECOMMANDCOMMANDTEXTCMDTEXT/SQL语句OLECOMMANDTRANSACTIONOLETRANSACTION/建立一个事务IVALUEOLECOMMANDEXECUTENONQUERYOLETRANSACTIONCOMMIT/提交事务CATCHSYSTEMDATAOLEDBOLEDBEXCEPTIONEXOLETRANSACTIONROLLBACK/事务没有执行结束则回滚THROWEXCATCHSYSTEMEXCEPTIONEX2THROWEX2FINALLYOLECONNECIONCLOSERETURNIVALUE/封装根据COMMAND对象填充DATAREADER的方法/返回DATAREADER类型的值/SQL语句/PUBLICOBJECTOLEEXECUTEREADERSTRINGCMDTEXTOLEDBCONNECTIONOLECONNECIONTHISCREATECONNECTIONOLECONNECIONOPENOLEDBTRANSACTIONOLETRANSACTIONOLECONNECIONBEGINTRANSACTIONTRYOLEDBCOMMANDOLECOMMANDNEWOLEDBCOMMANDOLECOMMANDCONNECTIONOLECONNECIONOLECOMMANDCOMMANDTEXTCMDTEXTOLECOMMANDTRANSACTIONOLETRANSACTIONOLEDBDATAREADERDROLECOMMANDEXECUTEREADER/OLETRANSACTIONCOMMIT/如果有数据用WHILE循环依次显示数据OBJECTSNULLWHILEDRREADSDRGETVALUE0/返回SQLDATAREADERRETURNS/返回SQLDATAREADER/RETURNOLECOMMANDEXECUTEREADERCATCHSYSTEMDATAOLEDBOLEDBEXCEPTIONEXOLETRANSACTIONROLLBACKTHROWEXCATCHSYSTEMEXCEPTIONEX2THROWEX2FINALLYOLECONNECIONCLOSE程序名称DATAIMAGEHELPERCSUSINGSYSTEMUSINGSYSTEMCOLLECTIONSGENERICUSINGSYSTEMTEXTUSINGSYSTEMDRAWINGUSINGSYSTEMIONAMESPACELOADIMAGESAPPCLASSDATAIMAGEHELPERACCESSHELPER/将数据库中读取到的BYTE转换为IMAGE类型/ACCESS数据库内读取到的BYTE/IMAGE类型PUBLICIMAGEGETIMAGEBYBEYTBYTEIMAGEBYTESTREAMSTREAMNEWMEMORYSTREAMIMAGEBYTERETURNIMAGEFROMSTREAMSTREAM/将图片文件转换为BYTE类型/图片文件路径/图片的BYTE流PUBLICBYTEGETBEYTIMAGEBYPATHSTRINGIMAGEPATHFILESTREAMFILESTREAMNEWF