Saving/Retreving BLOB object in Spring3MVC and Hibernate


CREATE TABLE `documents` (
   `id` int (11) NOT NULL AUTO_INCREMENT,
   ` name ` varchar (200) NOT NULL ,
   `description` text NOT NULL ,
   `filename` varchar (200) NOT NULL ,
   `content` mediumblob NOT NULL , /* for ORACLE enter BLOB*/
   `content_type` varchar (255) NOT NULL ,
   `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
   PRIMARY KEY (`id`)
);
pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.dufeng</groupId>
  <artifactId>MavenWebUpload</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  <build>
    <plugins>
      <plugin>
        <artifactId>maven-compiler-plugin</artifactId>
        <configuration>
          <source>1.5</source>
          <target>1.5</target>
        </configuration>
      </plugin>
      <plugin>
        <artifactId>maven-war-plugin</artifactId>
        <version>2.0</version>
      </plugin>
    </plugins>
  </build>
  <dependencies>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>2.5</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-orm</artifactId>
      <version>${org.springframework.version}</version>
    </dependency>
    
    <!-- jstl -->
  <dependency>
           <groupId>jstl</groupId>
           <artifactId>jstl</artifactId>
           <version>1.1.2</version>
       </dependency>


       <dependency>
           <groupId>taglibs</groupId>
           <artifactId>standard</artifactId>
           <version>1.1.2</version>
    </dependency>
   
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.10</version>
    </dependency>
    <dependency>
      <groupId>commons-dbcp</groupId>
      <artifactId>commons-dbcp</artifactId>
      <version>20030825.184428</version>
    </dependency>
    <dependency>
      <groupId>commons-pool</groupId>
      <artifactId>commons-pool</artifactId>
      <version>1.5.4</version>
    </dependency>
    <dependency>
      <groupId>commons-fileupload</groupId>
      <artifactId>commons-fileupload</artifactId>
      <version>1.2.1</version>
    </dependency>
    <dependency>
      <groupId>commons-io</groupId>
      <artifactId>commons-io</artifactId>
      <version>1.3</version>
    </dependency>
    
    <dependency>
   <groupId>org.hibernate</groupId>
   <artifactId>hibernate-core</artifactId>
   <version>3.6.3.Final</version>
</dependency>
 <dependency>
<groupId>javassist</groupId>
<artifactId>javassist</artifactId>
<version>3.12.1.GA</version>
</dependency>
<dependency>
<groupId>cglib</groupId>
<artifactId>cglib</artifactId>
<version>2.2.2</version>
</dependency>
  </dependencies>
  <properties>
    <org.springframework.version>3.0.2.RELEASE</org.springframework.version>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>
</project>

File: /src/main/java/com/dufeng/docmanager/model/Document.java
package com.dufeng .docmanager.model;
 
import java.sql.Blob;
import java.sql.Date;
 
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.Table;
 
@Entity
@Table (name= "documents" )
public class Document {
     
     @Id
     @GeneratedValue
     @Column (name= "id" )
     private Integer id;
 
     @Column (name= "name" )
     private String name;
 
     @Column (name= "description" )
     private String description;
 
     @Column (name= "filename" )
     private String filename;
 
     @Column (name= "content" )
     @Lob
     private Blob content;
     
     @Column (name= "content_type" )
     private String contentType;
     
     @Column (name= "created" )
     private Date created;
     
     //Getter and Setter methods
}
File: src/main/java/com/dufeng/docmanager/dao/DocumentDAO.java
package com.dufeng .docmanager.dao;
 
import java.util.List;
 
import net.viralpatel.docmanager.model.Document;
 
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;
 
@Repository
public class DocumentDAO {
     
     @Autowired
     private SessionFactory sessionFactory;
     
     @Transactional
     public void save(Document document) {
         Session session = sessionFactory.getCurrentSession();
         session.save(document);
     }
     
     @Transactional
     public List<Document> list() {
         Session session = sessionFactory.getCurrentSession();
         List<Document> documents = null ;
         try {
             documents = (List<Document>)session.createQuery( "from Document" ).list();
 
         } catch (HibernateException e) {
             e.printStackTrace();
         }
         return documents;
     }
     
     @Transactional
     public Document get(Integer id) {
         Session session = sessionFactory.getCurrentSession();
         return (Document)session.get(Document. class , id);
     }
 
     @Transactional
     public void remove(Integer id) {
         Session session = sessionFactory.getCurrentSession();
         
         Document document = (Document)session.get(Document. class , id);
         
         session.delete(document);
     }
}
File: /src/webapp/WEB-INF/web.xml
<? xml version = "1.0" encoding = "UTF-8" ?>
< web-app xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance"
     xmlns = "http://java.sun.com/xml/ns/javaee"
     xmlns:web = "http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
     xsi:schemaLocation = "http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
     id = "WebApp_ID" version = "2.5" >
     < display-name >DocumentManager</ display-name >
     < welcome-file-list >
         < welcome-file >index.html</ welcome-file >
     </ welcome-file-list >
     < servlet >
         < servlet-name >spring</ servlet-name >
         < servlet-class >
             org.springframework.web.servlet.DispatcherServlet
         </ servlet-class >
         < load-on-startup >1</ load-on-startup >
     </ servlet >
     < servlet-mapping >
         < servlet-name >spring</ servlet-name >
         < url-pattern >*.html</ url-pattern >
     </ servlet-mapping >
</ web-app >
File: /src/main/webapp/WEB-INF/jdbc.properties
jdbc.driverClassName= com.mysql.jdbc.Driver
jdbc.dialect=org.hibernate.dialect.MySQLDialect
jdbc.databaseurl=jdbc:mysql://localhost:3306/demo
jdbc.username=root
jdbc.password=root
File: /src/main/webapp/WEB-INF/spring-servlet.xml
<? xml  version = "1.0" encoding = "UTF-8" ?>
< beans xmlns = "http://www.springframework.org/schema/beans"
     xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance"
     xmlns:aop = "http://www.springframework.org/schema/aop"
     xmlns:context = "http://www.springframework.org/schema/context"
     xmlns:jee = "http://www.springframework.org/schema/jee"
     xmlns:lang = "http://www.springframework.org/schema/lang"
     xmlns:p = "http://www.springframework.org/schema/p"
     xmlns:tx = "http://www.springframework.org/schema/tx"
     xmlns:util = "http://www.springframework.org/schema/util"
     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
         http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
         http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
         http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd
         http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang.xsd
         http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
         http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd">
 
     < context:annotation-config />
     < context:component-scan base-package = "com.dufeng.docmanager" />
 
     < bean id = "jspViewResolver"
         class = "org.springframework.web.servlet.view.InternalResourceViewResolver" >
         < property name = "viewClass"
             value = "org.springframework.web.servlet.view.JstlView" />
         < property name = "prefix" value = "/WEB-INF/jsp/" />
         < property name = "suffix" value = ".jsp" />
     </ bean >
 
     < bean id = "propertyConfigurer"
         class = "org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
         p:location = "/WEB-INF/jdbc.properties" />
 
     < bean id = "dataSource"
         class = "org.apache.commons.dbcp.BasicDataSource" destroy-method = "close"
         p:driverClassName = "${jdbc.driverClassName}"
         p:url = "${jdbc.databaseurl}" p:username = "${jdbc.username}"
         p:password = "${jdbc.password}" />
 
 
     < bean id = "sessionFactory"
         class = "org.springframework.orm.hibernate3.LocalSessionFactoryBean" >
         < property name = "dataSource" ref = "dataSource" />
         < property name = "configLocation" >
             < value >classpath:hibernate.cfg.xml</ value >
         </ property >
         < property name = "configurationClass" >
             < value >org.hibernate.cfg.AnnotationConfiguration</ value >
         </ property >
         < property name = "hibernateProperties" >
             < props >
                 < prop key = "hibernate.dialect" >${jdbc.dialect}</ prop >
                 < prop key = "hibernate.show_sql" >true</ prop >
                 < prop key = "hibernate.connection.SetBigStringTryClob" >true</ prop >
                 < prop key = "hibernate.jdbc.batch_size" >0</ prop >
             </ props >
         </ property >
     </ bean >
     < bean id = "multipartResolver"
         class = "org.springframework.web.multipart.commons.CommonsMultipartResolver" >
 
         <!-- one of the properties available; the maximum file size in bytes -->
         < property name = "maxUploadSize" value = "10000000" />
     </ bean >
     < tx:annotation-driven />
 
     < bean id = "transactionManager"
         class = "org.springframework.orm.hibernate3.HibernateTransactionManager" >
         < property name = "sessionFactory" ref = "sessionFactory" />
     </ bean >
</ beans >
File: /src/main/resources/hibernate.cfg.xml
<? xml version = '1.0' encoding = 'utf-8' ?>
<!DOCTYPE hibernate-configuration PUBLIC
     "-//Hibernate/Hibernate Configuration DTD//EN"
     "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 
  
< hibernate-configuration >
     < session-factory >
         < mapping class = "com.dufeng.docmanager.model.Document" />
     </ session-factory >
         
</ hibernate-configuration >
File: /src/main/java/com/dufeng/docmanager/controller/DocumentController.java

package com.dufeng .docmanager.controller;
 
import java.io.IOException;
import java.io.OutputStream;
import java.sql.Blob;
import java.sql.SQLException;
import java.util.Map;
 
import javax.servlet.http.HttpServletResponse;
 
import com.dufeng .docmanager.dao.DocumentDAO;
import com.dufeng .docmanager.model.Document;
 
import org.apache.commons.io.IOUtils;
import org.hibernate.Hibernate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.MultipartFile;
 
@Controller
public class DocumentController {
     
     @Autowired
     private DocumentDAO documentDao;
     
     @RequestMapping ( "/index" )
     public String index(Map<String, Object> map) {
         try {
             map.put( "document" , new Document());
             map.put( "documentList" , documentDao.list());
         } catch (Exception e) {
             e.printStackTrace();
         }
 
         return "documents" ;
     }
 
     @RequestMapping (value = "/save" , method = RequestMethod.POST)
     public String save(
             @ModelAttribute ( "document" ) Document document,
             @RequestParam ( "file" ) MultipartFile file) {
         
         
         System.out.println( "Name:" + document.getName());
         System.out.println( "Desc:" + document.getDescription());
         System.out.println( "File:" + file.getName());
         System.out.println( "ContentType:" + file.getContentType());
         
         try {
             Blob blob = Hibernate.createBlob(file.getInputStream());
 
             document.setFilename(file.getOriginalFilename());
             document.setContent(blob);
             document.setContentType(file.getContentType());
         } catch (IOException e) {
             e.printStackTrace();
         }
         
         try {
             documentDao.save(document);
         } catch (Exception e) {
             e.printStackTrace();
         }
         
         return "redirect:/index.html" ;
     }
 
     @RequestMapping ( "/download/{documentId}" )
     public String download( @PathVariable ( "documentId" )
             Integer documentId, HttpServletResponse response) {
         
         Document doc = documentDao.get(documentId);
         try {
             response.setHeader( "Content-Disposition" , "inline;filename=\"" +doc.getFilename()+ "\"" );
             OutputStream out = response.getOutputStream();
             response.setContentType(doc.getContentType());
             IOUtils.copy(doc.getContent().getBinaryStream(), out);
             out.flush();
             out.close();
         
         } catch (IOException e) {
             e.printStackTrace();
         } catch (SQLException e) {
             e.printStackTrace();
         }
         
         
         return null ;
     }
 
     @RequestMapping ( "/remove/{documentId}" )
     public String remove( @PathVariable ( "documentId" )
             Integer documentId) {
         
         documentDao.remove(documentId);
         
         return "redirect:/index.html" ;
     }
}

File: /src/main/webapp/WEB-INF/jsp/documents.jsp

<%@taglib uri="http://www.springframework.org/tags" prefix="spring"%>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
< html >
< head >
     < title >Document Manager</ title >
</ head >
< body >
 
< h2 >Document Manager</ h2 >
 
< h3 >Add new document</ h3 >
< form:form method = "post" action = "save.html" commandName = "document" enctype = "multipart/form-data" >
     < form:errors path = "*" cssClass = "error" />
     < table >
     < tr >
         < td >< form:label path = "name" >Name</ form:label ></ td >
         < td >< form:input path = "name" /></ td >
     </ tr >
     < tr >
         < td >< form:label path = "description" >Description</ form:label ></ td >
         < td >< form:textarea path = "description" /></ td >
     </ tr >
     < tr >
         < td >< form:label path = "content" >Document</ form:label ></ td >
         < td >< input type = "file" name = "file" id = "file" ></ input ></ td >
     </ tr >
     < tr >
         < td colspan = "2" >
             < input type = "submit" value = "Add Document" />
         </ td >
     </ tr >
</ table
</ form:form >
 
< br />
< h3 >Document List</ h3 >
< c:if  test = "${!empty documentList}" >
< table class = "data" >
< tr >
     < th >Name</ th >
     < th >Description</ th >
     < th >&nbsp;</ th >
</ tr >
< c:forEach items = "${documentList}" var = "document" >
     < tr >
         < td width = "100px" >${document.name}</ td >
         < td width = "250px" >${document.description}</ td >
         < td width = "20px" >
             < a href = "${pageContext.request.contextPath}/download/${document.id}.html" >< img
                 src = "${pageContext.request.contextPath}/img/save_icon.gif" border = "0"
                 title = "Download this document" /></ a >
         
             < a href = "${pageContext.request.contextPath}/remove/${document.id}.html"
                 onclick = "return confirm('Are you sure you want to delete this document?')" >< img
                 src = "${pageContext.request.contextPath}/img/delete_icon.gif" border = "0"
                 title = "Delete this document" /></ a >
         </ td >
     </ tr >
</ c:forEach >
</ table >
</ c:if >
</ body >
</ html >



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值