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

上传文件通过mybatis存储到数据库的BLOB格式中HTML 页面 需要设置一个文件框htmlview plaincopy1. 2. 3. 4. 5. 上传操作方法：javaview plaincopy1. publicintdoUpload()throwsException2. 3. Mapparam=newHashMap();4. ServletFileUploadservletFileUpload=newServletFileUpload();5. FileItemIteratoritr=servletFileUpload.getItemIterator(mSGA.getCurrentRequest();6. while(itr.hasNext()7. FileItemStreamfi=itr.next();8. if(file.equals(fi.getFieldName()9. InputStreamis=fi.openStream();10. byteb=FileCopyUtils.copyToByteArray(is);/FileCopyUtils为spring下的一个工具类。11. if(b=null|b.length=0)return0;12. param.put(FILE,b);/此处所用的参数类型为byte13. 14. 15. 16. /各种参数放入param你懂得。17. 18. /dao为个人封装的工具类。19. 20. param.put(ID,dao.getSequence(SEQ_NAME);21. 22. returndao.insert(mapper_id,param);23. mapper文件对应的sql设置htmlview plaincopy1. 2. INSERTINTODEMO3. (ID,FILE)4. VALUES5. (#ID,#FILE,jdbcType=BLOB)-此处需要加上jdbcType=BLOB6. 通过MyBatis实现图片数据的存储 与读取开发环境：Mybatis:3.0.5MySQL:5.x1. 数据库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文件id,graphic_dataINSERT INTO user_graphic_t ()values (#id,#graphicData)SELECTfrom user_graphic_t WHEREid=#id order by id desc3. 映射VO：public class UserGraphicVo private Long id;private byte graphicData; /get/set方法4. DAO层调用public void addUserGraphic(UserGraphicVo userGraphicVo) getSqlSessionTemplate().insert(userGraphicVo.insertUserGraphic, userGraphicVo);5. JSP页面展示图片6. Action处理public void showReportImage() response.setContentType(image/jpeg); if (!.equals(id) List list = userGraphicService.findUserGraphicVoById(id);if(null != list & !list.isEmpty()OutputStream os = null;try os = response.getOutputStream();os.write(list.get(0).getGraphicData();os.flush(); catch (IOException e) L(读取文件出错！ + e.getMessage(); finally if(null != os)try os.close(); catch (IOException e) L(关闭文件输出流出错！ + e.getMessage();7. 参考资料 /blog/1630672 /pzhtpf/article/details/7400