<!--数据库驱动--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <!--mybatis-plus--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.4.0</version> </dependency>
添加lombok依赖,简化开发,不是必须的
<!--lombok--> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </dependency>
datasource: url: jdbc:mysql://localhost:3306/time?useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=GMT%2B8 username: root password: driver-class-name: com.mysql.cj.jdbc.Driver
导入依赖:springfox-swagger2;springfox-swagger-ui
<!--swagger--> <!-- https://mvnrepository.com/artifact/io.springfox/springfox-swagger2 --> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-swagger2</artifactId> <version>2.9.2</version> </dependency> <!-- https://mvnrepository.com/artifact/io.springfox/springfox-swagger-ui --> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-swagger-ui</artifactId> <version>2.9.0</version> </dependency>
编写SwaggerConfig配置类:
@Configuration //配置类 @EnableSwagger2 //开启Swagger2 public class SwaggerConfig { //配置Swagger的docket的bean实例 @Bean public Docket ccaApi() { return new Docket(DocumentationType.SWAGGER_2) .groupName("task") .genericModelSubstitutes(DeferredResult.class) .useDefaultResponseMessages(false) .forCodeGeneration(true) //过滤路径 .pathMapping("/") .select() //扫描包名 .apis(RequestHandlerSelectors.basePackage("com.example.demo.controller")) .build() .apiInfo(taskApiInfo()); } private ApiInfo taskApiInfo() { return new ApiInfoBuilder() .title("测试服务接口列表")//大标题 .version("1.0")//版本 .build();} }
在yml文件中配置
mybatis-plus:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
同步实体类:
@TableField(fill = FieldFill.INSERT) private LocalDateTime gmtCreat; @TableField(fill = FieldFill.INSERT_UPDATE) private LocalDateTime gmtModified;
编写处理类:MyMetaObjectHandler
@Slf4j @Component//把处理器加入到IOC容器中 public class MyMetaObjectHandler implements MetaObjectHandler { //插入时的填充策略 @Override public void insertFill(MetaObject metaObject) { log.info("start insert fill..."); this.strictInsertFill(metaObject, "gmtCreat", LocalDateTime.class, LocalDateTime.now()); this.strictUpdateFill(metaObject, "gmtModified", LocalDateTime.class, LocalDateTime.now()); } //更新时的填充策略 @Override public void updateFill(MetaObject metaObject) { log.info("start update fill..."); this.strictUpdateFill(metaObject, "gmtModified", LocalDateTime.class, LocalDateTime.now()); } }
同步实体类:
@Version private Integer version;
编写配置类:MyBatisPlusConfig
注册组件://新版本弃用,直接加@version就可以使用乐观锁
导入分页插件
@Bean public PaginationInterceptor paginationInterceptor() { PaginationInterceptor paginationInterceptor = new PaginationInterceptor(); // 设置请求的页面大于最大页后操作, true调回到首页,false 继续请求 默认false // paginationInterceptor.setOverflow(false); // 设置最大单页限制数量,默认 500 条,-1 不受限制 // paginationInterceptor.setLimit(500); // 开启 count 的 join 优化,只针对部分 left join paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true)); return paginationInterceptor; }
使用Page对象
原文:https://www.cnblogs.com/xcl1997/p/13810287.html