当前位置：Gxlcms > 数据库问题 > springMVC+spring+hibernate注解上传文件到数据库，下载，多文件上传

springMVC+spring+hibernate注解上传文件到数据库，下载，多文件上传

时间：2021-07-01 10:21:17 帮助过：8人阅读

20) NOT NULL AUTO_INCREMENT, `realName` varchar(36) DEFAULT NULL, `fileContent` mediumblob, `handId` bigint(20) DEFAULT NULL, `customerId` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `fk_id` (`handId`), CONSTRAINT `fk_id` FOREIGN KEY (`handId`) REFERENCES `handprocess` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8； CREATE TABLE `handprocess` ( `id` bigint(20) NOT NULL DEFAULT ‘0‘, `handTime` bigint(20) DEFAULT NULL, `handName` varchar(20) DEFAULT NULL, `reason` varchar(100) DEFAULT NULL, `annexStr` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

处理过程（handprocess）和附件表（annex）一对多关系，一条处理过程可以有多个附件

除了springmvc+hibernate+spring的jar，还需要

commons-fileupload-1.3.1.jar

commons-io-2.0.1.jar

数据库保存上传文件内容使用mediumblob类型

mysql保存数据库二进制文件使用blob类型，其大小如下

  1. TinyBlob 最大 <span style="color: #800080;">255</span><span style="color: #000000;">
  2. Blob 最大 65K
  3. MediumBlob 最大 16M
  4. LongBlob 最大 4G</span>

springmvc中需添加配置文件

  1. <bean id=<span style="color: #800000;">"</span><span style="color: #800000;">multipartResolver</span><span style="color: #800000;">"</span>
  2.         <span style="color: #0000ff;">class</span>=<span style="color: #800000;">"</span><span style="color: #800000;">org.springframework.web.multipart.commons.CommonsMultipartResolver</span><span style="color: #800000;">"</span>>
  3.         <property name=<span style="color: #800000;">"</span><span style="color: #800000;">maxUploadSize</span><span style="color: #800000;">"</span> value=<span style="color: #800000;">"</span><span style="color: #800000;">10000000</span><span style="color: #800000;">"</span>></property>  <!-- <span style="color: #0000ff;">byte</span> -->
  4.         <property name=<span style="color: #800000;">"</span><span style="color: #800000;">defaultEncoding</span><span style="color: #800000;">"</span> value=<span style="color: #800000;">"</span><span style="color: #800000;">utf-8</span><span style="color: #800000;">"</span> />
  5.     </bean>

其中maxUploadSizes的大小是上传文件大小，单位：字节

实体：

  1. <span style="color: #000000;">package com.h3c.zgc.upload;
  2. import javax.persistence.Column;
  3. import javax.persistence.Entity;
  4. import javax.persistence.Id;
  5. import javax.persistence.Table;
  6. </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  7.  * 附件     和处理过程多对一
  8.  * @author GoodLuck
  9.  *
  10.  </span><span style="color: #008000;">*/</span><span style="color: #000000;">
  11. @Entity
  12. @Table(name</span>=<span style="color: #800000;">"</span><span style="color: #800000;">annex</span><span style="color: #800000;">"</span>,catalog=<span style="color: #800000;">"</span><span style="color: #800000;">itac</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  13. </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> Annex {
  14.     @Id
  15.     @Column(name</span>=<span style="color: #800000;">"</span><span style="color: #800000;">id</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  16.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> Long id;
  17.     </span><span style="color: #008000;">//</span><span style="color: #008000;">上传文件的名称</span>
  18.     @Column(name=<span style="color: #800000;">"</span><span style="color: #800000;">realName</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  19.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> String realName;
  20.     </span><span style="color: #008000;">//</span><span style="color: #008000;">上传文件的内容</span>
  21.     @Column(name=<span style="color: #800000;">"</span><span style="color: #800000;">fileContent</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  22.     </span><span style="color: #0000ff;">private</span> <span style="color: #0000ff;">byte</span><span style="color: #000000;">[] fileContent;
  23.     </span><span style="color: #008000;">//</span><span style="color: #008000;">处理过程的id</span>
  24.     @Column(name=<span style="color: #800000;">"</span><span style="color: #800000;">handId</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  25.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> Long handId;
  26.     </span><span style="color: #008000;">//</span><span style="color: #008000;">客户id</span>
  27.     @Column(name=<span style="color: #800000;">"</span><span style="color: #800000;">customerId</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  28.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> Long customerId;
  29.     
  30.     </span><span style="color: #008000;">//</span><span style="color: #008000;">getter and setter ...</span>
  31. <span style="color: #000000;">    
  32.     
  33. }</span>
  1. <span style="color: #000000;">package com.h3c.zgc.upload;
  2. import javax.persistence.Column;
  3. import javax.persistence.Entity;
  4. import javax.persistence.Id;
  5. import javax.persistence.Table;
  6. import javax.persistence.Transient;
  7. @Entity
  8. @Table(name</span>=<span style="color: #800000;">"</span><span style="color: #800000;">handprocess</span><span style="color: #800000;">"</span>,catalog=<span style="color: #800000;">"</span><span style="color: #800000;">itac</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  9. </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> HandProcess {
  10.     
  11.     @Id
  12.     @Column(name</span>=<span style="color: #800000;">"</span><span style="color: #800000;">id</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  13.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> Long id;
  14.     @Column(name</span>=<span style="color: #800000;">"</span><span style="color: #800000;">handTime</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  15.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> Long handTime;
  16.     @Column(name</span>=<span style="color: #800000;">"</span><span style="color: #800000;">handName</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  17.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> String handName;
  18.     @Column(name</span>=<span style="color: #800000;">"</span><span style="color: #800000;">reason</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  19.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> String reason;
  20.     @Column(name</span>=<span style="color: #800000;">"</span><span style="color: #800000;">annexStr</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  21.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> String annexStr;
  22.     @Transient
  23.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> String handTimeStr;
  24.     
  25.     </span><span style="color: #008000;">//</span><span style="color: #008000;">getter and setter ...</span>
  26. <span style="color: #000000;">    
  27.     
  28. }</span>

dao层

  1. <span style="color: #000000;">package com.h3c.zgc.upload;
  2. import java.io.Serializable;
  3. import java.util.List;
  4. import javax.annotation.Resource;
  5. import org.hibernate.SQLQuery;
  6. import org.hibernate.Session;
  7. import org.hibernate.SessionFactory;
  8. import org.hibernate.transform.Transformers;
  9. import org.springframework.orm.hibernate4.support.HibernateDaoSupport;
  10. import org.springframework.stereotype.Repository;
  11. @Repository
  12. </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> UploadDownDao extends HibernateDaoSupport{
  13.     @Resource
  14.     </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span> <span style="color: #0000ff;">set</span><span style="color: #000000;">(SessionFactory sessionFactory){
  15.         </span><span style="color: #0000ff;">this</span><span style="color: #000000;">.setSessionFactory(sessionFactory);
  16.     }
  17.     
  18.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> Session getSession(){
  19.         </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">this</span><span style="color: #000000;">.getSessionFactory().openSession();
  20.     }
  21.     </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  22.      * 获取附件id最大值
  23.      </span><span style="color: #008000;">*/</span>
  24.     <span style="color: #0000ff;">public</span><span style="color: #000000;"> Long getMaxIdOfAnnex(){
  25.         List l </span>= <span style="color: #0000ff;">this</span>.getHibernateTemplate().find(<span style="color: #800000;">"</span><span style="color: #800000;">select max(id) from Annex</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  26.         System.</span><span style="color: #0000ff;">out</span><span style="color: #000000;">.println(l);
  27.         </span><span style="color: #0000ff;">if</span>(l!=<span style="color: #0000ff;">null</span>&&l.size()==<span style="color: #800080;">1</span>&&l.<span style="color: #0000ff;">get</span>(<span style="color: #800080;">0</span>)!=<span style="color: #0000ff;">null</span><span style="color: #000000;">){
  28.             </span><span style="color: #0000ff;">return</span> (Long) l.<span style="color: #0000ff;">get</span>(<span style="color: #800080;">0</span><span style="color: #000000;">);
  29.         }
  30.         </span><span style="color: #0000ff;">return</span> <span style="color: #800080;">0L</span><span style="color: #000000;">;
  31.     }
  32.     </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  33.      * 获取处理过程id最大值
  34.      * @return
  35.      </span><span style="color: #008000;">*/</span>
  36.     <span style="color: #0000ff;">public</span><span style="color: #000000;"> Long getMaxIdOfHandProcess(){
  37.         List l </span>= <span style="color: #0000ff;">this</span>.getHibernateTemplate().find(<span style="color: #800000;">"</span><span style="color: #800000;">select max(id) from HandProcess</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  38.         System.</span><span style="color: #0000ff;">out</span><span style="color: #000000;">.println(l);
  39.         </span><span style="color: #0000ff;">if</span>(l!=<span style="color: #0000ff;">null</span>&&l.size()==<span style="color: #800080;">1</span>&&l.<span style="color: #0000ff;">get</span>(<span style="color: #800080;">0</span>)!=<span style="color: #0000ff;">null</span><span style="color: #000000;">){
  40.             </span><span style="color: #0000ff;">return</span> (Long) l.<span style="color: #0000ff;">get</span>(<span style="color: #800080;">0</span><span style="color: #000000;">);
  41.         }
  42.         </span><span style="color: #0000ff;">return</span> <span style="color: #800080;">0L</span><span style="color: #000000;">;
  43.     }
  44.     </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  45.      * 保存附件
  46.      * @param annex
  47.      * @return
  48.      </span><span style="color: #008000;">*/</span>
  49.     <span style="color: #0000ff;">public</span><span style="color: #000000;"> Serializable saveAnnex(Annex annex){
  50.         </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">this</span><span style="color: #000000;">.getHibernateTemplate().save(annex);
  51.     }
  52.     </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  53.      * 保存处理过程
  54.      * @param hp
  55.      * @return
  56.      </span><span style="color: #008000;">*/</span>
  57.     <span style="color: #0000ff;">public</span><span style="color: #000000;"> Serializable saveHandProcess(HandProcess hp){
  58.         </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">this</span><span style="color: #000000;">.getHibernateTemplate().save(hp);
  59.     }
  60.     </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  61.      * 获取处理过程列表，左连接查询
  62.      * @return
  63.      </span><span style="color: #008000;">*/</span>
  64.     <span style="color: #0000ff;">public</span> List getHandProcessList(){<span style="color: #008000;">//</span><span style="color: #008000;">有没有可能没有附件，附件annex，处理过程handprocess</span>
  65.         SQLQuery query = <span style="color: #0000ff;">this</span>.getSession().createSQLQuery(<span style="color: #800000;">"</span><span style="color: #800000;">select h.id handprocessId,h.annexStr annexStr,a.id annexId,a.realName realName,h.handTime handTime,h.handName handName,h.reason reason from handprocess h left join annex a on a.handId=h.id</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  66.         query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
  67.         List list </span>=<span style="color: #000000;"> query.list();
  68.         </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> list;
  69.     }
  70.     </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  71.      * 根据id获取附件信息
  72.      * @param annexId
  73.      * @return
  74.      </span><span style="color: #008000;">*/</span>
  75.     <span style="color: #0000ff;">public</span><span style="color: #000000;"> Annex getAnnexById(Long annexId){
  76.         </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">this</span>.getHibernateTemplate().<span style="color: #0000ff;">get</span>(Annex.<span style="color: #0000ff;">class</span><span style="color: #000000;">, annexId);
  77.     }
  78.     </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  79.      * 修改处理过程
  80.      * @param hp
  81.      </span><span style="color: #008000;">*/</span>
  82.     <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> updateHandProcess(HandProcess hp){
  83.         </span><span style="color: #0000ff;">this</span><span style="color: #000000;">.getHibernateTemplate().update(hp);
  84.     }
  85. }</span>

service层

  1. <span style="color: #000000;">package com.h3c.zgc.upload;
  2. import java.io.Serializable;
  3. import java.util.List;
  4. import java.util.Map;
  5. import javax.annotation.Resource;
  6. import javax.transaction.Transactional;
  7. import org.springframework.stereotype.Service;
  8. @Service
  9. </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> UploadDownService {
  10.     @Resource
  11.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> UploadDownDao uploadDownDao;
  12.     
  13.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> Long getMaxIdOfAnnex(){
  14.         </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownDao.getMaxIdOfAnnex();
  15.     }
  16.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> Long getMaxIdOfHandProcess(){
  17.         </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownDao.getMaxIdOfHandProcess();
  18.     }
  19.     @Transactional
  20.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> Serializable saveAnnex(Annex annex){
  21.         </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownDao.saveAnnex(annex);
  22.     }
  23.     @Transactional
  24.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> Serializable saveHandProcess(HandProcess hp){
  25.         </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownDao.saveHandProcess(hp);
  26.     }
  27.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> Annex getAnnexById(Long annexId){
  28.         </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownDao.getAnnexById(annexId);
  29.     }
  30.     </span><span style="color: #0000ff;">public</span> List<Map<String,Object>><span style="color: #000000;"> getHandProcessList(){
  31.         </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownDao.getHandProcessList();
  32.     }
  33.     @Transactional
  34.     </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> updateHandProcess(HandProcess hp){
  35.         </span><span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownDao.updateHandProcess(hp);
  36.     }
  37. }</span>

controller层

  1. <span style="color: #000000;">package com.h3c.zgc.upload;
  2. import java.io.BufferedOutputStream;
  3. import java.io.ByteArrayOutputStream;
  4. import java.io.IOException;
  5. import java.io.InputStream;
  6. import java.io.Serializable;
  7. import java.text.DateFormat;
  8. import java.text.ParseException;
  9. import java.text.SimpleDateFormat;
  10. import java.util.List;
  11. import java.util.Map;
  12. import javax.annotation.Resource;
  13. import javax.servlet.http.HttpServletRequest;
  14. import javax.servlet.http.HttpServletResponse;
  15. import org.springframework.stereotype.Controller;
  16. import org.springframework.web.bind.annotation.RequestMapping;
  17. import org.springframework.web.bind.annotation.RequestParam;
  18. import org.springframework.web.multipart.MultipartFile;
  19. @Controller
  20. </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> UploadDownFileController {
  21.     @Resource
  22.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> UploadDownService uploadDownService;
  23.     </span><span style="color: #008000;">//</span><span style="color: #008000;">单文件上传到数据库，MultipartFile中封装了上传文件的信息</span>
  24.     @RequestMapping(<span style="color: #800000;">"</span><span style="color: #800000;">upload</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  25.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> String upload(HandProcess hp, HttpServletRequest request,
  26.             @RequestParam(</span><span style="color: #800000;">"</span><span style="color: #800000;">uploadFile1</span><span style="color: #800000;">"</span><span style="color: #000000;">) MultipartFile uploadFile1)
  27.             throws IOException, ParseException {
  28.         
  29.         InputStream </span><span style="color: #0000ff;">is</span> =<span style="color: #000000;"> uploadFile1.getInputStream();
  30.         </span><span style="color: #0000ff;">byte</span>[] buffer = <span style="color: #0000ff;">this</span>.inputStrean2ByteArr(<span style="color: #0000ff;">is</span><span style="color: #000000;">);
  31.         </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  32.          * 保存处理过程信息
  33.          </span><span style="color: #008000;">*/</span>
  34.         <span style="color: #008000;">//</span><span style="color: #008000;"> get max id then ++1</span>
  35.         Long hpMaxId = <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownService.getMaxIdOfHandProcess();
  36.         DateFormat df </span>= <span style="color: #0000ff;">new</span> SimpleDateFormat(<span style="color: #800000;">"</span><span style="color: #800000;">yyyy-MM-dd hh:mm:ss</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  37.         hp.setHandTime(df.parse(hp.getHandTimeStr()).getTime());
  38.         hp.setId(hpMaxId </span>+ <span style="color: #800080;">1</span><span style="color: #000000;">);
  39.         </span><span style="color: #008000;">//</span><span style="color: #008000;">保存处理过程</span>
  40.         Serializable hpId = <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownService.saveHandProcess(hp);
  41.         </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  42.          * 保存附件
  43.          </span><span style="color: #008000;">*/</span><span style="color: #000000;">
  44.         Annex annex </span>= <span style="color: #0000ff;">new</span><span style="color: #000000;"> Annex();
  45.         annex.setCustomerId(</span><span style="color: #800080;">1L</span><span style="color: #000000;">);
  46.         annex.setHandId((Long) hpId);
  47.         annex.setRealName(uploadFile1.getOriginalFilename());
  48.         annex.setFileContent(buffer);
  49.         </span><span style="color: #008000;">//</span><span style="color: #008000;">查找附件id最大值</span>
  50.         annex.setId(<span style="color: #0000ff;">this</span>.uploadDownService.getMaxIdOfAnnex() + <span style="color: #800080;">1</span><span style="color: #000000;">);
  51.         Serializable aid </span>= <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownService.saveAnnex(annex);
  52.         </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  53.          * 获取处理过程列表
  54.          </span><span style="color: #008000;">*/</span><span style="color: #000000;">
  55.         List</span><Map<String, Object>> <span style="color: #0000ff;">as</span> = <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownService
  56.                 .getHandProcessList();
  57.         </span><span style="color: #0000ff;">for</span> (Map<String, Object> map : <span style="color: #0000ff;">as</span><span style="color: #000000;">) {
  58.             map.put(</span><span style="color: #800000;">"</span><span style="color: #800000;">handTime</span><span style="color: #800000;">"</span>, df.format(map.<span style="color: #0000ff;">get</span>(<span style="color: #800000;">"</span><span style="color: #800000;">handTime</span><span style="color: #800000;">"</span><span style="color: #000000;">)));
  59.         }
  60.         request.setAttribute(</span><span style="color: #800000;">"</span><span style="color: #800000;">as</span><span style="color: #800000;">"</span>, <span style="color: #0000ff;">as</span><span style="color: #000000;">);
  61.         </span><span style="color: #0000ff;">return</span> <span style="color: #800000;">"</span><span style="color: #800000;">annex/annexList</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  62.     }
  63.     </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  64.      * 多文件上传
  65.      * @param hp   处理过程
  66.      * @param request
  67.      * @param uploadFile1   上传文件
  68.      * @return
  69.      * @throws IOException
  70.      * @throws ParseException
  71.      </span><span style="color: #008000;">*/</span><span style="color: #000000;">
  72.     @RequestMapping(</span><span style="color: #800000;">"</span><span style="color: #800000;">uploadOneMore</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  73.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> String uploadOneMore(HandProcess hp, HttpServletRequest request,
  74.             @RequestParam(</span><span style="color: #800000;">"</span><span style="color: #800000;">uploadFile1</span><span style="color: #800000;">"</span><span style="color: #000000;">) MultipartFile[] uploadFile1)
  75.             throws IOException, ParseException {
  76.         </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  77.          * 保存处理过程信息
  78.          </span><span style="color: #008000;">*/</span>
  79.         <span style="color: #008000;">//</span><span style="color: #008000;"> get max id then ++1</span>
  80.         Long hpMaxId = <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownService.getMaxIdOfHandProcess();
  81.         DateFormat df </span>= <span style="color: #0000ff;">new</span> SimpleDateFormat(<span style="color: #800000;">"</span><span style="color: #800000;">yyyy-MM-dd hh:mm:ss</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  82.         hp.setHandTime(df.parse(hp.getHandTimeStr()).getTime());
  83.         hp.setId(hpMaxId </span>+ <span style="color: #800080;">1</span><span style="color: #000000;">);
  84.         </span><span style="color: #008000;">//
  85. </span>        Serializable hpId = <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownService.saveHandProcess(hp);
  86.         </span><span style="color: #008000;">//</span><span style="color: #008000;">保存改工单下的所有附件</span>
  87.         <span style="color: #0000ff;">for</span> (<span style="color: #0000ff;">int</span> i = <span style="color: #800080;">0</span>; i < uploadFile1.length; i++<span style="color: #000000;">) {
  88.             InputStream </span><span style="color: #0000ff;">is</span> =<span style="color: #000000;"> uploadFile1[i].getInputStream();
  89.             </span><span style="color: #0000ff;">byte</span>[] buffer = <span style="color: #0000ff;">this</span>.inputStrean2ByteArr(<span style="color: #0000ff;">is</span><span style="color: #000000;">);
  90.             </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  91.              * 保存附件
  92.              </span><span style="color: #008000;">*/</span><span style="color: #000000;">
  93.             Annex annex </span>= <span style="color: #0000ff;">new</span><span style="color: #000000;"> Annex();
  94.             annex.setCustomerId(</span><span style="color: #800080;">1L</span><span style="color: #000000;">);
  95.             annex.setHandId((Long) hpId);
  96.             annex.setRealName(uploadFile1[i].getOriginalFilename());
  97.             annex.setFileContent(buffer);
  98.             annex.setId(</span><span style="color: #0000ff;">this</span>.uploadDownService.getMaxIdOfAnnex() + <span style="color: #800080;">1</span><span style="color: #000000;">);
  99.             Serializable annexId </span>= <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownService.saveAnnex(annex);
  100.             
  101.         }
  102.         </span><span style="color: #008000;">//</span><span style="color: #008000;">多文件上传，一个处理过程下面要有多个附件，在页面中显示的时候，一个处理过程后面要显示多个附件
  103.         </span><span style="color: #008000;">//</span><span style="color: #008000;">更新表handprocess</span>
  104.         <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownService.updateHandProcess(hp);
  105.         
  106.         List</span><Map<String, Object>> <span style="color: #0000ff;">as</span> = <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownService
  107.                 .getHandProcessList();
  108.         request.setAttribute(</span><span style="color: #800000;">"</span><span style="color: #800000;">as</span><span style="color: #800000;">"</span>, <span style="color: #0000ff;">as</span><span style="color: #000000;">);
  109.         </span><span style="color: #0000ff;">return</span> <span style="color: #800000;">"</span><span style="color: #800000;">annex/annexList</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  110.     }
  111.     
  112.     </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  113.      * 文件下载
  114.      * @param response
  115.      * @param annexId
  116.      * @throws IOException
  117.      </span><span style="color: #008000;">*/</span><span style="color: #000000;">
  118.     @RequestMapping(</span><span style="color: #800000;">"</span><span style="color: #800000;">download</span><span style="color: #800000;">"</span><span style="color: #000000;">)
  119.     </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> download(HttpServletResponse response, Long annexId)
  120.             throws IOException {
  121.         Annex a </span>= <span style="color: #0000ff;">this</span><span style="color: #000000;">.uploadDownService.getAnnexById(annexId);
  122.         </span><span style="color: #0000ff;">byte</span>[] b =<span style="color: #000000;"> a.getFileContent();
  123.         response.setContentType(</span><span style="color: #800000;">"</span><span style="color: #800000;">application/octet-stream;charset=UTF-8</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  124.         response.setCharacterEncoding(</span><span style="color: #800000;">"</span><span style="color: #800000;">utf-8</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  125.         response.setHeader(</span><span style="color: #800000;">"</span><span style="color: #800000;">Content-Disposition</span><span style="color: #800000;">"</span><span style="color: #000000;">,
  126.                 </span><span style="color: #800000;">"</span><span style="color: #800000;">attachment;filename=</span><span style="color: #800000;">"</span> + <span style="color: #0000ff;">new</span> String(a.getRealName().getBytes(<span style="color: #800000;">"</span><span style="color: #800000;">gbk</span><span style="color: #800000;">"</span>),<span style="color: #800000;">"</span><span style="color: #800000;">iso-8859-1</span><span style="color: #800000;">"</span>));  <span style="color: #008000;">//</span><span style="color: #008000;">防止文件乱码</span>
  127. <span style="color: #000000;">
  128.         BufferedOutputStream bos </span>= <span style="color: #0000ff;">new</span><span style="color: #000000;"> BufferedOutputStream(
  129.                 response.getOutputStream());
  130.         bos.write(b);
  131.         bos.close();
  132.     }
  133.     </span><span style="color: #008000;">/*</span><span style="color: #008000;">*
  134.      * inputstream转成byte数组
  135.      * @param inStream
  136.      * @return
  137.      * @throws IOException
  138.      </span><span style="color: #008000;">*/</span>
  139.     <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">byte</span><span style="color: #000000;">[] inputStrean2ByteArr(InputStream inStream) throws IOException {
  140.         ByteArrayOutputStream swapStream </span>= <span style="color: #0000ff;">new</span><span style="color: #000000;"> ByteArrayOutputStream();
  141.         </span><span style="color: #0000ff;">byte</span>[] buff = <span style="color: #0000ff;">new</span> <span style="color: #0000ff;">byte</span>[<span style="color: #800080;">100</span><span style="color: #000000;">];
  142.         </span><span style="color: #0000ff;">int</span> rc = <span style="color: #800080;">0</span><span style="color: #000000;">;
  143.         </span><span style="color: #0000ff;">while</span> ((rc = inStream.read(buff, <span style="color: #800080;">0</span>, <span style="color: #800080;">100</span>)) > <span style="color: #800080;">0</span><span style="color: #000000;">) {
  144.             swapStream.write(buff, </span><span style="color: #800080;">0</span><span style="color: #000000;">, rc);
  145.         }
  146.         </span><span style="color: #0000ff;">byte</span>[] in2b =<span style="color: #000000;"> swapStream.toByteArray();
  147.         </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> in2b;
  148.     }
  149. }</span>

main.jsp

  1. <%@ page language=<span style="color: #800000;">"</span><span style="color: #800000;">java</span><span style="color: #800000;">"</span> contentType=<span style="color: #800000;">"</span><span style="color: #800000;">text/html; charset=UTF-8</span><span style="color: #800000;">"</span><span style="color: #000000;">
  2.     pageEncoding</span>=<span style="color: #800000;">"</span><span style="color: #800000;">UTF-8</span><span style="color: #800000;">"</span>%>
  3.     <%@taglib prefix=<span style="color: #800000;">"</span><span style="color: #800000;">c</span><span style="color: #800000;">"</span> uri=<span style="color: #800000;">"</span><span style="color: #800000;">http://java.sun.com/jsp/jstl/core</span><span style="color: #800000;">"</span>%>
  4. <!DOCTYPE html PUBLIC <span style="color: #800000;">"</span><span style="color: #800000;">-//W3C//DTD HTML 4.01 Transitional//EN</span><span style="color: #800000;">"</span> <span style="color: #800000;">"</span><span style="color: #800000;">http://www.w3.org/TR/html4/loose.dtd</span><span style="color: #800000;">"</span>>
  5. <html>
  6. <head>
  7. <meta http-equiv=<span style="color: #800000;">"</span><span style="color: #800000;">Content-Type</span><span style="color: #800000;">"</span> content=<span style="color: #800000;">"</span><span style="color: #800000;">text/html; charset=UTF-8</span><span style="color: #800000;">"</span>>
  8. <title>Insert title here</title>
  9. <script type=<span style="color: #800000;">"</span><span style="color: #800000;">text/javascript</span><span style="color: #800000;">"</span> src=<span style="color: #800000;">"</span><span style="color: #800000;">${pageContext.request.contextPath }/resources/js/jquery-1.11.1.js</span><span style="color: #800000;">"</span>></script>
  10. </head>
  11. <body>
  12. <a href=<span style="color: #800000;">"</span><span style="color: #800000;">${pageContext.request.contextPath }/getAllStudent</span><span style="color: #800000;">"</span>>查找所有用户</a>
  13. <a href=<span style="color: #800000;">"</span><span style="color: #800000;">${pageContext.request.contextPath }/savePerson</span><span style="color: #800000;">"</span>>单独保存Person</a>
  14. <a href=<span style="color: #800000;">"</span><span style="color: #800000;">${pageContext.request.contextPath }/savePersonHouse</span><span style="color: #800000;">"</span>>保存Person和House</a>
  15. <br/>
  16. <form action=<span style="color: #800000;">"</span><span style="color: #800000;">${pageContext.request.contextPath }/getArr</span><span style="color: #800000;">"</span> >
  17.     <input type=<span style="color: #800000;">"</span><span style="color: #800000;">text</span><span style="color: #800000;">"</span> name=<span style="color: #800000;">"</span><span style="color: #800000;">workSheetId</span><span style="color: #800000;">"</span>/><br/>
  18.     <input type=<span style="color: #800000;">"</span><span style="color: #800000;">submit</span><span style="color: #800000;">"</span> value=<span style="color: #800000;">"</span><span style="color: #800000;">search</span><span style="color: #800000;">"</span>/>
  19. </form>
  20. <br/><br/><br/>  
  21. <form action=<span style="color: #800000;">"</span><span style="color: #800000;"><c:url value=</span><span style="color: #800000;">"</span>/upload<span style="color: #800000;">"</span><span style="color: #800000;">/></span><span style="color: #800000;">"</span> method=<span style="color: #800000;">"</span><span style="color: #800000;">post</span><span style="color: #800000;">"</span> enctype=<span style="color: #800000;">"</span><span style="color: #800000;">multipart/form-data</span><span style="color: #800000;">"</span>><span style="color: #000000;">
  22.     处理时间：</span><input type=<span style="color: #800000;">"</span><span style="color: #800000;">text</span><span style="color: #800000;">"</span> name=<span style="color: #800000;">"</span><span style="color: #800000;">handTimeStr</span><span style="color: #800000;">"</span>/><br><span style="color: #000000;">
  23.     处理人：</span><input type=<span style="color: #800000;">"</span><span style="color: #800000;">text</span><span style="color: #800000;">"</span> name=<span style="color: #800000;">"</span><span style="color: #800000;">handName</span><span style="color: #800000;">"</span>/><br/><span style="color: #000000;">
  24.     原因：</span><input type=<span style="color: #800000;">"</span><span style="color: #800000;">text</span><span style="color: #800000;">"</span> name=<span style="color: #800000;">"</span><span style="color: #800000;">reason</span><span style="color: #800000;">"</span>/><br/><span style="color: #000000;">
  25.     选择文件：</span><input type=<span style="color: #800000;">"</span><span style="color: #800000;">file</span><span style="color: #800000;">"</span> name=<span style="color: #800000;">"</span><span style="color: #800000;">uploadFile1</span><span style="color: #800000;">"</span>/><br/>
  26.     <input type=<span style="color: #800000;">"</span><span style="color: #800000;">submit</span><span style="color: #800000;">"</span> value=<span style="color: #800000;">"</span><span style="color: #800000;">submit</span><span style="color: #800000;">"</span>/>
  27. </form>
  28. <br/><span style="color: #000000;">
  29. upload one more
  30. </span><form action=<span style="color: #800000;">"</span><span style="color: #800000;"><c:url value=</span><span style="color: #800000;">"</span>/uploadOneMore<span style="color: #800000;">"</span><span style="color: #800000;">/></span><span style="color: #800000;">"</span> method=<span style="color: #800000;">"</span><span style="color: #800000;">post</span><span style="color: #800000;">"</span> enctype=<span style="color: #800000;">"</span><span style="color: #800000;">multipart/form-data</span><span style="color: #800000;">"</span>><span style="color: #000000;">
  31.     处理时间：</span><input type=<span style="color: #800000;">"</span><span style="color: #800000;">text</span><span style="color: #800000;">"</span> name=<span style="color: #800000;">"</span><span style="color: #800000;">handTimeStr</span><span style="color: #800000;">"</span>/><br><span style="color: #000000;">
  32.     处理人：</span><input type=<span style="color: #800000;">"</span><span style="color: #800000;">text</span><span style="color: #800000;">"</span> name=<span style="color: #800000;">"</span><span style="color: #800000;">handName</span><span style="color: #800000;">"</span>/><br/><span style="color: #000000;">
  33.     原因：</span><input type=<span style="color: #800000;">"</span><span style="color: #800000;">text</span><span style="color: #800000;">"</span> name=<span style="color: #800000;">"</span><span style="color: #800000;">reason</span><span style="color: #800000;">"</span>/><br/><span style="color: #000000;">
  34.     选择文件：</span><input type=<span style="color: #800000;">"</span><span style="color: #800000;">file</span><span style="color: #800000;">"</span> name=<span style="color: #800000;">"</span><span style="color: #800000;">uploadFile1</span><span style="color: #800000;">"</span>/><br/><span style="color: #000000;">
  35.     选择文件：</span><input type=<span style="color: #800000;">"</span><span style="color: #800000;">file</span><span style="color: #800000;">"</span> name=<span style="color: #800000;">"</span><span style="color: #800000;">uploadFile1</span><span style="color: #800000;">"</span>/><br/><span style="color: #000000;">
  36.     选择文件：</span><input type=<span style="color: #800000;">"</span><span style="color: #800000;">file</span><span style="color: #800000;">"</span> name=<span style="color: #800000;">"</span><span style="color: #800000;">uploadFile1</span><span style="color: #800000;">"</span>/><br/>
  37.     <input type=<span style="color: #800000;">"</span><span style="color: #800000;">submit</span><span style="color: #800000;">"</span> value=<span style="color: #800000;">"</span><span style="color: #800000;">submit</span><span style="color: #800000;">"</span>/>
  38. </form>
  39. </body>
  40. </html>

annexList.jsp  显示处理过程已经处理过程下附件

  1. <%@ page language=<span style="color: #800000;">"</span><span style="color: #800000;">java</span><span style="color: #800000;">"</span> contentType=<span style="color: #800000;">"</span><span style="color: #800000;">text/html; charset=UTF-8</span><span style="color: #800000;">"</span><span style="color: #000000;">
  2.     pageEncoding</span>=<span style="color: #800000;">"</span><span style="color: #800000;">UTF-8</span><span style="color: #800000;">"</span>%>
  3. <%@taglib prefix=<span style="color: #800000;">"</span><span style="color: #800000;">c</span><span style="color: #800000;">"</span> uri=<span style="color: #800000;">"</span><span style="color: #800000;">http://java.sun.com/jsp/jstl/core</span><span style="color: #800000;">"</span>%>
  4. <!DOCTYPE html PUBLIC <span style="color: #800000;">"</span><span style="color: #800000;">-//W3C//DTD HTML 4.01 Transitional//EN</span><span style="color: #800000;">"</span> <span style="color: #800000;">"</span><span style="color: #800000;">http://www.w3.org/TR/html4/loose.dtd</span><span style="color: #800000;">"</span>>
  5. <html>
  6. <head>
  7. <meta http-equiv=<span style="color: #800000;">"</span><span style="color: #800000;">Content-Type</span><span style="color: #800000;">"</span> content=<span style="color: #800000;">"</span><span style="color: #800000;">text/html; charset=UTF-8</span><span style="color: #800000;">"</span>>
  8. <title>Insert title here</title>
  9. <script type=<span style="color: #800000;">"</span><span style="color: #800000;">text/javascript</span><span style="color: #800000;">"</span><span style="color: #000000;">
  10.     src</span>=<span style="color: #800000;">"</span><span style="color: #800000;">${pageContext.request.contextPath }/resources/js/jquery-1.11.1.js</span><span style="color: #800000;">"</span>></script>
  11. </head>
  12. <body>
  13.     <table>
  14.         <c:forEach items=<span style="color: #800000;">"</span><span style="color: #800000;">${as }</span><span style="color: #800000;">"</span> <span style="color: #0000ff;">var</span>=<span style="color: #800000;">"</span><span style="color: #800000;">ah</span><span style="color: #800000;">"</span> varStatus=<span style="color: #800000;">"</span><span style="color: #800000;">status</span><span style="color: #800000;">"</span>>
  15.             <tr>
  16.                 <td>${ah[<span style="color: #800000;">‘</span><span style="color: #800000;">handprocessId</span><span style="color: #800000;">‘</span>] }</td>
  17.                 <td>${ah[<span style="color: #800000;">‘</span><span style="color: #800000;">handName</span><span style="color: #800000;">‘</span>] }</td>
  18.                 <td>${ah[<span style="color: #800000;">‘</span><span style="color: #800000;">reason</span><span style="color: #800000;">‘</span>] }</td>
  19.                 <td id=<span style="color: #800000;">"</span><span style="color: #800000;">id${status.index }</span><span style="color: #800000;">"</span>>${ah[<span style="color: #800000;">‘</span><span style="color: #800000;">handTime</span><span style="color: #800000;">‘</span>] }</td>
  20.                 
  21.                 <td><span style="color: #000000;">
  22.                     ${ah[</span><span style="color: #800000;">‘</span><span style="color: #800000;">annex</span><span style="color: #800000;">‘</span>][<span style="color: #800000;">‘</span><span style="color: #800000;">realName</span><span style="color: #800000;">‘</span><span style="color: #000000;">] }
  23.                     </span><a href=<span style="color: #800000;">"</span><span style="color: #800000;"><c:url value=</span><span style="color: #800000;">"</span>/download?annexId=${ah[<span style="color: #800000;">‘</span><span style="color: #800000;">annexId</span><span style="color: #800000;">‘</span>] }<span style="color: #800000;">"</span><span style="color: #800000;">/></span><span style="color: #800000;">"</span>>${ah[<span style="color: #800000;">‘</span><span style="color: #800000;">realName</span><span style="color: #800000;">‘</span>] }</a>
  24.                 </td>
  25.             </tr>
  26.         </c:forEach>
  27.     </table>
  28. </body>
  29. <script type=<span style="color: #800000;">"</span><span style="color: #800000;">text/javascript</span><span style="color: #800000;">"</span>>
  30.     
  31. </script>
  32. </html>

 

springMVC+spring+hibernate注解上传文件到数据库，下载，多文件上传

标签：

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！