java上传文件通过mybatis存储到数据库BLOB格式中.docx

?上传文件通过mybatis存储到数据库的BLOB格式中HTML? 页面需要设置一个文件框[html]?view plaincopyform?enctype=multipart/form-data??????input?type=file?name=file?/????/form??上传操作方法：[java]?view plaincopy????public?int?doUpload()?throws?Exception?{????????????MapString,?Object?param?=?new?HashMapString,Object();??????????ServletFileUpload?servletFileUpload?=?new?ServletFileUpload();??????????FileItemIterator?itr?=?servletFileUpload.getItemIterator(mSGA.getCurrentRequest());??????????while?(itr.hasNext())?{??????????????FileItemStream?fi?=?itr.next();??????????????if?(file.equals(fi.getFieldName()))?{??????????????????InputStream?is?=?fi.openStream();??????????????????byte[]?b?=?FileCopyUtils.copyToByteArray(is);????//FileCopyUtils???为spring下的一个工具类。??????????????????if?(b?==?null?||?b.length?==?0)?{?return?0;?}??????????????????param.put(FILE,?b);//此处所用的参数类型为?byte[]??????????????}??????????}????//////////各种参数放入param你懂得。。。。????//dao?为个人封装的工具类。。。????????????param.put(ID,?dao.getSequence(SEQ_NAME));????????????return?dao.insert(mapper_id,?param);??????}??mapper文件对应的sql设置[html]?view plaincopyinsert?id=mapper_id?parameterType=Map??????INSERT?INTO?DEMO??????(ID,FILE)??????VALUES??????(#{ID},?#{FILE,jdbcType=BLOB})?--此处需要加上jdbcType=BLOB??/insert??通过MyBatis实现图片数据的存储与读取开发环境：Mybatis:3.0.5MySQL:5.x?1. 数据库Scheme---- Table structure for table `user_graphic_t`--DROP TABLE IF EXISTS `user_graphic_t`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `user_graphic_t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `graphic_data` blob, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=360 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;2. Mapper文件resultMap id=userGraphicMap type=userGraphicVoid column=id property=id jdbcType=DECIMAL /result column=graphic_data property=graphicData jdbcType=BLOB //resultMapsql id=resultColumnid,graphic_data/sqlinsert id=insertUserGraphic parameterType=userGraphicVoINSERT INTO user_graphic_t (inc