spring mvc+hibernate 图片存储至blob

package cn.edu.ccut.service; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.sql.Blob; import java.util.Date; import java.util.List; import javax.annotation.Resource; import javax.imageio.stream.FileImageInputStream; import org.apache.commons.fileupload.disk.DiskFileItem; import org.hibernate.Hibernate; import org.springframework.stereotype.Service; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.multipart.commons.CommonsMultipartFile; import cn.edu.ccut.dao.PhotoDao; import cn.edu.ccut.inter.PhotoDaoInterface; import cn.edu.ccut.inter.PhotoServiceInterface; import cn.edu.ccut.po.Photo; @Service("PhotoService") public class PhotoService implements PhotoServiceInterface { @Resource(name = "PhotoDao") private PhotoDaoInterface pd; @Override public boolean addPhoto(Photo photo, MultipartFile image, String url) { String fileName = image.getOriginalFilename(); int pointIndex = fileName.lastIndexOf("."); String extendName = fileName.substring(pointIndex + 1); String newFilename = new Date().getTime() + "." + extendName; // Blob blob = null; FileInputStream fis; try { // ------------对 image进行类型转换，完成存储----------- CommonsMultipartFile cf = (CommonsMultipartFile) image; DiskFileItem fi = (DiskFileItem) cf.getFileItem(); File file = fi.getStoreLocation(); // fis = new FileInputStream(file); blob = Hibernate.createBlob(fis); } catch (FileNotFoundException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } photo.setBlob1(blob); int count = pd.Add(photo); if (count > 0) { try { InputStream in = image.getInputStream(); OutputStream out = new FileOutputStream(url + "/" + newFilename); int cun = 0; byte[] b = new byte[1024]; while ((cun = in.read(b)) != -1) { out.write(b, 0, cun); } out.close(); in.close(); return true; } catch (Exception e) { return false; } } else { return false; } } @Override public List<Photo> getAllPhoto() { List<Photo> photo = pd.getAllPhoto(); return pd.getAllPhoto(); } @Override public List<Photo> queryPhoto(String id) { List<Photo> photo = pd.queryPhoto(Integer.parseInt(id)); return photo; } }