前言
我相信我们在日常开发中,难免会遇到对各种媒体文件的操作,由于业务需求的不同对文件操作的代码实现也大不相同
数据库设计
/*
Navicat Premium Data Transfer
Source Server : MySQL 5.5
Source Server Type : MySQL
Source Server Version : 50554 (5.5.54)
Source Host : localhost:3306
Source Schema : tgadmin
Target Server Type : MySQL
Target Server Version : 50554 (5.5.54)
File Encoding : 65001
Date: 20/06/2023 03:07:47
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文件id',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名',
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件类型',
`size` bigint(20) NULL DEFAULT NULL COMMENT '文件大小(kb)',
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问路径',
`location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件地址',
`download` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '下载地址',
`md5` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件md5',
`is_Delete` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除 0:未删除 1:删除',
`enable` tinyint(1) NULL DEFAULT 1 COMMENT '是否禁用链接 1:可用 0:禁用用',
`upload_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上传时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uni_md5`(`md5`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 64 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件表' ROW_FORMAT = Compact;
SET FOREIGN_KEY_CHECKS = 1;
yaml配置我们的上传路径
# 文件上传配置
files:
ip: localhost
upload:
location: file:F:/项目/SpringBoot+vue/tg-admin/server/files/
path: /img/**
上传
maven配置
<!-- hutool-->
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-all</artifactId>
<version>5.8.15</version>
</dependency>
<!-- MybatisPlus-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.2</version>
</dependency>
文件类
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.io.Serializable;
import java.sql.Timestamp;
/**
* @Program: admin
* @ClassName File
* @Author: liutao
* @Description: 文件
* @Create: 2023-03-16 18:51
* @Version 1.0
**/
@Data
@TableName("sys_file")
@AllArgsConstructor
@NoArgsConstructor
@ApiModel("文件表")
public class Files implements Serializable {
private static final long serialVersionUID = 1L;
@ApiModelProperty("文件id")
@TableId(type = IdType.AUTO)
private Integer id;
@ApiModelProperty("文件名称")
private String name;
@ApiModelProperty("文件类型")
private String type;
@ApiModelProperty("文件大小")
private Long size;
@ApiModelProperty("文件地址")
private String location;
@ApiModelProperty("访问url")
private String url;
@ApiModelProperty("开启状态")
private String download;
@ApiModelProperty("是否删除")
private Boolean isDelete;
@ApiModelProperty("文件md5")
private String md5;
@ApiModelProperty("开启状态")
private Boolean enable;
@ApiModelProperty("上传时间")
private Timestamp uploadTime;
}
文件接口 文章来源:https://www.toymoban.com/news/detail-783268.html
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.io.FileUtil;
import cn.hutool.core.util.IdUtil;
import cn.hutool.core.util.StrUtil;
import cn.hutool.crypto.SecureUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.tg.admin.common.Result;
import com.tg.admin.entity.Files;
import com.tg.admin.entity.User;
import com.tg.admin.service.FileService;
import com.tg.admin.utils.JwtUtil;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.List;
/**
* @Program: admin
* @ClassName: FileController
* @Author: liutao
* @Description: 文件处理
* @Create: 2023-03-16 18:15
* @Version 1.0
**/
@Api(tags = "文件接口")
@RestController
@RequestMapping("/file")
public class FileController {
private static final Logger log = LoggerFactory.getLogger(FileController.class);
@Value("${files.ip}")
private String ip;
@Value("${server.port}")
private String port;
@Value("${files.upload.path}")
private String path;
@Value("${files.upload.location}")
private String fileUploadPath;
@Autowired
private FileService fileService;
@ApiOperation("分页查询所有文件信息")
@GetMapping("/page")
public Result<Files> findPage(@RequestParam Integer pageNum,
@RequestParam Integer pageSize,
@RequestParam String name,
@RequestParam String type) {
IPage<Files> page = new Page<>(pageNum, pageSize);
QueryWrapper<Files> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("is_Delete", false);
if (!"".equals(name)) {
queryWrapper.like("name", name);
}
if (!"".equals(type)) {
queryWrapper.like("type", type);
}
User currentUser = JwtUtil.getCurrentUser();
log.info("当前用户------{}", currentUser);
return Result.success(fileService.page(page, queryWrapper));
}
@ApiOperation("根据id删除文件")
@DeleteMapping("/{id}")
public Result<Files> delete(@PathVariable Integer id) {
Files files = fileService.getById(id);
files.setIsDelete(true);
fileService.updateById(files);
return Result.success();
}
@ApiOperation("根据id批量删除文件")
@PostMapping("del/batch")
public Result<Files> deleteBatch(@RequestBody List<Integer> ids) {
QueryWrapper<Files> queryWrapper = new QueryWrapper<Files>();
queryWrapper.in("id", ids);
List<Files> files = fileService.list(queryWrapper);
files.forEach(file -> {
file.setIsDelete(true);
fileService.updateById(file);
});
return Result.success();
}
@ApiOperation(value = "更新或新增", httpMethod = "POST")
@PostMapping("/update")
public Result<Files> save(@RequestBody Files files) {
return Result.success(fileService.saveOrUpdate(files));
}
/**
* @MethodName: upload
* @description: 文件上传
* @Author: LiuTao
* @Param: [file]
* @UpdateTime: 2023/3/16 18:39
* @Return: java.lang.String
* @Throw: IOException
**/
@ApiOperation("上传文件接口")
@PostMapping("/upload")
public Result<Files> upload(@RequestParam MultipartFile file,
HttpServletRequest request) throws IOException {
// 文件原始名
String originalFilename = file.getOriginalFilename();
// 文件类型
String type = FileUtil.extName(originalFilename);
// 文件大小
long size = file.getSize();
String today = DateUtil.today().replace("-", "/");
// 定义一个文件唯一的标识码
String fileUUID = IdUtil.fastSimpleUUID() + StrUtil.DOT + type;
// 下载地址
String download = request.getScheme() + "://" + ip + ":" + port + "/file/" + fileUUID;
// 重命名文件
fileUploadPath = fileUploadPath.replace("file:", "");
path = path.replace("**", "") + today + StrUtil.C_SLASH;
// 判断目录是否存在。不存在就创建
if (!FileUtil.exist(fileUploadPath + today)) {
FileUtil.mkdir(fileUploadPath + today);
}
// 上传的文件
File uploadFile = new File(fileUploadPath + today + StrUtil.C_SLASH + fileUUID);
System.out.println(fileUploadPath);
// 文件存入磁盘
file.transferTo(uploadFile);
// 获取文件md5
String md5 = SecureUtil.md5(uploadFile);
// 查询数据库有没有当前md5
Files one = getFileMd5(md5);
String url;
if (one != null) {
uploadFile.delete();
return Result.waring("文件重复", one.getUrl());
} else {
url = request.getScheme() + "://" + ip + ":" + port + path + fileUUID;
}
// 存入数据库
Files saveFile = new Files();
saveFile.setName(originalFilename);
saveFile.setType(type);
saveFile.setSize(size / 1024);
saveFile.setLocation(uploadFile.getCanonicalPath());
saveFile.setUrl(url);
saveFile.setDownload(download);
saveFile.setMd5(md5);
fileService.save(saveFile);
return Result.success(url);
}
@ApiOperation("下载文件接口")
@GetMapping("/{fileUUID}")
public void download(@PathVariable String fileUUID,
HttpServletResponse response) throws IOException {
Files one = fileService
.lambdaQuery()
.like(Files::getLocation, fileUUID)
.one();
File uploadFile = new File(one.getLocation());
ServletOutputStream outputStream = response.getOutputStream();
response.addHeader("Content-Disposition", "attachment;filename =" + URLEncoder.encode(fileUUID, "UTF-8"));
response.setContentType("application/octet-stream");
byte[] bytes = FileUtil.readBytes(uploadFile);
outputStream.write(bytes);
outputStream.flush();
outputStream.close();
}
private Files getFileMd5(String md5) {
QueryWrapper<Files> wrapper = new QueryWrapper<>();
wrapper.eq("md5", md5);
List<Files> list = fileService.list(wrapper);
return list.size() == 0 ? null : list.get(0);
}
}
配置静态资源映射文章来源地址https://www.toymoban.com/news/detail-783268.html
@Value("${files.upload.path}")
private String filePath;
@Value("${files.upload.location}")
private String fileLocation;
@Override
public void addResourceHandlers(ResourceHandlerRegistry registry) {
//注册配置类,使用addResourceHandlers方法,将本地路径fileLocation映射到filePath路由上。
registry.addResourceHandler(filePath).addResourceLocations(fileLocation);
WebMvcConfigurer.super.addResourceHandlers(registry);
}
到了这里,关于SpringBoot整合Hutool实现文件上传下载的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!