✨✨个人主页:沫洺的主页

 📚📚系列专栏: 📖 JavaWeb专栏📖 JavaSE专栏 📖 Java基础专栏📖vue3专栏 

                           📖MyBatis专栏📖Spring专栏📖SpringMVC专栏📖SpringBoot专栏

💖💖如果文章对你有所帮助请留下三连✨✨

🍸效果 

在后端向前端返回统一格式data里一般按照需求是要包含分页信息的,比如总条数和按照每页的条数去返回对应的总页数等

​

🍹搭建多模块环境(父子项目) 

项目创建参考SpringBoot专栏里:

​

父项目scm-root的pom.xml

4.0.0org.springframework.bootspring-boot-starter-parent2.7.4com.momingscm-root14-SNAPSHOTpom1.8scm-authorityscm-appscm-daoscm-dtoscm-entityscm-servicescm-apiscm-coreorg.mybatismybatis3.5.6compilecn.hutoolhutool-all5.8.5

数据库

首先实现简单的查询业务

scm-dto模块

pom.xml依赖

        org.projectlomboklomboktrue

创建UserDto实体类

package com.moming.dto;import lombok.Data;@Data
public class UserDto {private Integer id;private String username;private String password;
}

scm-entity模块

pom.xml依赖

        org.projectlomboklomboktrue

创建UserEntity实体类

package com.moming.entity;import lombok.Data;@Data
public class UserEntity {private Integer id;private String username;private String password;
}

scm-dao模块

pom.xml依赖

        org.mybatismybatiscompilecom.momingscm-entity14-SNAPSHOTcompile

创建UserDao接口

package com.moming.dao;import com.moming.entity.UserEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;import java.util.List;@Mapper
public interface UserDao {@Select("select * from tb_user order by id")List select();}

scm-service模块

pom.xml依赖

        org.springframeworkspring-contextcn.hutoolhutool-allcom.momingscm-dao14-SNAPSHOTcompilecom.momingscm-dto14-SNAPSHOTcompile

创建UserService业务类

package com.moming.service;import cn.hutool.core.bean.BeanUtil;
import com.moming.dao.UserDao;
import com.moming.dto.UserDto;
import com.moming.entity.UserEntity;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;@Service
public class UserService {@Autowiredprivate UserDao userDao;public List select(){List entityList = userDao.select();List userDtos = BeanUtil.copyToList(entityList, UserDto.class);return userDtos;}
}

scm-app模块

pom.xml依赖

        org.springframework.bootspring-boot-starter-weborg.springframework.bootspring-boot-starter-testtestorg.springframework.dataspring-data-jdbcmysqlmysql-connector-javaruntimecom.alibabadruid-spring-boot-starter1.2.9org.mybatis.spring.bootmybatis-spring-boot-starter2.1.4com.momingscm-service14-SNAPSHOTcompile

创建controller/UserController

package com.moming.controller;import com.moming.dto.UserDto;
import com.moming.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;import java.util.List;@RestController
@RequestMapping("/api/user")
public class UserController {@Autowiredprivate UserService userService;@GetMapping("/select")public List select(){return userService.select();}
}

创建resources/application.yml

#数据库连接信息配置
spring:datasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/db5?useSSL=false&useServerPrepStmts=trueusername: rootpassword: 123456druid:initial-size: 10 # 初始化时建立物理连接的个数min-idle: 10 # 最小连接池数量maxActive: 200 # 最大连接池数量maxWait: 60000 # 获取连接时最大等待时间，单位毫秒
#映射文件所在位置
mybatis:mapper-locations: classpath:mapper/*Mapper.xml#别名type-aliases-package: com.moming.entity#配置日志级别
logging:level:com.moming: debug

启动类App运行后调用接口测试

​

🥂统一返回格式

scm-dto模块

创建ResponseDto实体类

package com.moming.dto;import lombok.Data;@Data
public class ResponseDto {private int code;private String message;private Object data;
}

scm-app模块

创建advice/MyResponseAdvice

package com.moming.advice;import cn.hutool.core.lang.Dict;
import cn.hutool.json.JSONUtil;
import com.moming.dto.PageInfo;
import com.moming.dto.ResponseDto;
import com.moming.local.PageInfoLocal;
import org.springframework.core.MethodParameter;
import org.springframework.http.MediaType;
import org.springframework.http.converter.HttpMessageConverter;
import org.springframework.http.converter.StringHttpMessageConverter;
import org.springframework.http.server.ServerHttpRequest;
import org.springframework.http.server.ServerHttpResponse;
import org.springframework.web.bind.annotation.ExceptionHandler;
import org.springframework.web.bind.annotation.RestControllerAdvice;
import org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdvice;@RestControllerAdvice(basePackages = MyResponseAdvice.BASEPACKAGES)
public class MyResponseAdvice implements ResponseBodyAdvice