perms = new ArrayList<>();
list.forEach(menu->{
perms.add(menu.getPerms());
});
return perms.indexOf(authorize) != -1;
}
}
```
通过在controller中添加权限注解实现验证权限
# 自定义指令
https://cn.vuejs.org/guide/reusability/custom-directives.html#function-shorthand
定义指令
# 上传头像
添加菜单
```sql
ALTER TABLE `menu`
CHANGE `icon` `icon` VARCHAR(100) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '菜单图标';
INSERT INTO `menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `QUERY`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `STATUS`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES('系统加载','0','0','',NULL,NULL,'','1','0','M','1','0','sys:user:profile','','',NULL,'',NULL,'');
SELECT @parentId := LAST_INSERT_ID();
INSERT INTO `menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `QUERY`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `STATUS`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES('用户设置', @parentId,'0','user_profile','profile/user_info',NULL,'','1','0','C','1','0','user:profile:page',NULL,'',NULL,'',NULL,'');
```
## 配置权限
## 编写页面
yyzx-vue/src/views/profile/user_info.vue
# 上传下载
## 设计一个上传信息的存储表
```sql
CREATE TABLE `file_info`(
`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
`origin_name` VARCHAR(200) COMMENT '原始文件名',
`path` VARCHAR(200) COMMENT '硬盘中的存储路径',
`ext` VARCHAR(10) COMMENT '扩展名',
`size` BIGINT COMMENT '存储大小',
`create_time` DATETIME COMMENT '上传时间',
`create_by` VARCHAR(100) COMMENT '上传的用户',
PRIMARY KEY (`id`)
) ENGINE=INNODB CHARSET=utf8mb4;
```
## 生成单表的CURD
FileInfo FileInfoMapper FileInfoService
```java
package com.neuedu.yyzx.mapper;
import com.neuedu.yyzx.po.FileInfo;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.util.Date;
import java.util.UUID;
import static org.junit.jupiter.api.Assertions.*;
/**
* @author 金山
* 项目：yyzx
* site: https://blog.fulfill.com.cn
* 描述
* @data 2025/4/2514:05
*/
@SpringBootTest
class FileInfoMapperTest {
@Autowired
FileInfoMapper fileInfoMapper;
@Test
public void test(){
FileInfo fileInfo = new FileInfo();
fileInfo.setOriginName("我的头像.png");
fileInfo.setExt("png");
fileInfo.setPath(UUID.randomUUID().toString()+ ".png");
fileInfo.setCreateTime(new Date());
fileInfo.setSize(1003685L);
int count = fileInfoMapper.insert(fileInfo);
System.out.println("count = " + count);
}
}
```
## 上传文件功能
添加依赖 用于解析request 对象中的 文件
````xml
commons-fileupload
commons-fileupload
1.5
````
```java
package com.neuedu.yyzx.controller;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
import java.io.File;
import java.io.IOException;
import java.util.UUID;
@RestController
public class FileUploadController {
private String UPLOAD_DIR = "D:\\upload";
/**
* http://localhost:8080/upload
* pic: xxxxxx
* @param pic
* @return
* @throws IOException
*/
@PostMapping("/upload")
String upload(MultipartFile pic) throws IOException {
// 1 将临时空间的文件，转储到 D:\\upload
String originalFileName = pic.getOriginalFilename();
// 扩展名
String ext = originalFileName.substring(originalFileName.lastIndexOf("."));
// 转储的新文件名
String newFileName = UUID.randomUUID().toString() + ext;
// 转储到 D:\\upload 下的 uuid.png/uuid.jpg
pic.transferTo(new File(UPLOAD_DIR, newFileName));
// 2 将数据存储到 db
/**
* 当前时间
* 上传的ip
* 操作的工号
* 上传的文件名
*
*/
// 3 跳转到列表页
return "newFileName:"+newFileName;
}
}
```
## 文件下载
```java
package com.neuedu.yyzx.controller;
import com.neuedu.yyzx.po.FileInfo;
import com.neuedu.yyzx.service.FileInfoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.core.io.FileSystemResource;
import org.springframework.http.HttpHeaders;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
import java.io.File;
import java.io.IOException;
import java.util.Date;
import java.util.UUID;
@RestController
public class FileUploadController {
@Autowired
FileInfoService fileInfoService;
private String UPLOAD_DIR = "D:\\upload";
/**
* http://localhost:8080/upload
* pic: xxxxxx
* @param pic
* @return
* @throws IOException
*/
@PostMapping("/upload")
FileInfo upload(MultipartFile pic) throws IOException {
// 1 将临时空间的文件，转储到 D:\\upload
String originalFileName = pic.getOriginalFilename();
// 扩展名
String ext = originalFileName.substring(originalFileName.lastIndexOf("."));
// 转储的新文件名
String newFileName = UUID.randomUUID().toString() + ext;
// 转储到 D:\\upload 下的 uuid.png/uuid.jpg
pic.transferTo(new File(UPLOAD_DIR, newFileName));
// 2 将数据存储到 db
/**
* 当前时间
* 上传的ip
* 操作的工号
* 上传的文件名
*
*/
FileInfo fileInfo = new FileInfo();
fileInfo.setOriginName(originalFileName);
fileInfo.setExt(ext);
fileInfo.setPath(newFileName);
fileInfo.setCreateTime(new Date());
fileInfo.setSize(pic.getSize());
boolean success = fileInfoService.save(fileInfo);
// 3 跳转到列表页
return fileInfo;
}
/**
* http://localhost:8080/downlod/3
* @param fid
* @return
* @throws IOException
*/
@GetMapping("/downlod/{fid}")
public ResponseEntity download2(@PathVariable Long fid ) throws IOException {
//根据文件ID 查询 完整登路径
FileInfo info = fileInfoService.getById(fid);
return ResponseEntity.ok().
header(HttpHeaders.CONTENT_TYPE, "application/octet-stream").
header(HttpHeaders.CONTENT_DISPOSITION, "attachment;filename=" + info.getOriginName()).
body(new FileSystemResource(new File(UPLOAD_DIR, info.getPath())));
}
}
```
测试的时候记得在拦截器的配置中放开，因为暂时没有登录
```java
package com.neuedu.yyzx.config;
import com.neuedu.yyzx.interceptor.LoginInterceptor;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.CorsRegistry;
import org.springframework.web.servlet.config.annotation.InterceptorRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
@Configuration
// @EnableWebMvc
public class WebConfig implements WebMvcConfigurer {
@Autowired
private LoginInterceptor loginInterceptor;
/**
* 设置允许跨域
*
* @param registry
*/
@Override
public void addCorsMappings(CorsRegistry registry) {
registry.addMapping("/*/**")
.allowedOrigins("*")
.allowedMethods("*")
.maxAge(3600);
// Add more mappings...
}
@Override
public void addInterceptors(InterceptorRegistry registry) {
registry.addInterceptor(loginInterceptor)
.addPathPatterns("/**") // 大部分是需要 拦截
.excludePathPatterns(
"/upload",
"/downlod/**",
"/login",
"/*.html", "/**/*.html", "/**/*.css", "/**/*.js", "/profile/**", "/v3/api-docs/*",
"/swagger-ui.html", "/swagger-resources/**", "/webjars/**", "/*/api-docs/*"
); // 例外的
}
}
```
### 添加头像地址字段
```sql
ALTER TABLE `user`
ADD COLUMN `avatar` VARCHAR(500) NULL COMMENT '上传头像(文件ID)' AFTER `is_delete`;
```