介绍:接下来我会把一些我日常用到的框架整合在一起,每一次整合都是在前一章的基础上进行,所以后面的整合不会重复放前面的代码。如果大家有什么好的框架都可以推荐一下
一、添加依赖(在pom.xml文件中添加)
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.2</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-generator</artifactId>
<version>3.5.2</version>
</dependency>
注意:如果要使用mybatis plus的代码生成,就需要而外引入mybatis-plus-generator;因为Mybatis-Plus从3.0.3之后移除了代码生成器与模板引擎的默认依赖;
完整的代码
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- Mybatis-Plus 依赖 -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.2</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-generator</artifactId>
<version>3.5.2</version>
</dependency>
<!-- Mysql 依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!-- Druid 依赖 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.9</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
二、新增代码生成工具类
import com.baomidou.mybatisplus.generator.FastAutoGenerator;
import com.baomidou.mybatisplus.generator.config.OutputFile;
import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
import java.io.File;
import java.util.Collections;
/**
* 代码生成工具类
*
* @author yaoson
* @date 2022/10/15 13:11
**/
public class GeneratorCodeUtils {
/**
* 代码生成
* @param isMoreModule 是否多模块项目
* @param url 数据库连接地址
* @param username 数据库账号
* @param password 数据库密码
* @param author 作者
* @param outputDir 指定输出目录
* @param parentPg 父包名
* @param moduleName 父包模块名
* @param tableNames 表名;同时生成多张表时,用英文,隔开
* @param tablePrefix 表前缀
*/
public static void createCode(boolean isMoreModule, String url, String username, String password, String author, String outputDir, String parentPg, String moduleName, String tableNames, String...tablePrefix){
String projectPath = System.getProperty("user.dir");
String xmlPath = projectPath + "/src/main/resources/mappers/" + moduleName;
outputDir = projectPath + "/src/main/java";
if (isMoreModule) {
xmlPath = projectPath + File.separator + outputDir + "/src/main/resources/mappers/" + moduleName;
outputDir = projectPath + File.separator + outputDir + "/src/main/java";
}
String finalOutputDir = outputDir;
String finalXmlPath = xmlPath;
FastAutoGenerator.create(url, username, password)
.globalConfig(builder -> {
builder.author(author) // 设置作者
.disableOpenDir() // 禁止打开输出目录
.outputDir(finalOutputDir); // 指定输出目录
})
.packageConfig(builder -> {
builder.parent(parentPg) // 设置父包名
.moduleName(moduleName) // 设置父包模块名
.pathInfo(Collections.singletonMap(OutputFile.xml, finalXmlPath)); // 设置mapperXml生成路径
})
.strategyConfig(builder -> {
builder.addInclude(tableNames) // 设置需要生成的表名
.addTablePrefix(tablePrefix) // 设置过滤表前缀
.entityBuilder() // 实体类策略配置
.enableLombok() // 开启lombok
.serviceBuilder() // service 策略配置
.formatServiceFileName("%sService")
.mapperBuilder() // mapper策略配置
.enableMapperAnnotation(); // @mapper注解开启
})
.templateEngine(new FreemarkerTemplateEngine()) // 使用Freemarker引擎模板,默认的是Velocity引擎模板
.execute();
}
}
三、添加Mybatis-Plus配置文件
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import java.util.Collections;
/**
* Mybatis-Plus配置类
*
* @author yaoson
* @date 2022/10/15 14:15
**/
@Configuration
@EnableTransactionManagement
public class MybatisPlusConfig {
/**
* 分页插件
*/
@Bean
public PaginationInnerInterceptor paginationInnerInterceptor() {
PaginationInnerInterceptor paginationInterceptor = new PaginationInnerInterceptor();
// 设置最大单页限制数量,默认 500 条,-1 不受限制
paginationInterceptor.setMaxLimit(-1L);
paginationInterceptor.setDbType(DbType.MYSQL);
// 开启 count 的 join 优化,只针对部分 left join
paginationInterceptor.setOptimizeJoin(true);
return paginationInterceptor;
}
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor(){
MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
mybatisPlusInterceptor.setInterceptors(Collections.singletonList(paginationInnerInterceptor()));
return mybatisPlusInterceptor;
}
}
注意:不配置的话,无法使用Mybatis-Plus的分页功能;
四、修改yml配置文件
server:
port: 8086
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/shop?serverTimezone=Hongkong&useUnicode=true&characterEncoding=UTF-8&useSSL=true
username: root
password: root
jackson:
date-format: yyyy-MM-dd HH:mm:ss
time-zone: GMT+8
serialization:
write-dates-as-timestamps: false
mybatis-plus:
mapper-locations: classpath:/mappers/**/*.xml
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
五、展示自动生成的文件
CarouselInfo:
@Getter
@Setter
@TableName("cms_carousel_info")
public class CarouselInfo implements Serializable {
private static final long serialVersionUID = 1L;
/**
* 主键ID
*/
@TableId(value = "id", type = IdType.AUTO)
private Long id;
/**
* 图片URL
*/
private String carouselUrl;
/**
* 跳转类型:0-不跳转,1-小程序内部,2-小程序外部
*/
private Integer skipType;
/**
* 跳转URL
*/
private String skipUrl;
}
CarouselInfoMapper:
@Mapper
public interface CarouselInfoMapper extends BaseMapper<CarouselInfo> {
}
CarouselInfoService:
public interface CarouselInfoService extends IService<CarouselInfo> {
}
CarouselInfoServiceImpl:
@Service
public class CarouselInfoServiceImpl extends ServiceImpl<CarouselInfoMapper, CarouselInfo> implements CarouselInfoService {
}
本章到此结束,接下来会继续更新加强整合,尽情期待。