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

上传文件通过mybatis存储到数据库的BLOB格式中
HTML 页面需要设置一个文件框
[html]view plaincopy
1.<form enctype="multipart/form-data">
2.
3.<input type="file"name="file"/>
4.
5.</form>
上传操作方法：
[java]view plaincopy
1.public int doUpload() throws Exception {
2.
3. Map<String, Object> param = new HashMap<String,Object>();
4. ServletFileUpload servletFileUpload = new ServletFileUpload();
5. FileItemIterator itr = servletFileUpload.getItemIterator(mSGA.getCur
rentRequest());
6.while (itr.hasNext()) {
7. FileItemStream fi = itr.next();
8.if ("file".equals(fi.getFieldName())) {
9. InputStream is = fi.openStream();
10.byte[] b = FileCopyUtils.copyToByteArray(is); //FileCopyU
tils 为spring下的一个工具类。

11.if (b == null || b.length == 0) { return0; }
12. param.put("FILE", b);//此处所用的参数类型为 byte[]
13. }
14. }
15.
16.//////////各种参数放入param你懂得。

17.
18.//dao 为个人封装的工具类。

19.
20. param.put("ID", dao.getSequence("SEQ_NAME"));
21.
22.return dao.insert("mapper_id", param);
23. }
mapper文件对应的sql设置
[html]view plaincopy
1.<insert id="mapper_id"parameterType="Map">
2. INSERT INTO DEMO
3. (ID,FILE)
4. VALUES
5. (#{ID}, #{FILE,jdbcType=BLOB}) --此处需要加上jdbcType=BLOB
6.</insert>
通过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="ng.Long" resultMap="userGraphicMap">
SELECT
<include refid="resultColumn" />
fromuser_graphic_t WHERE
id=#{id}
order by id desc
</select>
3. 映射VO：
public class UserGraphicVo {
private Long id;
private byte[] graphicData;
//get/set方法
}
4. DAO层调用
public void addUserGraphic(UserGraphicVouserGraphicVo) {
getSqlSessionTemplate().insert("userGraphicVo.insertUserGraphic", userGraphicVo);
}
5. JSP页面展示图片
<imgsrc="${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()){
OutputStreamos = null;
try {
os = response.getOutputStream();
os.write(list.get(0).getGraphicData());
os.flush();
} catch (IOException e) {
("读取文件出错！" +
e.getMessage());
} finally {
if(null != os){
try {
os.close();
} catch (IOException e) {
("关闭文件输出流出错！" + e.getMessage());
}
}
}
}
}
}
7. 参考资料
/blog/1630672
/pzhtpf/article/details/7400606
/admin/blogs/1630698
/dcjob/blog/item/cd0cb809d8e43e3ce824886a.html。