mybatis-plus代码生成+分页插件
配置代码生成
public class MybatisPlusGenerator {
public static void main(String[] args) {
FastAutoGenerator.create("jdbc:mysql://127.0.0.1:3306/mybatis_plus_demo?useUnicode=true&characterEncoding=utf-8&useSSL=false&&serverTimezone=Asia/Shanghai",
"root", "111111")
.globalConfig(builder -> {
builder.author("shang")
.fileOverride()
.dateType(DateType.ONLY_DATE)
.outputDir("D://generate");
})
.packageConfig(builder -> {
builder.parent("com.shang.mybatisPlusDemo")
.pathInfo(Collections.singletonMap(OutputFile.mapperXml, "D://generate"));
})
.strategyConfig(builder -> {
builder.addInclude("test_table")
.addTablePrefix("t_", "b_")
.entityBuilder().enableLombok().enableRemoveIsPrefix()
.controllerBuilder().enableRestStyle()
.serviceBuilder()
.mapperBuilder().enableMapperAnnotation().enableBaseResultMap()
;
})
.templateEngine(new FreemarkerTemplateEngine())
.execute();
}
}
配置分页插件
@Configuration
public class MybatisPlusConfig {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
return interceptor;
}
}
简单测试分页
@RestController
@RequestMapping("/test-table")
public class TestTableController {
@Autowired
protected ITestTableService testTableService;
@GetMapping
public Page<TestTable> test(){
Page<TestTable> page = new Page<>();
return testTableService.page(page);
}
}
说明
- 具体信息见项目:https://github.com/763977251/MyDemo/tree/main/mybatis-plus-demo
- 执行resources下sql文件夹下的sql文件
- 配置数据库地址密码