通过MyBatis实现图片数据的存储 与读取
开发环境：
Mybatis:3.0.5
MySQL: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="userGraphicVo"><id column="id" property="id" jdbcType="DECIMAL" /><result column="graphic_data" property="graphicData" jdbcType="BLOB" /></resultMap><sql id="resultColumn">id,graphic_data</sql><insert id="insertUserGraphic" parameterType="userGraphicVo">INSERT INTO user_graphic_t (<include refid="resultColumn" />)values (#{id},,#{graphicData})</insert><select id="selectUserGraphic" parameterType="java.lang.Long" resultMap="userGraphicMap">SELECT<include refid="resultColumn" />from user_graphic_t WHEREid=#{id} order by id desc</select>3. 映射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页面展示图片
<img src="${ctxPath}/apps/showImage.action?id=${userGraphic.id}" />?6. Action处理
public void showReportImage() {? ? ? ? ? ? ? ? response.setContentType("image/jpeg");? ? ? ? ? ? ? ? if (!"".equals(id)) {List<UserGraphicVo> 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) {Log.info("读取文件出错！" + e.getMessage());} finally {if(null != os){try {os.close();} catch (IOException e) {Log.info("关闭文件输出流出错！" + e.getMessage());}}}}}}7. 参考资料
??? http://springsfeng.iteye.com/blog/1630672
??? http://blog.csdn.net/pzhtpf/article/details/7400606
??? http://springsfeng.iteye.com/admin/blogs/1630698
??? http://hi.baidu.com/dcjob/blog/item/cd0cb809d8e43e3ce824886a.html