本次案例用的是IDEA创建的maven的web项目
文件上传是客户端到服务器,文件下载是服务器输出给客户端
步骤一:在pom.xml文件中导入依赖
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.7</maven.compiler.source>
<maven.compiler.target>1.7</maven.compiler.target>
<springversion>5.0.8.RELEASE</springversion>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<!-- 加入ServletAPI --><!--从此处下面,依赖权威重点,上面一个依赖是自带的-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<!-- MySQL依赖 start -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- 加入MyBatis 依赖 start -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.2.8</version>
</dependency>
<!-- 引入Spring(包含SpringMVC) 依赖 start -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${springversion}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${springversion}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-oxm</artifactId>
<version>${springversion}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${springversion}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${springversion}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${springversion}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${springversion}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${springversion}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${springversion}</version>
</dependency>
<!-- 引用c3p0 依赖 start
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.2.1</version>
</dependency>
-->
<!-- 引用插件依赖:MyBatis整合Spring,如果mybatis版本在3.4及以上版本
mybatis-spring的版本要在1.3以上 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<!-- JSTL -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- 德鲁伊数据连接池 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.9</version>
</dependency>
<!-- pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>4.1.6</version>
</dependency>
<!--处理json-->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.5</version>
</dependency>
<!--导出excel-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.6</version>
</dependency>
<!--javaee-->
<dependency>
<groupId>javax</groupId>
<artifactId>javaee-api</artifactId>
<version>7.0</version>
<scope>provided</scope>
</dependency>
<!--文件上传下载-->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
<dependency>
<groupId>joda-time</groupId>
<artifactId>joda-time</artifactId>
<version>2.9.9</version>
</dependency>
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.5</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.5</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.12</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.6</version>
</dependency>
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-io/commons-io -->
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
</dependencies>
重点关注最后两个依赖,即commons-fileupload上传,commons-io以流的形式读取下载
步骤二:配置WEB-INF下的web.xml文件,用如下代码将原内容覆盖
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5"><!--头部信息换成2.5的,不然下面的某些东西可能无发生效-->
<!--没有web.xml文件,controller的请求地址都不能生效。因为需要在这当中读取xml配置文件-->
<display-name>Archetype Created Web Application</display-name>
<!--利用DispatcherServlet核心类加载spring.xml配置文件-->
<servlet>
<servlet-name>aa</servlet-name><!--与servlet-mapping中的servlet-name要保持一致-->
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>aa</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!--处理post乱码,设置字符集-->
<filter>
<filter-name>bb</filter-name><!--与下面的filter-mapping中的filter-name一致-->
<filter-class>
org.springframework.web.filter.CharacterEncodingFilter
</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>bb</filter-name>
<url-pattern>/*</url-pattern><!--给所有文件设置字符集-->
</filter-mapping>
</web-app>
步骤三:在resources下创建mybatis-config.xml文件(也可以不用创建,个人习惯)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--给类起别名-->
<!--<typeAliases>
<!–<typeAlias type="com.entity.Student" alias="abc"></typeAlias>–>
<package name="com.qf.entity"></package>
</typeAliases>-->
<plugins>
<plugin interceptor="com.github.pagehelper.PageHelper">
<property name="dialect" value="mysql"/>
</plugin>
</plugins>
</configuration>
步骤四:在resources文件夹下创建spring.xml,配置扫描注解的xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!--加p、tx、mvc、context命名空间-->
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!--连接数据库,即创建数据库连接对象-->
<bean id="db" class="com.alibaba.druid.pool.DruidDataSource"><!--druid连接池包路径,其他两个连接池路径自己不知道可以网上找找。找到评论留言,分享给其他人吧-->
<property name="username" value="root"></property><!--你连接的数据库的用户名-->
<property name="password" value="root"></property><!--连接的数据库的密码-->
<property name="url" value="jdbc:mysql://localhost:3306/buy"></property><!--连接的数据库的地址,此处的数据库名叫hospital-->
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property><!--根据使用的数据库连接池以及数据库,找对应的连接池,三种连接池,druid,c3p0,dbcp。去百度吧。此处用的druid连接池和myql数据库-->
</bean>
<!--用context命名空间扫描注解包-->
<context:component-scan base-package="com"><!--扫描com包下的所有注解,这个com包是我们自定义的,我们创建的所有java类都放在该包下面,具体可见最下面的案例框架图的com包的位置--></context:component-scan>
<!--创建InternalResourceViewResolver视图解析器,注意下面这四行,尤其是前后缀的这两行会影响你在跳转页面的前后缀名,如return "/index.jsp",在使用这两句前后缀语句后,只需return "index"即可-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/"></property> <!--给return跳转页面时加前缀-->
<property name="suffix" value=".jsp"></property><!--加后缀-->
</bean>
<!--用MVC命名空间加注解驱动-->
<mvc:annotation-driven></mvc:annotation-driven>
<!--创建sqlsesion工厂,专门读取xml文件的-->
<bean id="factory" class="org.mybatis.spring.SqlSessionFactoryBean"><!--org.mybatis.spring.SqlSessionFactoryBean整合了mybatis和sring中的sqlsession-->
<property name="dataSource" ref="db"></property><!--将数据库连接赋进dataSource属性中-->
<property name="configLocation" value="classpath:mybatis-config.xml"></property><!--加载mybatis-config.xml配置文件-->
</bean>
<!--使用dao层实现类的时候,需要得到sqlSessionTemplate对象
<bean class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="factory"></constructor-arg><!–将上面创建好的sqlsesion对象当成SqlSessionTemplate类的一个构造参数–>
</bean>-->
<!--6.省略dao实现类,扫描dao层的接口--><!--在上传文件的案例中这里少了一个扫描mapper文件sql语句的一段-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.qf.dao"></property>
<property name="sqlSessionFactoryBeanName" value="factory" ></property>
</bean>
<bean id="tx" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="db"></property>
</bean>
<tx:advice id="ad" transaction-manager="tx" ></tx:advice><!--id必须起个名字-->
<!--8.配置静态资源-->
<mvc:default-servlet-handler></mvc:default-servlet-handler>
<!--文件上传的对象,必须创建这个对象,controller才不会报错,文件上传的重要步骤。注意:对象id名必须是multipartResolver-->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver" p:defaultEncoding="utf-8" p:maxUploadSize="9999999">
</bean>
</beans>
步骤五:创建下载的处理类
该案例将该类命名为:DownloadFile
package com.qf.controller;
import org.apache.commons.io.FileUtils;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.IOException;
import java.io.PrintWriter;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
@Controller
public class DownloadFile {
@RequestMapping("/download")
public ResponseEntity<byte[]> down(String filename, HttpServletRequest request,HttpServletResponse response){//filename是页面传过来的要下载的文件的文件名
//转换成服务器路径
String realPath = request.getRealPath("/uploadfile");//真实路径
System.out.println("realPath:"+realPath);//运行时结果:realPath:C:\Users\Administrator\Desktop\专门接受\springboot项目(1014)\springbootapp1015\示例代码1015更新2\download\target\download\uploadfile
String filepath=realPath+"/"+filename;//也就是文件夹路径加文件名来下载对应的文件
File f=new File(filepath);
//创建头信息的工具类
HttpHeaders httpHeaders=new HttpHeaders();
httpHeaders.setContentType(MediaType.APPLICATION_OCTET_STREAM);//设置响应的类型为流的类型
try {
httpHeaders.setContentDispositionFormData("attachment", URLEncoder.encode(filename,"utf-8")); //设置以弹窗的方式提示用户下载;attachment为固定值;URLEncoder设置编码方式
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
ResponseEntity<byte[]> file= null;//为什么用byte[]?用byte[]表示我们以字节来读取
try {
file = new ResponseEntity<byte[]>(FileUtils.readFileToByteArray(f),httpHeaders, HttpStatus.CREATED);
} catch (IOException e) {
e.printStackTrace();
}
return file;//一定要有此返回,不然下载不到文件
}
}
步骤六:在webapp中创建存放要下载的文件夹,本案例将该文件夹命名为:uploadfile
uploadfile存放要下载的东西,在项目运行前先在该文件中存放好下载的资源
步骤七:本次案例用到的页面
本案例将该案例命名为:download.jsp
<%@page pageEncoding="UTF-8" contentType="text/html; charset=utf-8" language="java" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<script type="text/javascript" src="Js/jquery.js"></script>
</head>
<body>
文件名:<input type="text" id="filename">
<input type="button" id="download" value="下载">
<script>
var download = document.getElementById("download");
var filename = document.getElementById("filename");
var f = filename.value;
download.onclick=function () {
location.href="/download?filename="+$("input[id=filename]").val()
alert($("input[id=filename]").val())
}
</script>
</body>
</html>
注意事项:该jsp页面由于由el表达式,weile使其生效,必须导入jquery.js文件
本次案例结构图: