SpringBoot项目知识点1
本文系学习瑞吉外卖项目,记录一个单体项目运用到的后端知识点。
1. 项目创建三部曲
1.1 Pom文件
集成了以下组件:
- SpringBoot2.4.5
- MyBatis-Plus 3.4.2
- lombok 1.18.20
- fastjson 2.0.26
- MySQL驱动包
- 数据库连接池(druid)
- 阿里短消息发送插件
- redis
- 增强版swagger(knife4j)
<?xml version="1.0" encoding="UTF-8"?>
<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.guigutool</groupId>
<artifactId>reggie</artifactId>
<version>1.0-SNAPSHOT</version>
<parent>
<artifactId>spring-boot-starter-parent</artifactId>
<groupId>org.springframework.boot</groupId>
<version>2.4.5</version>
</parent>
<properties>
<java.version>1.8</java.version>
<jackson.version>2.12.7</jackson.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<scope>compile</scope>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.2</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.20</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>2.0.26</version>
</dependency>
<dependency>
<groupId>commons-lang</groupId>
<artifactId>commons-lang</artifactId>
<version>2.6</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.23</version>
</dependency>
<dependency>
<groupId>com.aliyun</groupId>
<artifactId>aliyun-java-sdk-core</artifactId>
<version>4.5.16</version>
</dependency>
<dependency>
<groupId>com.aliyun</groupId>
<artifactId>aliyun-java-sdk-dysmsapi</artifactId>
<version>2.1.0</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-redis</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-cache</artifactId>
</dependency>
<!-- spring2.x集成redis依赖common-pool-->
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-pool2</artifactId>
<!--不要带版本号,防止冲突-->
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>${jackson.version}</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>${jackson.version}</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.module</groupId>
<artifactId>jackson-module-jaxb-annotations</artifactId>
<version>${jackson.version}</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>${jackson.version}</version>
</dependency>
<!-- 增强swagger-->
<dependency>
<groupId>com.github.xiaoymin</groupId>
<artifactId>knife4j-spring-boot-starter</artifactId>
<version>3.0.3</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<version>2.4.5</version>
</plugin>
</plugins>
</build>
</project>
1.2 yml配置
TODO:可以添加springboot配置说明
驼峰命名映射开启:
mybatis-plus:
configuration:
#在映射实体或者属性时,将数据库中表名和字段名中的下划线去掉,按照驼峰命名法映射
map-underscore-to-camel-case: true
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
完整的配置如下:
server:
port: 8080
spring:
application:
name: reggie
datasource:
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/reggie?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
username: root
password: root
redis:
host: 127.0.0.1
port: 6379
database: 0
cache:
redis:
time-to-live: 1800000 #缓存有效期
mybatis-plus:
configuration:
#在映射实体或者属性时,将数据库中表名和字段名中的下划线去掉,按照驼峰命名法映射
map-underscore-to-camel-case: true
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
global-config:
db-config:
id-type: ASSIGN_ID
reggie:
upload:
path: d:\\tmp\\pic\\
1.3 启动类
@Slf4j
@EnableCaching
@SpringBootApplication
@EnableTransactionManagement
public class ReggieApplication {
public static void main(String[] args) {
SpringApplication.run(ReggieApplication.class,args);
log.info("项目启动成功");
}
}
@Slf4j 日志注解
@EnableCaching 开启缓存
@EnableTransactionManagement 开启事务
@SpringBootApplication 默认SpringBoot启动
2.配置文件(Config文件夹下WebMvcConfig)
2.1 静态资源配置
默认静态资源需要放到static或者template文件夹下,如果我们需要自定指定文件夹,则需要自己手工配置访问静态资源的权限。
文件的结构如下:
@Configuration
public class WebMvcConfig extends WebMvcConfigurationSupport{
@Override
protected void addResourceHandlers(ResourceHandlerRegistry registry) {
log.info("开始静态资源映射..");
registry.addResourceHandler("/backend/**").addResourceLocations("classpath:/backend/");
registry.addResourceHandler("/front/**").addResourceLocations("classpath:/front/");
}
}
2.2 配置消息转换器
/**
* 扩展mvc框架的消息转换器
* @param converters
*/
@Override
protected void extendMessageConverters(List<HttpMessageConverter<?>> converters) {
log.info("扩展消息转换器...");
//创建消息转换器对象
MappingJackson2HttpMessageConverter messageConverter = new MappingJackson2HttpMessageConverter();
//设置对象转换器,底层使用Jackson将java对象转为Json
messageConverter.setObjectMapper(new JacksonObjectMapper());
//将上面的消息转换器对象追加到mvc框架的转换器容器中
converters.add(0, messageConverter);
}
2.3 完整配置
/**
* @Author: KingWang
* @Date: 2023/3/7
* @Desc:
**/
@Slf4j
@Configuration
@EnableSwagger2
@EnableKnife4j
public class WebMvcConfig extends WebMvcConfigurationSupport {
@Override
protected void addResourceHandlers(ResourceHandlerRegistry registry) {
log.info("开始静态资源映射..");
registry.addResourceHandler("/backend/**").addResourceLocations("classpath:/backend/");
registry.addResourceHandler("/front/**").addResourceLocations("classpath:/front/");
//swagger文档需要添加下面2行
registry.addResourceHandler("/doc.html").addResourceLocations("classpath:/META-INF/resources/");
registry.addResourceHandler("/webjars/**").addResourceLocations("classpath:/META-INF/resources/webjars/");
}
/**
* 扩展mvc框架的消息转换器
* @param converters
*/
@Override
protected void extendMessageConverters(List<HttpMessageConverter<?>> converters) {
log.info("扩展消息转换器...");
//创建消息转换器对象
MappingJackson2HttpMessageConverter messageConverter = new MappingJackson2HttpMessageConverter();
//设置对象转换器,底层使用Jackson将java对象转为Json
messageConverter.setObjectMapper(new JacksonObjectMapper());
//将上面的消息转换器对象追加到mvc框架的转换器容器中
converters.add(0, messageConverter);
}
@Bean
public Docket createRestApi(){
return new Docket(DocumentationType.SWAGGER_2)
.apiInfo(apiInfo())
.select()
.apis(RequestHandlerSelectors.basePackage("com.guigutool.reggie.controller"))
.paths(PathSelectors.any())
.build();
}
public ApiInfo apiInfo(){
return new ApiInfoBuilder()
.title("瑞吉外卖")
.version("1.0")
.description("瑞吉外卖接口文档")
.build();
}
}
3. 项目分层举例
3.1 Mapper
@Mapper
public interface UserMapper extends BaseMapper<User> {
}
3.2 Service
接口:
public interface UserService extends IService<User> {
}
实现类:
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
}
3.3 Controller
@Slf4j
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@Autowired
private RedisTemplate redisTemplate;
@PostMapping("/sendMsg")
public R<String> sendMsg(@RequestBody User user, HttpSession session){
//获取手机号
String phone = user.getPhone();
if(StringUtils.isNotEmpty(phone)){
//生成随机的4位验证吗
String code = ValidateCodeUtils.generateValidateCode(4).toString();
log.info("code:{}", code);
//调用阿里云提供的短信API完成发送短信
// SMSUtils.sendMessage("reggie","",phone,code);
//需要将生成的验证码保存到Session
// session.setAttribute(phone,code);
//将生成的验证码保存到Session中,并且设置有效期为5分钟
redisTemplate.opsForValue().set(phone,code,5, TimeUnit.MINUTES);
return R.success("发送成功,验证码是:" + code);
}
return R.error("验证码发送失败");
}
/**
* 移动端用户登录
* @param map
* @param session
* @return
*/
@PostMapping("/login")
public R<User> login(@RequestBody Map map, HttpSession session){
String phone = map.get("phone").toString();
String code = map.get("code").toString();
// Object codeInSession = session.getAttribute(phone);
//从redis中获取缓存的验证码
Object codeInSession = redisTemplate.opsForValue().get(phone);
if(Objects.nonNull(codeInSession) && codeInSession.equals(code)){
LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.eq(User::getPhone,phone);
User user = userService.getOne(queryWrapper);
if(Objects.isNull(user)){
user = new User();
user.setPhone(phone);
user.setStatus(1);
userService.save(user);
}
//登录成功
session.setAttribute(SystemConstant.MOBILE_USER_ID,user.getId());
//如果用户登录成功,则删除Redis中缓存的验证码
redisTemplate.delete(phone);
return R.success(user);
}
return R.error("登录失败");
}
}
4. 登录与退出
4.1 登录流程
处理逻辑:
(1) 将页面提交的密码进行md5加密
(2) 根据页面提交的用户名查询数据库
(3) 如果没有查询到,返回登录失败
(4) 如果查询到,密码比对,如果不一致返回登录失败结果
(5) 查看员工状态,如果为已禁用状态,则返回员工已禁用消息
(6) 登录成功,将员工id存入session,并返回登录成功结果
/**
* 员工登录
* @param request
* @param employee
* @return
*/
@PostMapping("/login")
public R<Employee> login(HttpServletRequest request, @RequestBody Employee employee){
//1.将前端传过来的密码通过MD5方式加密,
//2.查询数据库,该用户名是否存在
//3.如果不存在,则返回错误
//4.如果存在则,则比对密码是否一致,如果不一致,则返回错误,如果一致
//5. 如果一致,则查看用户状态是否已禁用,如果为禁用,则返回禁用结果。
//6. 如果都通过,则登录成功,将用户Id存入Session,并返回登录成功结果。
//1.将前端传过来的密码通过MD5方式加密,
String password = employee.getPassword();
password = DigestUtils.md5DigestAsHex(password.getBytes());
//2.查询数据库,该用户名是否存在
LambdaQueryWrapper<Employee> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.eq(Employee::getUsername,employee.getUsername());
Employee emp = employeeService.getOne(queryWrapper);
//3.如果不存在,则返回错误
if(Objects.isNull(emp)){
return R.error("登录失败");
}
//4.如果存在则,则比对密码是否一致,如果不一致,则返回错误,如果一致
if(!emp.getPassword().equals(password)){
return R.error("用户名和密码错误");
}
//5. 如果一致,则查看用户状态是否已禁用,如果为禁用,则返回禁用结果。
if(emp.getStatus() == 0){
return R.error("账号已经禁用");
}
//6. 如果都通过,则登录成功,将用户Id存入Session,并返回登录成功结果。
request.getSession().setAttribute(SystemConstant.SESSION_USER_ID,emp.getId());
return R.success(emp);
}
4.2 退出流程
处理逻辑:
(1) 清理session中的用户Id
(2) 返回结果
/**
* 员工退出
* @param request
* @return
*/
@PostMapping("/logout")
public R<String> logout(HttpServletRequest request){
request.getSession().removeAttribute(SystemConstant.SESSION_USER_ID);
return R.success("退出成功");
}
5. 增删改查
5.1 新增@PostMapping
/**
* 新增员工
* @param employee
* @return
*/
@PostMapping
public R<String> save(HttpServletRequest request, @RequestBody Employee employee){
log.info("新增员工,员工信息:{}",employee.toString());
//设置初始密码123456,需要进行md5加密处理
employee.setPassword(DigestUtils.md5DigestAsHex(SystemConstant.INIT_PASSWORD.getBytes()));
// employee.setCreateTime(LocalDateTime.now());
// employee.setUpdateTime(LocalDateTime.now());
//获取当前登录用户Id
Long currentUserId = (Long) request.getSession().getAttribute(SystemConstant.SESSION_USER_ID);
// employee.setCreateUser(currentUserId);
// employee.setUpdateUser(currentUserId);
employeeService.save(employee);
return R.success("新增员工成功");
}
5.2 修改@PutMapping
/**
* 根据Id修改员工信息
* @param employee
* @return
*/
@PutMapping
public R<String> update(HttpServletRequest request,@RequestBody Employee employee){
log.info(employee.toString());
long id = Thread.currentThread().getId();
log.info("线程id为:{}", id);
Long employeeId = (Long) request.getSession().getAttribute(SystemConstant.SESSION_USER_ID);
employee.setUpdateUser(employeeId);
employee.setUpdateTime(LocalDateTime.now());
employeeService.updateById(employee);
return R.success("员工信息修改成功");
}
5.3 查询@GetMapping
@GetMapping("/{id}")
public R<Employee> getById(@PathVariable Long id){
log.info("根据id查询");
Employee employee = employeeService.getById(id);
if(Objects.nonNull(employee)){
return R.success(employee);
}
return R.error("没有查询到对应员工信息");
}
5.4 删除@DeleteMapping
@DeleteMapping
public R<String> delete(@RequestParam List<String> ids){
log.info("delete ids: {}",ids);
setmealService.removeWithDish(ids);
return R.success("套餐删除成功");
}
6. 事务开启
对于一个接口中有多个服务都和数据库执行了相关操作,为了保证一致性,必须使用事务。
(1) @EnableTransactionManagement 添加注解开启事务
@Slf4j
@EnableCaching
@SpringBootApplication
@EnableTransactionManagement
public class ReggieApplication {
public static void main(String[] args) {
SpringApplication.run(ReggieApplication.class,args);
log.info("项目启动成功");
}
}
(2) 在service中使用事务注解@Transactional
@Transactional
@Override
public void updateWithFlavor(DishDto dishDto) {
//保存菜品的基本信息到菜品表dish
this.updateById(dishDto);
Long dishId = dishDto.getId(); //菜品id
//先清理dish_flavor表中记录
LambdaQueryWrapper<DishFlavor> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.eq(DishFlavor::getDishId, dishId);
dishFlavorService.remove(queryWrapper);
//再保存菜品的口味数据到菜品口味表dish_flavor中
List<DishFlavor> dishFlavors = dishDto.getFlavors().stream().map(x -> {
x.setDishId(dishId);
return x;
}).collect(Collectors.toList());
dishFlavorService.saveBatch(dishFlavors);
String key = "dish:" + dishDto.getCategoryId();
redisTemplate.delete(key);
}
7. 文件的下载
7.1 前端样例
<div class="container">
<el-upload class="avatar-uploader"
action="/common/upload"
:show-file-list="false"
:on-success="handleAvatarSuccess"
:before-upload="beforeUpload"
ref="upload">
<img v-if="imageUrl" :src="imageUrl" class="avatar"></img>
<i v-else class="el-icon-plus avatar-uploader-icon"></i>
</el-upload>
</div>
7.2 后端文件(Controller文件夹)
上传与下载通用接口
package com.guigutool.reggie.controller;
import com.guigutool.reggie.common.R;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.UUID;
/**
* @Author: KingWang
* @Date: 2023/3/12
* @Desc: 文件上传和下载
**/
@Slf4j
@RestController
@RequestMapping("/common")
public class CommonController{
@Value("${reggie.upload.path}")
private String basePath;
@PostMapping("/upload")
public R<String> upload(MultipartFile file){
//file是一个临时文件,需要转存到指定位置,否则本次请求完成后临时文件会删除
log.info(file.toString());
String originalFileName = file.getOriginalFilename();
String suffix = originalFileName.substring(originalFileName.lastIndexOf("."));
//使用UUID重新生成文件名,防止文件名重复造成文件覆盖
String fileName = UUID.randomUUID().toString() + suffix;
//如果目录不存在,则创建目录
File dir = new File(basePath);
if(!dir.exists()){
dir.mkdirs();
}
try{
file.transferTo(new File(basePath + fileName));
}catch (IOException e){
e.printStackTrace();
}
return R.success(fileName);
}
/**
* 文件下载
* @param name
* @param response
*/
@GetMapping("/download")
public void download(String name, HttpServletResponse response){
//输入流,通过输入流读取文件内容
try {
FileInputStream fileInputStream = new FileInputStream(new File(basePath + name));
//输出流,通过输出流将文件写回浏览器,在浏览器展示图片
ServletOutputStream outputStream = response.getOutputStream();
response.setContentType("image/jpeg");
int len = 0;
byte[] bytes = new byte[1024];
while((len = fileInputStream.read(bytes))!=-1){
outputStream.write(bytes,0,len);
outputStream.flush();
}
outputStream.close();
fileInputStream.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e){
e.printStackTrace();
}
}
}
9.通用工具类
9.1 通用返回结果类(Common文件夹)
import lombok.Data;
import java.io.Serializable;
import java.util.HashMap;
import java.util.Map;
@Data
public class R<T> implements Serializable {
private Integer code; //编码:1成功,0和其它数字为失败
private String msg; //返回的信息
private T data; //数据
private Map map = new HashMap(); //动态数据
public static <T> R<T> success(T object) {
R<T> r = new R<T>();
r.data = object;
r.code = 1;
return r;
}
public static <T> R<T> error(String msg) {
R r = new R();
r.msg = msg;
r.code = 0;
return r;
}
public R<T> add(String key, Object value) {
this.map.put(key, value);
return this;
}
}
9.2 过滤器(filter文件夹)
过滤器用来拦截未经授权的页面禁止访问,这里是在登录环节中使用。
登录的过程中,实现步骤如下:
(1) 创建自定义的过滤器LoginCheckFilter
(2) 添加Component注解
(3) 完善过滤器的处理逻辑
/**
* @Author: KingWang
* @Date: 2023/3/8
* @Desc:
**/
@Component
@WebFilter(filterName = "loginCheckFilter", urlPatterns = "/*")
@Slf4j
public class LoginCheckFilter extends HttpFilter {
//路径匹配器,支持通配符
public static final AntPathMatcher PATH_MATCHER = new AntPathMatcher();
// @Override
// public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
// HttpServletRequest request = (HttpServletRequest) servletRequest;
// HttpServletResponse response = (HttpServletResponse) servletResponse;
// log.info("拦截到请求:{}", request.getRequestURI());
// filterChain.doFilter(request,response);
// }
@Override
protected void doFilter(HttpServletRequest request, HttpServletResponse response, FilterChain chain) throws IOException, ServletException {
log.info("拦截到请求:{}", request.getRequestURI());
//1. 获取本次请求的URI
String requestURI = request.getRequestURI();
//2.定义不需要处理的请求路径
String[] urls = new String[]{
"/employee/login",
"/employee/logout",
"/backend/**",
"/front/**",
"/common/**",
"/user/sendMsg", //移动端发送短信
"/user/login", //移动端登录
"/doc.html", //生成swagger api文件,这里不放行,在登录后,也可以查看
"/webjars/**",
"/swagger-resources",
"/v2/api-docs"
};
//2. 判断本次请求是否需要处理
boolean check = check(urls, requestURI);
//3. 如果不需要处理,则直接放行
if(check){
chain.doFilter(request,response);
return;
}
//4-1. 判断登录状态,如果已登录,则直接放行
if(request.getSession().getAttribute(SystemConstant.SESSION_USER_ID) != null){
Long employeeId = (Long)request.getSession().getAttribute(SystemConstant.SESSION_USER_ID);
BaseContext.setCurrentId(employeeId);
long id = Thread.currentThread().getId();
log.info("线程id为:{}", id);
chain.doFilter(request,response);
return;
}
//4-2 . 判断登录状态,如果已登录,则直接放行 移动端登录
if(request.getSession().getAttribute(SystemConstant.MOBILE_USER_ID) != null){
Long userId = (Long)request.getSession().getAttribute(SystemConstant.MOBILE_USER_ID);
BaseContext.setCurrentId(userId);
long id = Thread.currentThread().getId();
log.info("线程id为:{}", id);
chain.doFilter(request,response);
return;
}
//5. 如果未登录,则返回未登录结果,通过输出流方式向客户端页面响应数据
response.getWriter().write(JSON.toJSONString(R.error("NOTLOGIN")));
return;
}
/**
* 路径匹配,检查本次请求是否需要放行
* @param urls
* @param requestURI
* @return
*/
private boolean check(String[] urls, String requestURI){
for(String url:urls){
if(PATH_MATCHER.match(url, requestURI)) return true;
}
return false;
}
}
9.3 全局异常处理器(Common文件夹)
annotations = {RestController.class, Controller.class}
指定在上面注解的类中捕获异常
/**
* @Author: KingWang
* @Date: 2023/3/9
* @Desc: 全局异常处理
**/
@ControllerAdvice(annotations = {RestController.class, Controller.class})
@ResponseBody
@Slf4j
public class GlobalExceptionHandler {
/**
* 异常处理方法
* @param ex
* @return
*/
@ExceptionHandler(CustomException.class)
public R<String> exceptionHandler(CustomException ex){
log.error(ex.getMessage());
return R.error(ex.getMessage());
}
}
9.4 MP分页插件(config文件夹)
/**
* @Author: KingWang
* @Date: 2023/3/9
* @Desc: 配置MP的分页插件
**/
@Configuration
public class MybatisPlusConfig {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor(){
MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
return mybatisPlusInterceptor;
}
}
分页查询案例:
/**
* 员工信息的分页查询
* @param page
* @param pageSize
* @param name
* @return
*/
@GetMapping("/page")
public R<Page> page(int page,int pageSize, String name){
log.info("page:{}, pageSize:{},name:{}", page,pageSize,name);
//构造分页构造器
Page pageInfo = new Page(page,pageSize);
//构造条件构造器
LambdaQueryWrapper<Employee> queryWrapper = new LambdaQueryWrapper();
//添加过滤条件
queryWrapper.like(StringUtils.isNotEmpty(name), Employee::getName,name);
//添加排序条件
queryWrapper.orderByDesc(Employee::getUpdateTime);
//执行查询
employeeService.page(pageInfo, queryWrapper);
return R.success(pageInfo);
}
9.5 消息转换器(Common文件夹)
针对long类型的数字,如果太长时接收会丢失精度,所以希望在接收long类型的数字时,需要统一转换为字符串来传入后天。
(1) 先定义转换类
package com.guigutool.reggie.common;
import com.fasterxml.jackson.databind.DeserializationFeature;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.databind.module.SimpleModule;
import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
import com.fasterxml.jackson.datatype.jsr310.deser.LocalDateDeserializer;
import com.fasterxml.jackson.datatype.jsr310.deser.LocalDateTimeDeserializer;
import com.fasterxml.jackson.datatype.jsr310.deser.LocalTimeDeserializer;
import com.fasterxml.jackson.datatype.jsr310.ser.LocalDateSerializer;
import com.fasterxml.jackson.datatype.jsr310.ser.LocalDateTimeSerializer;
import com.fasterxml.jackson.datatype.jsr310.ser.LocalTimeSerializer;
import java.math.BigInteger;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.time.format.DateTimeFormatter;
import static com.fasterxml.jackson.databind.DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES;
/**
* 对象映射器:基于jackson将Java对象转为json,或者将json转为Java对象
* 将JSON解析为Java对象的过程称为 [从JSON反序列化Java对象]
* 从Java对象生成JSON的过程称为 [序列化Java对象到JSON]
*/
public class JacksonObjectMapper extends ObjectMapper {
public static final String DEFAULT_DATE_FORMAT = "yyyy-MM-dd";
public static final String DEFAULT_DATE_TIME_FORMAT = "yyyy-MM-dd HH:mm:ss";
public static final String DEFAULT_TIME_FORMAT = "HH:mm:ss";
public JacksonObjectMapper() {
super();
//收到未知属性时不报异常
this.configure(FAIL_ON_UNKNOWN_PROPERTIES, false);
//反序列化时,属性不存在的兼容处理
this.getDeserializationConfig().withoutFeatures(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES);
SimpleModule simpleModule = new SimpleModule()
.addDeserializer(LocalDateTime.class, new LocalDateTimeDeserializer(DateTimeFormatter.ofPattern(DEFAULT_DATE_TIME_FORMAT)))
.addDeserializer(LocalDate.class, new LocalDateDeserializer(DateTimeFormatter.ofPattern(DEFAULT_DATE_FORMAT)))
.addDeserializer(LocalTime.class, new LocalTimeDeserializer(DateTimeFormatter.ofPattern(DEFAULT_TIME_FORMAT)))
.addSerializer(BigInteger.class, ToStringSerializer.instance)
.addSerializer(Long.class, ToStringSerializer.instance)
.addSerializer(LocalDateTime.class, new LocalDateTimeSerializer(DateTimeFormatter.ofPattern(DEFAULT_DATE_TIME_FORMAT)))
.addSerializer(LocalDate.class, new LocalDateSerializer(DateTimeFormatter.ofPattern(DEFAULT_DATE_FORMAT)))
.addSerializer(LocalTime.class, new LocalTimeSerializer(DateTimeFormatter.ofPattern(DEFAULT_TIME_FORMAT)));
//注册功能模块 例如,可以添加自定义序列化器和反序列化器
this.registerModule(simpleModule);
}
}
(2) 配置转换器(Config文件夹的WebMvcConfig类中)
同2.2中代码。
/**
* 扩展mvc框架的消息转换器
* @param converters
*/
@Override
protected void extendMessageConverters(List<HttpMessageConverter<?>> converters) {
log.info("扩展消息转换器...");
//创建消息转换器对象
MappingJackson2HttpMessageConverter messageConverter = new MappingJackson2HttpMessageConverter();
//设置对象转换器,底层使用Jackson将java对象转为Json
messageConverter.setObjectMapper(new JacksonObjectMapper());
//将上面的消息转换器对象追加到mvc框架的转换器容器中
converters.add(0, messageConverter);
}
0:表示放到索引第一位,优先使用。
9.6 公共字段填充(Common文件夹)
(1) 实体类增加@TableField注解
@TableField(fill = FieldFill.INSERT)
private LocalDateTime createTime;
@TableField(fill = FieldFill.INSERT_UPDATE)
private LocalDateTime updateTime;
@TableField(fill = FieldFill.INSERT)
private Long createUser;
@TableField(fill = FieldFill.INSERT_UPDATE)
private Long updateUser;
(2) 自动填充类
package com.guigutool.reggie.common;
import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.reflection.MetaObject;
import org.springframework.stereotype.Component;
import java.time.LocalDateTime;
/**
* @Author: KingWang
* @Date: 2023/3/10
* @Desc: 自定义元数据对象处理器
**/
@Component
@Slf4j
public class MyMetaObjectHandler implements MetaObjectHandler {
/**
* 插入操作自动填充
* @param metaObject
*/
@Override
public void insertFill(MetaObject metaObject) {
log.info("公共字段自动填充[insert]...");
log.info(metaObject.toString());
metaObject.setValue("createTime", LocalDateTime.now());
metaObject.setValue("updateTime", LocalDateTime.now());
metaObject.setValue("createUser", BaseContext.getCurrentId());
metaObject.setValue("updateUser", BaseContext.getCurrentId());
}
/**
* 更新操作自动填充
* @param metaObject
*/
@Override
public void updateFill(MetaObject metaObject) {
log.info("公共字段自动填充[update]");
log.info(metaObject.toString());
long id = Thread.currentThread().getId();
log.info("线程id为:{}", id);
metaObject.setValue("updateTime", LocalDateTime.now());
metaObject.setValue("updateUser", BaseContext.getCurrentId());
}
}
9.7 公共会话(Common文件夹)
使用ThreadLocal保存当前用户id,在相同的线程中,可以访问指定的变量。
/**
* @Author: KingWang
* @Date: 2023/3/10
* @Desc: 基于ThreadLocal封装工具类,用户保存和获取当前登录用户Id
**/
public class BaseContext {
private static ThreadLocal<Long> threadLocal = new ThreadLocal<>();
public static void setCurrentId(Long id){
threadLocal.set(id);
}
public static Long getCurrentId(){
return threadLocal.get();
}
}
资料链接
链接:https://pan.baidu.com/s/1wiZuW5-NHpRYtR2ksWDy4w?pwd=1y7t
提取码:1y7t